Senior Oracle Integration (OIC) Consultant

Job Title: Senior Oracle Integration (OIC) Consultant

Experience: 5+ Years

Location: Chennai

Employment Type: Full-time

Number of Resources: 1

As a Senior Oracle Integration Cloud (OIC) Technical Consultant, you will lead the design, development, and delivery of Oracle Cloud PaaS integrations across Oracle Fusion Cloud (ERP, HCM, SCM) and external systems. You will provide day-to-day support for a variety of customers. You will work closely with Technical Leads, Functional Leads, and Client Stakeholders to deliver scalable, secure, and performant integration solutions leveraging OIC, Oracle SaaS APIs, and complementary OCI services.

This role demands strong hands-on expertise in Oracle Integration Cloud (OIC), Oracle Visual Builder and various modes of integrations. You are expected to mentor junior developers, own technical deliverables, and drive best practices for integration and automation.

Key Responsibilities:

·       Troubleshoot production issues and persistent problems and work with key stakeholders to address the root causes in OIC.

·       Design, build and support integrations using Oracle Integration Cloud (OIC) including Application Integration (Orchestration), Scheduled Integrations, and File-based Integrations

·       Develop and support REST/SOAP-based integrations between Oracle Fusion Cloud (ERP/HCM/SCM) and other custom/on-premises/cloud-based applications

·       Implement error handling, retry mechanisms, and OIC monitoring/logging best practices

·       Support all aspects of Cloud Quarterly Releases from Impact Assessment through testing and defect support on technical components

·       Utilize Oracle Visual Builder for custom UIs and Oracle Process Automation (OPA) for workflow orchestration (where needed)

·       Work with Oracle SaaS services (ERP, HCM, SCM) to consume OTBI, FBDI and HDL for integration scenarios

·       Design and configure security components such as OAuth2 flows

·       Collaborate with clients on data mapping, transformation logic, and interface contracts

·       Drive performance tuning and optimization for long-running integrations and large payload handling

·       Conduct code reviews, enforce standards, and guide junior developers and offshore teams

·       Prepare design documents, integration specifications, and deployment artifacts

Must have skills:

·       5+ years’ experience in Oracle integration technologies (OIC)

·       Strong knowledge of Oracle SaaS APIs (ERP/HCM/SCM), including REST/SOAP endpoints, security tokens, and web service catalogs

·       Experience with Oracle BI Publisher (BIP), OTBI, FBDI and HDL’s

·       Hands-on expertise in XML, XSLT, XPath, JSON, SOAP, REST, and SQL

·       Familiarity with Oracle SaaS data models and common business processes (e.g., AP/AR/PO/GL, HCM/Payroll)

·       Experience with OIC connectivity to external platforms (e.g., Azure, SAP, Salesforce, Workday)

·       Strong understanding of authentication protocols (OAuth2, Basic, API Key) and OCI Vault management

·       Experience with troubleshooting and debugging OIC flows using diagnostic logs, audit trails, and activity streams

·       Excellent communication skills, stakeholder management, and ability to lead technical discussions

·       Experience with Oracle Visual Builder

Good to have Skills:

Experience with Oracle Process Automation (OPA)

Experience with Oracle APEX

Qualifications:

Bachelor’s degree in computer science, Engineering, or related discipline

Oracle certifications in OIC or Oracle Cloud Platform (preferred but not mandatory)