ETL Lead consultant
Infosys
Infosys
Join our team as an ETL Lead Consultant, a pivotal role within Infosys Quality Engineering. You will be instrumental in analyzing business needs, designing source-to-target mappings, and refining data models. This position offers a challenging opportunity to drive data quality and validation initiatives for complex ETL processes.
Leverage your expertise to develop comprehensive test plans, scenarios, cases, and scripts. Your responsibilities will include validating data extraction, transformation, and loading across various systems, ensuring seamless data flow and integrity. This role is ideal for an experienced professional seeking to make a significant impact in data engineering and quality assurance.
This role is situated in our Bangalore, India office, and is a full-time, onsite position. We are seeking individuals with a proven track record in data warehousing and ETL testing, ready to lead and innovate.
Key responsibilities include in-depth analysis of business requirements, source-to-target mappings, and data models. You will be tasked with developing and executing test plans, scenarios, cases, and scripts for ETL processes. Crucially, you will validate data extraction, transformation, and loading, ensuring accuracy between source and target systems.
Perform rigorous testing across Data Warehouse, ETL, Data Migration, Regression, and Integration. Verify data quality, integrity, reconciliation, and completeness. Execute SQL queries for robust data validation and backend testing. Identify, track, and resolve all data-related defects promptly.
Validate large-scale datasets and data pipelines, collaborating closely with ETL developers, data engineers, business analysts, and stakeholders. Participate actively in Agile/Scrum ceremonies and release testing. Generate comprehensive test execution reports and quality metrics to drive continuous improvement.
We are seeking an experienced ETL Lead Consultant with 8-12 years of experience in data services testing, specifically focusing on Data Warehouse and ETL tools. A strong foundation in analyzing business requirements and data models is essential.
Candidates must possess a Bachelor's degree in Engineering, B.Tech, BCA, B.Sc, or a Master's degree such as MCA, M.Sc, or M.Tech. Proficiency in executing SQL queries for data validation and backend testing is a must. Experience in identifying, tracking, and resolving data-related defects is also required.
Excellent collaboration and communication skills are necessary to work effectively with cross-functional teams and stakeholders. Familiarity with Agile/Scrum methodologies and participation in release testing activities is expected. The role is based in Bangalore, India, requiring an onsite presence.
Infosys
Information Technology & Services