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.
Solid 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.
Solid understanding of Agile/Scrum delivery models.
Experience with defect management tools such as JIRA or Azure DevOps.
Excellent analytical, troubleshooting, and communication skills.

📌 Senior Etl Tester Bengaluru
🏢 Tech Mahindra
📍 Bengaluru