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.

Contract 6 months, possible extension

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

Nice-To-Have:

• Public Sector experience