TS
Oracle Accounting Hub & Cloud Integration SME
Tellus Solutions
- 🇺🇸 United States
- On-site
- 1 day ago
- Oracle
- Oracle Fusion
- SOAP
- XML
- JSON
- SQL
- PL/SQL
- Python
- Oracle Cloud
- REST API
- Data Modeling
- ERP
- Devops
- SOX
- Regulatory Compliance
1 day ago
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
- 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
Oracle Accounting Hub & Cloud Integration SME · Tellus Solutions