Solution Architect – Oracle Retail

Job not on LinkedIn

November 13

Apply Now

Receive Emails with Similar Jobs

UltraCon Consultoria

WebsiteLinkedInAll Job Openings

Consulting • SaaS • Education

UltraCon Consultoria is a consultancy specializing in the allocation of experts in SAP, Oracle, and other platforms. They focus on system improvement projects, organizational projects, and training programs, ensuring businesses leverage management and operational efficiency through expert guidance.

11 - 50 employees

Founded 1998

☁️ SaaS

📚 Education

📋 Description

• Design, build, and maintain scalable Oracle Retail solutions for extracting, transforming, and loading data into enterprise data warehouses. • Write optimized Oracle SQL queries (joins, partitioning, indexing, CTEs) to support large-scale transformations and analytical workloads. • Automate solution workflows using Unix shell scripting, including error handling, logging, and scheduled execution (cron or enterprise schedulers). • Implement star and snowflake data models using data warehousing best practices to improve query performance and data accessibility. • Perform performance tuning of Oracle Retail applications and SQL pipelines to reduce latency and maximize throughput for batch and near-real-time processing. • Collaborate with QA and business teams to implement data validation, profiling, and reconciliation mechanisms to ensure high data quality.

🎯 Requirements

• Advanced expertise in Oracle Retail, including implementation, customization, and integration with enterprise systems. • Proficiency with core Oracle Retail modules such as RMS, RPM, and ReSA, with a strong focus on configuration and optimization. • Solid understanding of solution architecture, including system design, requirements analysis, and technical implementation. • Practical knowledge of data warehousing concepts, including facts/dimensions, slowly changing dimensions (SCD Types 1 and 2), surrogate keys, and ETL staging frameworks. • Familiarity with version control systems (e.g., Git), CI/CD practices, and Agile/Scrum methodologies. • Significant prior experience in architecture, with direct exposure to Oracle Retail solution design. • Proven ability to design complex retail solutions that handle large volumes of structured and unstructured data, with a focus on performance and scalability. • Demonstrated expertise in debugging, monitoring, and optimizing Oracle Retail solutions, including log analysis, integration troubleshooting, and performance tuning. • Prior experience with relational databases and advanced SQL tuning for analytical workloads and reporting use cases. • Experience working in Unix/Linux environments for batch automation and orchestration scripting.

🏖️ Benefits

• Remote work • 100% remote