Oracle Fusion Financials Technical Lead or Oracle Cloud ERP Integration Architect Job Chicago area,Illinois USA,Software Development

Job Description

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.

Must have Skills

API
Data Modeling
JSON
Oracle
Python
XML

Required Education

Bachelor's Degree

Visa

Visa-Any, No H1b

Required Skills

Oracle&Integration Technologies
Oracle Accounting Hub Cloud Service (AHCS)
Oracle Data Integrator (ODI)
Oracle Integration Cloud (OIC)
Oracle Cloud Integration Architecture
RESTAPIs
SOAP Services
XML
JSON
FBDI(File-Based Data Import )
File-basedintegrations
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 )
BIPublisher
Financial Data Intelligence (FDI)

Preferred/Nice-to-Have Skills

Oracle

FusionERPCloudand Financials Cloud
Oracle Fusion General Ledger
Financial Data Warehouse Architecture
Data Reconciliation Frameworks
Dev Opsand Release Management
Cloud Migration and Modernization Initiatives
High-volume

Financial Transaction Processing Systems
Banking/Financial Servicesindustryexperience
Knowledgeofaccounting,reconciliation,andfinancialreportingprocesses
Understandingofaudit,SOX,andregulatorycompliancerequirements

Required Responsibilities

Integration Architecture&Development
Designandimplementend-to-endintegrationarchitecturesupporting

Oracle Accounting Huband Oracle Fusion applications
LeadtechnicaldesignanddevelopmentacrossODI,OIC,REST/SOAPAPIs,XML/JSON,FBDI,file-basedintegrations,SQL/PL/SQL,and Python
Defineintegrationpatterns,security standards,anddataexchangemechanismsbetweensourcesystemsand

Oracle Cloud applications
Collaboratewithenterprisearchitecture,infrastructure,andsecurityteamstoensurescalableandsecuresolutions
Accounting Hub Data Integration
DesignanddevelopsourcedataingestionframeworksforAHCS
Defineandimplementsource-to-targetmappingsandtransformationlogic
DesignaccountingeventandtransactiondatastructuresrequiredbyAHCS
Develop,validate,and support

Accounting Hubinboundinterfaces
Supportonboardingofmultiplesourcesystemsinto Accounting Hub
Ensuredataquality,completeness,andreconciliationacrossintegratedapplications
Data Model&Transformation Design
Designandoptimizeaccountingandreconciliationdatamodels
DevelopcomplextransformationsusingODI,OIC,SQL,PL/SQL,and Python
Createreusableintegrationcomponentsandbestpractices
Analyzeandresolvedataintegrity,processing,andperformanceissues
Support large-volumetransactionprocessinganddataloadingactivities
Troubleshooting&Pro…