Back to Jobs
Finance

Oracle Accounting Hub & Cloud Integration SME - No C2C

Purplejack Technologies LLCChicago, IL🇺🇸United States

Why this role stands out

This hybrid role offers a fantastic opportunity to shape critical financial integrations and advance your expertise in Oracle Accounting Hub and Cloud technologies, fostering significant career growth. You'll thrive here if you possess strong technical skills in ODI, OIC, and various integration patterns, and are eager to collaborate on innovative solutions within a reputable company. Apply now to leverage your talents and make a real impact.

Quick overview

SeniorityMid Senior
Work modeHybrid
LocationChicago, IL, United States
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