OIC+PLSQL

Remote: 
Full Remote
Contract: 
Work from: 

Offer summary

Qualifications:

3+ years of experience in Oracle Integration Cloud (OIC) and PL/SQL development., Strong skills in creating and optimizing complex database logic., Familiarity with REST/SOAP APIs, JSON, XML, and XSLT., Good communication and problem-solving abilities..

Key responsibilities:

  • Design and deploy integrations using OIC components like ICS, PCS, and VBCS.
  • Build real-time and batch integrations between Oracle Fusion Cloud and other systems.
  • Develop and optimize PL/SQL procedures to support integration logic.
  • Monitor and troubleshoot OIC integrations and maintain documentation.

Elfonze Technologies logo
Elfonze Technologies Scaleup https://www.elfonze.com/
201 - 500 Employees
See all jobs

Job description

This is a remote position.

Job Summary

We are looking for a skilled Oracle Integration Cloud (OIC) Developer with strong PL/SQL expertise. The ideal candidate should have 3+ years of hands-on experience in developing integrations using OIC (including ICS, PCS, and VBCS) and be proficient in writing complex PL/SQL procedures for backend data operations and transformations.


Key Responsibilities
  • Design, develop, and deploy integrations using Oracle Integration Cloud (OIC) components – Application Integration (ICS), Process Automation (PCS), Visual Builder (VBCS), and File/FTP adapters.

  • Build real-time and batch integrations between Oracle Fusion Cloud applications and on-premise/third-party systems.

  • Develop and optimize PL/SQL procedures, packages, functions, and triggers to support integration logic and data processing.

  • Collaborate with functional and technical teams to gather requirements and design scalable integration solutions.

  • Monitor, troubleshoot, and resolve issues in OIC integrations and PL/SQL logic.

  • Maintain integration documentation and support SIT/UAT and deployment activities.

  • Ensure best practices in API management, security, exception handling, and performance tuning.


Required Skills & Qualifications
  • 3+ years of hands-on experience in Oracle Integration Cloud (OIC) – Application and Process integrations.

  • Strong PL/SQL skills with experience in creating and optimizing complex database logic.

  • Experience with REST/SOAP APIs, JSON, XML, and XSLT.

  • Knowledge of Fusion Cloud data models and web service integrations.

  • Familiarity with event-based integrations, scheduled orchestration flows, and message publishing/subscription.

  • Ability to work independently in a fast-paced, collaborative environment.

  • Good communication, documentation, and problem-solving skills.


Preferred Qualifications
  • Experience integrating with Oracle Fusion SaaS modules (Finance, SCM, HCM).

  • Knowledge of Visual Builder (VBCS) and Process Automation (PCS).

  • Exposure to Oracle Autonomous Database and OCI is a plus.

  • Oracle Cloud certifications (OIC, PL/SQL, or related) are a plus.



Required profile

Experience

Spoken language(s):
English
Check out the description to know which languages are mandatory.

Other Skills

  • Communication
  • Problem Solving

Related jobs