onsite
ETL Tester
Software Engineer
ETL Tester responsible for validating data flows, ensuring mapping accuracy, and maintaining quality across data warehouses using advanced ETL tools and techniques.
About the role
Key Responsibilities
- Design, execute, and maintain comprehensive test plans for ETL processes, covering data mapping, transformation, and loading stages.
- Validate data integrity and quality by comparing source and target datasets, identifying discrepancies, and documenting findings.
- Collaborate with data engineers and analysts to troubleshoot data issues, propose solutions, and verify fixes.
- Automate repetitive test cases using scripting or ETL testing tools to improve efficiency and coverage.
- Maintain detailed test documentation, including test cases, results, and defect logs, ensuring traceability and compliance.
Requirements
- Proven experience testing ETL pipelines in a data warehouse environment.
- Hands‑on knowledge of SQL and at least one ETL tool (e.g., Informatica, Talend, SSIS).
- Strong analytical skills with the ability to identify root causes of data anomalies.
- Excellent communication skills for documenting defects and collaborating across teams.
Skills
software developmentsystem designproblem solving