Associate Lead Consultant - Oracle EBS Technical Job

Experience

We are seeking a Senior Oracle EBS SCM Technical Consultant who can bridge the gap between supply chain requirements and system architecture developing, integrating, and maintaining RICEFW objects (Reports, Interfaces, Conversions, Extensions, Forms, and Workflows) within modules like Inventory, Purchasing, and Order Management

Experience 8 - 10 Years

Job Description

Key Responsibilities:

• • RICEFW Development: Design and build custom components using PL/SQL, Oracle Forms, and Oracle Reports / BI Publisher. 
  • Data Migration: Extract, transform, and load (ETL) legacy supply chain data into EBS using standard API's, Open Interfaces, and Data Loader. 
  • System Integration: Develop and maintain interfaces and APIs to facilitate data exchange between Oracle EBS and external third-party or legacy systems. 
  • Workflow & Forms Customization: Modify existing workflows and design new custom extensions and forms to align the system with unique operational processes.
  • Technical Documentation: Author Technical Specification documents (e.g., MD070), detailing system architecture, table structures, and code logic for functional or development teams. 
  • Performance Tuning: Troubleshoot complex system performance issues, optimize slow-running SQL queries, and monitor concurrent programs to ensure seamless operations.
  • Upgrades & Patching: Assist in system upgrades (e.g., R12.1 to R12.2) and apply necessary database patches while ensuring custom objects remain compatible

Required Technical/ Functional Competencies

REQUIRED QUALIFICATIONS:

Minimum Work Experience, Qualifications, Knowledge, Skills, Abilities

• Education: Bachelor’s or Master’s degree in Computer Science, Information Technology, or a related field.\

Technical Expertise

• Programming: Master level in SQL, PL/SQL, Packages, Procedures, Functions, and Triggers.
• Development Tools: Proficiency in Oracle Forms, Oracle Reports, BI Publisher, JDeveloper, and SQL Developer.
• Frameworks: Extensive experience with Oracle Application Framework (OAF) and Oracle Workflow Builder.
• Data Tools: Strong knowledge of standard Oracle Open Interfaces and APIs for data conversion.

Functional & Domain Knowledge

• Core Modules: Deep understanding of Oracle SCM data models and table structures for Inventory (INV), Purchasing (PO), and Order Management (OM).
• Methodologies: Experience with the Oracle Application Implementation Methodology (AIM), specifically creating documents like MD070 (Technical Design) and TE020 (Unit Test Script)

Required Behavioral Competencies

Accountability: 

• Being a role model for taking initiative and ensuring others take initiative, removing obstacles for others, taking ownership for results and deadlines for self and others, and acting as a role model for being responsible.
• Identify project risks, issues, and dependencies and proactively support resolution.
• Strong analytical and problem-solving abilities.
• Excellent stakeholder management and communication skills.
• Ability to work independently and in a collaborative team environment.
• Strong ownership and accountability mindset.

Agility:

• Works with a diverse set of situations, people and groups and adapts and motivates self and team to thrive in changing environment.

Collaboration:

• Reaches out to others in team to ensure connections are made and team members are working together.
• Looks for ways to integrate work with other teams, identifying similarities and opportunities, making necessary changes in work to ensure successful integration.

Customer Focus:

• Engages in executive customer discovery to predict future needs of customers and drives customer relationships with a long-term focus and takes actions to enhance customer loyalty.

Communication:

• Communicates and presents complex ideas, information, and data to multiple, broad, and demanding stakeholders internal and/or external to the Organization.
• Helps others communicate better with their audience. Demonstrates honest, direct, and transparent communication and facilitates conversations within the team and its close collaborators.

Drives Results:

• Proactively seeks challenging and differentiated opportunities and drives and motivates team members to take on more responsibility.

Resolves Conflict:

• Balances the business interests of all stakeholders and manages any conflicts offering mutually beneficial options.

Certifications