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