About the Role :
We are seeking an experienced Oracle SCM Technical Consultant with strong expertise in Oracle Cloud SCM, Warehouse Management System (WMS), and the Oracle EBS Inventory module.
The role focuses on PL / SQL-based interface development and integrations between legacy and modern WMS applications.
This is a lead PL / SQL development role that also requires functional knowledge of Supply Chain Management, Inventory Management, and Warehouse Management.
Note : There is no requirement for EBS forms, reports, UI customizations, or front-end development.
Key Responsibilities :
- Develop, enhance, and maintain PL / SQL packages, procedures, and interfaces for seamless data exchange between applications.
- Design and implement efficient SQL queries and scripts for reporting, data validation, and reconciliation.
- Collaborate with functional teams to understand warehouse operations, inventory management, and integration touchpoints.
- Monitor and troubleshoot interface errors, ensuring timely resolution to minimize operational impact.
- Optimize PL / SQL code and SQL queries for performance and scalability.
- Maintain technical documentation including interface designs, data mappings, and business rules.
- Be willing and able to work in rotational shifts, including night shifts or extended hours as required by business operations.
Required Skills & Qualifications :
Hands-on experience with Oracle E-Business Suite (R12 or later) or Fusion Cloud Applications in modules such as Procurement, Inventory, Order Management, and Warehouse Management.Strong expertise in PL / SQL and SQL development, including packages, procedures, functions, and complex query optimization.In-depth knowledge of Oracle Cloud SCM Warehouse Management System (WMS) processes and integrations.Proven experience in developing and supporting interfaces between Oracle EBS / Fusion Cloud and Oracle SCM WMS Cloud applications.Solid understanding of warehouse operations and inventory workflows.Excellent problem-solving and communication skills.Bachelors Degree in Computer Science, Information Technology, or a related field.Must-Have Skills :
Oracle EBS Inventory or Fusion Cloud Inventory, Order Management, Warehouse ManagementStrong SQL / PLSQL development and support expertise(ref : hirist.tech)