Oracle Ebs Technical Consultant

Prudence Technology; Kolkata District; On-site; INR 900,000 - 1,500,000; Full time

Job summary

Apps Tech in Kolkata is seeking an Oracle Apps Developer to onsite work from the customer office. The role requires strong experience with RICE components and developing/maintaining custom Oracle code and interfaces to forms-based applications.

You will build PL/SQL packages, procedures, and functions, implementing complex business logic, and work with functional consultants on technical designs. Proficiency in Oracle Forms/Reports and performance tuning is essential.

Qualifications

• Strong experience in Oracle Applications R12/11i suite.
• Proficient in Oracle Forms and Reports development.
• Experience with PL/SQL packages, procedures and triggers.
• Familiar with APPS Data Model and coding standards.
• Solid understanding of performance tuning and SQL optimization.
• Excellent communication and collaboration with functional teams.

Responsibilities

• Develop/maintain Oracle custom code and interfaces to Oracle Forms-based applications.
• Develop PL/SQL packages, procedures, and functions to implement complex business logic.
• Collaborate with functional consultants for technical design of requirements.
• Document technical designs and comment code thoroughly.
• Perform unit testing and integration testing with other components and larger Oracle applications.
• Ensure shell scripting, Java, and SQL tuning are applied as needed.
• Design and update OAF pages; work with R12/11i modules (AP/AR/GL/FA/INV/OM).
• Maintain adherence to data models and coding standards.

Skills

RICE Components

Oracle Forms

PL/SQL

Performance Tuning

OAF Pages

APPS Modules (AP/AR/GL/FA/INV/OM)

Shell Scripting

Java

SQL Tuning

Communication Skills

Data Model Knowledge

Coding Standards

Documentation

Unit & Integration Testing

Tools

Oracle Reports (BI/XML/RDF)

Job description

Apps Tech:

• 1. Onsite Requirement to work from Customer Office in Kolkata
• 2. Must have strong experience in RICE Components.
• 3. Develop/maintain oracle custom code and interfaces to oracle forms - based applications in accordance with business requirements.
• 4. Develop PL/SQL packages, procedures, and functions, and trigger from UI events or database triggers, to implement complex business logic.
• 5. Proficient in Form Personalization.
• 6. Work with functional consultants to come out with the appropriate technical design for business requirements.
• 7. Document all technical designs as well as comment or annotate actual development.
• 8. Be responsible for complete unit testing and integration testing with other custom components and the larger oracle application.
• 9. Good knowledge of Shell scripting, Java, SQL tuning, Designing of OAF pages is a plus.
• 10. Experience in R12 and 11i Series with Modules like AP,AR,GL,FA,INV,OM.
• 11. Solid Business Process / Requirement Analysis and Re- engineering Required.
• 12. Proficient in Oracle Forms, Oracle Reports (BI / XML / RDF), Oracle Workflow and Oracle RDBMS.
• 13. Good Understanding of Performance Tuning.
• 14. Must be Familiar with APPS Data Model and Oracle Coding Standard.
• 15. Should have a good communication skill.