Sign upLog in

Technical Lead -Oracle Retail Solutions

Tata Consultancy Services Ltd

Antioch, CA

Apply
JOB DETAILS
SALARY
$120,000–$170,000 Per Year
SKILLS
Acceptance Testing, Analysis Skills, Application Programming Interface (API), Atlassian JIRA, Business Processes, Business Support, Change Management, Change Requests/Orders, 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, Linux Operating System, Merchandising, Oracle, Oracle PL-SQL, Order Processing, Pricing, Problem Solving Skills, Purchase Orders, Purchasing/Procurement, Reconciliation, Regression Testing, 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), Supply Chain Operations, System Validation, Systems Administration/Management, Technical Consulting, Technical Leadership, Unix Operating Systems
LOCATION
Antioch, CA
POSTED
30+ 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 managem ent, 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)

Salary Range: $120,000 - $170,000 a year

#LI-JH1

About the Company

T

Tata Consultancy Services Ltd