Senior Developer – Oracle Retail Merchandising

Project overview

This contract role focuses on designing, developing, enhancing, and supporting Oracle Retail Merchandising applications for enterprise-scale retail processes. The core requirements are hands-on Oracle Retail Merchandising knowledge, strong Oracle PL/SQL and complex SQL development, performance tuning, Oracle Retail integrations and data flows, batch processing, and production troubleshooting. Unix/Linux and shell scripting, Git and CI/CD, data migration and ETL, data warehousing, and Agile/Scrum are preferred rather than mandatory.

The structured experience range is 5–8 years, with senior-level ownership of technical deliverables expected. The location is Porto; the description does not specify a work mode or country, and the employment type is contract.

Responsibilities

• Design, develop, enhance, and maintain solutions within Oracle Retail Merchandising applications.
• Develop complex PL/SQL queries, stored procedures, functions, packages, and triggers for retail merchandising processes.
• Optimize SQL and PL/SQL code using appropriate joins, indexing, partitioning, CTEs, and performance-tuning techniques.
• Support Oracle Retail Merchandising implementations, including customization, data migration, configuration, and integration with upstream/downstream systems.
• Develop and support batch processing and merchandising data workflows with appropriate error handling, logging, and scheduling
• Troubleshoot application, data, integration, and performance issues across merchandising processes.
• Perform data validation, reconciliation, and profiling to ensure merchandising data quality, working closely with QA and business teams.
• Participate in technical design, code reviews, defect resolution, release activities, and production support.
• Collaborate with functional consultants, business analysts, QA teams, and other application teams to deliver merchandising solutions.
• Follow Git, CI/CD, Agile, and Scrum development practices.

Requirements

• Hands-on Oracle Retail Merchandising modules
• Oracle PL/SQL development
• Complex SQL development and optimization
• Stored procedures, functions, packages, and triggers
• SQL and PL/SQL performance tuning
• Oracle database concepts
• Oracle Retail integrations and data flows
• Batch processing and job scheduling
• Troubleshooting and production support
• Retail merchandising domain knowledge

Project details

• Start: flexible
• Remote: hybrid
• Location: Portugal, PT