Senior ETL Developer

About the job
Role: Senior ETL Developer

Client: Government, Broader Public Sector

Job Type: Contract

Term: 12 Months

Workplace Type: Hybrid / Onsite

Pay Rate: Negotiable

Start date: 2-3 weeks

Location: Toronto, ON

Language: English

Clearance: N/A

ATS ID #: 9596

Hi there! Thanks for stopping by 👋

Interested in working with us in the future?

members who share and follow a company they’re interested in, like Wirehead, are 5x more likely to receive a message from a recruiter than those who don’t.

Requirements: What you’ll need

Skills, Knowledge, Experience, and Qualifications:

Core Qualifications

10+ years of experience in ETLdevelopment and data migration, preferably in complex or regulated environments.
Strong expertise with Oracle databases and Azure SQL.
Proven hands-on experience with Azure Data Factory(ADF) including pipeline orchestration and transformation flows.
In-depth understanding of data quality, auditability, schema mapping, and rollback planning.
Technical Proficiency
Advanced SQL(PL/SQL, T-SQL), ADF Data Flows, Triggers
Tools: PowerDesigner, Excel, Azure DevOps, Git
Familiarity with transformation formats such as Parquet and knowledge of incremental loads, CDC strategies
Experience with CI/CD deployment automation for ETL artifacts

Nice to Have

Experience working on public sector or regulated industry data projects
Knowledge of data governance, privacy, and retention policies
Exposure to other ETL or orchestration platforms (AWS Glue, Informatica, GCP Dataflow)

Must Haves:

Experience design, build, and maintain ETL pipelines using Azure Data Factory (ADF) to support secure and efficient data migration between different databases.
Experience in data cleansing, transformation, and field mapping to ensure high-quality, audit-ready data.
Proven hands-on experience with Azure Data Factory (ADF) including pipeline orchestration and transformation flows.
Experience with CI/CD deployment automation for ETL artifacts

Key Responsibilities:

Design, build, and maintain ETL pipelines using Azure Data Factory (ADF) to support secure and efficient Oracle-to-Azure data migration.
Lead efforts in data cleansing, transformation, and field mapping to ensure high-quality, audit-ready data.
Deploy and validate ETL processes across multiple environments (Dev, Test, UAT, Prod).
Troubleshoot and optimize ETL jobs, implement rollback strategies, and ensure performance at scale.
Document processes, data models, exception handling logic, and support runbooks for ongoing operations.
Collaborate with internal stakeholders, including data analysts, solution architects, and business users.
 

Key Deliverables:

Production-ready ETL pipelines that meet enterprise architecture and security standards
Support in the documentation of transformation logic, field mappings, and exception rules, in collaboration with business and data teams
Successfully validated data migrations with audit trail capabilities and performance metrics
Tested and deployable ETL scripts and configuration artifacts to support production readiness

HOW TO APPLY

Patrick Marsanis hiring for this position.

**Please ensure you send me a connection and follow Wirehead to be considered.

Follow Wirehead on LinkedIn

Interested in working with us in the future?

members who follow a company they’re interested in, like Wirehead, are 5x more likely to receive a message from a recruiter than those who don’t.

We thank all candidates for their interest but advise that only candidates selected for interviews will be contacted. Rest assured that your resume will be kept on our database and will be considered for all future opportunities.

Applicants must be authorized to work in Canada.

Copyright 2007 – 2025 | Wirehead Talent | All rights reserved