RQ10840 – Software Developer – ETL – Senior

Cyber-Infomax Solutions Inc.; Toronto; On-site; CAD 100,000 - 150,000; Full time

Job summary

The Ministry of Public and Business Service Delivery and Procurement seeks a data engineering specialist to design and develop data warehousing solutions with focus on extracting, transforming, and loading data from diverse sources into star/snowflake schemas.

You will automate complex ETL/ELT processes using PL/SQL and modern data tools, build denormalized data assets, and optimize performance across Oracle, SQL Server, MySQL, and PostgreSQL ecosystems.

Qualifications

• Experience designing and loading data into star/snowflake schemas.
• Proficiency building complex ETL/ELT pipelines with PL/SQL and related tools.
• Ability to de-normalize data, perform cleansing, and load to multiple DBMSs.
• Strong SQL skills across Oracle, MySQL, SQL Server; data modelling and query tuning.
• Experience with cloud platforms (Azure, Google, AWS) and Azure Data Factory.
• Hands-on with data migration/integration across Windows/UNIX environments.
• Experience with version control and issue tracking (GitHub, JIRA, Azure DevOps).
• Familiarity with Oracle RAC, OEM, Data Guard, and Exadata ecosystems.

Skills

Data warehousing design

ETL/ELT processes

PL/SQL

Python

Unix shell

Advanced SQL

Data modelling

Data migration

Data integration

Performance tuning

Oracle database

SQL Server

MySQL

PostgreSQL

Elasticsearch

Azure SQL Server

Azure Data Factory

Azure

JIRA

Azure DevOps

GitHub

Tools

Oracle OEM (OEM Cloud)

RMAN

SQL Server

Job description

Ministry of Public and Business Service Delivery and Procurement
Land & Resources Cluster
40 St. Clair West, Toronto

Must Have:

• 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 and recovery
• Elasticsearch for search/reporting, tuning for performance optimization
• Working knowledge of issue tracking system JIRA, Azure DevOps
• Using Git hub for version control and data model changes
• Oracle Enterprise Manager (OEM Cloud 12c, OEM 11g Grid), Oracle Names Server, Oracle Net Service, Oracle Connection Manager, and Oracle Advanced Security, Oracle RAC, Oracle Network, Names Server, Data Guard, Oracle Exadata, Oracle Warehouse Builder (OWB)
• PL/SQL Programming for database change tracking and data warehousing
• Data migration and data integration across different platforms (Windows to UNIX, Windows to Windows, UNIX to UNIX)
• /Recovery (Restore) and refresh production and Dev/UAT/Test using RMAN to SAN storage