Tata Consultancy Services · 1 week ago
Product Consultant
Pleasanton, CA
Full-time
Onsite
Senior Level, Lead/Staff
$180K/yr - $195K/yr
15+ years expTata Consultancy Services is looking for a Product Consultant with extensive experience in Oracle Retail RMS. The role involves providing support for Oracle RMS and its integrated modules, troubleshooting production issues, and ensuring data accuracy across systems.
Business Information SystemsConsultingInformation TechnologyIT Management
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
Qualification
Required
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
Bachelors (B.E)
BACHELOR OF COMPUTER SCIENCE
Company
Tata Consultancy Services
Tata Consultancy Services is a business solutions company that specializes on information technology services and consulting.
10001+ employees
H1B Sponsorship
Tata Consultancy Services has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (7880)
2024 (9690)
2023 (8537)
2022 (11159)
2021 (9813)
2020 (11984)
Funding
Current Stage
Public CompanyTotal Funding
unknown2004-08-25IPO
Leadership Team
K. Krithivasan
Chief Executive Officer & Managing Director
Aarthi Subramanian
President and Chief Operating Officer
Recent News
Trak.in - Indian Business of Tech, Mobile & Startups
2026-01-22
Hindu Business Line
2026-01-21
Company data provided by crunchbase