Oracle Accounting Hub (AHCS) Technical SME Consultant

Spectraforce Technologies, Inc.; Chicago (IL); Hybrid; USD 140,000 - 180,000; Full time

Job summary

Spectraforce Technologies, Inc. is seeking an Oracle Accounting Hub (AHCS) Technical SME Consultant in Chicago, IL for a 12-month hybrid engagement.

The role centers on designing, building, and supporting an integrated AHCS and Oracle Cloud Finance GL platform, including data ingestion, transformation, interfaces, reporting, and production support. The candidate should have 8+ years of Oracle Financials technical experience and 5+ years in AHCS, with hands-on ODI, OIC, REST/SOAP APIs, XML/JSON,

Qualifications

• 8+ years of Oracle Financials technical implementation experience.
• 5+ years of hands-on AHCS technical experience.
• Strong experience with Oracle Cloud integration technologies and data architecture.
• Proven experience designing and supporting AHCS interfaces.
• Experience with ODI, OIC, REST/SOAP APIs, XML, JSON, FBDI, SQL, PL/SQL, and Python.

Responsibilities

• Design end-to-end integration architecture for AHCS and Fusion applications.
• Lead technical design and development across ODI, OIC, APIs, and data structures.
• Define integration patterns, security standards, and data exchange mechanisms.
• Develop source data ingestion, mappings, and transformation logic.
• Provide production support and optimization for large-scale integrations.
• Collaborate with enterprise architecture, security, and infra teams.

Skills

ODI

OIC

REST APIs

XML

JSON

FBDI

SQL

PL/SQL

Python

AHCS

Oracle Cloud

Tools

ODI

OIC

SQL

PL/SQL

Job description

Job Title: Oracle Accounting Hub (AHCS) Technical SME Consultant

Location: Chicago, IL - Hybrid

Duration: 12 Months

Job Description: We are seeking an experienced Oracle Accounting Hub (AHCS) Technical SME to support the design, development, integration, and implementation of a strategic Accounting Rules Engine and Oracle Cloud Finance GL platform. The consultant will be responsible for end-to-end integration architecture, source data ingestion, data transformation, interface development, reporting, performance optimization, and production support across Oracle Accounting Hub and related Oracle Cloud technologies.

Key Responsibilities

• * Design and implement end-to-end integration architecture supporting Oracle Accounting Hub and Oracle Fusion applications.


• * Lead technical design and development activities across:


• * o Oracle Data Integrator (ODI)


• * o Oracle Integration Cloud(OIC)


• * o REST/SOAP APIs


• * o XML and JSON message structures


• * o FBDI (File-Based Data Import)


• * o File-based integrations


• * o SQL and PL/SQL development


• * o Python-based data processing and automation


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

Reporting & Analytics

• * Design and develop operational and financial reports using:


• * o Oracle Transactional Business Intelligence (OTBI)


• * o Oracle BI Publisher


• * o Financial Data Intelligence (FDI)


• * Develop dashboards, reconciliation reports, exception reports, and ad hoc analytics.


• * Partner with Finance and Accounting teams to support reporting requirements.

Documentation & Governance

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

Required Qualifications

• * 8+ years of Oracle Financials technical implementation experience.


• * 5+ years of hands-on Oracle Accounting Hub (AHCS) technical experience.


• * Strong experience with Oracle Cloud integration technologies and data architecture.


• * Proven experience designing and supporting Accounting Hub interfaces.


• * Strong expertise in:


• * o Oracle Data Integrator (ODI)


• * o Oracle Integration Cloud(OIC)


• * o REST/SOAP APIs


• * o XML


• * o JSON


• * o FBDI


• * o SQL


• * o PL/SQL


• * o Python


• * Experience developing and supporting large-scale enterprise integrations.


• * Strong troubleshooting and performance optimization skills.


• * Experience working with Finance, Accounting, and business stakeholders.

Preferred Qualifications

• * Experience with Oracle Fusion ERP Cloud and Financials Cloud.


• * Experience with Oracle Integration Cloud (OIC).


• * Banking or Financial Services industry experience.


• * Knowledge of accounting, reconciliation, and financial reporting processes.


• * Experience with cloud-based data warehouse and analytics solutions.


• * Understanding of audit, SOX, and regulatory compliance requirements.

Required Skills

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


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


• * Financial Data Intelligence (FDI)

Industry Experience Preferred: Banking / Financial Services / Capital Markets

Nice-to-Have Skills

• * Oracle Integration Cloud (OIC)


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