Oracle Accounting Hub & Cloud Integration SME

Tellus Solutions
  • Chicago, IL
  • Instant Apply
7 days ago

Job Description

Job Description:
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

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

Numbers & Facts

LocationChicago, IL

Skills

  • Acceptance Testingunmatched
  • Accountingunmatched
  • Application Programming Interface (API)unmatched
  • Banking Servicesunmatched
  • Best Practicesunmatched
  • Business Intelligenceunmatched
  • Cloud Applicationsunmatched
  • Cloud Architectureunmatched
  • Cloud Computingunmatched
  • Corrective Actionunmatched
  • Data Analysisunmatched
  • Data Import/Exportunmatched
  • Data Modelingunmatched
  • Data Processingunmatched
  • Data Qualityunmatched
  • Data Structuresunmatched
  • Data Warehousingunmatched
  • Design Documentunmatched
  • DevOpsunmatched
  • Enterprise Architectureunmatched
  • Error Handlingunmatched
  • Financeunmatched
  • Financial Reportingunmatched
  • Financial Servicesunmatched
  • Financial Systemsunmatched
  • Financial Transactionsunmatched
  • Identify Issuesunmatched
  • JSONunmatched
  • Knowledge Transferunmatched
  • Onboardingunmatched
  • Operations Planningunmatched
  • Operations Processesunmatched
  • Oracleunmatched
  • Oracle Applicationsunmatched
  • Oracle Data Integratorunmatched
  • Oracle ERPunmatched
  • Oracle Financialsunmatched
  • Oracle Fusion Middlewareunmatched
  • Oracle General Ledgerunmatched
  • Oracle PL-SQLunmatched
  • Performance Analysisunmatched
  • Performance Tuning/Optimizationunmatched
  • Production Supportunmatched
  • Python Programming/Scripting Languageunmatched
  • REST (Representational State Transfer)unmatched
  • Reconciliationunmatched
  • Regulatory Complianceunmatched
  • Regulatory Requirementsunmatched
  • Release Management/Engineeringunmatched
  • Reporting Dashboardsunmatched
  • Root Cause Analysisunmatched
  • SOAP (Simple Object Access Protocol)unmatched
  • SQL (Structured Query Language)unmatched
  • Sarbanes-Oxley Act (SOX)unmatched
  • Support Documentationunmatched
  • Technical Leadershipunmatched
  • Technical Writingunmatched
  • Technical/Engineering Designunmatched
  • Transaction Processing/Managementunmatched
  • XML (EXtensible Markup Language)unmatched

Be found by employers

5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.

Level up your application

Professional resume templates

Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

Free resume templates

Free resume builder

Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

Free resume builder