Oracle SCM Technical Consultant

Oracle SCM Technical Consultant

We are seeking an experienced Plan to Manufacture (PTM) ? Developer with strong expertise as an Oracle E?Business Suite (EBS) SCM PL/SQL Developer, specializing in data conversion and migration from EBS to Oracle Fusion SCM. The ideal candidate will possess deep hands?on experience in PL/SQL development, legacy data conversions, and Oracle EBS SCM data models, combined with a solid functional understanding of Plan to Manufacture (PTM) processes. This role is critical to ensuring accurate, performant, and validated data migration as part of Oracle Fusion transformation programs. The role works closely with SCM functional consultants, Fusion functional teams, data migration leads, and business stakeholders to deliver high?quality conversion outcomes.

Key Responsibilities

• Design, develop, and execute PL/SQL?based data conversion programs to support EBS to Oracle Fusion SCM migration, including data extraction from Oracle E?Business Suite, data transformation and cleansing, and loading data into Fusion staging or interface layers.
• Support Plan to Manufacture (PTM)?related SCM modules, including Inventory, Bills of Material (BOM), Routings, Work in Process (WIP), Manufacturing, and Supply Chain Planning.
• Analyze and interpret Oracle EBS SCM data models, setups, and dependencies to ensure accurate data mapping to Fusion.
• Work closely with SCM functional teams to understand business rules, setup dependencies, and master/transactional data.
• Translate functional conversion requirements into technical specifications and validate migrated data through reconciliation and business sign?off.
• Develop and maintain PL/SQL packages, procedures, functions, and validation scripts, as well as conversion and reconciliation reports.
• Implement error handling and restart mechanisms for conversion cycles.
• Support mock conversions, SIT, UAT, dress rehearsals, and production cutover activities.
• Troubleshoot and resolve data migration issues, performance bottlenecks, and data integrity exceptions.
• Ensure adherence to data governance, auditability, and migration best practices.
• Prepare and maintain technical documentation, data mapping specifications, and conversion run books.

Requirements

• Required Skills:
• Strong PL/SQL development expertise in Oracle E?Business Suite SCM.
• Hands?on experience with EBS to Fusion data conversion or migration projects.
• Solid functional understanding of Plan to Manufacture (PTM) processes.
• In?depth knowledge of Oracle EBS SCM modules, including Inventory, BOM/Routings, WIP, and Planning.
• Experience working with large data volumes and complex data relationships.
• Strong analytical, problem?solving, and communication skills.
• Ability to collaborate effectively with functional and technical migration teams.

• Good to Have Skills:
• Experience with Oracle Fusion SCM interfaces and data loading mechanisms.
• Exposure to Oracle Integration tools or File?Based Data Import (FBDI).
• UNIX shell scripting for batch execution and automation.

Work Arrangements

• Type: Contract
• Experience: 7-12 years
• Location: Bangalore, Karnataka, INDIA