Oracle Technical Consultant - Forms & Reports

Job Description :

We are seeking a skilled Oracle Technical Consultant with strong expertise in Oracle E-Business Suite (EBS) development and customization. The ideal candidate should have hands-on experience in SQL, PL/SQL, Oracle Forms, Reports, OAF, XML Publisher, and Oracle Workflow, along with a good understanding of Oracle EBS technical architecture and business modules.

Roles & Responsibilities :

- Develop, customize, and support Oracle EBS applications.

- Design and develop SQL and PL/SQL packages, procedures, functions, and triggers.

- Develop and customize Oracle Forms and Reports.

- Build and enhance OAF (Oracle Application Framework) pages.

- Develop XML Publisher (BI Publisher) reports.

- Customize Oracle Workflow and implement Forms Personalization and Custom.pll.

- Develop and consume Oracle APIs and Interface Programs.

- Perform performance tuning of SQL and PL/SQL code.

- Work with Oracle EBS base tables, views, TL tables, and FND Flexfields.

- Collaborate with functional consultants to analyze business requirements and deliver technical solutions.

- Follow coding standards, SDLC processes, and change management practices.

- Use JIRA for task tracking and defect management.

Required Skills :

- Strong SQL & PL/SQL programming skills.

- Hands-on experience with Oracle Forms and Oracle Reports.

- Experience with Oracle Application Framework (OAF).

- Oracle Workflow, XML Publisher (BI Publisher), and Oracle APIs.

- Forms Personalization and Custom.pll.

- Oracle EBS Technical Architecture.

- TOAD or SQL Developer.

- Performance tuning and debugging.

- Knowledge of SDLC and JIRA.

- Functional Knowledge

- Good understanding of Oracle EBS modules such as :

1. Purchasing (PO)

2. Order Management (OM)

3. Inventory (INV)

4. Accounts Payable (AP)

5. Accounts Receivable (AR)

6. General Ledger (GL)

7. Oracle Process Manufacturing (OPM)