Senior Software Developer - ETL

Source Code; Toronto; Hybrid; CAD 85,000 - 110,000; Full time

Job summary

A tech company in Toronto is seeking a Sr. Software Developer to design and implement data pipelines through ETL processes. The role requires advanced skills in PL/SQL, Azure SQL Server, and cloud technologies (Azure, Google, AWS). Candidates must be adept at troubleshooting technical challenges in software operations. This position offers a hybrid work model with expectations for onsite presence starting from October 20. Competitive compensation will be provided.

Qualifications

• Proficiency in designing, building, and optimizing complex ETL processes.
• Hands-on experience with cloud technologies like Azure, Google, or AWS.
• Advanced knowledge of Azure SQL Server and Azure Data Factory.

Responsibilities

• Design and implement data pipelines through ETL processes.
• Translate technical specifications into tested applications.
• Troubleshoot technical problems during software operations.

Skills

ETL/ELT processes

PL/SQL

Cloud technologies (Azure, Google, AWS)

Azure SQL Server

Azure Data Factory

JIRA

Azure DevOps

Job description

About the job RQ09622 - Sr. Software Developer - ETL

RQ09622 - Sr. Software Developer - ETL

Downtown, Toronto (St. Clair W)

Hybrid - - Candidate MUST work 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 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