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.
- 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