Job Title: Oracle Integration Cloud (OIC) Technical Consultant – Fusion FinancialsLocation: RemoteDuration: Long Term Contract Key Responsibilities
Design, develop, deploy, and support integrations using Oracle Integration Cloud (OIC Gen2/Gen3).
Develop inbound and outbound integrations between Oracle Fusion Financials and third-party applications.
Work with Oracle Fusion modules:
Accounts Payable (AP)
Accounts Receivable (AR)
General Ledger (GL)
Project Portfolio Management (PPM)
Develop integrations using REST APIs, SOAP Web Services, ERP Cloud Adapter, Database Adapter, and FTP/SFTP Adapter.
Implement FBDI-based integrations for financial transactions and master data.
Develop BI Publisher reports and SQL queries to extract financial and project-related information.
Integrate AP invoices, AR transactions, receipts, GL journals, projects, and contracts.
Develop complex data mappings using XSLT, XPath, JSON, and XML.
Implement error handling, exception management, logging, and notification mechanisms.
Develop SQL/PLSQL packages, procedures, and staging tables for integration processing.
Work with Oracle Fusion Business Events and event-driven integrations.
Perform unit testing, SIT, UAT, deployment, and production support.
Troubleshoot integration failures and resolve technical issues.
Prepare technical design documents, mapping documents, and deployment documentation.
Coordinate with Finance functional consultants and business teams to understand integration requirements.
Required Technical Skills
Oracle Integration Cloud (OIC Gen2/Gen3)
Oracle Fusion Financials – AP, AR, GL
Oracle Fusion PPM
REST and SOAP APIs
ERP Cloud Adapter
Database Adapter
FTP/SFTP Adapter
FBDI and ESS Jobs
BI Publisher
SQL and PL/SQL
XML, XSLT, XPath, JSON
Oracle Fusion Business Events
Postman and API testing
Qualifications
8+ years of Oracle technical experience.
5+ years of hands-on OIC integration development experience.
Strong understanding of Oracle Fusion AP, AR, GL, and PPM.
Experience implementing end-to-end Oracle Fusion ERP integrations.
Ability to independently handle integration development, troubleshooting, and production support.
Strong communication and client-facing skills.