Find work in Canada.

318,539 jobs across our Canadian network. How we count

Jobs in Canada

25+ jobs

Email me new jobs Save this search

Added 9 hours ago
SM
RQ11635 – Software Developer – ETL – Senior
S M Software Solutions Inc
Toronto, ON
- Internship
We are seeking a Senior Software Developer – ETL with strong experience in data warehousing, business intelligence, reporting, ETL development, Oracle SQL/PL/SQL, Informatica, Crystal…
Added 9 hours ago
SM
RQ11635 – Software Developer – ETL – Senior
S M Software Solutions Inc
Toronto, ON
- Internship
We are seeking a Senior Software Developer – ETL with strong experience in data warehousing, business intelligence, reporting, ETL development, Oracle SQL/PL/SQL, Informatica, Crystal…
Added 9 hours ago
SM
RQ11635 – Software Developer – ETL – Senior
S M Software Solutions Inc
Toronto, ON
- Internship
We are seeking a Senior Software Developer – ETL with strong experience in data warehousing, business intelligence, reporting, ETL development, Oracle SQL/PL/SQL, Informatica, Crystal…
Added 19 hours ago
S
Patient Experience iCare Exchange Integrations Engineer
Sanofi
Toronto, ON
- Full-time
Expert-level proficiency in Informatica Intelligent Cloud Services (IICS), Python, Snowflake, and AWS cloud services and architecture.
Added 21 hours ago
SM
RQ11635 – Software Developer – ETL – Senior
S M Software Solutions Inc
Toronto, ON
- Internship
We are seeking a Senior Software Developer – ETL with strong experience in data warehousing, business intelligence, reporting, ETL development, Oracle SQL/PL/SQL, Informatica, Crystal…
Added 21 hours ago
SM
RQ11635 – Software Developer – ETL – Senior
S M Software Solutions Inc
Toronto, ON
- Internship
We are seeking a Senior Software Developer – ETL with strong experience in data warehousing, business intelligence, reporting, ETL development, Oracle SQL/PL/SQL, Informatica, Crystal…
Added 1 day ago
NV
Senior Business Intelligence Developer (ID#5552)
New Value Solutions
Vancouver, BC · Greater Vancouver, BC
- Contract
Experience with Cognos Report Studio, Cognos TM1, Tableau, Informatica, or similar BI/ETL tools.
Added 1 day ago
B
Senior ETL Developer
Bevertec
Toronto, ON
- Contract
5+ years’ experience in Designing, developing and testing in Informatica.
Added 1 day ago
2I
Senior ETL Developer
2iSolutions Inc.
Toronto, ON
- Contract
5+ years' experience in Designing, developing and testing in Informatica.
Added 1 day ago
W
Microsoft Analytics Developer
Workiy
Vancouver, BC
- Contract
Experience with ETL tools such as SSIS or Informatica
Added 2 days ago
PS
Junior SQL/ ETL Developer
Prodigy Systems Inc.
Toronto, ON
- $35 to $40 CAD / hour
- Contract
We're looking for a Junior SQL/ETL Developer for a 6 months contract with high possibility of extension. Role is hybrid with 2 days a week on site in Downtown Toronto.
Added 2 days ago
Mainframe Developer
Capgemini
Mississauga, ON
Design and support ETL solutions using Informatica PowerCenter/IICS.
Added 3 days ago
ES
ETL Developer (Insurance Domain)
Enterprise Solutions Inc.
Markham, ON
- Contract
Experience in building ETL workflows using Informatica PC
Added 4 days ago
T
Architect
TechDoQuest
Toronto, ON
- Contract
Expertise in design and orchestrating data acquisition pipelines using AWS Glue for ETL/ELT, Snowflake OpenFlow and Apache Airflow for workflow automation, enabling seamless ingestion of…
Added 4 days ago
RB
Senior Data Engineer
Royal Bank of Canada
Vancouver, BC
- Full-time
…Data Engineer to architect and build scalable, cloud-native ETL/ELT pipelines that power our enterprise data ecosystem. In this critical role, you will design end-to-end data solutions…
Added 4 days ago
R
Senior Data Engineer
RBC
Vancouver, BC
- Full-time
…Data Engineer to architect and build scalable, cloud-native ETL/ELT pipelines that power our enterprise data ecosystem. In this critical role, you will design end-to-end data solutions…
Added 4 days ago
XC
Senior Developer Engineer/Leader
Xcelerated Consulting Group, LLC.
Montreal, QC
- Contract
Messaging / Integration (Preferred): Familiarity with JMS, Kafka, Informatica ETL, or simi
Added 5 days ago
C
Oracle PL/SQL / Informatica Developer
CGI
Halifax, NS
- Full-time
We are seeking an experienced Senior Database Developer to join a high performing technology team supporting large scale, business critical applications. The successful candidate will bring…
Added 5 days ago
C
Director - Enterprise Data Warehouse and Data Platforms
CGI
Ottawa, ON
- Full-time
Provide technical leadership across enterprise data warehousing, data modelling, ETL/ELT, batch and streaming pipelines, data quality, metadata, governance, security, and analytics.
Added 5 days ago
TT
Senior Data Engineer
Tundra Technical Solutions
Toronto, ON
- $70 to $77 CAD / hour
- Contract
Build and optimize ELT/ETL processes for structured, semi-structured, and unstructured data sources.
Added 5 days ago
H
ETL Tester
Hays
Toronto, ON
- Contract
ETL & Data Integration : Informatica PowerCenter
Added 6 days ago
C
ETL Tester (Contract)
CoreFactor
Toronto, ON · Greater Toronto Area, Canada
- Contract
CoreFactor is searching for an ETL Tester on a contract basis for a Financial Services client in the GTA .
Added 6 days ago
CI
ETL Tester (Contract)
CoreFactor Inc.
Toronto, ON · Downtown Toronto (Toronto Dominion Centre / Design Exchange), Ontario
- Full-time
CoreFactor is searching for an ETL Tester on a contract basis for a Financial Services client in the GTA .
Added 8 days ago
T
Data Engineer (Data Modeling/Data Governance)
Tangerine
Toronto, ON
- Full-time
Develop cloud-based data solutions using GCP, BigQuery, Apache Airflow, Informatica, Python, and SQL.
Added 8 days ago
Data Engineer (Data Modeling/Data Governance)
Scotiabank
Toronto, ON
Develop cloud-based data solutions using GCP, BigQuery, Apache Airflow, Informatica, Python, and SQL.

CoreFactor Inc.

ETL Tester (Contract)

Toronto, ON, Canada
Downtown Toronto (Toronto Dominion Centre / Design Exchange), ON, Canada

Full-time

Apply About employer

Applications open in a new tab.

Job details

Job type: Full-time
Posting language: English
Posted: Sep 27, 2026

Original job description

CoreFactor is searching for an ETL Tester on a contract basis for a Financial Services client in the GTA .

This position is hybrid and will require the successful incumbent to go into the office four (4) days per week.

Roles and Responsibilities

Collaborate with developers, business analysts, data engineers, and other stakeholders to identify, troubleshoot, and resolve data quality issues.
Participate in requirements reviews, source-to-target mapping sessions, and design discussions to ensure testability, completeness, and data quality.
Analyze source-to-target mappings, define test strategies, create comprehensive test cases, and perform rigorous data validation.
Validate data accuracy, completeness, and integrity through source-to-target reconciliation and transformation testing.
Execute complex SQL queries, perform backend testing, and validate ETL transformations across Oracle, SQL Server, and BigQuery platforms.
Validate end-to-end ETL workflows, data pipelines, and data movement across source, staging, and target environments.
Work with multiple source systems containing structured, semi-structured, and JSON data.
Develop and maintain automated data validation, reconciliation, and regression tests using Python, SQL, and other automation utilities.
Support continuous improvement of ETL testing processes through automation and reusable testing frameworks.
Own test planning, test execution, defect management, regression validation, test reporting, and testing sign-off for assigned EDW initiatives.
Collaborate with project teams to support release readiness activities and ensure delivery quality.
Maintain test cases, test results, defect logs, and other QA artifacts in Jira, Confluence, and related project repositories.

Requirements

5+ years of hands-on experience in ETL testing, data validation, source-to-target reconciliation, data transformation testing, and end-to-end validation of data pipelines in Data Warehouse environments.
Strong experience with SQL, backend testing, ETL validation, and complex BigQuery queries for data validation, reconciliation, and troubleshooting.
Strong understanding of Data Warehousing concepts, ETL processes, data modeling, and data quality principles.
Hands-on experience with Oracle, SQL Server, BigQuery, Informatica PowerCenter, Airflow/Cloud Composer, and GCP data services.
Experience validating data across source, staging, and target systems, including structured, semi-structured, and JSON data.
Experience developing and maintaining ETL test automation solutions using Python, SQL, or similar technologies for automated data validation, reconciliation, and regression testing.
Proven ability to own test planning, test execution, regression validation, defect management, and testing sign-off activities for EDW initiatives.

Apply About employer

More about this job

Responsibilities

Collaborate with cross-functional teams to troubleshoot data quality issues and validate ETL workflows across various platforms. Manage the end-to-end testing lifecycle, including test planning, execution, and reporting for data warehouse initiatives.

Requirements

Requires 5+ years of hands-on experience in ETL testing, data validation, and source-to-target reconciliation within data warehouse environments. Proficiency in SQL, Python, and major data platforms like BigQuery, Oracle, and Informatica is essential.

Skills

ETL Testing
SQL
Data Validation
BigQuery
Oracle
SQL Server
Informatica PowerCenter
Python
Data Warehousing
Data Modeling
Airflow
Cloud Composer
GCP
Backend Testing
Defect Management
Regression Testing

Visa sponsorship

Not detected in the job text

Keywords

ETL Testing
Data Warehouse
SQL
Python
BigQuery
Oracle
SQL Server
Informatica PowerCenter
Airflow
Cloud Composer
GCP
Data Validation
Source-to-target Mapping
Backend Testing
Data Integrity
Regression Testing
Defect Management
Jira
Confluence
Financial Services
Data Pipelines
Automation
Data Modeling
Quality Assurance
Structured Data
Semi-structured Data
JSON
EDW
Reconciliation
Test Planning

Report this job