Oracle Cloud Integration Lead

Description :

Roles and 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 modelling 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.

- Take handover on all the technical components from the implementation partner migrated in

the production environment.

- Support and enhance development of custom solution built on Oracle Jet with WebLogic

framework.

- Support and enhance integrations built using Apex forms.

- Develop skillset of the members of the team to enhance their skill on the OIC, Apex, OJET, SQL, BIP etc.

- Introduce new technical ideas, inputs, expertise to enhance existing technical integrations

and solutions to improve data performance and user experience.

- Keep update on all the new technical capabilities introduced by Oracle in the ERP product

space and demonstrate useful cases for acceptance on the project where applicable.

- 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

- Identifies and applies creative and innovative approaches to resolving product

implementation and integration obstacles and problems.

- Design and develop OTBI reports, FRC reports and write basic data exactions queries using

SQL

- Support and manage all Finance and third-party integrations

- Establish/define reconciliation process and reports and support the business users during

month-end and year-end reconciliation process

- Design and define process wise custom fusion roles and provide the data access as

appropriate

- Should work with Oracle support team for application bugs/enhancements

- Should encourage the business to use Oracle standard functionalities and reports

- Mapping business requirements and translating these requirements into Oracle Applications

functional specifications.

- Develop unit test scripts and coordinate User Acceptance Testing of the system enhancements or custom solutions.

Required Qualifications & Skills :

- Minimum of 5 years' experience as an Integration consultant

- Minimum 2 full life cycle implementations of OIC and 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

- High attention to details.

- Employs technical expertise, and interpersonal relations to interact with senior level,

stakeholders and external providers, and to execute initiatives/changes that achieves

companys objectives.

- Demonstrates the ability to contribute and successfully deliver against business strategy and set KPIs.

- Experience with business requirements, technical analysis and design, coding, testing, and

implementation of customization within software environment

- Proven ability to be self-directed and operate effectively in a fast-paced, high-energy environment