Ministry of Public and Business Service Delivery and ProcurementLand & Resources Cluster40 St. Clair West, TorontoMust Have:Data warehousing design and development with focus on extracting, transforming data coming from various data sources and loading into star/snowflake schemasDesign, build, automate and optimize complex data ETL/ELT processes using PL/SQL and equivalentWriting 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, administrationAdvanced 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 FactoryProficient in creating Data Factory pipelines for copy activity and custom Azure developmentPL/SQL for data extraction, transformation, and loading, initial setup and other ETL experience management and support, such as troubleshooting, performance tuning, failover and recoveryElasticsearch for search/reporting, tuning for performance optimizationWorking knowledge of issue tracking system JIRA, Azure DevOpsUsing Git hub for version control and data model changesOracle 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 warehousingData 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

📌 Rq10840 – Software Developer – Etl – Senior (Toronto)
🏢 Cyber-Infomax Solutions
📍 Toronto