Project Overview

Key Responsibilities

- Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities.
- Translate technical systems specifications into working, tested applications, including developing detailed programming specifications, writing and/or generating code, compiling data-driven programs, maintaining, and conducting unit tests.
- Resolve and troubleshoot technical problems which arise during the use and operation of software packages, including technical assistance in implementation, conversion and migrations.

Qualifications & Requirements

- Must be able to work 3 days onsite per week
- Data warehousing design and development with focus on extracting, transforming data coming from various data sources and loading into star/snowflake schemas
- Design, build, automate and optimize complex data ETL/ELT processes using PL/SQL and equivalent
- Writing complex procedures/pkg/views/scripts to do data de-normalization, data extraction,



data transformation(cleansing), and data loading.
- Creating data assets (denormalized) from highly normalized Oracle database, and load the data asset to another type of DBMS (Microsoft SQL DBs, Postgress, etc.)
- Relational databases (Oracle, MySQL, SQL Server), data modelling (relational & dimensional), advanced SQL, query optimization, data replication, administration
- Advanced SQL skills (PL/SQL, TSQL)
- Scripting languages (Python, Unix shell)
- Cloud technologies (Azure, Google, AWS)
- Advanced skills and hands on experience with Azure SQL Server and Azure Data Factory
- Proficient in creating Data Factory pipelines for copy activity and custom Azure development
- PL/SQL for data extraction, transformation, and loading, initial setup and other ETL experience management and support, such as troubleshooting, performance tuning, failover

📌 Software Developer - ETL (Toronto)
🏢 GovTech Talent Solutions
📍 Toronto