The ETL Tester is responsible for validating end-to-end data flows, ensuring consistency and correctness across data warehouse pipelines and reporting layers. Key responsibilities include:

• Designing and executing test cases for ETL processes, ensuring accurate data extraction, transformation, and loading across systems
• Performing data validation and reconciliation across source systems, staging areas, and target data warehouse tables (fact and dimension models)
• Writing complex SQL queries and joins in Oracle databases to validate data mappings and business rules
• Developing Python scripts to automate testing activities, data checks, and validation workflows
• Analyzing source-to-target data mappings and identifying discrepancies or transformation issues
• Executing data comparison and manipulation tasks to ensure integrity across datasets
• Working with Unix/Linux commands to support testing, data extraction, and environment navigation
• Collaborating with development and data engineering teams to resolve defects and improve data quality

Requirements

This role requires a highly skilled data testing professional with strong experience in ETL validation, database technologies, and scripting. The ideal candidate combines technical depth with strong analytical thinking:

• 10+ years of overall IT experience with 5–6 years focused on ETL and data warehouse testing
• Strong hands-on expertise in Oracle database technologies and advanced SQL scripting
• Proven experience in writing complex SQL queries, joins, and data validation logic
• Solid Python scripting skills for automation and data validation tasks
• Strong understanding of ETL processes, including data warehouse architecture and testing methodologies
• Experience analyzing source systems, staging areas, and fact/dimension data models
• Good knowledge of Unix/Linux commands for data handling and testing support
• Strong analytical skills with expertise in data validation, reconciliation, and comparison
• Ability to work independently in remote, distributed teams
• Selenium knowledge is a plus for automation exposure

Benefits

• Fully remote work opportunity across Canada and the USA
• Long-term contract engagement providing stability and continuity
• Exposure to large-scale enterprise data warehouse environments
• Opportunity to work with advanced ETL pipelines and complex data ecosystems
• Collaborative environment with data engineering and analytics teams
• Skill development in Python automation and modern data testing practices

We use an AI-powered matching process to ensure your application is reviewed quickly, objectively, and fairly against the role's core requirements. Our system identifies the top-fitting candidates, and this shortlist is then shared directly with the hiring company. The final decision and next steps (interviews, assessments) are managed by their internal team.

We appreciate your interest and wish you the best!

Why Apply Through Jobgether?

Data Privacy Notice: By submitting your application, you acknowledge that Jobgether will process your personal data to evaluate your candidacy and share relevant information with the hiring employer. This processing is based on legitimate interest and pre-contractual measures under applicable data protection laws (including GDPR). You may exercise your rights (access, rectification, erasure, objection) at any time.

#LI-CL1