About This Role
This senior ETL Tester role is crucial for ensuring the reliability of data for analytics, reporting, and critical business operations. The successful candidate will be responsible for validating the accuracy, completeness, and integrity of data as it flows through enterprise-grade Extract, Transform, Load (ETL) and Extract, Load, Transform (ELT) processes and data pipelines. The role involves designing and executing comprehensive test plans, scenarios, and cases for complex data transformations, data migrations, and data warehousing solutions, collaborating closely with data engineers, developers, business analysts, and other stakeholders.
Responsibilities
- Analyze business, functional, and technical requirements to identify testable scenarios and clarify ambiguities in user stories and specifications
- Design comprehensive test plans, test scenarios, and test cases for ETL workflows, data platforms, and reporting solutions
- Execute manual and automated testing for ETL processes, data transformations, data validation, and data pipelines
- Perform thorough data validation, data comparison, and backend testing to ensure the accuracy of data transformations and mappings
- Validate data mapping, transformations, aggregations, and business rules across source systems, staging layers, data warehouses, and reporting layers
- Conduct data integrity checks, reconciliations, and consistency validations using advanced SQL and other data validation techniques
- Write and execute complex SQL queries for data validation, reconciliation, integrity checks, and to verify data transformations and business rules
- Identify, log, track, and manage defects using tools such as Jira or Azure DevOps
- Collaborate with developers and data engineers to resolve issues and verify fixes
- Support ETL performance testing and validate load performance against benchmarks
- Analyze pipeline runtime, throughput, latency, and resource utilization
- Document test execution results, defect reports, test evidence, and sign-off artifacts to support quality assurance, audits, and compliance
- Communicate test results, risks, quality metrics, and recommendations clearly to cross-functional stakeholders
- Actively participate in Agile delivery processes, including Program Increment planning, stand-ups, sprint planning, grooming, and retrospectives
- Collaborate effectively with cross-functional teams
- Incorporate learnings and best practices to improve the ETL testing process over time
- Contribute to continuous QA process improvements
Requirements
- Bachelor’s degree or higher from a reputed university
- 6 to 10 years of experience in manual and automated testing, with a strong focus on ETL, data transformation, and data validation
