Oracle Technical Consultant

Experience Range - 6 to 10 years.

Location - Bengaluru, Chennai, Pune, Hyderabad, Noida.

Notice Period - Immediate to 60 days.

Job Description:

Seeking an experienced Plan to Manufacture (PTM) Developer with strong expertise as an Oracle EBusiness Suite (EBS) SCM PL/SQL Developer, specializing in data conversion and migration from EBS to Oracle Fusion SCM.

The ideal candidate will have deep handson 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 highquality conversion outcomes.

DETAILED RESPONSIBILITIES / DUTIES:

• Design, develop, and execute PL/SQLbased data conversion programs to support EBS to Oracle Fusion SCM migration, including:
• Data extraction from Oracle EBusiness 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 signoff
• 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 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

Skills:

Required

• Strong PL/SQL development expertise in Oracle EBusiness Suite SCM
• Handson experience with EBS to Fusion data conversion or migration projects
• Solid functional understanding of Plan to Manufacture (PTM) processes
• Indepth knowledge of Oracle EBS SCM modules, including:
• Inventory
• BOM / Routings
• WIP
• Planning
• Experience working with large data volumes and complex data relationships
• Strong analytical, problemsolving, and communication skills
• Ability to collaborate effectively with functional and technical migration teams

Good to Have

• Experience with Oracle Fusion SCM interfaces and data loading mechanisms
• Exposure to Oracle Integration tools or FileBased Data Import (FBDI)
• UNIX shell scripting for batch execution and automation

Experience:

• 610+ years of experience as an Oracle EBS SCM PL/SQL Developer
• Proven experience supporting EBS to Oracle Fusion SCM migration or upgrade initiatives
• Strong exposure to manufacturing and supply chain business domains

Required

• Bachelors degree in information technology, Computer Science, Engineering, or a related field