ETL Test Engineer

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

Job summary

Infosys Quality Engineering seeks a data services tester to analyze requirements and data models, design ETL test cases, and ensure accurate data extraction, transformation, and loading. You will validate data end-to-end and collaborate with cross-functional teams in an Agile environment.

The role emphasizes SQL-based validation, defect tracking, and testing of data warehouses and reporting systems, with engagement across stakeholders and developers.

Qualifications

• Must have experience in data services testing and data warehouse testing.
• Strong understanding of ETL processes and data validation concepts.
• Familiarity with defect tracking and agile ceremonies.

Responsibilities

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

Skills

Analytical thinking

Attention to detail

Stakeholder collaboration

Agile/Scrum participation

Education

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

Tools

SQL

ETL tools

Job description

Roles 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 Requirement

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

Educational Requirement

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

Preferred Skills

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

Service Line

• Infosys Quality Engineering