Design, develop, and execute comprehensive test plans and test cases for complex ETL processes and data pipelines.
Validate data accuracy, completeness, and consistency using advanced SQL queries for data validation and reconciliation.
Develop and maintain robust automated test scripts using Java / JEE for data validation, regression testing, and overall data quality assurance.
Implement API Automation testing strategies for data services and microservices, using tools / frameworks like REST Assured to ensure seamless integration and performance.
Collaborate closely with ETL developers, data engineers, and business analysts in an Agile / Scrum methodology to understand data flows, transformation logic, and functional requirements.
Identify, document, and track defects, issues, and risks using defect management tools such as Jira or Client ALM, and work with development teams for timely resolution.
Participate in the continuous improvement of testing processes and tools, potentially integrating automated tests into CI / CD pipelines using tools like Jenkins or GitLab.
Create and maintain test data and test environments, ensuring proper configuration for testing activities.
Prepare detailed test summary reports and provide clear communication of testing progress and results to stakeholders.
Required Qualifications & Skills :
years of hands-on experience in ETL testing and data quality assurance.
Strong proficiency in writing complex SQL queries , including joins, subqueries, and aggregate functions, for data validation and backend testing.
Hands-on programming experience with Java / JEE for developing and enhancing automation frameworks.
Proven experience in designing and implementing API automation testing strategies.
Familiarity with test automation tools and frameworks such as Selenium , TestNG, or Cucumber is a plus.
Strong understanding of data warehousing concepts , data modeling (star and snowflake schemas), and ETL processes.
Experience with ETL tools like Informatica, Talend, or SSIS is beneficial.
Excellent analytical skills with a keen attention to detail and strong problem-solving abilities.
Strong communication and collaboration skills to work effectively with cross-functional teams in an onsite setting.
Create a job alert for this search
ETL TESTING • TORONTO, ON
Similar jobs
ETL QA Tester
TEKsystems • Markham
Full-time +1
Be among the first 25 applicants.Get AI-powered advice on this job and more exclusive features.Location : Markham, ON ( 4 days onsite per week ).
Contract Term : 6 months to start.We’re hiring an expe...Show more
Last updated: 24 days ago • Promoted
Senior ETL Engineer - Azure Data Lakes, D365 (Hybrid)
Source Code • Toronto
Full-time +1
A leading technology company is seeking a Sr.Software Developer - ETL to work in a hybrid model in Toronto, ON.The ideal candidate will have over 8 years of experience in data integration and ETL d...Show more
Last updated: 19 days ago • Promoted
LabVIEW Test Engineer
Global Connect Technologies • newmarket, ON, ca
Full-time
Job Title : LabVIEW Test Engineer Location : Southfield, MI Duration : Long Term Job Summ...Show more
Last updated: 17 days ago • Promoted
Certified Guidewire Business Analyst
Coforge • markham, ON, ca
Full-time
Job Title : Certified Guidewire Business Analyst Skills : Guidewire cloud, Claims / Billing, Agile Experience : 8+ ye...Show more
Last updated: 4 days ago • Promoted
Senior ETL Tester
CGI • Toronto
Full-time
This role is hybrid and requires you to be at a Client office in downtown, Toronto at a minimum 4 days per week - subject to change at any time.
We are seeking a highly skilled professional with str...Show more
Last updated: 30+ days ago • Promoted
ETL & Functional Tester ( Canada Only)
Divine Match Talent • Toronto
Full-time
Our client is a leading provider of innovative healthcare technology solutions focused on organ transplantation and allocation.
They deliver powerful, scalable platforms that support national-level ...Show more
Last updated: 3 days ago • Promoted
Senior ETL Developer
Encore Technical Solutions Inc. • Markham
Full-time
A degree in Computer Science, Software Engineering, or comparable professional experience.CDC techniques, and crafting / optimizing SQL queries.
MS SSIS / SSDT and Pitney Bowes migration utilities.Famil...Show more
Last updated: 14 days ago • Promoted
Senior ETL Engineer
Swagher • Toronto
Full-time
Senior ETL EngineerScotiabankTorontoRequisition ID : 238183 Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.
The Team • • • We are the CRM, Sales...Show more
Last updated: 24 days ago • Promoted
Azure Data Engineer — ETL Testing & Data Lakes Specialist
Themesoft Inc. • Toronto
Full-time
A prominent IT solutions provider is seeking a tech-savvy professional in Toronto, Canada.The ideal candidate will have expertise in ETL concepts, data integration, and data warehousing.Proficiency...Show more
Last updated: 3 days ago • Promoted
Sr ETL Developer
Bevertec • Toronto
Full-time
Designing and developing scalable Medallion Data Lakehouse architectures.Expertise in data ingestion, transformation, and curation using Delta Lake and Databricks.
Experience integrating structured ...Show more
Last updated: 20 days ago • Promoted
Senior Quality Assurance Analyst - Saint Laurent Consulting
Saint Laurent Consulting • richmond hill, on, ca
Part-time
Quality Assurance (QA) Analyst.Saint Laurent Consulting is hiring on behalf of our client.We are seeking a detail-oriented Quality Assurance (QA) Analyst to support ongoing testing for a large, pub...Show more
Last updated: 21 days ago • Promoted
Senior ETL Engineer – Databricks, Delta Lake, Hybrid
Rubicon Path • Toronto
Full-time
A leading technology firm in Toronto seeks a Software Developer - ETL to design and implement ETL processes using Azure Databricks.
This role involves optimizing data flow for analytics and data lak...Show more
Last updated: 24 days ago • Promoted
ETL Developer
Tata Consultancy Services • Toronto
Full-time
Tata Consultancy Services (TCS) is an equal opportunity employer, and embraces diversity in race, nationality, ethnicity, gender, age, physical ability, neurodiversity, and sexual orientation, to c...Show more
Role : Oracle Integration Cloud (OIC).Good knowledge in with Oracle Integration Cloud (OIC).Oracle SaaS modules and their integration touchpoints.
Exposure to REST / SOAP web services, XML, JSON and o...Show more
Last updated: 8 days ago • Promoted
Ab Initio ETL Developer
Adastra Corporation • Markham
Full-time
Join our team at Adastra as a Senior Ab Initio ETL Developer and be at the forefront of enterprise data solutions.In this role, you will lead ETL development, provide expert guidance, and collabora...Show more
A digital transformation company in Toronto is seeking a skilled QA tester experienced in manual and automated testing across various platforms.
The ideal candidate will have strong SQL knowledge, e...Show more
Last updated: 20 days ago • Promoted
Senior ETL Engineer
Thebusinessyear • Toronto
Full-time
Senior ETL EngineerScotiabankTorontoRequisition ID : 238183 Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.
The Team • • • We are the CRM, Sales...Show more
Last updated: 24 days ago • Promoted
Business Analyst III - Confidential
Confidential • markham, on, ca
Full-time
Our teams are committed to always being innovative and staying at the forefront, by joining our Training Center Operations Experience team, you will have the opportunity to actively participate in ...Show more