Oracle Accounting Hub & Cloud Integration SME
Required Education
Bachelor's Degree
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
