Find work in Canada.

493,559 jobs across our Canadian network. How we count

Jobs in Canada

25+ jobs

Email me new jobs Save this search

Added 1 hour ago
BR
Senior Software Developer – ETL / Data Migration
BITS Recruiting
Toronto, ON
- $90 to $96 CAD / hour
- Contract
We are seeking a Senior Software Developer specializing in ETL and data migration to support a digital transformation initiative for a public-sector client. The successful candidate will…
Added 2 hours ago
GT
Senior Mainframe Assembler Programmer
Global Technical Talent, an Inc. 5000 Company
Toronto, ON
- $65 to $80 CAD / hour
- Contract
Our client, a leading Canadian financial institution, is seeking an experienced Senior Mainframe Assembler Programmer to support business-critical banking applications and regulatory…
Added 5 hours ago
SM
RQ10575 – Software Developer – ETL – Senior
S M Software Solutions Inc
Toronto, ON
- Full-time
We are seeking a Senior Software Developer – ETL with extensive experience in data migration, ETL development, data conversion, database technologies, and digital transformation…
Added 17 hours ago
SM
RQ10575 – Software Developer – ETL – Senior
S M Software Solutions Inc
Toronto, ON
- Full-time
We are seeking a Senior Software Developer – ETL with extensive experience in data migration, ETL development, data conversion, database technologies, and digital transformation…
Added 17 hours ago
SM
RQ10575 – Software Developer – ETL – Senior
S M Software Solutions Inc
Toronto, ON
- Full-time
We are seeking a Senior Software Developer – ETL with extensive experience in data migration, ETL development, data conversion, database technologies, and digital transformation…
Added 20 hours ago
YC
JEE Developer, senior
Yoush Consulting
Toronto, ON
- Full-time
…System and Enrollment and Consent Management / Claims Data Entry…
Added 1 day ago
SM
RQ10575 – Software Developer – ETL – Senior
S M Software Solutions Inc
Toronto, ON
- Full-time
We are seeking a Senior Software Developer – ETL with extensive experience in data migration, ETL development, data conversion, database technologies, and digital transformation…
Added 1 day ago
SM
RQ10575 – Software Developer – ETL – Senior
S M Software Solutions Inc
Toronto, ON
- Full-time
We are seeking a Senior Software Developer – ETL with extensive experience in data migration, ETL development, data conversion, database technologies, and digital transformation…
Added 2 days ago
BC
Senior DB2 DBA
BMO Capital Markets
Toronto, ON
- Full-time
We are looking for a Senior Database Administrator (Db2 z/OS) to join our Mainframe Platform & Application Services team. In this role, you'll help design, optimize, and support the…
Added 2 days ago
EF
Senior Software Engineer, Finance System
Element Fleet Management
Toronto, ON
- Full-time
As a Senior Software Engineer, Finance System, you will design, develop, and maintain scalable software solutions that support Element’s enterprise financial systems and digital…
Added 3 days ago
I-
Senior ETL Developer
I8IS - Infiniti Software Solutions
Toronto, ON
- Full-time
We are seeking a Senior ETL Software Developer to lead and support data migration from legacy applications to modernized solutions. The successful candidate will develop and implement data…
Added 3 days ago
A
Chief Mainframe Architect
Atos
Canada
- Full-time
…defines and guides end-to-end solution architecture across applications, data, infrastructure, integration, security, and technology platforms, ensuring alignment with enterprise…
Added 3 days ago
YC
JEE Developer, senior
Yoush Consulting
Toronto, ON
- Full-time
…System and Enrollment and Consent Management / Claims Data Entry…
Added 3 days ago
N
Enterprise Architect
Nutrien
Calgary, AB
- Full-time
The Enterprise Architect - Applications & ERP defines and maintains Nutrien’s enterprise application and ERP architecture direction. The role creates a transparent view of the application…
Added 3 days ago
LI
Software Developer - ETL - Senior
Lotus IT Solutions
Toronto, ON · Greater Toronto Area, Canada
- Contract
…and Business Service Delivery and Procurement, is seeking a Senior Software Developer – ETL to support a critical digital transformation initiative. The successful consultant will provide…
Added 3 days ago
M
RQ10575 - Software Developer - ETL - Senior
Maarut
Toronto, ON
- Contract
senior Software Developer ETL is required to provide best practice
Added 4 days ago
Programmer Analyst Advisory(Mainframe Developer)
Scotiabank
Toronto, ON
The Senior Mainframe Developer is responsible for the design, development, maintenance, and support of Commercial Lending applications. The successful candidate will work closely with…
Added 4 days ago
B
Senior DB2 DBA
BMO
Toronto, ON · SCC
- Full-time
We are looking for a Senior Database Administrator (Db2 z/OS) to join our Mainframe Platform & Application Services team. In this role, you'll help design, optimize, and support the…
Added 5 days ago
TT
Senior Java Developer – IBM MDM v12
Tamanna Technology
Toronto, ON · Greater Toronto Area, Canada
- Contract
We are seeking a 𝗦𝗲𝗻𝗶𝗼𝗿 𝗝𝗮𝘃𝗮 𝗗𝗲𝘃𝗲𝗹𝗼𝗽𝗲𝗿 with 𝟭𝟬+ 𝘆𝗲𝗮𝗿𝘀 𝗼𝗳 𝗲𝘅𝗽𝗲𝗿𝗶𝗲𝗻𝗰𝗲 in enterprise application development. Candidates must have strong expertise in…
Added 5 days ago
C
Expert Solution Information Architecture-CA
CN
Montreal, QC
- Full-time
Minimum 12 years of experience with applications, data, and cloud
Added 5 days ago
TT
Senior Java / J2EE Developer
Tamanna Technology
Toronto, ON · Greater Toronto Area, Canada
- Contract
We are seeking an experienced and detail-oriented Java / J2EE Developer to join our development team. In this role, you will design, develop, and maintain high-performance enterprise…
Added 5 days ago
C
Senior Enterprise Architecture Consultant – Enterprise Modernization
CGI
Vancouver, BC
- Full-time
The Senior Enterprise Architecture Consultant owns and governs the end to end target state architecture for a large scale enterprise modernization and legacy transition program. The role…
Added 5 days ago
C
Senior Mainframe Developer - Hybrid
Cognizant
Toronto, ON
- Full-time
We are seeking a highly skilled Mainframe Developer with 8+years of experience in designing developing enhancing and supporting enterprise-scale Mainframe applications. The ideal candidate…
Added 6 days ago
Senior Group Insurance Underwriter
The Canada Life Assurance Company
Winnipeg, MB · London, ON · Toronto, ON
The Senior Group Insurance Underwriter is directly responsible for assessing the risk and making decisions associated with the sale, amendment and renewal of assigned cases. And, at times,…
Added 6 days ago
CL
Senior Group Insurance Underwriter
Canada Life
Toronto, ON
- Full-time
The Senior Group Insurance Underwriter is directly responsible for assessing the risk and making decisions associated with the sale, amendment and renewal of assigned cases. And, at times,…

Lotus IT Solutions

Software Developer - ETL - Senior

Toronto, ON, Canada
Greater Toronto Area, Canada, Canada

Contract

Apply About employer

Applications open in a new tab.

Job details

Job type: Contract
Apply by: Nov 21, 2026
Experience: 7+ years of experience developing and documenting ETL processes for data conversion and migration projects
Posting language: English
Posted: Oct 22, 2026

Original job description

Sign in to apply for this position Sign In to Apply

Ref: RQ10575 Contract – 10 Months (Extension Possible) Onsite – Toronto (21 College Street)

Posted Date: 2026-10-22

Location: Onsite – Toronto (21 College Street)

Public Sector Experience: Required – OPS / Public Sector

Contract End Date: 2027-10-05 *

Rate: $101/hour

Overview

Justice Technology Services (JTS), under the Ministry of Public and Business Service Delivery and Procurement, is seeking a Senior Software Developer – ETL to support a critical digital transformation initiative. The successful consultant will provide best-practice migration solutions and oversee all aspects of data and file migration from legacy applications to a modernized solution. This is a hands-on senior technical role requiring deep expertise in ETL development, data profiling, and enterprise-scale data migration.

Key Responsibilities

Design and implement best-practice ETL migration solutions for data and file conversion from legacy systems to new modernized platforms
Analyze legacy data and files stored across a variety of data sources and formats, completing thorough data profiling activities
Develop and execute data migration strategy including data mapping, interface definitions, mock conversions, enhancements, and actual conversion runs
Translate technical system specifications into working, tested applications including detailed programming specifications and unit-tested code
Work with importing files from heterogeneous platforms and coordinate data file migration activities
Define testing strategy and conduct testing to ensure data integrity and perform data comparisons
Generate data migration exception reports and perform data cleansing as required
Perform post-migration audit and data reconciliation to validate conversion accuracy
Resolve and troubleshoot technical problems arising during software operation, implementation, conversion, and migration
Provide pre- and post-effective conversion support to business clients
Develop and maintain documentation including ETL mappings, data dictionaries, business cases, and data migration strategy and plans
Establish strong working relationships with clients and interact effectively at all levels of the organization

Must-Have Requirements

7+ years of experience developing and documenting ETL processes for data conversion and migration projects
Extensive experience with data migration and migration planning in the context of digital transformation, including migrating data from legacy applications to modernized solutions
Extensive experience with relational database structures and RDBMS platforms including Oracle, MS SQL Server, and Azure SQL Database
Ability to write complex SQL queries and conduct data analysis, data validation, and resolve complex technical problems
Experience migrating document and file attachments from legacy solutions to new modernized platforms
Experience working with cloud database technologies, specifically Azure SQL
Experience working with ETL tools such as Azure Data Factory, Informatica, or equivalent enterprise ETL platforms
Experience developing technical documentation including ETL mappings, data dictionaries, data migration strategies, and migration plans
Knowledge and understanding of Information Management principles, concepts, policies, and practices
Strong understanding of master data and transactional data concepts and their interdependencies

Nice-to-Have Skills

Full life-cycle data conversion experience with enterprise systems, including deployment
Experience with all phases of data migration including profiling, mapping, developing migration solutions, validation, and audit
Proficiency in query languages including SQL and PL-SQL, including construction of complex query statements
Knowledge of mainframe data formats, data types, segments, and non-relational data structures
Experience ensuring data migration solutions are designed for scalability
Strong data analysis, investigative, and logic skills with high attention to detail
Experience with data conversion scripts and a variety of ETL tools such as Informatica and Azure Data Factory
Experience liaising with cross-functional teams to define and understand to-be migration requirements
Experience completing mapping, interfaces, conversion work, and verifying completeness and accuracy of converted data
Experience supporting cutover processes and delivering required system changes in coordination with development or dedicated conversion teams
Proven track record of meeting deadlines and managing competing priorities in client-facing environments
Strong communication, facilitation, negotiation, consensus-building, and problem-solving skills

Work Environment

This is a fully onsite position located at 21 College Street, Toronto. The consultant is expected to work 7.25 hours per calendar day between 8:00 AM and 5:00 PM (excluding breaks), Monday to Friday. A Security Level of CRJMC is required for this role. Please note that the start date is subject to change based on security clearance and contract signing timelines.

Previous Job Job Listings Next Job

Final role details, responsibilities, and terms will be confirmed with shortlisted candidates. Compensation may vary based on experience. Errors and omissions excepted.

Apply About employer

More about this job

Responsibilities

Design and implement ETL solutions to migrate data and files from legacy systems to modernized platforms, including profiling, mapping, conversion, validation, and reconciliation. Troubleshoot migration issues, support clients before and after conversion, and maintain migration documentation and plans.

Requirements

Requires at least 7 years of experience developing and documenting ETL processes, with extensive experience in enterprise data migration, relational databases, complex SQL, and Azure SQL. Candidates must also have experience migrating document attachments, using enterprise ETL tools, and applying information management principles.

Skills

ETL Development
Data Migration
Data Profiling
SQL
Oracle
Microsoft SQL Server
Azure SQL Database
Azure Data Factory
Informatica
Data Mapping
Data Validation
Data Reconciliation
Data Cleansing
Data Analysis
Technical Documentation
Information Management

Visa sponsorship

Not detected in the job text

Keywords

ETL
Data Migration
Digital Transformation
Data Profiling
Data Mapping
Data Conversion
SQL
PL-SQL
Oracle
Microsoft SQL Server
Azure SQL Database
Azure Data Factory
Informatica
Relational Databases
Master Data
Transactional Data
Data Validation
Data Reconciliation
Data Cleansing
Data Dictionaries
Information Management
Legacy Systems
Mainframe Data Formats
File Migration
Mock Conversions
Cutover Support
Data Integrity
Public Sector
Ontario Public Service
CRJMC Security Clearance

Report this job