Overview
Skills
Job Details
REMOTE - OCI Fusion Developer
Excellent com is necessary. Strong understanding of financial terminology is a non-negotiable.
Duration: This will be a 6-month engagement.
Location: REMOTE must work EST hours and reside within the United States
Industry: Strong financial services background is essential. Must understand financial/accounting terminology
Overview
We are seeking a hands-on Oracle Fusion / OCI Architect to lead and execute critical financial integration work for an enterprise acquisition. This individual will be responsible for standing up and operationalizing a robust data-ingestion and reporting architecture in Oracle Cloud Infrastructure (OCI) and Fusion Financials, ensuring the acquiring entity has Day-1 access to complete, accurate, and auditable financial data.
This is not a conceptual or advisory role the architect must be able to design, build, and deliver. The work will involve brute-force extraction and transformation in the near term, with a path toward establishing a sustainable, automated solution thereafter. Key Responsibilities
1. Architecture & Integration Design
Architect end-to-end financial data-ingestion and integration flows between Oracle Fusion and OCI Autonomous Transaction Processing (ATP).
Define data-movement patterns (extract, transform, load) to re-ingest financial data and currency balances between systems.
Establish and document ingestion frameworks that can evolve toward automation post-acquisition.
2. Hands-On Technical Development
Develop and optimize OIC (Oracle Integration Cloud) integrations, Fusion Extracts, and ATP ingestion processes.
Build and tune queries, reports, and data pipelines to support daily re-evaluations, exchange-rate handling, and financial consolidation.
Design, deploy, and validate schemas and APIs in ATP, ensuring they can scale to large-volume financial extracts.
Create or enhance Fusion BI Publisher / OTBI reports as needed to enable day-one financial visibility.
3. Financial Domain Expertise
Apply deep understanding of Fusion Financials (GL, AP, AR, FA, CM) and enterprise financial structures (Chart of Accounts, functional vs. reporting currencies, re-valuation processes, and exchange-rate management).
Ensure all financial data extracts and transformations adhere to audit and compliance standards no brute-force shortcuts that compromise reconciliation or traceability.
Work closely with Finance, Accounting, and Enterprise Data teams to interpret business requirements without extensive accounting translation.
4. Transition & Stabilization
Stand up a repeatable extraction and reporting environment capable of supporting audit requirements.
Collaborate with internal enterprise architects to transition from the initial brute-force ingestion to a sustainable, production-grade integration model.
Mentor other developers and data engineers as the environment matures. Required Qualifications
10+ years overall IT experience with at least 5 years in Oracle Fusion Cloud Financials.
Proven, hands-on experience in OIC (Oracle Integration Cloud), Fusion Data Extracts, and Autonomous Transaction Processing (ATP).
Strong financial domain knowledge General Ledger, Chart of Accounts, re-valuation, multi-currency, and consolidation processes.
Demonstrated ability to handle large-volume data extraction and transformation for audit-ready financial reporting.
Expert in SQL / PL-SQL, REST integrations, and OCI data services.
Ability to independently architect and develop not just oversee conceptually.
Prior experience in M&A / Day-1 financial readiness or similar enterprise integration programs strongly preferred.
Preferred Skills
Familiarity with Fusion BI Publisher, OTBI, and Oracle Analytics Cloud (OAC).
Experience building reusable data models and transformation logic across financial domains.
Strong understanding of audit, compliance, and reconciliation processes in multi-currency environments.
Excellent communication skills; able to collaborate with finance and technical stakeholders with minimal translation.