ETL Developer

Location: Toronto, ON (Hybrid, 4 days per week on-site at 87 Sir William Hearst Ave.)

Language: Excellent written and verbal English communication skills

Duration: Contract

Background Check Requirement: Must be eligible to meet applicable government security screening requirements. Previous Ontario Public Service (OPS) experience is mandatory.

Join a high-impact public sector team focused on delivering modern, reliable data integration solutions that support critical government services. This opportunity is ideal for an experienced ETL and Azure Data Developer who thrives in complex technical environments and enjoys transforming business requirements into scalable, high-quality data solutions.

Working alongside cross-functional technical and business teams, you'll contribute to the design, development, and enhancement of enterprise data platforms. Your expertise will help drive innovation, improve data quality, and support informed decision‑making across the organization.

You'll have the opportunity to work on meaningful projects that leverage modern Azure technologies while collaborating with experienced professionals in a highly collaborative environment.

This role offers exposure to enterprise-scale data initiatives, the chance to contribute to continuous improvement, and the opportunity to expand your expertise in cloud‑based data integration, Dev Ops, and business intelligence solutions.

• Design, develop, and implement enterprise ETL solutions using Azure Data Factory, Databricks, Logic Apps, and Function Apps.
• Build and maintain data movement pipelines, perform complex data transformations, and optimize performance for large data volumes.
• Enhance and support existing ETL processes by troubleshooting issues, validating data transformations, and improving overall reliability.
• Develop database solutions using Oracle PL/SQL and SQL Server stored procedures to support business and operational requirements.
• Contribute to Azure Dev Ops CI/CD pipelines, source control, and deployment processes using Git Hub, Azure Repos, Azure Pipelines, and Azure Resource Manager.
• Collaborate with business stakeholders to gather requirements and deliver scalable, high-quality data integration solutions.
• Support reporting and analytics initiatives using IBM Cognos and Microsoft Power BI.

• Previous Ontario Public Service (OPS) experience is required.
• Extensive experience designing and developing ETL solutions using Azure Data Factory and Databricks, including Self‑Hosted Integration Runtime, ETL pipelines, performance tuning, complex data transformations, Azure Roles, and ADF Debugger.
• Hands‑on experience with Informatica, including Workflow Manager, Repository Manager, Designer, and Workflow Monitor.
• Experience developing solutions using Logic Apps and Azure Function Apps, along with Rapid Application Development (RAD) methodologies.
• Strong experience with Azure Dev Ops, CI/CD concepts, Azure Boards, Azure Test Plans, Azure Pipelines, Azure Repos, Azure Artifacts, Git Hub, and source code version control.
• Extensive experience developing Oracle PL/SQL programs, SQL Server stored procedures, and working with Oracle, Microsoft SQL Server, Azure SQL Database, Synapse, and relational and hierarchical database technologies.
• Strong analytical, problem‑solving, and communication skills with the ability to work effectively in collaborative technical environments.

We welcome individuals of all backgrounds, experiences, and identities including those who identify as women, members of racialized groups, Indigenous Peoples, persons with disabilities, and 2

SLGBTQIA+ communities. If you require an accommodation, please review our accessibility policy and reach out to our accessibility officer with any questions. All qualified applicants will receive fair consideration for employment.