Oracle SCM Technical Consultant - EBS/WMS Modules

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