MonoSpear Technologies - Oracle Integration Cloud Technical Consultant

Job Title : Oracle Integration Cloud (OIC) Specialist

Location : Remote

Experience Level : 2 - 6 years

Job Summary :

We are looking for an experienced Oracle Integration Cloud (OIC) Specialist to join our growing team. The ideal candidate will have a strong understanding of OIC integration patterns and a proven track record in implementing and managing integrations across a variety of Oracle and third-party systems. This role requires hands-on experience in designing, developing, deploying, and maintaining integrations using OIC components and capabilities.

Key Responsibilities :

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

- Configure OIC connections including Trigger, Invoke, and Trigger & Invoke roles

- Handle fault management using OIC Fault Handlers and implement exception handling

- Implement activities like Stage File (list files, zip/unzip), Local Integration Invoke, Wait, Fault, etc.

- Create and manage integrations using SOAP, REST, DB, FTP, and ERP adapters

- Develop integrations based on FBDI or web service-based approaches

- Monitor, debug, and migrate OIC integrations across environments

- Configure and manage Lookups, and optionally Libraries, Certificates, and Key Stores

- Optimize performance for large file processing and segment read strategies

- Implement encryption/decryption logic in FTP and Stage File activities as needed

- Write SQL queries and basic PL/SQL scripts for DB-based integrations

- (Optional) Work with BIP reports and Report Services if required

- Collaborate with functional and technical teams to analyze requirements and deliver solutions

- (Optional) Utilize Kafka or OCI Streaming for real-time integrations

Required Qualifications :

- 2 to 6 years of hands-on experience in Oracle Integration Cloud

Strong hands-on experience with :

- Stage File activity and its operations (list, read, write, zip/unzip)

- Integration components such as SOAP, REST, FTP, DB, ERP connections

- Fault handling and integration orchestration in OIC

- Monitoring and migration of integrations

- SQL and basic PL/SQL development

- Lookup configuration and integration lifecycle management

Familiarity with :

- FBDI or web service-based integration methods

- OIC encryption/decryption mechanisms (preferred)

- BIP reports (preferred but not mandatory)

- Kafka/OCI Streaming (good to have)

- Strong problem-solving, analytical, and troubleshooting abilities

- Excellent communication and teamwork skills

Preferred Qualifications :

- Oracle Cloud Platform Application Integration Certification

- Exposure to Report Service, Library configuration, and Certificate & Key Management

- Knowledge of large file handling and segment-based processing in OIC