What are the responsibilities and job description for the ETL Tester with strong Python position at Jobgether?
This position is posted by Jobgether on behalf of a partner company. We are currently looking for a ETL Tester with strong Python in Canada.
This role is focused on ensuring the accuracy, integrity, and reliability of enterprise data pipelines within large-scale data warehouse environments. The tester will play a critical part in validating complex ETL processes across source systems, staging layers, and target data models. Working in a remote, collaborative environment, the position requires strong analytical capabilities and deep SQL expertise to verify data transformations and business rules. The role also involves hands-on scripting using Python to support automation and data validation activities. You will work closely with data engineers and business stakeholders to ensure high-quality data delivery. This is a long-term contract opportunity suited for professionals experienced in data-centric testing within modern data ecosystems.
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
How Jobgether works:
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