Experience : 6-8 Years.

Role Overview :

We are looking for a seasoned Oracle EBS Technical Consultant with strong expertise in RICEW (Reports, Interfaces, Conversions, Extensions, Workflows) to support a complex Oracle EBS R12.x environment.

The role will focus on L2/L3 defect analysis, production support, and integration troubleshooting across SCM and Finance modules.

This is a hands-on technical role requiring deep skills in PL/SQL, Oracle APIs, debugging, and working with functional teams to resolve incidents and defects in business-critical processes.

The ideal candidate will be well-versed in end-to-end technical architecture, performance diagnostics, and integration troubleshooting, with the ability to resolve complex issues across production and non-production environments.

Key Responsibilities:

- Provide L2/L3 technical support and defect resolution for custom RICEW components across SCM (Order Management, Inventory, Procurement, WMS) and Finance (AR, AP, GL, FA).

- Troubleshoot and fix issues in :

1. Custom Reports (Oracle Reports, BI Publisher).

2. Custom Interfaces with 3PL, Retail, WMS, banking, and external systems.

3. Conversions and data load processes (bulk inserts, validations, staging tables).

4. Extensions using PL/SQL packages, Forms Personalizations, OAF.

5. Workflows for order processing, approvals, and notifications.

- Investigate data discrepancies, integration failures, and custom code bugs using PL/SQL, logs, and debug tools.

- Analyze and resolve issues related to data integrity, duplicate records, stuck transactions, and incorrect postings across modules.

- Maintain custom APIs, triggers, procedures, and views.

- Monitor and improve performance of custom code through AWR/ASH analysis, SQL tuning, and indexing strategies.

- Collaborate with functional consultants to understand business impact and translate into technical resolution steps.

- Perform code corrections, unit testing, and deployment preparation for production-safe fixes.

- Conduct root cause analysis (RCA) and develop reusable fix patterns or automation.

- Support batch job failures, concurrent program performance issues, and custom object dependency resolution.

- Participate in incident triage, work with middleware, DBA, and infra teams to resolve upstream/downstream failures.

- Handle ticketing via ServiceNow, ensuring SLA compliance and knowledge base updates.

- Maintain and enhance documentation for custom components and their dependencies across business flows.

- Manage inbound and outbound integrations with 3PL, Retail, WMS, banking, and external SaaS systems.

- Maintain source control, migration scripts, and patch impact assessments (via tools like STAT or manual analysis).

- Document all changes; ensure version-controlled, audit-ready artifacts.