Sign upLog in

Product Consultant -Oracle Retail Solutions

Tata Consultancy Services Ltd

Plymouth, MN

Apply
JOB DETAILS
SALARY
$120,000–$200,000 Per Year
SKILLS
Acceptance Testing, Analysis Skills, Application Programming Interface (API), Atlassian JIRA, Business Processes, Business Support, Change Management, Change Order Management, Consulting, Corrective Action, Data Analysis, Data Management, Data Quality, Debugging Skills, Documentation, Environmental Monitoring, Environmental Work, Finance, Functional Testing, IT Governance, IT Service Management (ITSM), Identify Issues, Incident Management, Information Technology & Information Systems, Information Technology/Systems Audit, Integration Testing, Inventory Costs, Inventory Management, Legal, Linux Operating System, Loan Funding, Merchandising, Oracle, Oracle PL-SQL, Order Processing, Pricing, Problem Solving Skills, Purchase Orders, Purchasing/Procurement, Reconciliation, Regression Testing, Release Management/Engineering, Remedy, Retail, Retail Management, Retail Merchandising, Retail Sales, Root Cause Analysis, SQL (Structured Query Language), Scripting (Scripting Languages), Service-Oriented Architecture (fka Distributed Object Architecture), ServiceNow, Software Patches, Standard Operating Procedures (SOP), Student Loans, Supply Chain Operations, System Validation, Systems Administration/Management, Technical Consulting, Unix Operating Systems
LOCATION
Plymouth, MN
POSTED
2 days ago

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 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.
  • 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)

TCS Employee Benefits Summary

  • Discretionary Annual Incentive.
  • Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.
  • Family Support: Maternal & Parental Leaves.
  • Insurance Options: Auto & Home Insurance, Identity Theft Protection.
  • Convenience & Professional Growth: Commuter Benefits & Certification & Training Reimbursement.
  • Time Off: Vacation, Time Off, Sick Leave & Holidays.
  • Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.

Salary Range: $120000 - $200000 a year

#LI-JH1

About the Company

T

Tata Consultancy Services Ltd