Core 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
Lead the design and development of SAS-based products, ensuring alignment with business requirements.
Actively contribute in an Agile environment, participating in sprints, stand-ups, and retrospectives.

Essential:

Bachelors degree in Computer Sciences or equivalent or a related discipline
Minimum of 5 years' experience as an Integration consultant
Minimum 2 full life cycle implementations of OIC
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.

Oracle Integration Consultant