Senior Oracle EBS R12 & OIC Technical Consultant – SCM Integration

Santa Clara, CA, US • Posted 3 hours ago • Updated 3 hours ago
Full Time
No Travel Required
On-site
$75 - $80/hr
Fitment

Dice Job Match Score™

🔢 Crunching numbers...

Job Details

Skills

  • oracle

Summary

Key Responsibilities

  • Design, develop, and maintain Oracle EBS R12 technical components using SQL, PL/SQL packages, procedures, functions, views, triggers, and staging tables.
  • Develop Oracle EBS public APIs, open interfaces, custom concurrent programs, and request sets.
  • Implement FND_REQUEST processing and interface error-handling mechanisms.
  • Design, develop, and support OIC integrations using REST, SOAP, JSON, XML, SFTP, database, and file-based integration methods.
  • Develop bidirectional integrations between Oracle EBS R12 and Oracle Fusion Cloud.
  • Build data extracts and interfaces for Inventory, BOM, WIP, Purchasing, Order Management, MRP/ASCP, and SCM Planning.
  • Support integration of items, suppliers, inventory balances, forecasts, demand, supply, purchase orders, work orders, and planning recommendations.
  • Implement integration controls, including logging, reconciliation, retry mechanisms, duplicate prevention, and monitoring.
  • Troubleshoot SQL performance, concurrent program failures, API errors, OIC mappings, and data-quality issues.
  • Support technical design documentation, unit testing, CRP, SIT, UAT, cutover, go-live, and hypercare.
  • Develop or support custom Oracle Forms when required.

Required Skills

  • 8–10+ years of Oracle technical development experience.
  • Strong hands-on Oracle EBS R12 development.
  • Advanced SQL/PLSQL programming, debugging, and performance tuning.
  • Oracle EBS public APIs, open interfaces, concurrent programs, and staging tables.
  • Hands-on Oracle Integration Cloud (OIC) development.
  • REST/SOAP web services, JSON, XML, and SFTP integration experience.
  • Knowledge of Oracle EBS manufacturing and SCM modules.
  • Experience with Inventory, BOM, WIP, Purchasing, Order Management, and MRP/ASCP.
  • Unix/Linux and shell scripting.
  • Experience supporting integration testing, troubleshooting, and production deployments.

Preferred Skills

  • Oracle Fusion SCM Planning Cloud.
  • Oracle Demand Management.
  • Oracle Supply Planning.
  • Oracle Application Framework (OAF).
  • Oracle Forms development.
  • Oracle EBS Integrated SOA Gateway.
  • Manufacturing or global supply chain implementation experience.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 91175610
  • Position Id: 9146477
  • Posted 3 hours ago
Contact the job poster
LA

Lana Anya

Recruiter @ TECHAGI SOLUTIONS LLC

Create job alert
Never miss an opportunity! Create an alert based on the job you applied for.