First seen by Alion on Nov 20, 2026.
We are looking for an experienced ETL Tester with strong expertise in data warehouse testing, ETL validation, and database testing.
The ideal candidate should have hands-on experience in validating data pipelines, performing data reconciliation, and ensuring data accuracy, completeness, and consistency across source and target systems.
Key Responsibilities:
- Design, develop, and execute test cases for ETL processes, data migration, and data warehouse applications.
- Validate data extraction, transformation, and loading processes across multiple source and target systems.
- Perform source - to - target data validation and reconciliation to ensure data accuracy and completeness.
- Write and execute complex SQL queries to validate data transformations, business rules, and data integrity.
- Perform backend testing, database testing, and data quality validation.
- Identify, analyse, and report data discrepancies, defects, and inconsistencies.
- Validate data mapping documents and transformation logic against business requirements.
- Perform functional, regression, integration, and end - to - end testing of ETL workflows.
- Collaborate with developers, data engineers, business analysts, and stakeholders to resolve data - related issues.
- Prepare test plans, test scenarios, test cases, and test execution reports.
- Participate in defect triage meetings and ensure timely resolution of identified issues.
Required Skills & Qualifications:
- 5 - 8 years of experience in ETL Testing, Data Warehouse Testing, or Database Testing.
- Strong hands - on experience in ETL testing methodologies and data validation.
- Advanced SQL skills, including complex queries, joins, subqueries, and stored procedures.
- Experience with ETL tools such as Informatica, Talend, SSIS, DataStage, or equivalent.
- Good understanding of data warehousing concepts, data modelling, and database architecture.
- Experience in source - to - target validation, data reconciliation, and data quality testing.
- Knowledge of relational databases such as Oracle, SQL Server, or PostgreSQL.
- Experience in defect management and test management tools such as Jira, HP ALM, or equivalent.
- Strong analytical, problem - solving, and debugging skills.
- Ability to work closely with cross - functional teams in an Agile environment.
Preferred Skills:
- Exposure to cloud - based data platforms such as AWS, Azure, or GCP.
- Familiarity with big data testing and technologies such as Hadoop or Spark.
- Knowledge of data pipeline validation and automation testing frameworks.
- Understanding of Agile and Scrum methodologies
Skills
ETL/Datawarehouse Testing, ETL, Data Migration, Data Warehousing, Data Validation, Talend, SSIS, Datastage, AWS, Data Quality, Big Data Testing

