Oracle Retail Product Analyst

Tata Consultancy Services; Boston (MA); On-site; USD 150,000 - 175,000; Full time

Benefits offered by this job

Discretionary incentive

Medical coverage

Dental & Vision

Parental leave

Training reimbursement

401K plan

Vacation and holidays

Job summary

Tata Consultancy Services is seeking an experienced professional to support Oracle Retail RMS systems in a complex retail environment. The role focuses on item setup, pricing, inventory, cost reconciliation, and data integrity across RMS modules.

You will troubleshoot production issues, coordinate with vendors, and ensure seamless data transfers between RMS, POS, Finance, and Warehouse systems. Candidates should have 15+ years with RMS, strong SQL/PLSQL skills, and robust knowledge of Unix/Linux

Qualifications

• 15+ years of hands-on experience with Oracle Retail RMS (v16.x or later).
• Strong understanding of retail merchandising processes.
• Experience with item setup, purchasing, pricing, inventory, and invoice reconciliation.
• Proficient in SQL and PL/SQL for data analysis, debugging, and fixes.
• Familiar with Unix/Linux environments for job monitoring and log analysis.

Responsibilities

• Investigate, troubleshoot, and resolve production issues related to RMS and interfaces.
• Ensure accuracy of data flow between RMS and POS, Finance, and Warehouse systems.
• Monitor RMS interface jobs and data transfers; resolve integration failures (SOA, OIC, flat files).
• Coordinate with Oracle Support and partners for defects, patches, or upgrades.
• Maintain configurations, data mappings, and system interfaces across RMS modules.

Skills

Oracle RMS

SQL/PLSQL

Unix/Linux

Retail merchandising

Data analysis

Issue troubleshooting

Job description

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


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

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.

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