Oracle Technical Consultant

Johnson Electric Group; Chennai District; On-site; INR 1,800,000 - 2,500,000; Full time

Job summary

Johnson Electric in Chennai, India, seeks an experienced Oracle EBS R12.2 developer. You will lead system customization for core modules, create interfaces to MES/WMS/CRM/OA/payroll, and optimize SQL performance to support stable ERP operations.

The role requires 10–13 years of exclusive EBS R12.2 development experience, strong PL/SQL skills, and a disciplined approach to testing, documentation, and on-time delivery.

Qualifications

• Bachelor's degree or above in Computer Science, Software Engineering, Database or related technical majors.
• 10 to 13 years Oracle EBS R12.2 exclusive development experience, with independent full-cycle customization, integration and project delivery experience.
• Proficient in Oracle PL/SQL development, including packages, stored procedures, triggers and functions; skilled in SQL tuning, index optimization and database performance analysis.
• In-depth understanding of EBS R12.2 architecture, AD utilities and ZDDP online patching mechanism, familiar with EBS standard development tools and specifications.

Responsibilities

• System Customization & Development: Conduct standard secondary development and personalized customization for Oracle EBS R12.2 core modules (GL, AP, AR, BOM, FA, PO, INV, OM, WIP) including form modification, report development, workflow configuration and function expansion, complying with Oracle official specifications and enterprise coding standards and follow JE development standard and version control procedure.
• Prepare Program Migration Steps, Technical Specification (MD070) and Unit Test Report (TE110) according to JE development standard.
• Perform Program Unit Test and assist in Problem solving during Functional Test (FAT) and User Acceptance Test (UAT)
• Cross-System Integration: Design and develop stable data interfaces between EBS and third-party systems (MES, WMS, CRM, OA, payroll system, etc.) via PL/SQL, API, WebService, REST API and OAF, ensuring accurate and consistent data synchronization.
• Performance Tuning & Optimization: Optimize SQL statements, concurrent programs and interface execution efficiency, resolve system bottlenecks, slow queries and program exceptions guarantee stable ERP operation.
• Technical Support & Troubleshooting: Provide daily on-demand technical support, quickly locate and fix system bugs, data anomalies and functional failures; analyze business requirements and deliver feasible technical solutions.
• System Upgrade & Maintenance: Participate in EBS R12.2.10 patch updates, version iterations and environment migrations, proficiently apply AD ZDDP online patching mechanism to ensure zero business interruption during upgrades and complete regression testing.
• Documentation & Team Support: Compile standardized technical documents (development design, interface specs, deployment records, troubleshooting logs); accumulate project experience, maintain team knowledge base and guide junior developers.
• Project Delivery: Participate in requirement review and solution discussion, control development progress and quality to ensure on-time and high-quality project delivery.

Skills

Oracle EBS R12.2

PL/SQL development

SQL tuning

Performance analysis

Back-end customization

Education

Bachelors in CS/SE

Job description

Key Responsibilities

• System Customization & Development: Conduct standard secondary development and personalized customization for Oracle EBS R12.2.10 core modules (GL, AP, AR, BOM, FA, PO, INV, OM, WIP) including form modification, report development, workflow configuration and function expansion, complying with Oracle official specifications and enterprise coding standards and follow JE development standard and version control procedure.

Prepare Program Migration Steps, Technical Specification (MD070) and Unit Test Report (TE110) according to JE development standard.

Perform Program Unit Test and assist in Problem solving during Functional Test (FAT) and User Acceptance Test (UAT)

• Cross-System Integration: Design and develop stable data interfaces between EBS and third-party systems (MES, WMS, CRM, OA, payroll system, etc.) via PL/SQL, API, WebService, REST API and OAF, ensuring accurate and consistent data synchronization.
• Performance Tuning & Optimization: Optimize SQL statements, concurrent programs and interface execution efficiency, resolve system bottlenecks, slow queries and program exceptions guarantee stable ERP operation.
• Technical Support & Troubleshooting: Provide daily on-demand technical support, quickly locate and fix system bugs, data anomalies and functional failures; analyze business requirements and deliver feasible technical solutions.
• System Upgrade & Maintenance: Participate in EBS R12.2.10 patch updates, version iterations and environment migrations, proficiently apply AD ZDDP online patching mechanism to ensure zero business interruption during upgrades and complete regression testing.
• Documentation & Team Support: Compile standardized technical documents (development design, interface specs, deployment records, troubleshooting logs); accumulate project experience, maintain team knowledge base and guide junior developers.
• Project Delivery: Participate in requirement review and solution discussion, control development progress and quality to ensure on-time and high-quality project delivery.

Job Requirements

Mandatory Requirements

• Bachelors degree or above in Computer Science, Software Engineering, Database or related technical majors.
• 10 to 13 Years Oracle EBS R12.2 exclusive development experience, with independent full-cycle customization, integration and project delivery experience.
• Proficient in Oracle PL/SQL development, including packages, stored procedures, triggers and functions; skilled in SQL tuning, index optimization and database performance analysis.
• In-depth understanding of EBS R12.2 architecture, AD utilities and ZDDP online patching mechanism, familiar with EBS standard development tools and specifications.