Overview
Skills
Job Details
W2 Position
REMOTE - OCI Fusion Developer Opportunity 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 Need on our W2 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.