Oracle Retail Technical Consultant

Job Title : Oracle Retail Technical Consultant.

Experience : 3- 4 Years.

Location : Pune, Mumbai, Hyderabad, Bangalore, Chennai, Gurgaon, Kolkata (Hybrid Model).

Job Description :

We are seeking a highly skilled Oracle Retail Technical Consultant with 3- 4 years of experience in Oracle Retail applications, integration, and PL/SQL development.

The ideal candidate should have strong technical expertise in MFCS (Merchandising Foundation Cloud Service) integrations, Oracle Retail architecture, and hands-on PL/SQL coding, with the ability to troubleshoot and support production environments.

Key Responsibilities :

- Work on Oracle Retail Technical Integrations and understand data flow architecture across modules.

- Integrate MFCS with boundary/third-party applications using middleware (OIC, SOA Suite, MuleSoft) or point-to-point methods.

- Design and develop complex PL/SQL queries, procedures, packages, and triggers with a focus on performance tuning and debugging.

- Collaborate with functional teams to translate business requirements into technical solutions.

- Support and troubleshoot integration issues in production environments, ensuring smooth data flow across applications.

- Ensure compliance with best practices for Oracle Retail technical architecture and integration patterns (File-based, RFI, API-based).

- Provide technical support for Oracle Retail core modules such as Merchandising, Pricing, and Inventory.

Required Skills :

- Strong hands-on experience with PL/SQL (complex queries, packages, procedures, triggers, tuning, debugging).

- Solid understanding of Oracle Retail Integration & Data Flow Architecture.

- Practical knowledge of integration patterns : File-based, RFI (Retail Financial Integration), and API-based.

- Hands-on experience with MFCS (Merchandising Foundation Cloud Service) integrations with boundary/third-party applications.

- Experience working with middleware platforms (Oracle Integration Cloud, SOA Suite, MuleSoft, etc.) or point-to-point integrations.

- Strong troubleshooting and problem-solving skills in Oracle Retail technical environments.

- Excellent communication skills for effective interaction with business and functional teams.

Good To Have Skills :

- Exposure to Oracle APEX (dashboards, reporting, UI development).

- Experience with Oracle Retail SaaS environments.

- Knowledge of Oracle Integration Cloud (OIC) or similar middleware tools.

Additional Information :

Shift Timings : UK Shift (1 :30 PM 10 :30 PM IST) with on-call support as required.