13069 - Solution Architect – Oracle Retail

Vaga não está no LinkedIn

Novembro 13

Candidatar-se

Receber Emails com Vagas Similares

UltraCon Consultoria

SiteLinkedInTodas as Vagas

Consulting • SaaS • Education

A UltraCon Consultoria é uma consultoria especializada na alocação de especialistas em SAP, Oracle e outras plataformas. Focamos em projetos de melhoria de sistemas, projetos organizacionais e programas de treinamento, assegurando que as empresas potencializem a gestão e a eficiência operacional por meio de orientação especializada.

11 - 50 funcionários

Fundada em 1998

☁️ SaaS

📚 Educação

Descrição

• Design, build, and maintain scalable Oracle Retail solutions for extracting, transforming, and loading data into enterprise data warehouses. • Write optimized Oracle SQL queries (joins, partitions, indexing, CTEs) supporting large-scale transformations and analytical workloads. • Automate solution workflows using Unix Shell Scripting, incorporating error handling, logging, and scheduled execution (cron or enterprise schedulers). • Implement star and snowflake data models using best practices for data warehousing 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 ensuring high data quality.

🎯 Requisitos

• 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 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 environments. • Strong prior experience in Architecture, with direct exposure to Oracle Retail solution design. • Proven ability to design complex retail solutions handling large volumes of structured and unstructured data with 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.

🏖️ Benefícios

• Trabalho remoto • 100% remote