What are the responsibilities and job description for the Oracle Accounting Hub & Cloud Integration SME - No C2C position at Purplejack Technologies LLC?
- 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
Salary : $63