Oracle Fusion Financials Technical Lead or Oracle Cloud ERP Integration Architect

Brickstech; Chicago (IL); On-site; USD 120,000 - 170,000; Full time

Job summary

Brickstech is seeking a senior Oracle Financials technical expert to lead end-to-end integration for AHCS and Oracle Fusion apps. You will design ingestion frameworks, mappings, and data models for high-volume financial transactions, using ODI, OIC, REST/SOAP APIs, XML/JSON, FBDI, SQL/PL/SQL, and Python.

Hybrid collaboration with Finance, Enterprise Architecture and Security teams to ensure audit, SOX compliance, and scalable, secure cloud integrations; lead SIT/UAT, cutover and hypercare with

Qualifications

• Bachelor's degree required.
• 8+ years Oracle Financials technical experience.
• 5+ years AHCS hands-on technical experience.
• Experience designing end-to-end integrations for Oracle Cloud.

Responsibilities

• Design and implement end-to-end integration architectures for AHCS and Oracle Fusion.
• Lead ODI, OIC, REST/SOAP APIs, XML/JSON, FBDI and file-based integrations.
• Define source-to-target mappings and data exchange patterns between sources and Oracle Cloud.
• Develop source data ingestion frameworks for AHCS.
• Define and implement accounting event and transaction data structures for AHCS.
• Support SIT, UAT, cutover, go-live and hypercare with operational documentation.
• Develop reports/dashboards using OTBI, BI Publisher, and FDI.
• Partner with Finance, Enterprise Architecture and Security teams for audit and compliance.

Skills

API

Data Modeling

JSON

Oracle

Python

XML

ODI

OIC

RESTAPIs

SOAPServices

SQL

PL/SQL

FBDI

File-based integrations

Data Transformation

Performance Optimization

Troubleshooting

InterfaceDevelopment

DataModeling

ReconciliationDataDesign

AccountingHub

AuditSOX

Education

Bachelor's Degree

Tools

ODI

OIC

OTBI

BI Publisher

FDI

Job description

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&IntegrationTechnologies
• OracleAccountingHubCloudService(AHCS)
• OracleDataIntegrator(ODI)
• OracleIntegrationCloud(OIC)
• OracleCloudIntegrationArchitecture
• RESTAPIs
• SOAPServices
• XML
• JSON
• FBDI(File-BasedDataImport)
• File-basedintegrations
• Development&Data
• SQL
• PL/SQL
• Python
• SourceDataIngestion
• DataModeling
• DataTransformation
• ReconciliationDataDesign
• InterfaceDevelopment
• Performance&Support
• PerformanceOptimization
• ErrorHandling&Monitoring
• Troubleshooting&RootCauseAnalysis
• Reporting&Analytics
• OTBI(OracleTransactionalBusinessIntelligence)
• BIPublisher
• FinancialDataIntelligence(FDI)

Preferred/Nice-to-Have Skills

• OracleFusionERPCloudandFinancialsCloud
• OracleFusionGeneralLedger
• FinancialDataWarehouseArchitecture
• DataReconciliationFrameworks
• DevOpsandReleaseManagement
• CloudMigrationandModernizationInitiatives
• High-volumeFinancialTransactionProcessingSystems
• Banking/FinancialServicesindustryexperience
• Knowledgeofaccounting,reconciliation,andfinancialreportingprocesses
• Understandingofaudit,SOX,andregulatorycompliancerequirements

Required Responsibilities

• IntegrationArchitecture&Development
• Designandimplementend-to-endintegrationarchitecturesupportingOracleAccountingHubandOracleFusionapplications
• LeadtechnicaldesignanddevelopmentacrossODI,OIC,REST/SOAPAPIs,XML/JSON,FBDI,file-basedintegrations,SQL/PL/SQL,andPython
• Defineintegrationpatterns,securitystandards,anddataexchangemechanismsbetweensourcesystemsandOracleCloudapplications
• Collaboratewithenterprisearchitecture,infrastructure,andsecurityteamstoensurescalableandsecuresolutions
• AccountingHubDataIntegration
• DesignanddevelopsourcedataingestionframeworksforAHCS
• Defineandimplementsource-to-targetmappingsandtransformationlogic
• DesignaccountingeventandtransactiondatastructuresrequiredbyAHCS
• Develop,validate,andsupportAccountingHubinboundinterfaces
• SupportonboardingofmultiplesourcesystemsintoAccountingHub
• Ensuredataquality,completeness,andreconciliationacrossintegratedapplications
• DataModel&TransformationDesign
• Designandoptimizeaccountingandreconciliationdatamodels
• DevelopcomplextransformationsusingODI,OIC,SQL,PL/SQL,andPython
• Createreusableintegrationcomponentsandbestpractices
• Analyzeandresolvedataintegrity,processing,andperformanceissues
• Supportlarge-volumetransactionprocessinganddataloadingactivities
• Troubleshooting&ProductionSupport
• Troubleshootinterfacefailures,dataprocessingissues,andintegrationdefects
• Performrootcauseanalysisandimplementcorrectiveactions
• Monitorintegrationperformanceandrecommendoptimizationopportunities
• SupportSIT,UAT,cutover,go-live,andhypercareactivities
• Createsupportdocumentationandoperationalprocedures
• DesignanddevelopoperationalandfinancialreportsusingOTBI,BIPublisher,andFDI
• Developdashboards,reconciliationreports,exceptionreports,andadhocanalytics
• PartnerwithFinanceandAccountingteamstosupportreportingrequirements
• Preparetechnicaldesigndocuments,interfacespecifications,anddeploymentguides
• Supportaudit,compliance,anddatagovernancerequirements
• Participateindesignreviewsandtechnicalarchitecturediscussions
• Provideknowledgetransfertointernalsupportanddevelopmentteams
• WorkwithFinance,Accounting,andbusinessstakeholders
• Collaboratewithenterprisearchitecture,infrastructure,andsecurityteams