Senior Software Developer - ETL

Akkodis group; Toronto; Hybrid; CAD 90,000 - 130,000; Full time

Job summary

Akkodis group is looking for a Senior Software Developer – ETL Specialist in Toronto to contribute to impactful public sector data initiatives. The ideal candidate will have deep expertise in ETL design, particularly using Azure Data Factory and Informatica tools. This role offers an innovative environment for those eager to enhance data solutions.

Qualifications

• Proven experience with ETL design and development.
• Strong expertise in data transformation within Azure and Informatica.
• Hands-on experience with Azure roles and data quality resolution.

Responsibilities

• Design and develop ETL processes in Azure.
• Optimize performance of ETL workflows.
• Maintain and enhance data quality.

Skills

ETL design

Data transformation

Performance optimization

CI/CD (DevOps)

SQL Server stored procedures

Oracle PL/SQL

Azure Data Factory

Databricks

ETL pipeline development

Informatica tools

IBM Cognos

Microsoft Power BI

Job description

We are hiring a Senior Software Developer – ETL Specialist for our Client. This role is ideal for someone with deep expertise in ETL design and development, particularly within Azure and Informatica environments, and a strong understanding of data transformation and performance optimization.

Job Title:Senior Software Developer – ETL Specialist

Job Location:Toronto, ON/Hybrid

Job Description:

Must-Haves:

• Proven experience with CI/CD (DevOps) pipelines and concepts

• Strong expertise in SQL Server stored procedures and Oracle PL/SQL development

Key Requirements:

• Skilled in Azure Data Factory, Databricks, and complex data transformations

• Experience with Self-Hosted Integration Runtime, ETL pipeline development, and performance tuning

• Proficiency in using ADF Debugger and managing Azure roles

• Hands-on experience with Informatica tools (Workflow Manager, Repository Manager, Designer, Monitor)

• Experience developing with Logic Apps and Function Apps

• Familiarity with rapid application development (RAD) methodologies

• Strong background in maintaining and enhancing ETL workflows and resolving data quality issues

• Working knowledge of IBM Cognos and Microsoft Power BI for business intelligence reporting

This is a great opportunity to contribute to impactful public sector data initiatives in a fast-paced, innovative environment.