Oracle Integration Cloud (OIC) Technical Consultant – Fusion Financials
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.