SCM Integrations Consultant (OIC, PL/SQL, BIP)
Apply NowCompany: Info Way Solutions
Location: Saint Louis, MO 63129
Description:
Job Title: SCM Integrations Consultant (OIC, PL/SQL, BIP)
Location: St Louis MO - Onsite Job
Duration - 6+ months
Job Summary:
We are seeking an experienced SCM Integrations Consultant with expertise in Oracle Integration Cloud (OIC), PL/SQL, and BI Publisher (BIP). The ideal candidate will be responsible for designing, developing, and maintaining supply chain management (SCM) system integrations within Oracle Cloud ERP and third-party applications. This role requires a deep understanding of Oracle Fusion SCM modules, APIs, and reporting tools to streamline procurement, inventory, order management, and logistics processes.
Key Responsibilities:
1. Oracle Integration Cloud (OIC) Development
Design and develop SCM integrations using Oracle Integration Cloud (OIC).
Configure and manage OIC adapters, connections, and orchestrations.
Implement data mappings, transformations, and process automation for SCM workflows.
Troubleshoot and optimize OIC integration performance.
2. PL/SQL Development & Database Management
Develop and optimize PL/SQL scripts, procedures, and functions for SCM data processing.
Manage data extraction, transformation, and loading (ETL) in Oracle databases.
Work with Oracle Fusion SCM tables, APIs, and FBDI to develop efficient queries and stored procedures.
Ensure data integrity, security, and performance tuning for supply chain transactions.
3. BI Publisher (BIP) Reporting & Analytics
Develop custom reports and dashboards using BI Publisher (BIP).
Generate procurement, inventory, and order management reports.
Work with XML, RTF, and Excel templates to customize SCM reports.
Optimize reports for performance and usability in Oracle Cloud SCM.
4. SCM System Integrations & Support
Collaborate with SCM, IT, and Business teams to gather integration requirements.
Integrate Oracle ERP SCM modules with external systems (suppliers, logistics partners, EDI, and warehouse management systems).
Provide ongoing support, troubleshooting, and enhancements for integrations and reports.
Ensure compliance with SCM regulations, audit requirements, and data governance standards.
Required Skills & Qualifications:
Location: St Louis MO - Onsite Job
Duration - 6+ months
Job Summary:
We are seeking an experienced SCM Integrations Consultant with expertise in Oracle Integration Cloud (OIC), PL/SQL, and BI Publisher (BIP). The ideal candidate will be responsible for designing, developing, and maintaining supply chain management (SCM) system integrations within Oracle Cloud ERP and third-party applications. This role requires a deep understanding of Oracle Fusion SCM modules, APIs, and reporting tools to streamline procurement, inventory, order management, and logistics processes.
Key Responsibilities:
1. Oracle Integration Cloud (OIC) Development
Design and develop SCM integrations using Oracle Integration Cloud (OIC).
Configure and manage OIC adapters, connections, and orchestrations.
Implement data mappings, transformations, and process automation for SCM workflows.
Troubleshoot and optimize OIC integration performance.
2. PL/SQL Development & Database Management
Develop and optimize PL/SQL scripts, procedures, and functions for SCM data processing.
Manage data extraction, transformation, and loading (ETL) in Oracle databases.
Work with Oracle Fusion SCM tables, APIs, and FBDI to develop efficient queries and stored procedures.
Ensure data integrity, security, and performance tuning for supply chain transactions.
3. BI Publisher (BIP) Reporting & Analytics
Develop custom reports and dashboards using BI Publisher (BIP).
Generate procurement, inventory, and order management reports.
Work with XML, RTF, and Excel templates to customize SCM reports.
Optimize reports for performance and usability in Oracle Cloud SCM.
4. SCM System Integrations & Support
Collaborate with SCM, IT, and Business teams to gather integration requirements.
Integrate Oracle ERP SCM modules with external systems (suppliers, logistics partners, EDI, and warehouse management systems).
Provide ongoing support, troubleshooting, and enhancements for integrations and reports.
Ensure compliance with SCM regulations, audit requirements, and data governance standards.
Required Skills & Qualifications:
- 5-10 years of experience in SCM Integrations & Oracle Cloud ERP.
- Hands-on expertise in Oracle Integration Cloud (OIC) & Web Services (SOAP/REST APIs).
- Strong knowledge of PL/SQL development, query optimization, and database performance tuning.
- Experience with BI Publisher (BIP), OTBI, and supply chain reporting.
- Familiarity with Oracle ERP SCM modules (Procurement, Inventory, Order Management, Manufacturing, Logistics).
- Experience in file-based integrations (FBDI), Web Services, and scheduled processes.
- Understanding of OAuth, SSO, security policies, and role-based access control (RBAC).
- Excellent problem-solving and troubleshooting skills.