Tata Consultancy Services

Oracle Retail Product Analyst

Tata Consultancy Services$150K — $175K *
Retail & Consumer Goods
11 - 15 years of experience
Job Overview by Ladders

Qualifications

  • 15+ years supporting Oracle Retail RMS (v16.x or later).
  • Strong understanding of retail merchandising processes.
  • Experience with item setup, purchasing, pricing, and inventory management.
  • Proficient in SQL and PL/SQL for data analysis and debugging.
  • Familiarity with Unix/Linux for job monitoring and log analysis.
  • Excellent analytical and problem-solving skills.

Responsibilities

  • Investigate and resolve production issues related to inventory and cost discrepancies.
  • Perform root cause analysis for recurring issues and implement preventive actions.
  • Ensure data accuracy between RMS and other systems like POS and Finance.
  • Monitor and resolve failures in data transfer jobs and integration layers.
  • Coordinate with vendors for product patches or upgrades.
  • Maintain system setups and configuration parameters across RMS modules.
  • Manage SQL fixes and data correction scripts with Database Administrators.
  • Conduct functional and integration testing for system changes.

Benefits

  • Discretionary Annual Incentive.
  • Comprehensive Medical Coverage including Health, Dental, and Vision.
  • Support for family with Maternal and Parental Leaves.
  • Insurance options like Auto & Home Insurance and Identity Theft Protection.
  • Reimbursement for certification and training, plus commuter benefits.
  • Generous time off policies including vacation and paid sick leave.
  • Legal and financial assistance options including 401K Plan and Student Loan Refinancing.
Full 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.


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: Aut& 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.


#LI-KR3

Salary Range-$150,000-$175,000 a year

About Tata Consultancy Services

Tata Consultancy Services (TCS) is an Indian multinational information technology (IT) services and consulting company, headquartered in Mumbai, Maharashtra, India. It is a subsidiary of Tata Group and operates in 149 locations across 46 countries. TCS is the largest Indian company by market capitalization and is ranked 11th on the Forbes Global 2000 list of the world's biggest public companies. TCS is also the second-largest IT services company in the world by revenue and the largest employer of women in India. The company provides services in areas including IT, consulting, and business solutions.
Learn more about Tata Consultancy Services
Size
469,261 employees
Industry

Similar Jobs

More Jobs at Tata Consultancy Services

More Retail & Consumer Goods Jobs

Find similar Oracle Retail Product Analyst jobs: