Systems Integrator

Job : 58767,
Job Category: Information & Technology,
Division & Section: Public Health, Operations & Business Services,
Work Location: 65 Front St W, Toronto, M5J 1E6,
Job Type & Duration: Full-time, Temporary 16 months Vacancy, Possibility of extension,
Hourly Rate and Wage Grade: $52.38- $57.39,
Shift Information: Monday to Friday, 35 hours per week, 7 hours per day,
Affiliation: L79 Full-time,
Number of Positions Open: 1,
Posting Period: 5-Jan-2026 to 19-Jan-2026,
HR Contact: Bushra Sani, ,
Division Contact: Nikhil Prasad, .

• Plans, support & implement Oracle Enterprise Data warehouse (EDW) related applications, Oracle Business Intelligence Enterprise Edition (OBIEE);
  Map viewer, Oracle Web Logic server;
  Oracle Data Integrator (ODI), and data integration via Extract‑Transform‑Load (ETL) environment for all stages (Development, Test / UAT, Production).
• Using Oracle OBIEE repository (RPD) to create, customize and maintain the End User Layers (Presentation Layer, Physical layer, Business Model & Mapping Layer), creates / updates business subject areas and folders, and defines analytical facilities (semantic layer) for end users, control & maintain the user access.
• Analyzes and develops standard and ad‑hoc/BI reports using Oracle tools (OBIEE).
• Evaluates the performance, systems log, installs and configures multi‑tiered Oracle Application Server (OAS), Oracle Business Intelligence (OBIEE) and Oracle data integrator (ODI) environment on Linux platform.
• Identifies risks and prepares action plans to mitigate.
• Liaises and co‑ordinates with internal & external groups / vendors on accomplishment of deliverables.
• Prepares and presents status report of DW environments and explanation for variances, issues, projects or work packages.
• Prepares findings & “Lessons Learned” from post‑implementation reviews, trouble shootings and root‑cause analysis.
• Assesses, analyzes, evaluates and recommends process & policy alternatives for BI & DW projects & work packages.
• Assist in preparation of DW Logical Data Models and Design documents for proposed solutions that leverage existing DW Start Schema model.
• Updates / maintains Data Warehouse databases / data models using Data modelling tool;
  Ensures data integrity and validation rules in ETLs.
• Provides input to BI & DW development team on transformation of clients’ business requirements.
• Recommends improvements to current methodology, process, standards, and policies.
• Assists staff in development implementation for OBIEE, ODI and repository (RPD) using MUD (multi‑user development) environment.
• Liaises with staff in development of test strategy, test cases & test scripts for system performance, usability and acceptance testing of system solutions developed.
• Leads team to draft implementation & rollout strategies and plans.
• Conducts walk‑through of deliverables to identify potential problems.
• Prepares training material and documentation for use by end users and staff.
• Collaborates with clients on “Go/No Go” cut‑over decisions, e.g., rollouts.

• University degree in computer science or the approved equivalent combination of education and/or experience.
• Extensive experience in Oracle Business Intelligence (OBIEE) Or Oracle Analytics Server (OAS), and Oracle Data Integrator (ODI) Administration, performance monitoring/tuning, managing Oracle Web Logic in multi‑tier High‑availability architecture / environment.
• Considerable experience in OBI Administration Tool (RPD) and OBIEE security setup including LDAP (e‑Directory, MSAD) integration.
• Considerable experience with Oracle database (OLTP and OLAP) administration / expert usage, and shell scripts.

• Technical knowledge for Oracle BI, ODI and J2EE/Web Logic applications and in security components.
• Ability to install, configure and administer the Oracle Fusion Middleware (OFM) in enterprise environment on UNIX/Linux server operating systems.
• Ability to work with Oracle 19c, its sustainment, implementation and integration with single sign‑on authentication mechanisms including MSAD, LDAP, e‑Directory, Oracle Internet Directory.
• Ability to perform logical and physical application server designs,…