Oracle Fusion Financials Technical Lead or Oracle Cloud ERP Integration Architect

Must have Skills:- API, Data Modeling, JSON, Oracle, Python, XML

Required Education: Bachelor's Degree

Visa-Any , No H1b

This role is for a senior Oracle Financials technical expert focused on end-to-end integration architecture for Oracle Accounting Hub Cloud Service (AHCS) and Oracle Fusion applications.

It requires a Bachelor's degree with 8+ years of Oracle Financials technical implementation experience and 5+ years of hands-on AHCS technical experience.

Candidate will design and implement integrations between multiple source systems and Oracle Cloud using ODI, OIC, REST/SOAP APIs, XML/JSON, FBDI, file-based integrations, SQL/PL/SQL, and Python, defining patterns, security and data exchange standards.

Core work includes building source data ingestion frameworks for AHCS, defining source-to-target mappings, accounting event structures, inbound interfaces, data modeling, transformation and reconciliation design for high-volume financial transactions.

Candidate will also handle performance optimization, error handling/monitoring, troubleshooting interface failures, root cause analysis, and support SIT, UAT, cutover, go-live and hypercare with operational documentation.

Additionally, you will develop reports/dashboards using OTBI, BI Publisher and Financial Data Intelligence (FDI) and partner with Finance, Enterprise Architecture and Security teams for audit, SOX and compliance requirements.

Implied/experience-based requirements:

8+ years of Oracle Financials technical implementation experience

5+ years of hands-on Oracle Accounting Hub (AHCS) technical experience

Required Skills

Oracle & Integration Technologies

Oracle Accounting Hub Cloud Service (AHCS)

Oracle Data Integrator (ODI)

Oracle Integration Cloud (OIC)

Oracle Cloud Integration Architecture

REST APIs

SOAP Services

XML

JSON

FBDI (File-Based Data Import)

File-based integrations

Development & Data

SQL

PL/SQL

Python

Source Data Ingestion

Data Modeling

Data Transformation

Reconciliation Data Design

Interface Development

Performance & Support

Performance Optimization

Error Handling & Monitoring

Troubleshooting & Root Cause Analysis

Reporting & Analytics

OTBI (Oracle Transactional Business Intelligence)

BI Publisher

Financial Data Intelligence (FDI)

Preferred / Nice-to-Have Skills

Oracle Fusion ERP Cloud and Financials Cloud

Oracle Fusion General Ledger

Financial Data Warehouse Architecture

Data Reconciliation Frameworks

DevOps and Release Management

Cloud Migration and Modernization Initiatives

High-volume Financial Transaction Processing Systems

Banking / Financial Services industry experience

Knowledge of accounting, reconciliation, and financial reporting processes

Understanding of audit, SOX, and regulatory compliance requirements

Required Responsibilities:-

Integration Architecture & Development

Design and implement end-to-end integration architecture supporting Oracle Accounting Hub and Oracle Fusion applications

Lead technical design and development across ODI, OIC, REST/SOAP APIs, XML/JSON, FBDI, file-based integrations, SQL/PL/SQL, and Python

Define integration patterns, security standards, and data exchange mechanisms between source systems and Oracle Cloud applications

Collaborate with enterprise architecture, infrastructure, and security teams to ensure scalable and secure solutions

Accounting Hub Data Integration

Design and develop source data ingestion frameworks for AHCS

Define and implement source-to-target mappings and transformation logic

Design accounting event and transaction data structures required by AHCS

Develop, validate, and support Accounting Hub inbound interfaces

Support onboarding of multiple source systems into Accounting Hub

Ensure data quality, completeness, and reconciliation across integrated applications

Data Model & Transformation Design

Design and optimize accounting and reconciliation data models

Develop complex transformations using ODI, OIC, SQL, PL/SQL, and Python

Create reusable integration components and best practices

Analyze and resolve data integrity, processing, and performance issues

Support large-volume transaction processing and data loading activities

Troubleshooting & Production Support

Troubleshoot interface failures, data processing issues, and integration defects

Perform root cause analysis and implement corrective actions

Monitor integration performance and recommend optimization opportunities

Support SIT, UAT, cutover, go-live, and hypercare activities

Create support documentation and operational procedures

Design and develop operational and financial reports using OTBI, BI Publisher, and FDI

Develop dashboards, reconciliation reports, exception reports, and ad hoc analytics

Partner with Finance and Accounting teams to support reporting requirements

Prepare technical design documents, interface specifications, and deployment guides

Support audit, compliance, and data governance requirements

Participate in design reviews and technical architecture discussions

Provide knowledge transfer to internal support and development teams

Work with Finance, Accounting, and business stakeholders

Collaborate with enterprise architecture, infrastructure, and security teams