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.