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
- TS
Principal Accountant
NewTalent Software Services, Inc
Maple Grove, MN🇺🇸Hybrid18 hours agoERPExternal AuditFP&A+6Finance - MP
Sr. Accountant-
NewmProgen
Oakland, CA🇺🇸On-site18 hours agoERPMicrosoft OfficeFinance - OR
Advanced Services Engineer -Patient Accounting
NewOracle
Cleveland, Ohio🇺🇸$24 - $50/hrOn-site4 hours agoEngineering - AR
Accounting Supervisor
ARS-Rescue Rooter
Cleveland, OH🇺🇸$60k - $70k/yrHybrid4 weeks agoAccounts PayableAccounts ReceivableInternal ControlsFinance - EE
Accounting & Finance Analyst (hybrid)
NewEdgeworth Economics LLC
United States🇺🇸$78k - $93k/yrHybrid2 days agoAccounts PayableAccounts ReceivableCPA+5Finance - AH
Senior Manager, Plant Accounting & Financial Operations
NewAmerican Honda Motor Co., Inc.
Anna, OH🇺🇸HybridYesterdayBudgetingFinancial AnalysisFinancial Reporting+4Finance