POSITION SUMMARY STATEMENT:

Seeking an experienced Plan to Manufacture (PTM) – Developer with robust 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 have 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.

DETAILED RESPONSIBILITIES / DUTIES:
- 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
- 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
- Validate migrated data through reconciliation and business sign‑off
- Develop and maintain:
- PL/SQL packages, procedures, functions, and validation scripts
- Conversion and reconciliation reports
- 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 bott

📌 Oracle EBS Fusion (Bengaluru)
🏢 HCL INDIA
📍 Bengaluru