Oracle Integration Consultant - Oracle Integration Cloud (OIC)

Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. We are in search of a highly motivated candidate to join our talented Team.

Job Title: Oracle Integration Consultant - Oracle Integration Cloud (OIC)

Location(s): New York City, NY

Description:
Oracle Integration Consultant - Oracle Integration Cloud (OIC)

• Lead the design, development, and implementation of enterprise integrations using Oracle Integration Cloud (OIC) across the Oracle Fusion ecosystem.
• Design and build integrations supporting Oracle Fusion modules including Accounts Payable (AP), Purchasing (PO), Accounts Receivable (AR), General Ledger (GL), Fixed Assets (FA), Subledger Accounting / FAH, and Inventory.
• Develop and maintain point-to-point, hub-and-spoke, and event-driven integration architectures using OIC best practices.
  • Design, configure, and manage OIC integrations, including:
  • App-driven orchestration integrations
  • Scheduled and basic integrations
  • Lookups, packages, error handling, and tracking
• Develop inbound and outbound integrations using REST and SOAP web services, leveraging Oracle Fusion public APIs.
• Support data exchange using FBDI, HDL, ATP (Autonomous Transaction Processing), and Managed File Transfer (MFT).
• Configure and manage MFT for secure file-based integrations, including encryption, sequencing, and exception handling.
• Design integration patterns supporting financial transactions, master data synchronization, inventory transactions, and accounting events.
• Ensure end-to-end data integrity and reconciliation across source systems, Fusion subledgers, FAH, and GL.
• Collaborate with functional consultants to translate business and functional requirements into robust integration solutions.
• Produce and maintain integration documentation including interface specifications, mapping documents, and error-handling procedures.
• Perform unit testing and support SIT, UAT, regression testing, and end-to-end integration validation.
• Monitor, troubleshoot, and resolve integration failures using OIC Insight, tracking, dashboards, and logs.
• Support cutover, go-live, hypercare, and post-production support activities.
• Assess and remediate impacts of quarterly Oracle Fusion and OIC releases on existing integrations.
• Enforce security, scalability, performance, and governance standards across the integration landscape.

• Bachelor's degree in Computer Science, Engineering, Information Systems, or related field.
• 10-12+ years of integration experience with 5+ years in Oracle Integration Cloud (OIC).
• Strong hands-on experience integrating Oracle Fusion Financials and SCM Cloud modules.
• Proven experience with:
  • Oracle Integration Cloud (OIC Gen2)
  • REST / SOAP APIs
  • FBDI, HDL
  • Oracle Managed File Transfer (MFT)
• Strong understanding of Fusion financial accounting flows, including subledger-to-GL posting via SLA / FAH.
• Experience integrating with on-prem and cloud-based third-party systems.
• Hands-on experience with Autonomous Transaction Processing (ATP) for integration persistence or custom reporting.
• Strong knowledge of XML, JSON, XPath, XSLT, and data transformation techniques.
• Experience supporting multi-ledger, multi-currency, and multi-region Oracle Cloud environments.
• Ability to troubleshoot complex integration issues across functional, technical, and infrastructure layers.
• Familiarity with DevOps, promotion strategies, and environment migration for OIC artifacts.
• Strong communication and stakeholder engagement skills.
• Certification in Oracle Integration Cloud (OIC) Certification.

Ampcus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veterans or individuals with disabilities.