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.
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
Location:
IN-GJ-Ahmedabad, India-Ognaj (eInfochips)
Time Type:
Full time
Job Category:
Engineering Services
