Data Engineer (ETL, ADF)

eInfochips · Ahmedabad

Position:

Role: Data Engineer
Location: Ahmedabad, Pune, Indore.

Experience: 5 Years

Technical Skills:

Tools: Azure Data Factory, SQL, Microsoft Power BI

Mandatory Skills:

Should be well-versed in the design and development of ETL and database developments for a large data warehouse
Should be able to work collaboratively with other team members, as well as users for operational support
Expertise in Azure data factory, SQL Stored procedure development, performance tuning.
Should possess very good communication with strong business and data analysis skills
Experience in using Agile methodologies
Experience in developing and working on Power BI reports for enterprise level reports.

Key Responsibilities:

Develop, fine tune, automate and maintain ETL pipelines using Azure Data factory and SQL server stored procedures
Develop ETL solutions using data integration tools for interfacing between source application and the Enterprise Data Warehouse
Document ETL data mappings, data dictionaries, processes, programs, and solutions as per established standards for data governance
Integrate ETL development with existing projects to maximize object reuse
Create, execute, and document unit test plans for ETL and data integration processes and programs
Work with the peers in data team to assess and troubleshoot potential data quality issues at key intake points such as validating control totals at intake.
Troubleshoot data issues and defects to determine root cause
Performance tuning of the ETL process and SQL queries, and recommend and implement ETL and query tuning techniques
Develop and create transformation queries, views, and stored procedures for ETL processes, and process automations

IN-GJ-Ahmedabad, India-Ognaj (eInfochips)

Full time

Engineering Services