Responsible for the design, development, and support of technical solutions within the Oracle ecosystem.
Maintain and enhance existing Oracle EBS R12 technical components, including PL/SQL packages, Stored Procedures, Oracle Reports, and XML Publisher.
Lead the extraction of legacy data from EBS tables and transform it into FBDI (File-Based Data Import) templates for ingestion into Fusion Cloud Financials.
Develop and support co-existence strategies where EBS and Cloud ERP systems exchange data during multi-year migration phases.
Build and monitor end-to-end integrations in Oracle Integration Cloud (OIC) using the ERP Cloud, FTP, and REST adapters.
Develop custom side-by-side extensions on Oracle Cloud Infrastructure (OCI) using SQL, Java, and OCI Object Storage to meet gaps in standard Cloud functionality.
Develop and consume SOAP and RESTful web services to facilitate real-time communication between Oracle Cloud and third-party Finance tools.
Create and maintain complex BI Publisher (BIP) reports, OTBI analysis, and Financial Reporting Studio (FRS) reports.
Provide technical support for Subledger Accounting (SLA) rule modifications to ensure proper accounting of custom transactions.
Perform root-cause analysis for production issues in both EBS (Forms/Reports/Workflows) and Cloud (OIC/Scheduled Processes).
Requirements
5–8 years of experience as an Oracle Technical Consultant/Developer