Oracle Retail Technical Consultant
Must Have Technical/Functional Skills
- 15+ years of hands-on experience supporting Oracle Retail RMS (v14.x, v16.x, or later).
- Strong understanding of retail merchandising processes —
- Item setup, purchasing, pricing, inventory, and invoice reconciliation.
- Experience with SQL and PL/SQL for data analysis, debugging, and fixes.
- Familiarity with Unix/Linux environments for job monitoring and log analysis.
- Working knowledge of Oracle integration technologies (SOA, OIC, flat files, or API-based).
- Experience using ITSM tools (ServiceNow, Jira, Remedy) for incident and change management.
- Excellent analytical, documentation, and problem-solving skills.
Core Modules Supported
- RMS (Retail Merchandising System): Item, supplier, cost, and purchase order management.
- RPM (Retail Price Management): Pricing, promotions, and markdowns.
- ReIM (Retail Invoice Matching): Invoice matching and cost reconciliation.
- ReSA (Retail Sales Audit): POS data validation and store-level reconciliations.
- Allocation / RWMS / SIM: Stock movement, allocation, and replenishment processes.
Roles & Responsibilities
- Provide L2/L3 support for Oracle RMS and its integrated suite
(RPM, ReIM, ReSA, Allocation, RWMS, SIM).
- Investigate, troubleshoot, and resolve production issues related to
- Item setup, purchase orders, inventory, and cost discrepancies.
- Perform root cause analysis (RCA) for recurring issues and implement preventive actions.
- Support daily and periodic batch processes,
EOD (End-of-Day), and EOW (End-of-Week) cycles.
- Ensure accuracy and consistency of data flow between RMS and other systems
(POS, Finance, Warehouse, etc.).
- Monitor interface jobs and data transfers, identifying and resolving failures in integration layers
(SOA, OIC, flat files, etc.).
- Coordinate with vendors (Oracle Support, integration partners)
for product defects, patches, or upgrades.
- Maintain configuration parameters and system setups across RMS modules.
- Manage data correction scripts, SQL fixes, and mass data updates in coordination with DBAs.
- Support patch deployments, upgrades, and functional testing.
- Maintain documentation of configurations, data mappings, and system interfaces.
- Participate in change requests, release managem ent, and deployment activities.
- Conduct functional, regression, and integration testing for new releases and patches.
- Collaborate with business teams to validate system fixes and enhancements in UAT environments.
- Ensure all system changes follow IT governance and audit standards.
- Partner with Merchandising, Finance, Supply Chain, and IT Operations teams
- to identify and resolve business process issues.
- Provide data analysis and reporting support using SQL queries or standard RMS reports.
- Train and guide L1 support and business users on common troubleshooting techniques.
- Document known issues, workarounds, and SOPs to enhance team efficiency.
Education
Bachelors (B.E)
Salary Range: $120,000 - $170,000 a year
#LI-JH1