Jobs in Canada

Group jobs by employerEmail me new jobs Save this search

Added 18 days ago
C
Technology, Production Support, Full Time Analyst, Mississauga, Canada, 2027
Citi
Mississauga, ON
- Full-time
Elevate your technical skills: As a Production Support Analyst, you'll master Linux/Unix, hone database expertise (SQL, Oracle, PostgreSQL), and build automation with Python. You'll gain…
Added 18 days ago
CO
Temporary Solutions Integration Specialist (up to 8 months)
City of Saint John
Saint John, NB
- Temporary
Must possess exceptional problem solving, critical thinking and analytical skills to troubleshoot and resolve issues and challenges · Must have a demonstrated understanding of the underlying concepts of project management methodologies
Added 18 days ago
CO
Application & Integration Technical Analyst
City of Saint John
Saint John, NB
- Full-time
Must have Class 5 driver’s license
Added 18 days ago
I-
Senior ETL Developer
I8IS - Infiniti Software Solutions
Toronto, ON
- Full-time
Strong experience with relational database management systems, including Oracle, Microsoft SQL Server, and Azure SQL Database.
Added 18 days ago
MI
Senior ETL Developer
Maarut Inc
Toronto, ON
- Contract
Extensive experience with various database structures and RDMS like Oracle, MS SQL Server, Azure SQL Database, and write complex SQL queries, conduct data analysis, data validation, and…
Added 18 days ago
SL
Data Engineer
Staffingine LLC
Toronto, ON
- Full-time
Ideal Candidate Profile: A hands-on Data Engineer with strong Databricks, Python, Azure database, and Oracle experience. AI experience will be an added advantage.
Added 18 days ago
C
Consultant Data Developer
CIBC
Toronto, ON
- Full-time
You need to be legally eligible to work at the location(s) specified above and, where applicable, must have a valid work or study permit
Added 18 days ago
C
Senior Application Developer
CIBC
Toronto, ON
- Full-time
As a member of CIBC’s team, the Senior Application Developer is responsible for the detailed technical design and development of applications using various technology platforms. The role…
Added 18 days ago
VS
Full Stack Developer (Java/React)
vTech Solution Canada
Toronto, ON
- Contract
Must have these technical skills:
Added 18 days ago
TC
SQL Developer
Tata Consultancy Services
Toronto, ON
- $90,000 to $120,000 CAD / year
- Full-time
Design, develop, and maintain complex SQL queries, stored procedures, functions, and database objects.
Added 18 days ago
C
Consultant, Databricks Developer
CIBC
Toronto, ON
- Full-time
You need to be legally eligible to work at the location(s) specified above and, where applicable, must have a valid work or study permit
Added 18 days ago
KR
Spring Boot Technical Consultant
KTek Resourcing
Montreal, QC
- Contract
Experience working with relational databases (Oracle, PostgreSQL)
Added 18 days ago
C
Technology Lead Analyst – Infrastructure Orchestration
Citi
Mississauga, ON
- Full-time
…middleware (e.g., Apache, Tomcat, IBM MQ, Kafka, Nginx) and database technologies (e.g., Oracle, PostgreSQL, MongoDB,…
Added 19 days ago
CO
Job ID #32294: Network Analyst II - Datacentre Operations
City Of Hamilton
Hamilton, ON
- Full-time
Added 19 days ago
I-
Senior Full Stack Developer
I8IS - Infiniti Software Solutions
Toronto, ON
- Full-time
Work Arrangement: Onsite – 5 days per week
Added 19 days ago
HD
Health Information Data Analyst
Hotel Dieu Shaver Health and Rehabilitation Centre
St. Catharines, ON
- Full-time
Work with clinicians to correctly reassign documentation to the proper account within Oracle/ Millenium.
Added 19 days ago
CO
Temporary Solutions Integration Specialist (up to 8 months)
City of Saint John
Saint John, NB
- Temporary
Must possess exceptional problem solving, critical thinking and analytical skills to troubleshoot and resolve issues and challenges · Must have a demonstrated understanding of the underlying concepts of project management methodologies
Added 19 days ago
CO
Application & Integration Technical Analyst
City of Saint John
Saint John, NB
- Full-time
Must have Class 5 driver’s license
Added 19 days ago
LI
Software Developer - ETL - Senior
Lotus IT Solutions
Toronto, ON · Greater Toronto Area, Canada
- Contract
Extensive experience with relational database structures and RDBMS platforms including Oracle, MS SQL Server, and Azure SQL Database
Added 19 days ago
LI
Senior Software Developer - Full Stack
Lotus IT Solutions
Toronto, ON
- Contract
This is a fully onsite role based at 222 Jarvis St., 5th Floor, Toronto, Ontario (5 days per week onsite)
Added 19 days ago
SM
RQ11657 – Software Developer – Senior
S M Software Solutions Inc
Toronto, ON
- Internship
Work Arrangement: Onsite – 5 Days per Week · Must have the following technical skills:
Added 19 days ago
B
Business Intelligence Specialist - Oracle
Bevertec
Toronto, ON
- $90 to $95 CAD / hour
- Contract
Public Sector Experience: must have
Added 19 days ago
E
MuleSoft Integration Developer
Experis
Calgary, AB
- Contract
Experience with relational databases, SQL, and database integrations, preferably Oracle.
Added 19 days ago
O
Senior Technical Program Manager
Oracle
Canada
- Full-time
Hands-on experience with OCI, Oracle Analytics Cloud, Fusion Data Intelligence, Oracle AI Data Platform, Autonomous Database/Data Warehouse, data integration, or related Oracle data and…
Added 19 days ago
P
Software Engineer
ProxyLink
Toronto, ON
- Contract
ProxyLink is hiring an experienced Software Developer to design, develop, enhance, maintain, and support enterprise applications and technology platforms. The successful candidate will have…

Lotus IT Solutions

Software Developer - ETL - Senior

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

Contract

Apply on LinkedIn 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 on LinkedIn 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

Work requirements

Jobs in Canada