Oracle Integration Consultant - Oracle Integration Cloud (OIC)

Ampcus, Inc; New York (NY); On-site; USD 120,000 - 150,000; Full time

Job summary

A global technology consulting firm based in New York City is seeking an Oracle Integration Consultant. The role involves leading enterprise integrations using Oracle Integration Cloud (OIC), developing integrations across various Oracle Fusion modules, and ensuring data integrity. Candidates should have a Bachelor's degree in a relevant field, significant integration experience, and expertise in Oracle Fusion. This position offers opportunities for personal growth in a collaborative environment.

Qualifications

• 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.
• Experience integrating with on-prem and cloud-based third-party systems.

Responsibilities

• Lead the design, development, and implementation of enterprise integrations using Oracle Integration Cloud (OIC).
• Produce and maintain integration documentation including interface specifications.
• Monitor, troubleshoot, and resolve integration failures using OIC Insight.

Skills

Integration experience

Oracle Integration Cloud (OIC)

REST / SOAP APIs

XML

JSON

Strong communication skills

Education

Bachelor's degree in Computer Science, Engineering, Information Systems, or related field

Tools

Oracle Integration Cloud (OIC Gen2)

Oracle Managed File Transfer (MFT)

Job description

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

New York City, NY

Key Responsibilities

• 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.

Required Qualifications

• 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.