Haystack
← Back to Jobs
Finance
PT

Oracle Accounting Hub & Cloud Integration SME - No C2C

Purplejack Technologies LLCChicago, IL🇺🇸United StatesPosted Oct 6, 2026

Quick Overview

Seniority
Mid Senior
Work mode
Hybrid
Location
Chicago, IL, United States
Posted
18 hours ago
Reconciliation

Job Description


  • 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
  • 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

Requirements

  • Oracle AHCS / Oracle Fusion Financials
  • ODI & Oracle Integration Cloud (OIC)
  • REST/SOAP APIs, XML, JSON & FBDI
  • SQL, PL/SQL & Python
  • Oracle Cloud Integration Architecture
  • Source-to-target mapping, data transformation & reconciliation
  • OTBI, BI Publisher & Financial Data Intelligence (FDI)
  • Performance optimization, monitoring & troubleshooting

Similar jobs