Oracle Integration Cloud( OIC Consultant )

Role & responsibilities

The Oracle Integration Cloud OIC Consultant P4 is responsible for designing developing testing and supporting integrations between Oracle Fusion Cloud applications ERP HCM SCM and external systems The role requires handson experience with OIC integrations adapters RESTSOAP services and production support along with strong troubleshooting and documentation skills

Key Responsibilities

Integration Design Development

Design and develop integrations using Oracle Integration Cloud OIC Gen2

Build and manage

AppDriven Integrations

Scheduled Integrations

Orchestrations

Lookups and Packages

Perform data mappings transformations and validations using OIC mapper

Implement reusable scalable integration patterns following Oracle best practices

Adapters Connectivity

Develop integrations using OIC adapters such as

ERP Cloud Adapter

HCM Cloud Adapter

REST Adapter

SOAP Adapter

FTP SFTP Adapter

DB Adapter

Handle filebased integrations inboundoutbound and APIbased realtime integrations

API Web Services

Design consume and expose REST and SOAP web services

Work with JSON XML XSD and WSDL payloads

Implement secure authentication mechanisms OAuth2 basic auth certificates

Error Handling Monitoring Support

Implement

Fault policies

Reusable error frameworks

Notifications and tracking

Monitor integrations and resolve

Data errors

Connectivity issues

Performance issues

Provide L2L3 production support and rootcause analysis

Support hypercare and post golive stabilization

Testing Deployment

Perform unit testing and support SIT UAT cycles

Fix defects and support retesting activities

Support migration across environments DEV TEST UAT PROD

Prepare deployment notes and rollback plans

Documentation Collaboration

Prepare and maintain

Integration Design Documents HLDLLD

Interface Control Documents ICD

Mapping specifications

Runbooks and support documentation

Collaborate with Functional Consultants VBCS teams and client stakeholders

Mandatory Skills Must Have

36 years of handson experience in Oracle Integration Cloud OIC

Strong expertise in

REST SOAP services

JSON XML XSD

Data mappings and transformations

Experience integrating with Oracle Fusion Cloud modules ERPHCMSCM

Strong troubleshooting and production support experience

Understanding of integration lifecycle and SDLC

Good to Have Skills

Oracle SOA Suite BPEL OSB MFT experience

Knowledge of OIC Gen2 advanced features

Exposure to Oracle ATP ADW

Experience with OCI services

OAuth2 certificates and cloud security concepts

Knowledge of BI Publisher extracts FBDI integrations

Skills

Mandatory Skills : Oracle Integration Cloud