Software Developer ETL

About the job
Role: Senior ETL Developer

Client: Ontario Government

Job Type: Contract

Term: 12 Months

Workplace Type: On-site

Pay Rate: $80.00 – $90.00

Start date: 2-3 weeks

Location: Toronto, ON

Language: English

Clearance: N/A

ATS ID #: 10462

Requirements: What you’ll need

Skills, Knowledge, Experience, and Qualifications:

ETL Development-Data Integration:

Extensive experience in gathering requirements and business process knowledge in order to design correct and high-quality data transformation.
Extensive experience in design, development, and implementation with Azure Data Factory, Databricks, including:
Self-Hosted Integration Runtime
Data movement, ETL pipelines
Performance tuning on large data volumes
Complex data transformations
ADF Debugger to validate data transformation.
Azure Roles
Experience with Informatica, including:
Workflow Manager
Repository Manager
Designer
Workflow Monitor
Experience with developing solutions using Logic App and Function App.
Experience in rapid application development (RAD) methodologies.
Experience in maintaining and improving existing ETL processes.
Experience in investigating data to identify potential issues within ETL pipelines.
Experience with Business Intelligence tools IBM Cognos and Microsoft PowerBI.
Azure Technologies:

Experience with CI/CD (DevOps) pipelines and concepts, including:
Azure Resource Management
GitHub Repo
Source code version control
Branching, pull requests, build, release, multiple parallel development repositories merge.
Experience with Azure DevOps, including:
Azure Boards
Azure Test Plans
Azure Pipelines
Azure Repos
Azure Artefacts
Oracle PL/SQL Development:

Extensive experience in designing and developing SQL Server Stored Procedure, Oracle PL/SQL programs.
Database Technologies:

Experience with Oracle, Microsoft SQL Server database and tools.
Experience with relational and hierarchical database technologies.
Extensive knowledge of Azure SQL DB and Synapse platforms, including:
Performance tuning on large data volume
 

Must haves:

Extensive experience in design, development, and implementation with Azure Data Factory, Databricks or Informatica.
Experience with CI/CD (DevOps) pipelines
Extensive experience in designing and developing SQL Server Stored Procedure, Oracle PL/SQL programs.
Experience with Oracle, Microsoft SQL Server database and tools.
 

PREFERRED SKILLS

Azure Data Factory + CI/CD + SQL + Oracle PL/SQL + Microsoft PowerBI + ETL + Informatica

HOW TO APPLY

Patrick Marsan is hiring for this position. Apply through LinkedIn or careers@wirehead.com

Learn more about our culture at wirehead.com/careers

We’re a Human and Contingency Workforce Management company, meaning we use artificial intelligence to improve all of our operations. In recruitment, AI helps us streamline the process for greater efficiency. However, we’ve built our systems to ensure that a human always reviews AI-generated output, and we never make automated hiring decisions.

Disclaimer: We only communicate with candidates through official @wirehead.com email addresses.

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 – 2026 | Wirehead Talent | All rights reserved