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