Oracle Accounting Hub Ahcs Technical Sme

The role focuses on Oracle Cloud integrations, AHCS inbound interfaces, data ingestion, data transformation, ODI, OIC, APIs, SQL/PLSQL, Python, and reporting.

• Design end-to-end integration architecture for Oracle Accounting Hub and Oracle Fusion applications.
• Develop integrations using:
  • ODI
  • OIC
  • REST/SOAP APIs
  • XML / JSON
  • FBDI
  • File-based integrations
  • SQL / PL/SQL
  • Python
• Define integration patterns, security standards, and data exchange mechanisms.

• Design source data ingestion frameworks for AHCS.
• Develop source-to-target mappings and transformation logic.
• Design accounting event and transaction data structures.
• Develop and support AHCS inbound interfaces.
• Onboard multiple source systems into Accounting Hub.
• Ensure data quality, completeness, and reconciliation.

• Design and optimize accounting and reconciliation data models.
• Develop transformations using ODI, OIC, SQL, PL/SQL, and Python.
• Create reusable integration components.
• Resolve data integrity and performance issues.
• Support large-volume transaction processing and data loading.

• Troubleshoot interface failures and integration defects.
• Perform root cause analysis and corrective actions.
• Monitor and optimize integration performance.
• Support SIT, UAT, cutover, go-live, and hypercare.
• Create support documentation and operational procedures.

Experience with:

• OTBI
• BI Publisher
• Financial Data Intelligence (FDI)

Develop:

• Dashboards
• Reconciliation reports
• Exception reports
• Ad hoc analytics

• Technical design documents
• Interface specifications
• Deployment guides
• Audit/compliance/data governance
• Design reviews
• Knowledge transfer

• 8+ years Oracle Financials technical implementation experience.
• 5+ years hands-on Oracle Accounting Hub (AHCS) experience.
• Strong Oracle Cloud integration and data architecture experience.
• Proven experience designing/supporting Accounting Hub interfaces.
• Strong experience with:
  • ODI
  • OIC
  • REST/SOAP
  • XML
  • JSON
  • FBDI
  • SQL
  • PL/SQL
  • Python
• Large-scale enterprise integration experience.
• Strong troubleshooting and performance optimization.
• Experience working with Finance, Accounting, and business stakeholders.

• Oracle Fusion ERP Cloud / Financials Cloud
• OIC
• Banking / Financial Services
• Accounting and reconciliation
• Financial reporting
• Cloud data warehouse / analytics
• Audit / SOX / regulatory compliance

Primary:

• Oracle Accounting Hub Cloud Service (AHCS)
• ODI
• OIC
• Oracle Cloud Integration Architecture
• REST APIs / SOAP
• XML / JSON
• FBDI
• SQL / PL/SQL
• Python
• Source Data Ingestion
• Data Modeling
• Data Transformation
• Reconciliation Data Design
• Interface Development
• Performance Optimization
• Error Handling / Monitoring
• Troubleshooting / Root Cause Analysis
• OTBI
• BI Publisher
• FDI

• Oracle Fusion General Ledger
• Financial Data Warehouse Architecture
• Data Reconciliation Frameworks
• DevOps / Release Management
• Cloud Migration / Modernization
• High-volume Financial Transaction Processing