Senior ETL Developer: Azure Data Factory & Oracle

Rubicon Path; Toronto; Hybrid; CAD 90,000 - 120,000; Full time

Job summary

A leading tech firm in Toronto is seeking a Senior Software Developer specialized in ETL processes to join their team. You will be responsible for designing and implementing data pipelines using Azure services, optimizing existing ETL workflows, and collaborating with IT professionals throughout the software development lifecycle. Candidates are expected to have extensive experience with Azure Data Factory and Informatica, along with a strong background in SQL development. The role requires presence in the office three days a week.

Qualifications

• Extensive experience in gathering requirements for data transformations.
• Experience with Azure Data Factory and Informatica.
• Strong SQL/PLSQL skills required.

Responsibilities

• Develop data pipelines using Azure Data Factory and Informatica.
• Deliver detailed system design documents conforming to standards.
• Optimize performance of ADF pipelines and databases.

Skills

Data transformation

Azure Data Factory

Informatica

Logic App

Performance tuning

SQL Server

Oracle PL/SQL

Business Intelligence tools

Tools

Azure Data Factory

Informatica PowerCenter

Sybase Power Designer

Azure DevOps

Job description

A leading tech firm in Toronto is seeking a Senior Software Developer specialized in ETL processes to join their team. You will be responsible for designing and implementing data pipelines using Azure services, optimizing existing ETL workflows, and collaborating with IT professionals throughout the software development lifecycle. Candidates are expected to have extensive experience with Azure Data Factory and Informatica, along with a strong background in SQL development. The role requires presence in the office three days a week.