Senior ETL Engineer – Onsite Toronto, Azure Cloud Migration

Randstad Canada; Toronto; Sur place; CAD 110 000 - 140 000; Plein temps

Résumé du poste

Randstad Canada is seeking an experienced Senior Software Developer - ETL to lead end-to-end data and document migration for enterprise modernization. You will analyze, profile, cleanse, and transform legacy data into Azure cloud databases, and build automated migration pipelines using Azure Data Factory, Informatica, and SQL-based tooling.

This onsite Toronto role spans 10 months with close collaboration alongside DBAs and architects.

Qualifications

• 7+ years of ETL, data migration, and data integration experience.
• Experience leading end-to-end data migration projects to cloud databases.
• Strong SQL, PL/SQL, and performance-tuning skills across Oracle and SQL Server.
• Proven ability to architect and implement data profiling, cleansing, and validation strategies.
• Hands-on with Azure Data Factory or Informatica in cloud environments.
• Experience documenting migration strategies, data dictionaries, and mappings.

Responsabilités

• Design and oversee full-lifecycle data and file migration solutions.
• Profile, cleanse, and transform legacy data and attachments for cloud platforms.
• Build, configure, and maintain scalable ETL/ELT pipelines.
• Develop complex SQL/PL-SQL queries and data extraction scripts.
• Lead document attachment migration to cloud storage repositories.
• Create migration artifacts including mappings, data dictionaries, and interface definitions.
• Provide post-migration validation, reconciliation, and audit support.

Connaissances

ETL

Data Migration

SQL

PL/SQL

Azure Data Factory

Informatica

Data Profiling

Audit & Validation

Outils

Azure Data Factory

Informatica

Oracle

MS SQL Server

Azure SQL Database

Description du poste

Randstad Canada is seeking an experienced Senior Software Developer - ETL to lead end-to-end data and document migration for enterprise modernization. You will analyze, profile, cleanse, and transform legacy data into Azure cloud databases, and build automated migration pipelines using Azure Data Factory, Informatica, and SQL-based tooling.

This onsite Toronto role spans 10 months with close collaboration alongside DBAs and architects.