Senior ETL Migration Engineer

Source Code; Toronto; On-site; CAD 110,000 - 140,000; Full time

Job summary

Source Code in Toronto is seeking a Sr. Software Developer - ETL for a 1-year onsite contract. You will lead end-to-end data migration from legacy systems, design interfaces, and ensure data integrity across Oracle, MS SQL Server and Azure SQL Database.

The role requires senior ETL expertise, strong SQL, and client-facing collaboration. Responsibilities include data profiling, mapping, mock conversions, and post-migration reconciliation, with scope spanning complex data sources and files

Qualifications

• 7+ years of experience in developing and documenting ETL for data conversion and migration.
• Extensive experience in data migration and migration planning in terms of digital transformation, ETL experience in migrating data from legacy applications to modernized solutions.
• 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 solve complex technical problems.
• Experience in migrating document attachments from legacy solution to a new modernized solution.
• Experience working in cloud DB technologies (such as Azure SQL).
• Experience working with ETL tools such as Azure Data Factory, Informatica, etc.
• Experience in development of documentation such as ETL mappings, data dictionaries, business case, data migration strategy and plan.

Responsibilities

• Provide best practice migration solutions and oversee all facilities of the data and files migration from legacy application to a new solution.
• Establish a strong working relationship with clients, interact effectively at all levels and analyses legacy data and files stored in a variety of data sources and formats.
• Analyze and complete data profiling and suggest any pre migration data cleansing activities.
• Complete data migration strategy, data mapping, define interfaces, perform mock conversion, define enhancements and perform actual conversion.
• Translate technical systems specifications into working, tested applications; develop detailed programming specifications, write/generate code, compile data-driven programs, and perform unit tests.
• Resolve and troubleshoot technical problems during implementation, conversion and migrations.
• Work with importing files from heterogeneous platforms and coordinate data file migration.
• Define testing strategy, plan and conduct testing to ensure data integrity and data comparisons.
• Perform post migration audit and data reconciliation.
• Generate data migration exception reporting and perform data cleansing as required.
• Provide pre- and post-effective conversion support to business clients.

Skills

ETL development

Data migration planning

Data profiling

Data mapping

SQL/PL-SQL

Data analysis

Client interaction

Tools

Oracle

MS SQL Server

Azure SQL Database

Informatica

Azure Data Factory

Job description

Source Code in Toronto is seeking a Sr. Software Developer - ETL for a 1-year onsite contract. You will lead end-to-end data migration from legacy systems, design interfaces, and ensure data integrity across Oracle, MS SQL Server and Azure SQL Database.

The role requires senior ETL expertise, strong SQL, and client-facing collaboration. Responsibilities include data profiling, mapping, mock conversions, and post-migration reconciliation, with scope spanning complex data sources and files