JobScans.in

Job description

Job Summary We are looking for a skilled **PL/SQL Developer with Oracle Retail (Retek RMS) experience** to support and enhance retail merchandising applications. The candidate will be responsible for developing, customizing, and maintaining Oracle Retail RMS solutions, performing database development, troubleshooting production issues, and collaborating with cross-functional teams to deliver scalable retail solutions. Key Responsibilities - Design, develop, test, and maintain PL/SQL programs, packages, procedures, functions, and triggers. - Customize and support Oracle Retail Merchandising System (RMS) modules. - Analyze business requirements and translate them into technical solutions. - Perform database tuning, optimization, and troubleshooting. - Support batch processing, interfaces, and data integrations within Oracle Retail. - Work on defect fixes, enhancements, and production support activities. - Collaborate with business analysts, functional teams, and application support teams. - Ensure compliance with coding standards and best practices. - Participate in code reviews, testing, and deployment activities. Required Skills Core Skills - Oracle PL/SQL - Oracle Database (11g/12c/19c) - SQL Query Optimization - Stored Procedures, Functions, Packages, Triggers - Performance Tuning Oracle Retail Skills - Oracle Retail Merchandising System (RMS) - Oracle Retail Integration Components (RIB) preferred - Retail Data Model understanding - Batch Processing - Retail Merchandising Concepts Additional Technical Skills - Unix/Linux Shell Scripting - Oracle Forms/Reports (good to have) - XML, JSON - Data Migration and Data Analysis - Version Control Tools (Git, SVN) Domain Skills - Retail Merchandising - Inventory Management - Pricing and Promotions - Purchase Orders - Supply Chain and Replenishment Preferred Qualifications - Bachelor's degree in Computer Science, Information Technology, or related field. - 3+ years of Oracle PL/SQL development experience. - Hands-on experience with Oracle Retail RMS implementations/support. - Experience working in Agile environments. - Strong analytical and troubleshooting skills.