Software Development Engineer II(Oracle Integration Cloud Developer)

Job Description

Role Overview

We are seeking a seasoned Oracle Integration Cloud (OIC) Developer with at least 6 years of hands-on experience to lead our integration and automation initiatives. The ideal candidate must possess deep technical expertise in OIC Generation 3 , managing complex integrations. Unique to this role is a strong focus on hyper-automation; the candidate will not only design API-led integrations but also leverage OIC’s native RPA & OCU document understanding capabilities to automate manual tasks. Experience with UiPath is highly desirable to bridge our existing automation landscape.

Required Qualifications

• Experience: Minimum 6+ years of progressive experience in Oracle Integration Cloud (OIC) and SOA technologies.
• OIC RPA: Hands-on experience with Oracle Integration Cloud’s native RPA features (designing bots, recording workflows, and managing robot agents).
• Technical Skills: Strong proficiency in XML, XSLT, XPath, JSON, REST, SOAP, and JavaScript for complex data mapping and transformation.
• Certifications: Oracle Cloud Platform Application Integration Specialist certification (preferred).

Preferred Qualifications (Nice to Have)

• UiPath RPA: Experience developing bots in UiPath Studio and managing them via UiPath Orchestrator.
• Experience integrating with Oracle SaaS modules (Fusion ERP, HCM, SCM).
• Knowledge of Visual Builder Cloud Service (VBCS) or Process Cloud Service (PCS).

Soft Skills

• Strong analytical and troubleshooting skills for debugging complex hybrid (API + RPA) workflows.
• Ability to communicate technical automation concepts to non-technical business stakeholders.
• Self-starter with the ability to lead migration projects independently.

Basic Requirements

Key Responsibilities

1. OIC Development & Architecture ( Gen 3)

• Design, develop, and deploy end-to-end integration solutions using Oracle Integration Cloud (OIC) Gen 3 , ensuring high availability and error handling.
• Lead migration efforts from OIC Gen 2 to Gen 3, including refactoring integrations to utilize Gen 3’s project-based architecture and improved connectivity features.
• Configure and manage Oracle Cloud Adapters (ERP, HCM, SCM, Salesforce, REST/SOAP) to ensure seamless data flow between SaaS, PaaS, and on-premise applications.
• Implement complex orchestration patterns (synchronous/asynchronous) and lookups to map cross-functional business processes.

2. Robotic Process Automation (OIC RPA)

• Identify opportunities for automation where APIs are unavailable and implement OIC Native RPA (Robots) to handle UI-based interactions.
• Design, record, and configure software robots within the OIC ecosystem to automate repetitive manual tasks (e.g., legacy system data entry, document scraping).
• Orchestrate hybrid workflows that combine API-based integrations with RPA bots to achieve end-to-end process automation.

3. UiPath & Automation Strategy

• Preferred: Integrate OIC with UiPath orchestrators to trigger advanced external bots or consume UiPath processes within OIC flows.
• Assess existing UiPath automations for potential migration to OIC Native RPA to consolidate licensing and infrastructure where applicable.

4. Integration & Workflow Automation

• Fusion ERP Integration: Build integrations using Oracle Integration Cloud (OIC) to map extracted JSON data (Vendor Name, Invoice Amount, Date) directly into Oracle Fusion ERP tables.
• API Orchestration: Develop Python scripts or OCI Functions to trigger the Document Understanding REST APIs whenever a new file lands in an Object Storage bucket.
• Exception Handling: Design workflows (using OCI Process Automation) that route “low confidence” extractions to a human manager for manual review before data is committed to the ledger.

5. Operations & Monitoring

• Utilize OIC Observability tools to monitor integration health, troubleshoot failures, and optimize performance (specifically addressing Gen 3 performance tuning).
• Manage connectivity agents for on-premise integrations, ensuring secure communication tunnels.