Oracle Retail MFCS Technical/Techno-Functional Consultant

Position: Oracle Retail MFCS Technical/Techno-Functional Consultant

Location: Remote / On-Demand Travel to Client Location

Duration: Long term contract

Job Summary

We are seeking an experienced Oracle Retail Merchandising Foundation Cloud Service (MFCS) Technical / Techno-Functional Consultant to support the design, development, integration, implementation, and enhancement of Oracle Retail Merchandising solutions.

The ideal candidate will have strong hands-on experience with Oracle Retail MFCS, including Merchandising System, Item, Supplier, Inventory, Pricing, Purchase Orders, Transfers, Sales Audit integration, and financial/retail downstream integrations. The candidate should be comfortable working across both technical and functional areas and collaborating with business, retail, and integration teams.

Key Responsibilities

• Design, develop, customize, and support Oracle Retail MFCS solutions based on business requirements.
• Analyze functional requirements and translate them into technical specifications and scalable MFCS solutions.
• Develop and maintain Oracle Retail MFCS interfaces, integrations, extensions, and customizations.
• Work extensively with Oracle Database, PL/SQL, SQL, stored procedures, packages, triggers, and performance tuning.
• Develop and support MFCS batch processes, jobs, and data interfaces.
• Work with retail master data including items, locations, suppliers, organizations, merchandise hierarchies, inventory, pricing, and purchasing.
• Support integration of MFCS with other Oracle Retail applications and external enterprise systems.
• Develop and troubleshoot integrations using REST APIs, SOAP services, XML, JSON, file-based integrations, and enterprise middleware.
• Work with downstream/upstream systems such as Oracle Retail SIM, RMS/MFCS, RPM, ReSA, Oracle Retail Xstore, Order Management, ERP/Finance, Warehouse Management, and other enterprise applications.
• Analyze interface failures, batch failures, data issues, and production incidents and provide root-cause analysis.
• Participate in technical design, code development, unit testing, SIT, UAT, deployment, and production support.
• Develop SQL queries and data validation scripts to troubleshoot and reconcile retail transaction and master data.
• Work closely with functional consultants and business users to understand retail processes and resolve application issues.
• Perform impact analysis for MFCS enhancements, patches, upgrades, and new implementations.
• Support data conversion, data migration, reconciliation, and validation activities.
• Prepare technical design documents, interface specifications, mapping documents, test cases, and support documentation.
• Follow coding standards, development best practices, and change-management processes.

Required Technical Skills

• 10+ years of IT experience with significant experience in Oracle Retail.
• Strong hands-on experience with Oracle Retail MFCS / Merchandising Foundation Cloud Service.
• Strong knowledge of Oracle Retail Merchandising architecture and data model.
• Strong Oracle SQL / PL/SQL development experience.
• Experience with MFCS batch processes and batch scheduling.
• Strong experience developing and troubleshooting retail integrations and interfaces.
• Experience with REST APIs, SOAP, XML, JSON, and file-based integrations.
• Experience with Oracle Database and performance tuning.
• Knowledge of Oracle Retail integration patterns and enterprise retail architecture.
• Experience with source control and deployment tools such as Git, Jenkins, Maven, or similar DevOps tools.
• Experience working in Agile/Scrum development environments.
• Strong debugging, troubleshooting, and production support skills.

Education

• Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field preferred