Data Engineer (ETL, ADF)

Position:

Data Engineer (ETL, ADF)

Job Description:

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.

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

Location:

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

Time Type:

Full time

Job Category:

Engineering Services