ETL Test Engineer

Infosys Limited; Chennai District; On-site; INR 600,000 - 900,000; Full time

Job summary

Infosys Limited in Chennai seeks an ETL Test Engineer with 3-5 years of experience to analyze requirements, design ETL test cases, and validate data across data pipelines. The role emphasizes data extraction, transformation, and loading checks with strong SQL and collaboration with cross-functional teams.

The candidate will participate in Agile/Scrum ceremonies and work within Infosys Quality Engineering to ensure data quality across warehouses and reporting systems.

Qualifications

• Experience in ETL testing and data validation.
• Proficient in SQL for data quality checks.
• Knowledge of data warehousing and testing methodologies.

Responsibilities

• Analyze business requirements, source-to-target mappings, and data models.
• Design and execute ETL test cases and test scenarios.
• Validate data extraction, transformation, and loading processes.
• Perform source-to-target data validation and reconciliation.
• Verify data completeness, accuracy, integrity, and consistency.
• Execute functional, regression, system, and integration testing.
• Create complex SQL queries for data validation.
• Identify, document, and track defects using defect management tools.
• Validate data warehouse, data marts, and reporting systems.
• Collaborate with developers, business analysts, data engineers, and stakeholders.
• Participate in Agile/Scrum ceremonies.

Skills

ETL Testing

SQL

Data Validation

Education

Bachelor of Engineering

BTech

BCA

BSc

MTech

MCA

MSc

Tools

ETL Tool

Data Quality

Data Warehouse Testing

SQL

Job description

CHENNAI, Infosys Limited ETL Test Engineer

Work Experience 3 - 5 Years

Job Title ETL Test Engineer

Educational Requirements

Bachelor of Engineering,BTech,BCA,BSc,MTech,MCA,MSc

Service Line

Infosys Quality Engineering

Responsibilities

Analyze business requirements, source-to-target mapping documents, and data models.Design and execute ETL test cases and test scenarios.Validate data extraction, transformation, and loading processes.Perform source-to-target data validation and reconciliation.Verify data completeness, accuracy, integrity, and consistency.Execute functional, regression, system, and integration testing.Create complex SQL queries for data validation.Identify, document, and track defects using defect management tools.Validate data warehouse, data marts, and reporting systems.Perform backend database testing.Collaborate with developers, business analysts, data engineers, and stakeholders.Participate in Agile/Scrum ceremonies.

Technical and Professional Requirements

Technology->Data Services Testing->Data Warehouse Testing->ETL tool, Technology->ETL & Data Quality->ETL - Others

Preferred Skills

Technology->ETL & Data Quality->ETL - Others Technology->Data Services Testing->Data Warehouse Testing->ETL tool