Systems Integrator Job Toronto area,Ontario Canada,IT/Tech

Position: SYSTEMS INTEGRATOR 1

Responsibilities

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.

Key

Qualifications:

Your application must describe your qualifications as they relate to:

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.

You must also have:

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, create and implement procedural steps that support, maintain and enhance the Oracle Fusion Middleware (OFM) / Oracle Analytics Server (OAS), OBIEE & ODI environment, including developing Automated Scripts/ procedures and portlets.

Ability to develop and implement procedures that enable proactive problem detection and avoidance, including disaster recovery planning and implementation.

Ability to work effectively with a group of multidisciplinary staff in a project team setting.

Ability to effectively communicate both orally and in writing.

Strong analytical and problem-solving skills, listening and interacting skills are essential.

Strong customer service orientation.

Ability to work with competing demands prioritizing and meeting deadlines.


Increase/decrease your Search Radius (miles)



Job Posting Language