Experience - 5 plus years
Key Skills & Responsibilities
- Oracle EBS knowledge in version 12.2 or above.
- Excellent hands-on expertise with Oracle technologies and should be able to analyze / create / modify Oracle components, such as PLSQL, Forms, Reports, XML publisher, workflows, shell scripts, etc.
- Should have good knowledge of Oracle modules like OM, PO, iProcurement, Inventory and basic understanding of the P2P and O2C flows.
- 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 Custom Reports (Oracle Reports, BI Publisher)
- Custom Interfaces with 3PL, Retail, WMS, financial and external systems.
- Conversions and data load processes (bulk inserts, validations, staging tables).
- Extensions using PL/SQL packages, Forms Personalizations, OAF.
- 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.
