Associate Lead Consultant – Oracle EBS Technical

YASH Technologies

Senior Oracle EBS SCM Technical Consultant bridging supply chain requirements and system architecture. Design and build custom components, develop interfaces, and optimize performance in Oracle EBS.

Posted 7/17/2026full-timePune • 🇮🇳 IndiaSeniorWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in PL/SQL, Oracle Forms, and Oracle Reports for custom component development, alongside strong capabilities in data migration and system integration using Oracle EBS. Proficient in technical documentation and performance tuning to ensure optimal system operations.

Highest-signal resume keywords

PL/SQL DevelopmentOracle Forms CustomizationData Migration (ETL)Oracle Application Framework (OAF)Technical Documentation (MD070)

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

SQLPL/SQLOracle FormsOracle ReportsBI PublisherJDeveloperSQL DeveloperOracle Open InterfacesOracle SCM Data ModelsOracle Workflow Builder

Tools & Technologies

Oracle EBSData LoaderAPIs

Industry Keywords

Supply Chain Management (SCM)Inventory (INV)Purchasing (PO)Order Management (OM)Oracle Application Implementation Methodology (AIM)

Tech Stack

Tools & technologies

ETLOracleSQL

About the role

Key responsibilities & impact

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.

Requirements

What you’ll need

Minimum Work Experience, Qualifications, Knowledge, Skills, Abilities
Bachelor’s or Master’s degree in Computer Science, Information Technology, or a related field.
Master level in SQL, PL/SQL, Packages, Procedures, Functions, and Triggers.
Proficiency in Oracle Forms, Oracle Reports, BI Publisher, JDeveloper, and SQL Developer.
Extensive experience with Oracle Application Framework (OAF) and Oracle Workflow Builder.
Strong knowledge of standard Oracle Open Interfaces and APIs for data conversion.
Deep understanding of Oracle SCM data models and table structures for Inventory (INV), Purchasing (PO), and Order Management (OM).
Experience with the Oracle Application Implementation Methodology (AIM), specifically creating documents like MD070 (Technical Design) and TE020 (Unit Test Script)

Benefits

Comp & perks

Flexible work arrangements
Free spirit, and emotional positivity
Agile self-determination, trust, transparency, and open collaboration
All Support needed for the realization of business goals
Stable employment with a great atmosphere and ethical corporate culture