ETL Tester
Key Responsibilities :
- Develop, execute, and maintain ETL test plans and test cases based on project requirements and specifications.
- Validate data extraction, transformation, and loading processes across multiple sources and target systems such as data warehouses and data lakes.
- Identify, document, and report defects within the ETL pipeline; collaborate with development teams for timely resolution.
- Perform data reconciliation by comparing source data with transformed and loaded outputs to ensure accuracy and integrity.
- Execute regression testing to confirm that changes in ETL processes do not disrupt existing functionality.
- Conduct performance testing to evaluate ETL pipeline behavior under various data loads.
- Validate data mappings and transformation logic between source and target systems.
- Participate in code reviews and contribute to testing process improvements.
- Develop and maintain automated testing scripts for repetitive or complex testing scenarios.
- Document test cases, defects, and results to ensure traceability and audit readiness.
- Assist in troubleshooting and debugging data issues in collaboration with engineering and analytics teams.
- Communicate test progress and results effectively to business analysts, developers, and stakeholders.
Required Skills & Qualifications :
Bachelor's degree in Computer Science, Information Technology, or a related discipline.2–5 years of hands-on experience in ETL testing or data validation roles.Strong knowledge of ETL tools such as Informatica , Talend , or SSIS , and solid understanding of data warehousing principles.Proficiency in writing and executing complex SQL queries for data validation and issue investigation.Experience with relational database systems (e.g., Oracle, SQL Server, MySQL, PostgreSQL).Understanding of data migration, integration, and transformation concepts.Familiarity with data modeling, schema design, and best practices for data quality.Experience in defect tracking and test documentation.Analytical mindset with excellent attention to detail and problem-solving abilities.Strong communication skills, both written and verbal.Ability to work independently and collaboratively in a fast-paced, team-oriented environment.Preferred Qualifications :
Experience with cloud-based ETL platforms such as AWS Glue or Azure Data Factory .Exposure to Agile and Scrum methodologies.Certifications in ETL testing, data analysis, or quality assurance frameworks.Familiarity with automation tools such as Selenium , QTP , or domain-specific testing frameworks.Skills Required
Test Automation, Etl Testing, Etl