Title: Oracle Fusion Technical Consultant
Duration: 6 Months Contract with a possibility for an extension
Work Location: PAN India
Work Timings: 12:00 – 9:00 pm IST (First 3 months while working from Office) & 2:00 – 11:00 pm IST (Partial overlap with US Team)
Key Responsibilities:
- Develop and maintain RICEW components (Reports, Integrations, Conversions, Extensions, Workflows) for Oracle Fusion ERP Cloud.
- Build and support integrations using Oracle Integration Cloud (OIC), including REST/SOAP interfaces, app-driven flows, scheduled processes, and file-based integrations.
- Design and develop data pipelines leveraging FDI (Fusion Data Intelligence), ODI (Oracle Data Integrator), and ADW (Autonomous Data Warehouse) for reporting, analytics, and data extraction use cases.
- Develop and optimize FBDI/ADFDI templates and logic for data conversions across Finance, Procurement, and PPM modules.
- Create, enhance, and secure BI Publisher, OTBI, and FRS reports, ensuring correct data sourcing and compliance with role-based security.
- Troubleshoot technical issues across integrations, OIC flows, ADW/FDI pipelines, reporting, and data reconciliation.
- Collaborate closely with functional consultants to convert business requirements into technical design specifications.
- Support SIT/UAT cycles by resolving technical defects, validating data flows, and contributing to traceability and regression test coverage.
- Conduct impact analysis for Oracle quarterly updates and assist in defect remediation and regression certification.
- Work with data migration teams to validate migration data, build reconciliation scripts, and ensure successful cutover migrations.
- Prepare and maintain technical design documents, deployment guides, and KT documentation.
- Support deployment and hypercare activities, ensuring stability of integrations, reports, and batch processes.
Required Qualifications:
- Bachelor's degree in Computer Science, Engineering, Information Systems, or related field.
- 6–10+ years of IT experience, with 7+ years hands-on development in Oracle Fusion ERP Cloud.
- Strong experience with OIC, including REST/SOAP APIs, orchestrations, file-based integrations, and secured connections.
- Hands-on expertise with FDI, ODI, ADW, and experience building data pipelines, extraction models, or analytical schemas.
- Strong technical skills with FBDI, ADFDI, SQL, PLSQL, XML, JSON, and XSLT.
- Experience developing and optimizing BI Publisher and OTBI reports.
- Understanding of Fusion ERP data models and technical touchpoints across GL, AP, AR, FA, CM, PO, SSP and FAH.
- Experience supporting large-scale ERP implementations, SIT/UAT cycles, integrations, and cutover activities.
- Ability to work collaboratively with offshore teams and cross-functional stakeholders.
- Strong troubleshooting, documentation, and communication skills.
- Preferred Certifications: OIC Integration Professional, Oracle BI certification.
