Senior ETL & Data Integration Engineer

Rubicon Path; Toronto; On-site; CAD 85,000 - 105,000; Full time

Job summary

A leading software development firm in Toronto is seeking a Senior Software Developer specialized in ETL and Azure Data Factory. The role involves designing data pipelines, collaborating with cross-functional teams, and ensuring high-quality data transformation. Candidates should have extensive experience with SQL Server, Oracle PL/SQL, and Business Intelligence tools. This position offers competitive salary and development opportunities.

Qualifications

• Extensive experience in gathering requirements and business process knowledge for high-quality data transformation.
• Experience with CI/CD pipelines and concepts.
• Extensive knowledge of Azure SQL DB and Synapse platforms.

Responsibilities

• Participate in project reviews and deliver system design documentation.
• Implement data pipelines using Azure Data Factory and Informatica.
• Collaborate with IT professionals throughout the project lifecycle.
• Optimize performance of ETL pipelines and databases.

Skills

ETL Development

Azure Data Factory

Data Transformation

Oracle PL/SQL

Business Intelligence Tools

SQL Server

Tools

Azure Data Factory

Informatica

Logic App

Function App

SQL Server

Oracle

Microsoft SQL Server

Databricks

IBM Cognos

Microsoft PowerBI

Job description

A leading software development firm in Toronto is seeking a Senior Software Developer specialized in ETL and Azure Data Factory. The role involves designing data pipelines, collaborating with cross-functional teams, and ensuring high-quality data transformation. Candidates should have extensive experience with SQL Server, Oracle PL/SQL, and Business Intelligence tools. This position offers competitive salary and development opportunities.