ETL Testers

Summary

We are seeking highly skilled ETL Testers to join our dynamic data engineering team. In this role, you will play a critical part in ensuring the accuracy, reliability, and performance of data pipelines that power our business intelligence, reporting, and analytics platforms. ETL Testers are responsible for validating data transformations, verifying data integrity across source and target systems, and ensuring compliance with business rules and regulatory standards. Your work will directly impact data quality, decision-making, and operational efficiency across departments. This position demands a deep understanding of ETL processes, data validation techniques, and testing methodologies in complex data environments. You will collaborate closely with data engineers, developers, and business analysts to identify issues early in the development lifecycle, reduce data downtime, and uphold the highest standards of data governance.

Responsibilities

• Design, develop, and execute comprehensive test plans and test cases for ETL processes across various data integration platforms.
• Validate data accuracy, completeness, consistency, and timeliness during ETL data extraction, transformation, and loading operations.
• Perform end-to-end testing of batch and real-time ETL workflows, including incremental and full loads.
• Conduct data profiling and anomaly detection to identify inconsistencies, duplicates, missing values, and outliers.
• Collaborate with data engineers and developers to troubleshoot and resolve defects in ETL logic and data pipelines.
• Utilize SQL and scripting languages to validate data at source, intermediate, and target stages.
• Maintain detailed test documentation, including test scripts, defect reports, and traceability matrices.
• Participate in Agile/Scrum ceremonies, including sprint planning, daily stand-ups, and retrospectives.
• Monitor and report on test coverage, defect trends, and data quality metrics.
• Ensure adherence to data security, privacy, and compliance standards (e.g., GDPR, HIPAA) during testing activities.

RequirementsRequirements:

• Bachelor’s degree in Computer Science, Information Technology, or a related field; or equivalent experience.
• Minimum of ${min_experience} years of hands-on experience in ETL testing within enterprise environments.
• Strong proficiency in SQL and experience with database systems such as Oracle, SQL Server, PostgreSQL, or Amazon Redshift.
• In-depth knowledge of ETL concepts, data warehousing, and data modeling (star schema, snowflake schema).
• Experience testing ETL tools such as Informatica PowerCenter, Talend, SSIS, or AWS Glue.
• Familiarity with testing frameworks and automation tools (e.g., Python, PyTest, Jenkins, Git).
• Proven ability to analyze complex data flows and identify root causes of data discrepancies.
• Excellent analytical, problem-solving, and communication skills with attention to detail.
• Experience working in Agile/DevOps environments with CI/CD pipelines.
• Knowledge of data quality standards and tools (e.g., Informatica DQ, IBM InfoSphere, Great Expectations).
• Understanding of cloud-based data platforms (AWS, Azure, GCP) and their ETL services is a plus.