Gold Plus Glass Industry logo

Manager -Oracle Apps Technical Development

Gold Plus Glass Industry

5 - 8 years

Noida Delhi Roorkee

Posted:7 hours ago

Job Description

Designation:

1. Job Summary

We are looking for an experienced Oracle Apps Technical Developer with strong expertise in Oracle E-Business Suite (EBS R12.2), Oracle Database, SQL, PL/SQL, Oracle Reports, BI Publisher, and technical development. The candidate will be responsible for developing and customizing Oracle EBS applications, reports, interfaces, conversions, extensions, and workflows to support business requirements across Finance, Procurement, Inventory, Order Management, Supply Chain, and other enterprise functions.

The candidate should have hands-on experience in Oracle EBS technical architecture, application development, production support, performance tuning, and integration with third-party applications.

2. Key Responsibilities

A. Oracle EBS Technical Development

  • Develop, customize, and maintain Oracle EBS R12.2 applications.
  • Develop and maintain custom programs, packages, procedures, functions, and database triggers using SQL and PL/SQL.
  • Develop and customize Oracle Forms and Oracle Reports as per business requirements.
  • Create and maintain custom objects, tables, views, synonyms, sequences, and indexes.
  • Develop EBS extensions following Oracle development standards and customization best practices.
  • Support standard and custom EBS functionalities across Finance, SCM, Procurement, Inventory, and Order Management.

B. Reports Development

  • Develop and maintain Oracle BI Publisher reports using RTF and Excel templates.
  • Create XML Publisher data definitions, data templates, and concurrent programs.
  • Develop RDF reports and support existing Oracle Reports.
  • Register concurrent programs, executables, report definitions, and parameters in Oracle EBS.
  • Troubleshoot report output, formatting, performance, and data discrepancies.

C. Interfaces and Data Conversions

  • Develop inbound and outbound interfaces for Oracle EBS.
  • Work with open interface tables, APIs, and interface programs.
  • Develop data conversion programs using SQL and PL/SQL.
  • Integrate Oracle EBS with third-party applications using REST APIs, web services, JSON, XML, and file-based interfaces.
  • Perform data validation, error handling, reconciliation, and interface monitoring.

D. Oracle EBS Technical Architecture

  • Understand Oracle EBS R12.2 architecture, including application and database tiers.
  • Understand the concepts of online patching, adop, edition-based redefinition, and custom application deployment.
  • Follow Oracle standards for custom schemas, APPS schema access, custom top directories, and application object registration.
  • Coordinate with DBA and infrastructure teams for deployments, patching, and environment management.

E. Workflow and Application Support

  • Develop and troubleshoot Oracle Workflow processes and notifications.
  • Support concurrent managers, concurrent requests, request sets, and scheduled jobs.
  • Analyze application errors, debug PL/SQL code, and resolve production issues.
  • Perform root-cause analysis for recurring incidents and implement permanent fixes.
  • Support month-end and year-end business activities and critical reporting requirements.

F. Performance Tuning and Documentation

  • Optimize SQL queries, PL/SQL procedures, and report execution.
  • Analyze execution plans, indexes, database waits, and performance bottlenecks in coordination with the DBA team.
  • Prepare technical design documents, unit test cases, deployment instructions, and support documentation.
  • Coordinate with functional consultants, business users, and external implementation partners.

3. Mandatory Technical Skills

  • Oracle E-Business Suite R12.2 technical development.
  • Oracle Database 19c or equivalent Oracle Database experience.
  • Advanced SQL and PL/SQL programming.
  • Oracle Forms and Oracle Reports.
  • Oracle BI Publisher / XML Publisher.
  • Concurrent Programs and Concurrent Managers.
  • Interfaces, conversions, APIs, and custom program registration.
  • Oracle EBS data model and standard application tables.
  • Troubleshooting, debugging, and SQL performance tuning.

4. Preferred Technical Skills

  • Oracle Workflow and AME.
  • Oracle Application Framework (OAF).
  • Oracle REST Data Services (ORDS) and REST API integration.
  • Oracle APEX application development.
  • Oracle EBS R12.2 online patching and ADOP.
  • Git or other version-control tools.
  • Integration with manufacturing, warehouse, logistics, HRMS, or other third-party applications.
  • Knowledge of Oracle EBS Finance, Purchasing, Inventory, Order Management, and Supply Chain modules.

5. Educational Qualifications

  • Bachelor's degree in Computer Science, Information Technology, Engineering, or a related discipline.
  • Oracle Database or Oracle EBS certifications are desirable.

6. Experience Requirements

  • 5–8 Years of hands-on experience in Oracle Apps Technical development.
  • Practical experience in Oracle EBS R12.2 customization and production support.
  • Proven experience in developing reports, interfaces, conversions, and extensions.
  • Ability to independently analyse requirements, develop technical solutions, and troubleshoot production issues.
  • Experience working with functional teams and supporting business-critical ERP applications.

7. Key Performance Indicators (KPIs)

  • Timely delivery of development and enhancement requests.
  • Quality and accuracy of reports, interfaces, and custom programs.
  • Resolution time for production incidents.
  • Reduction in recurring technical issues.
  • Performance and reliability of custom applications.
  • Compliance with Oracle EBS development and deployment standards.
  • Quality of technical documentation and testing.

8. Key Competencies

  • Strong analytical and problem-solving skills.
  • Good communication and stakeholder coordination.
  • Ability to work independently and collaboratively.
  • Strong troubleshooting and debugging capabilities.
  • Commitment to coding standards, security, and change management.

9. Recruitment Assessment Areas

Candidates will be assessed on Oracle EBS R12.2 technical architecture, SQL and PL/SQL programming, BI Publisher, Oracle Forms and Reports, interfaces, APIs, concurrent programs, and real-world production support scenarios.

Skills Required

Eb Oracle Management Technical EBS Application Development Oracle apps technical EBS

Learn the skills this job asks for

Free courses, interview questions and practice for each skill.

Work Mode

Work from Office

Job Type

Full Time

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now
Gold Plus Glass Industry logo
Gold Plus Glass Industry

RecommendedJobs for You

Gold Plus Glass Industry logo

Noida, Delhi, Roorkee

Gold Plus Glass Industry logo

Noida, Delhi, Roorkee