Senior Etl Tester

Tech Mahindra; Hyderabad, Chennai District, Bengaluru; Hybrid; INR 1,200,000 - 1,800,000; Full time

Job summary

Tech Mahindra is seeking an experienced ETL/Data Warehouse Tester to analyze requirements and design test strategies for data pipelines in Hyderabad. You will validate data across source-to-target mappings, perform migrations, and ensure data integrity through automated scripts and robust validation frameworks.

The role emphasizes SQL proficiency, complex data checks, and collaboration within Agile teams to deliver reliable data solutions and release readiness.

Qualifications

• 6+ years of experience in ETL/Data Warehouse Testing.
• Strong expertise in ETL testing methodologies and data validation techniques.
• Advanced SQL skills with complex queries, joins, CTEs, stored procedures, and data reconciliation.

Responsibilities

• Analyze business requirements, source-to-target mappings, and ETL design documents.
• Design and execute ETL test strategies, test plans, test cases, and test scenarios.
• Validate data accuracy, completeness, consistency, integrity, and traceability across source and target systems.
• Perform ETL, Data Warehouse, Data Migration, Regression, and Integration Testing.
• Write and execute complex SQL queries for data validation and reconciliation.
• Validate transformation rules, business logic, aggregations, calculations, and data mappings.
• Perform source-to-target data validation and investigate data discrepancies.
• Validate full-load, incremental-load, and Change Data Capture (CDC) processes.
• Create and maintain automated test scripts and data validation frameworks.
• Investigate data defects, perform root cause analysis, and collaborate with development teams for resolution.
• Validate data quality controls, exception handling, reconciliation reports, and audit requirements.
• Support Agile delivery teams and participate in sprint ceremonies.
• Perform performance and volume testing of data pipelines.
• Provide quality metrics, test execution reports, and release readiness assessments.

Skills

ETL Testing

SQL

Data Validation

Agile/Scrum

Tools

Informatica

SSIS

DataStage

Talend

Azure Data Factory

Job description

Key Responsibilities

• Analyze business requirements, source-to-target mappings, and ETL design documents.


• Design and execute ETL test strategies, test plans, test cases, and test scenarios.


• Validate data accuracy, completeness, consistency, integrity, and traceability across source and target systems.


• Perform ETL, Data Warehouse, Data Migration, Regression, and Integration Testing.


• Write and execute complex SQL queries for data validation and reconciliation.


• Validate transformation rules, business logic, aggregations, calculations, and data mappings.


• Perform source-to-target data validation and investigate data discrepancies.


• Validate full-load, incremental-load, and Change Data Capture (CDC) processes.


• Create and maintain automated test scripts and data validation frameworks.


• Investigate data defects, perform root cause analysis, and collaborate with development teams for resolution.


• Validate data quality controls, exception handling, reconciliation reports, and audit requirements.


• Support Agile delivery teams and participate in sprint ceremonies.


• Perform performance and volume testing of data pipelines.


• Provide quality metrics, test execution reports, and release readiness assessments.

Required Skills

• 6+ years of experience in ETL/Data Warehouse Testing.


• Strong expertise in ETL testing methodologies and data validation techniques.


• Advanced SQL skills including:
  
  
  
  • Complex Queries
  
  
  • Joins
  
  
  • CTEs
  
  
  • Stored Procedures
  
  
  • Data Reconciliation
  
  
  
  


• Experience with one or more ETL tools:
  
  
  
  • Informatica
  
  
  • SSIS
  
  
  • DataStage
  
  
  • Talend
  
  
  • Azure Data Factory (ADF)
  
  
  
  


• Experience in Data Migration Testing and Data Warehouse Testing.


• Strong understanding of Agile/Scrum delivery models.


• Experience with defect management tools such as JIRA or Azure DevOps.


• Excellent analytical, troubleshooting, and communication skills.