Oracle Fusion SCM Technical Consultant
Posted Updated
Summary
Technical consultant role centered on Oracle Fusion SCM: building BIP/OTBI reports, developing OIC integrations and inbound/outbound interfaces using FBDI, ADFdi and REST/SOAP APIs, writing SQL/PL-SQL for data extraction and migration, and supporting Procurement, Inventory, Manufacturing and Order Management solutions.
- Develop and maintain technical solutions for Oracle Fusion SCM modules.
- Design, develop, and support reports using BI Publisher (BIP) and OTBI.
- Build and maintain integrations between Oracle Fusion SCM and third-party applications.
- Develop inbound and outbound interfaces using Oracle Integration Cloud (OIC).
- Work on FBDI, ADFdi, and REST/SOAP APIs for data migration and integrations.
- Develop SQL and PL/SQL queries for data extraction and validation.
- Work with Oracle SCM tables, views, and data models.
- Develop custom reports for Procurement, Inventory, Manufacturing, and Order Management.
- Handle data conversions, migration, and reconciliation activities.
- Troubleshoot integration failures and reporting issues.
- Monitor scheduled jobs, ESS jobs, and interface processes.
- Collaborate with functional teams to understand business requirements and deliver technical solutions.
- Prepare technical design documents, mapping documents, and unit test cases.Role & responsibilities
Preferred candidate profile
- Oracle Fusion SCM Technical.
- Oracle BI Publisher (BIP).
- Oracle Transactional Business Intelligence (OTBI).
- Oracle Integration Cloud (OIC).
- SQL and PL/SQL.
- REST and SOAP APIs.
- FBDI and ADFdi.
- Oracle Fusion SCM reporting and integrations.