Job Title : Oracle Integration Cloud (OIC) Technical Consultant

Experience : 5 - 9 Years

Employment Type : Full-Time / Contractual

Job Category : Software Development / Integration Engineering

Domain : Oracle Cloud Technologies

Job Summary :

We are looking for an experienced Oracle Integration Cloud (OIC) Technical Consultant with 4 - 8 years of hands-on experience in designing, developing, implementing and supporting cloud-based integrations using Oracle Integration Cloud.

The ideal candidate should have strong expertise in OIC integration patterns, REST and SOAP APIs, database integrations, FTP operations and Oracle Fusion ERP integrations.

The candidate will be responsible for developing scalable integration solutions, managing data flows between enterprise applications and ensuring seamless connectivity across Oracle Cloud and third-party systems.

The role requires strong technical knowledge of integration components, error handling, troubleshooting and deployment, along with working knowledge of SQL and PL/SQL.

Key Responsibilities :

1. Oracle Integration Development :

- Design, develop and maintain integrations using Oracle Integration Cloud (OIC).

- Implement integration workflows using Stage File, Local Integration Invoke, Wait and Fault Handler activities.

- Configure triggers, invokes, connections and integration patterns.

- Develop synchronous and asynchronous integrations based on business requirements.

- Configure lookups and reusable integration components.

2. API & Application Integrations :

- Develop and manage REST and SOAP-based integrations.

- Configure and manage database, FTP, ERP and other application connections.

- Implement FBDI-based and web service-based integrations with Oracle Fusion applications.

- Ensure seamless data exchange between Oracle Cloud and external enterprise systems.

- Work with JSON, XML and other data formats for integration requirements.

3. Monitoring & Troubleshooting :

- Monitor integration execution and identify failures or performance issues.

- Debug and troubleshoot integration errors.

- Implement appropriate fault-handling mechanisms and exception management.

- Manage certificates, security configurations and connection-related issues.

- Perform integration migration across development, testing and production environments.

4. Database & Technical Support :

- Write and execute SQL queries for database integrations and data validation.

- Apply basic PL/SQL concepts wherever required.

- Perform integration testing and support deployment activities.

- Collaborate with functional consultants, technical teams and business stakeholders.

- Maintain technical documentation and ensure quality deliverables.

Required Skills & Qualifications :

- 4 - 8 years of experience in Oracle Integration Cloud development.

- Strong hands-on expertise in OIC integration development and configuration.

- Good understanding of integration patterns, triggers, invokes and connection management.

- Experience with Stage File, Local Integration Invoke, Wait and Fault Handler activities.

- Hands-on experience with REST, SOAP, FTP and database integrations.

- Experience in FBDI and Oracle Fusion ERP integrations.

- Knowledge of SQL and basic PL/SQL.

- Experience in integration monitoring, debugging, migration and error handling.

- Understanding of security configurations and certificate management.

- Strong analytical, troubleshooting and problem-solving skills.

- Excellent communication and collaboration abilities.