Solution Lead-Oracle Fusion

Job Purpose

The Applications Lead’s role is to supervise and maintain the organization’s repository of software applications through best practices and the appropriate staffing and management of a technical team. Team leaders are responsible for managing and overseeing the work of their teams
The Applications Lead is also responsible for planning, design, development, and deployment of information and software systems for business operations.
To provide support services to end users through various channels as required. Troubleshoots and remediates issues impacting the operation of the technology infrastructure to ensure continuity of business.

Key Result Responsibilities

Support and manage all OIC integrations, VBCS, PCS & App Composer deployed across all core fusion.

Manage end-to-end data integration implementations using Oracle technology.

ODI Administration and Load Balancing & Data warehousing concepts.

Database design, relational and dimensional data modeling skills.

Manage high data volume environments/performance tuning in ODI.

Build necessary queries, functions, packages, triggers and stored procedures in PL/SQL and T/SQL.

Build and manage data quality and governance policies and procedures.

Liaise with development teams on finalizing data models, data loading methodologies and data reconciliations tasks.

Manage building database scripts and integrate with release pipelines in Dev, UAT & Prod segments.

Support and manage all existing Custom solutions/processes built on PaaS

Build BI Reports, OTBI reports and write basic data exactions queries using SQL

Qualifications (Academic, training, languages)

Bachelor Degree in Computer Engineering/Computer Science/Information Technology.
ITIL Certified (Not mandatory)
Fluent in English Language.

Work Experience

Minimum of 5 years' experience as an Integration consultant

Minimum 2 full life cycle implementations of OIC

Oracle PaaS Certification is a plus.

Previous Project experiences in finance transformation

After go live support project experience.

Expert level using Oracle tools (Design Studio, Application Composer, Page Composer, Workflow – Approval Rules/Notifications, PL/SQL and Fusion Middleware Object Design, Development & Testing

Expertise in OIC, REST/SOAP Integration components

Experience with business requirements, technical analysis and design, coding, testing, and implementation of Extension within a software environment

Broad knowledge and deep domain experience within the Oracle PaaS/IaaS product