Oracle Fusion Financials Technical Lead or Oracle Cloud ERP Integration Architect

Must have Skills:- API, Data Modeling, JSON, Oracle, Python, XML Required Education: Bachelor's Degree Visa-Any , No H1b This role is for a senior Oracle Financials technical expert focused on end-to-end integration architecture for Oracle Accounting Hub Cloud Service (AHCS) and Oracle Fusion applications. It requires a Bachelor's degree with 8+ years of Oracle Financials technical implementation experience and 5+ years of hands-on AHCS technical experience. Candidate will design and implement integrations between multiple source systems and Oracle Cloud using ODI, OIC, REST/SOAP APIs, XML/JSON, FBDI, file-based integrations, SQL/PL/SQL, and Python, defining patterns, security and data exchange standards. Core work includes building source data ingestion frameworks for AHCS, defining source-to-target mappings, accounting event structures, inbound interfaces, data modeling, transformation and reconciliation design for high-volume financial transactions. Candidate will also handle performance optimization, error handling/monitoring, troubleshooting interface failures, root cause analysis, and support SIT, UAT, cutover, go-live and hypercare with operational documentation. Additionally, you will develop reports/dashboards using OTBI, BI Publisher and Financial Data Intelligence (FDI) and partner with Finance, Enterprise Architecture and Security teams for audit, SOX and compliance requirements. 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 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