Azure Data Engineer - Chennai, India - Indiglobe Solutions Pvt. Ltd.

Description

Years of experience: 7yearsSkills: Azure AzureSQLMode of Work: Hybrid (3 days WFO)Location: Chennai PuneBangaloreNotice Period: Max 30days Must tohave skills : Azure with SQL (Azure SQL) combination is amust to have. SSIS SSRS with Azure o SQL with Azure is what youneed to lookat.
Qualifications:

• 10 years ofexperience in ETL & Data Warehousing
• Should have excellent leadership &communication skills
• Should have strongworking experience on Data Lakehouse architecture
• Should have in depth knowledge on SSIS ETLTool and good working knowledge on Power BI
• Should have worked on data sources such as SAPand Salesforce
• Should have very good knowledgeof SSIS (ETL Tool) StreamSets (ETL Tool) Azure Cloud ADF AzureSynapse Analytics & Azure Hub Events
• Should have built solution automations in anyof the above ETL tools
• Should have executedatleast 2 Azure Cloud Data Warehousing projects
• Should have worked atleast 2 projects usingAgile/SAFe methodology
• Should havedemonstrated working knowledge on ITIL V4 concepts such as IncidentManagement Problem Management Change Management & KnowledgeManagement
• Should have working experience onany DevOps tools like GitHub Jenkins etc & onsemistructured data formats like JSON Parquet and/or XML files& written complex SQL queries for data analysis andextraction
• Should have in depth understandingon Data Warehousing Data Analysis Data Profiling Data Quality& Data Mapping
• Should have crossglobal location experience and been part of a team with atleast 15members in a global delivery model
• Should haveexperience in working with product managers project managersbusiness users applications development team members DBA teams andData Governance team on a daily basis to analyze requirementsdesign development and deployment technical solutions

Responsibilities:

• Analyze the different sourcesystems profile data understand document & fix Data Qualityissues
• Gather requirements and businessprocess knowledge in order to transform the data in a way that isgeared towards the needs of end users
• Writecomplex SQLs to extract & format source data for ETL/datapipeline
• Create design documents Source toTarget Mapping documents and any supporting documents needed fordeployment/migration
• Design Develop and TestETL/Data pipelines
• Design & buildmetadatabased frameworks needs for data pipelines
• Write Unit Test cases execute Unit Testing anddocument Unit Test results 1. Deploy ETL/Data pipelines
• Use DevOps tools to version push/pull code anddeploy across environments
• Support team duringtroubleshooting & debugging defects & bug fixesbusiness requests environment migrations & other adhocrequests
• Do production support enhancementsand bug fixes
• Work with business andtechnology stakeholders to communicate EDW incidents/problems andmanage their expectations
• Leverage ITILconcepts to circumvent incidents manage problems and documentknowledge
• Maintain and improve alreadyexisting processes
• Ensure that the datapipelines are stable secure maintainable and highlyavailable

azure,sqlazure,etl,data,data warehousing