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

#J-18808-Ljbffr

📌 – Software Developer – ETL – Senior (Ontario)
🏢 Cyber-Infomax Solutions
📍 Ontario