Senior Software Developer ETL

Source Code; Toronto; Hybrid; CAD 80,000 - 100,000; Full time

Job summary

A leading software development firm in Toronto is seeking a Sr. Software Developer to design and implement data pipelines and ETL processes. The ideal candidate will have advanced expertise in PL/SQL and experience with Azure SQL Server and cloud technologies. This hybrid role requires 3 days onsite and offers the opportunity to troubleshoot and resolve technical issues in a collaborative environment. Position starts on October 20, transitioning to full-time onsite by January 5.

Qualifications

• Experience with designing and optimizing data ETL/ELT processes.
• Advanced skills in PL/SQL for data management.
• Hands-on experience with Azure cloud technologies.

Responsibilities

• Design and implement data pipelines for extraction, transformation, and loading.
• Translate technical specifications into tested applications.
• Resolve technical issues during software operation.

Skills

ETL/ELT processes

PL/SQL

Cloud technologies

Azure SQL Server

Azure Data Factory

JIRA

Azure DevOps

Job description

About the job RQ09525 - Sr. Software Developer - ETL

Downtown, Toronto

Hybrid - 3 days onsite and 2 days remote. Starting October 20, resources are expected to come into the office 4 days per week. Starting January 5, resources are expected to come into the office 5 days per week. This is subject to change based on manager's discretion.

Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities.

Required to translate technical systems specifications into working, tested applications. This includes developing detailed programming specifications, writing and/or generating code, compiling data-driven programs, maintaining, and conducting unit tests.

Resolves and troubleshoots technical problems which arise during the use and operation of software packages, including technical assistance in implementation, conversion and migrations.

Must-Haves:

• Design, build, automate and optimize complex data ETL/ELT processes using PL/SQL and equivalent
• Cloud technologies (Azure, Google, AWS)
• Advanced skills and hands-on experience with Azure SQL Server and Azure Data Factory
• PL/SQL for data extraction, transformation, and loading, initial setup and other ETL experience management and support, such as troubleshooting, performance tuning, failover and recovery
• Working knowledge of issue tracking system JIRA, Azure DevOps