ETL Tester with strong Python in Canada Creek, Nova Scotia at Jobgether
Explore Related Opportunities
Job Description
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
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
- 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