Oracle Integration Cloud Consultant

Job Summary:

We are looking for a Senior Technical Consultant with strong expertise in Oracle Integration Cloud (OIC) to join our team and lead the design, development, and deployment of integration solutions across Oracle Fusion Cloud and third-party systems. The ideal candidate will have in-depth experience with OIC components, REST/SOAP APIs, FBDI, and a good understanding of Fusion Financials, SCM, and legacy systems such as Oracle EBS. Prior experience with Oracle SOA Suite is preferred and will be considered an added advantage. This is a hands-on technical role with responsibilities for designing scalable integrations, building extensions, and mentoring junior team members in a fast-paced enterprise environment.

Key Responsibilities:

· Design, build, and deploy integrations using Oracle Integration Cloud (OIC) including: App-Driven Integrations Scheduled IntegrationsFile-based and B2B Integrations Create REST/SOAP-based integrations with Fusion and non-Fusion systems.

· Handle FBDI/ADFDi-based data loads and UCM uploads. Develop mappings and logic using XSLT, JavaScript, and expression builders.

· Configure and implement error handling, retries, and fault propagation in integration flows.

· Use secure connections, external DB adapters, FTP/File Server, and on-premises agents.

· Configure and maintain connections, agents, and environment-specific setups in OIC.

· Promote code using OIC import/export and manage deployment pipelines with Git/GitHub.

· Follow best practices in version control, parameterization, and deployment automation.

· Analyze and troubleshoot errors using OIC activity stream, logs, and trace files.

· Create and maintain Technical Design Documents (TDDs), interface catalogs, and configuration records.

· Enforce naming standards, documentation practices, and code quality guidelines.

· Work with functional teams to analyze requirements and convert them into scalable integration solutions.

· Support system integration testing (SIT), UAT, go-live, and post-production support.

· Guide junior developers and ensure coding standards, quality, and best practices are followed.

Required Skills & Experience:

· 10+ years of technical experience with Oracle Technologies (5 years in OIC Gen2/Gen3).

· Strong in designing integrations using: App-Driven & Scheduled flowsFile-based, REST/SOAP, and ERP adapters Consuming Fusion Business Events Exception handling, callbacks, asynchronous flows Proficiency with FBDI, REST API, OAuth2, SOAP services, and XSLT Experience with Oracle Visual Builder Studio (VBS) for lightweight extensions is a plus.

· Experience in BI Publisher (BIP) for creating data extracts and outbound reports.

· Experience with Oracle Autonomous DB, ATP/ADW connections, and data encryption.

· Exposure to B2B integrations (AS2, EDI) and Oracle File ServerGood understanding of Oracle Fusion modules:Financials (AP, AR, GL)SCM (PO, Inventory, OM)Familiarity with Oracle EBS data structures and integration touchpoints is an advantage.

· Proficient in SQL, PL/SQL, XML, XSLT, and Web Service technologies.

· Strong documentation skills – HLDs, TDDs, Interface Design, Runbooks, and Deployment Guides.

· Strong problem-solving and analytical skills.

· Excellent verbal and written communication skills.

· Preferred Qualifications:Oracle Certified Specialist in Oracle Integration Cloud.

· Experience in Agile or DevOps delivery environments.

· Prior experience with Oracle SOA Suite (BPEL, Mediator, OSB).

· Exposure to Oracle Cloud Infrastructure (OCI) and security models.

· Ability to work independently and manage multiple priorities in a fast-paced environment.

Education:

Bachelor's or Master's degree in computer science, Information Systems, or a related technical field.