Test Engineer

Job Description ETL Test Engineer (Data migration)

Job Type: Full-Time

Experience - 6 to 12 Years

Work Mode: Hybrid

Shift Timing: 2:00 PM 11:00 PM IST

Work Locations: Chennai, Bengaluru, Pune, Mumbai,

About the Role

We are seeking an experienced ETL Test Engineer with strong expertise in ETL testing, data migration validation, and advanced SQL. The ideal candidate will have handson experience validating data pipelines, ensuring data accuracy, and working closely with crossfunctional teams throughout the data lifecycle.

Key Responsibilities

ETL & Data Pipeline Testing

• Design, execute, and maintain ETL test cases, test scenarios, and data validation frameworks.
• Perform endtoend testing of data extraction, transformation, and loading processes.
• Validate data flow across various layers (source staging warehouse reporting).
• Perform functional, integration, regression, and system testing for data-related components.

Data Migration Testing

• Validate data migration strategies, mapping sheets, and migration rules.
• Perform data completeness, data accuracy, and data consistency checks across legacy & target systems.
• Identify data mismatches, log defects, and drive rootcause analysis with developers and DB teams.

SQL & Database Validation

• Write and execute complex SQL queries for data profiling, reconciliation, and deepdive validation.
• Perform joins, subqueries, aggregations, window functions, and performance checks.
• Analyze large datasets and ensure correctness, integrity, and compliance.

Quality Assurance & Documentation

• Create and maintain test plans, test strategy, and defect reports.
• Use test management tools like JIRA, ALM, Azure DevOps or similar.
• Collaborate with ETL developers, data engineers, PMs, and business teams to ensure defectfree releases.

Required Skills & Experience

• 6+ years of experience in ETL/DWH testing.
• Strong handson experience in ETL tools (Informatica, DataStage, SSIS, Talend, or equivalent).
• Solid experience in data migration testing across enterprise environments.
• Proficiency in writing complex SQL queries (Oracle, SQL Server, PostgreSQL, Snowflake, etc.).
• Experience working with large datasets and enterprise data warehouses.
• Strong analytical skills and attention to detail.
• Familiarity with Agile/Scrum methodologies.