Etl Test Engineer

LTM; Pune District, Chennai, Bengaluru; Hybrid; INR 600,000 - 900,000; Full time

Job summary

LTM is seeking an ETL Tester in Pune to validate complex data pipelines. You will design and run SQL-based tests, verify data accuracy and integrity, and collaborate with data engineers and BI teams to ensure reliable data delivery.

The role requires hands-on experience with ETL tools and strong attention to data quality, mappings, and validation across source and target systems.

Qualifications

• Experience in ETL testing and data validation.
• Ability to create and execute test cases and SQL queries.
• Knowledge of data quality, mappings, and data integrity.

Responsibilities

• Perform ETL testing to validate data extraction, transformation, and loading processes.
• Create and execute test cases, test scenarios, and SQL queries for data validation.
• Verify data accuracy, completeness, integrity, and consistency between source and target systems.
• Validate data mappings, transformation rules, and data quality.
• Identify, track, and resolve defects in collaboration with developers and data engineers.
• Work with Data Warehouse, BI, and reporting teams to ensure high-quality data delivery.

Skills

ETL testing

SQL

Data validation

Defect tracking

Team collaboration

Tools

Informatica

Talend

SSIS

Job description

Job Description:

• Perform ETL testing to validate data extraction, transformation, and loading processes.
• Create and execute test cases, test scenarios, and SQL queries for data validation.
• Verify data accuracy, completeness, integrity, and consistency between source and target systems.
• Validate data mappings, transformation rules, record counts, and data quality.
• Identify, track, and resolve defects in collaboration with developers and data engineers.
• Work with Data Warehouse, BI, and reporting teams to ensure high-quality data delivery.
• Experience with ETL tools such as Informatica, Talend, SSIS, or similar platforms is preferred.