Haystack
← Back to Jobs
Sales
TC

Oracle Retail Product Analyst

TATA Consultancy Services LimitedUnited States🇺🇸United StatesPosted 30 Jul 2026

Why This Role Stands Out

Leverage your deep Oracle Retail RMS expertise in this hybrid role at a globally recognized company, driving critical merchandising and financial processes. You'll thrive here if you possess strong analytical skills and a passion for solving complex problems within retail operations, contributing to impactful projects and continuous skill development.

Quick Overview

Seniority
Mid Senior
Work mode
Hybrid
Location
United States
Posted
3 weeks ago
OraclePL/SQLSQLReconciliationRoot Cause Analysis

Job Description

Job Description
Must Have Technical/Functional Skills
  • 15+ years of hands-on experience supporting Oracle Retail RMS (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.
  • 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
  • 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.
  • 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 management, 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.
  • Document known issues, workarounds, and SOPs to enhance team efficiency.

Similar jobs

Browse related jobs

Apply now