ETL Testing Engineer
First seen by Alion on Sep 21, 2026.
Responsibilities :
- Test Planning and Strategy : Collaborate with data engineers, data analysts, and business stakeholders to understand ETL requirements and create test strategies and plans.
- Test Case Development : Design, write, and execute detailed test cases and test scripts to validate data extraction, transformation, and loading processes.
- Data Validation : Conduct source-to-target data validation to ensure data accuracy and consistency, and identify potential data quality issues.
- Regression Testing : Perform regression tests on ETL processes after changes or updates to ensure that new changes do not affect existing functionalities.
- Automation : Develop and implement test automation frameworks to streamline testing for ETL processes using tools such as SQL, Python, or other scripting languages.
- Performance Testing : Assess ETL job performance and identify areas for optimization to ensure data processing meets required timeframes.
- Defect Tracking : Document, track, and report defects and issues found during testing, working closely with development teams to resolve them.
- Documentation : Maintain comprehensive documentation for all testing phases, including requirements, test scripts, and defect tracking.
Requirements :
- Technical Expertise : Proficiency in SQL, data querying, and database testing; familiarity with ETL tools such as Informatica, Talend, SSIS, or similar platforms.
- Scripting Knowledge : Hands-on experience with test automation tools or scripting languages like Python, Shell scripting, or other related tools.
- Data Warehousing Knowledge : Strong understanding of data warehousing concepts, data integration, and ETL processes.
- Analytical Skills : Excellent problem-solving skills, with a keen eye for detail to identify data inconsistencies and errors.
- Tools : Familiarity with tools like JIRA, HP ALM, or any other test management tool for tracking testing progress and defect status.
- Soft Skills : Good communication skills to liaise with development and business teams, attention to detail, and the ability to work in a collaborative environment.
Skills
ETL, SQL, ETL/Datawarehouse Testing, Informatica, SSIS, Talend, Python, Testing, Data Quality, Data Validation