Analyst, Oracle EBS Technical

Job Purpose: (Why does the job exist?)

Design, develop, enhance, and support technical solutions within Oracle E-Business Suite (EBS). Translate functional and business requirements into reliable technical solutions using SQL, PL/SQL, Java, Oracle Reports, and XML Reports while providing L2 technical support, troubleshooting application issues, supporting integrations, and ensuring solution performance and maintainability.

Person Specifications: (Minimum attributes for the job holder to be effective in this job)Basic Academic Qualification

Bachelor’s degree in Computer Science, Information Technology, Software Engineering, Computer Engineering, or a related discipline.

Preferred Qualification

Postgraduate qualification in Computer Applications (MCA), Information Systems, Software Engineering, or a related discipline is advantageous.

Technical Certifications

Oracle Database PL/SQL Developer certification, Oracle EBS Technical certification, or other relevant Oracle certifications are preferred.

Experience

Minimum 3-5 years of relevant experience in Oracle EBS technical development, enterprise application development, reporting, integrations, or application support.

Specific Industry Experience

Hands-on experience in Oracle EBS technical development and production support, preferably supporting Oracle Financials and Supply Chain modules. Exposure to enterprise integrations and complex multi-application environments is preferred.

Computer Skills

Strong proficiency in SQL and PL/SQL, Oracle EBS technical architecture, Oracle Reports and XML/BI Publisher Reports, Java, Interfaces and APIs, Relational databases and data mapping, Technical debugging and troubleshooting

Language Proficiency

Very good proficiency in Business English, including the ability to interpret technical requirements, prepare solution designs and system documentation, and communicate effectively with technical and functional stakeholders.

Competencies/Skills

• Oracle EBS Technical Development
• SQL & PL/SQL Development
• Oracle Reporting
• Technical Analysis & Troubleshooting
• Integration & Data Management

Work Environment & Physical Effort

Primarily office-based, involving extensive use of computers and development tools, with regular interaction with technical, functional, and business teams.

Supervision Received (Job title of this position’s immediate Superior)Lead, Oracle Applications Functional Supervision Given (if any, job title/s of subordinates for this position)

None

Communications: (job title, department, and entities with which the position has an interface)Internal:IT Applications, Oracle Functional Teams, Technical Leads, Database Administration, Integration Teams, Infrastructure, and Application Support.External:Oracle, technology vendors, implementation partners, and consultants. Job Authority / Other Factors: (Decision-making authority, resources controlled, operational, financial, administrative functions, or any special distinct requirement for the job as required)

Develop and modify assigned Oracle EBS technical objects within approved standards; perform technical analysis and testing; recommend technical improvements; troubleshoot production issues; support deployments; and escalate significant application, database, integration, or architecture issues to the appropriate technical authority.

KEY RESULTS AREAS (KRA) (What areas or major activities will produce the contributions that the company expects from this job holder?)

• LIST OF RESPONSIBILITIES (Routine and non-routine tasks that have to be performed to achieve the KRA identified. Highlight the result that is expected from each task)

1

Oracle EBS Technical Development: Develop and maintain reliable Oracle EBS technical solutions supporting business requirements.

• Develop and enhance Oracle EBS technical objects using SQL, PL/SQL, Java, Oracle Reports, and XML/BI Publisher.

• Develop reports, procedures, packages, interfaces, conversions, and other approved technical components.

• Translate approved functional specifications into technical designs and solutions.

• Ensure developments follow established coding, security, performance, and documentation standards.

• Perform code review, debugging, optimization, and technical validation of assigned developments.

2

Reporting & Customization: Develop and maintain reporting and customization solutions supporting Oracle EBS business processes.

• Develop and customize Oracle Reports and XML/BI Publisher reports.

• Modify existing reports based on approved business and functional requirements.

• Develop queries, data extracts, and reporting solutions across applicable EBS modules.

• Troubleshoot report-performance, data, formatting, and execution issues.

• Ensure report customizations remain controlled, documented, and maintainable.

3

L2 Application Support & Troubleshooting: Resolve technical Oracle EBS incidents requiring advanced analysis and development expertise.

• Analyze escalated application, database, reporting, and technical incidents.

• Review logs, traces, concurrent requests, backend processes, and database information to identify root causes.

• Resolve technical issues within assigned authority and agreed service levels.

• Identify recurring application problems and recommend permanent corrective solutions.

• Escalate complex database, architecture, infrastructure, or product-related issues to appropriate L3 teams or Oracle.

4

Integration & Interface Support: Develop and support reliable data flows between Oracle EBS and other enterprise applications.

• Develop and support approved interfaces and integrations involving Oracle EBS.

• Investigate failed transactions, interface errors, and data-processing issues.

• Analyze error logs, transaction statuses, and data mappings to identify integration failures.

• Coordinate resolution with integration, database, functional, and external technical teams.

• Monitor recurring integration issues and recommend improvements to reliability and controls.

5

Testing, Change & Deployment Support: Ensure technical changes are properly tested, documented, and deployed.

• Perform unit and technical testing for developments, customizations, reports, and fixes.

• Support system integration testing, regression testing, and UAT activities.

• Analyze and resolve technical defects identified during testing.

• Support controlled migration and deployment of approved technical changes.

• Conduct post-deployment verification and resolve implementation issues.

6

Technical Documentation & Continuous Improvement: Maintain reliable technical documentation and continuously improve Oracle EBS solutions.

• Prepare technical design documents, program specifications, deployment instructions, and support documentation.

• Maintain documentation for customizations, reports, interfaces, fixes, and technical configurations.

• Maintain technical knowledge articles for recurring support issues.

• Identify opportunities to improve system performance, reliability, maintainability, and support efficiency.

• Share technical knowledge and reusable solutions with application-support teams.

7

Oracle Financials, Supply Chain & Localization Support: Apply relevant functional-domain knowledge when developing and supporting Oracle EBS solutions.

• Maintain working knowledge of Oracle Financials and Supply Chain business processes and module interactions.

• Understand technical dependencies across integrated Financials and Supply Chain processes.

• Support report development and customization for Oracle Financials and Supply Chain modules.

• Apply applicable India Localization requirements when developing or modifying Oracle reports.

• Coordinate with Functional Consultants to ensure technical solutions correctly address business-process requirements.

8

HSE Responsibility: Perform assigned responsibilities in accordance with company Health, Safety, and Environmental requirements.

• Comply with applicable HSE policies, procedures, and workplace requirements.

• Participate in mandatory HSE training and awareness activities.

• Report hazards, incidents, and unsafe conditions promptly.

• Maintain a safe and ergonomically appropriate workstation.

• Protect company systems, information, equipment, and other resources in accordance with established requirements.