Oracle Retail Data Migration Expert -
Oomple
Description
Job Title: Oracle Retail Data Migration Expert
Experience: 10+ Years
Location: Ottawa / Remote
Duration: 1 year, extendable
Role Overview
We are seeking a highly skilled Oracle Retail Data Migration Expert with extensive experience in leading enterprise-scale retail data migration initiatives within Oracle Retail implementations. The successful candidate will be responsible for planning, designing, executing, and validating end-to-end data migration activities, ensuring the successful transition of high-quality business data from legacy systems into Oracle Retail solutions.
This role requires deep expertise in Oracle Retail data structures, retail business processes, ETL methodologies, data quality management, and migration best practices. You will collaborate closely with business stakeholders, functional consultants, solution architects, technical teams, and system integrators to ensure accurate, complete, and timely data migration throughout the implementation lifecycle.
Key Responsibilities
- Data Migration Strategy: Develop and execute the overall data migration strategy, including migration planning, governance, sequencing, risk management, and cutover activities aligned with the Oracle Retail implementation roadmap.
- Data Discovery & Assessment: Analyze legacy retail systems to assess data quality, completeness, business rules, dependencies, and migration readiness while identifying data cleansing opportunities.
- Data Mapping: Define and document detailed source-to-target data mappings across Oracle Retail applications, ensuring alignment with business requirements and Oracle Retail data models.
- Data Cleansing & Quality: Collaborate with business stakeholders to identify duplicate, obsolete, or inaccurate data and establish cleansing rules to enhance overall data quality prior to migration.
- ETL & Data Transformation: Work with technical teams to design, develop, and validate ETL processes for extracting, transforming, and loading data into Oracle Retail applications.
- Migration Execution: Coordinate and execute multiple mock conversions, dress rehearsals, production migrations, and post-load validation activities while ensuring minimal business disruption.
- Data Validation & Reconciliation: Develop reconciliation processes to validate migrated data, including item masters, inventory balances, pricing, suppliers, purchase orders, and financial data to ensure completeness and accuracy.
- Cross-Functional Collaboration: Collaborate closely with Merchandising, Pricing, Inventory Management, Supply Chain, Store Operations, Finance, and IT teams to validate migrated data and resolve migration issues.
- End-to-End Implementation: Engage throughout the Oracle Retail implementation lifecycle, including solution design, system integration testing (SIT), user acceptance testing (UAT), cutover planning, go-live, and hypercare support.
- Documentation: Prepare migration strategies, data mapping documents, migration runbooks, validation reports, reconciliation reports, cutover plans, and migration governance documentation.
- Deployment Support: Assist in production deployment activities, monitor migration execution, troubleshoot migration issues, coordinate rollback planning, and provide hypercare support following go-live.
- Retail Domain Expertise: Strong understanding of retail operations and business processes, including Merchandising, Pricing & Promotions, Inventory Management, Store Operations, Supply Chain, Procurement, and Order Management.
- Oracle Retail Expertise: Extensive experience working with Oracle Retail applications including RMS, ReSA, RPM, SIM/SIOCS, Xstore POS, OMS, Customer Engagement, and other Oracle Retail solutions.
- Data Migration: Proven experience leading enterprise-scale data migration initiatives, including data profiling, cleansing, mapping, transformation, validation, reconciliation, and production cutover.
- Data Management: Strong understanding of master data management principles, data governance, reference data, data quality management, and data lifecycle best practices.
- ETL & Database Technologies: Experience with ETL tools and database technologies such as Oracle Data Integrator, Informatica, Talend, SQL, PL/SQL, Oracle Database, and related migration utilities.
- Technical Tools: Familiarity with Jira, Azure DevOps, MS Visio, SQL Developer, and data analysis tools.
- Integration & Architecture: Experience with Oracle Retail Integration Bus, Oracle Cloud Infrastructure, APIs, microservices architecture, and enterprise integration patterns is preferred.
- Analytical Mindset: Strong analytical, troubleshooting, and problem-solving skills with the ability to identify data issues and implement practical solutions.
- Stakeholder Management: Excellent communication and collaboration skills with the ability to engage business stakeholders, technical teams, system integrators, and executive leadership throughout migration activities.
- Global Teams: Experience working effectively within global, cross-functional, and distributed implementation teams.
Education & Certifications
- Bachelor's or Master's degree in Computer Science, Information Technology, Data Management, or a related field.
- Oracle Retail, Oracle Database, Oracle Cloud, or Data Management certifications are considered a major plus.
Preferred Experience
- Hands-on experience leading Oracle Retail data migration workstreams during full lifecycle implementations or upgrades.
- Experience migrating data from legacy retail merchandising, ERP, POS, warehouse management, and order management systems into Oracle Retail.
- Experience executing multiple mock conversions, production cutovers, and post-migration reconciliation activities.
- Prior experience working with system integrators or large retail organizations.
- Exposure to fast-paced omnichannel retail environments.
What Makes a Strong Candidate
- A deep understanding of Oracle Retail data models, retail business processes, and enterprise data migration methodologies.
- The ability to successfully lead complex data migration initiatives from strategy through production deployment.
- Proven experience delivering high-quality, accurate, and fully reconciled data migrations within large-scale Oracle Retail transformation programs.
- Strong collaboration skills, with the ability to work effectively across business, functional, and technical teams while maintaining a focus on data quality and business continuity.
- Demonstrated experience planning and executing multiple mock conversions, production cutovers, and post-go-live stabilization activities.
Work Environment: Remote, Canada
Call to Action: If you are a qualified consultant who meets the criteria outlined above, we encourage you to apply. Please click the apply button to submit your application or contact us for more information.
Vacancy posted a month ago
Similar jobs that could be interesting for youBased on the Oracle Retail Data Migration Expert - in Canada vacancy
- ...Description Job Opportunity: Oracle Retail Solution Architect Role Overview Job Title:... ...the-box capabilities. Integration & Data Management System Integration: Design... ...Strategy: Ensure data consistency, define migration strategies, and establish robust data...OracleFull timeRemote work
- ...Description Job Description: Oracle Retail Business Analyst Role Overview Job Title:... ...fixes to ensure overall solution quality. Data Management: Analyze business data and... ...reporting while ensuring data accuracy during migration and system implementation. Required...OracleFull timeRemote work
- ...Description Job Description: Oracle Retail Project Manager Company Overview We are dedicated to enhancing the quality of life... ...ensuring successful integration with systems while supporting data migration strategy and coordinating batch processing requirements. Governance...OracleLong term contract
- ...applications and next steps. Our partner is looking for a Presales Security Expert Mid-Market based in Canada. This is a customer-facing... ..., SDN, NFV, virtualization, centralized management, SIEM, and data center redundancy as an advantage. Previous experience working...SuggestedRemote job
$85k - $100k per year
...partners with the largest North American retailers and brands to deliver local promotions and... ...every step of the way. Flipp's CPG and Retail Media team focuses on building and maintaining... ...s consultative sales motion — grounded in data, tailored storytelling, and compelling...SuggestedLong term contractLocal areaRemote workFlexible hoursShift work- ...and next steps. Our partner is looking for a Principal Clinical Data Science Programmer based in Canada. This is a senior-level opportunity... ...stakeholders in a fast-paced environment. As a subject matter expert, you will mentor programmers, contribute to knowledge sharing,...Remote jobLong term contract
- ...applications and next steps. Our partner is looking for a Senior Clinical Data Science Programmer based in Canada. This is a senior... ...knowledge across the programming community. As a subject matter expert, you will help introduce better tools, processes, and programming...Remote job
- ...the most important work of your career. About the team The Data Foundations team drives Data Engineering and Data Apps and Tooling... ...Python - and while we don't expect everyone on the team to be an expert in all of these, you will work across all of these technologies...Internship
- ...opportunity to put the global economy within everyone's reach while doing the most important work of your career. About the team Data Science at Stripe is a vibrant community where data analysts and data scientists learn and grow together. You'll work with some of the...Full timeInternship
$150k - $185k per year
...tools and the largest charitable-giving database on the market. As the giving sector evolves, so does Kindsight. We combine real-time data, artificial intelligence, purpose-built CRM technology, donor research, and fundraising intelligence to help thousands of organizations...Long term contract- ...MAGASIN Dirigez toutes les opérations des magasins de manière systématique et efficace, selon les rythmes opérationnels établis d'adidas Retail Operating Rhythms Assurez-vous que les normes de gestion du commerce de détail adidas respectent les politiques, procédures,...Full timeApprenticeship
$150k - $250k per year
...(HCPs), and patients by orchestrating AI-enabled omnichannel engagement across the entire patient and prescriber lifecycle. As the Data Analytics Lead , you will own the data systems and associated measurement analyses that sit at the intersection of our products, customers...Remote jobInternshipWork at officeLocal areaWork from home$113.6k - $142k per year
...brings a dynamic skills marketplace and global network of real-world experts. By combining these strengths, we can connect more people and... ...difference at global scale. Job Overview: At Coursera, our Data Science team is helping to build the future of education through...- ...written) Qualifications: Must have or be pursuing a high school diploma or general education degree (GED). Three to six month’s retail experience is preferred. adidas celebrates diversity, supports inclusiveness and encourages individual expression in our...Afternoon shift
- ...Improvado is an AI-powered marketing data platform built for mid-market and enterprise teams. We help companies automate complex marketing... ...control and collaboration. Must Have Qualifications ~ Expert-level proficiency in at least one BI platform (Looker, Power BI,...Remote work
- ...Napkyn Summary: We believe in a world where data stimulates growth, creativity and inspiration. A world where people and technology work in concert to create new outcomes, new opportunities, and new customer connections. We believe that data, harnessed properly, can spark...Remote work
- ...Napkyn Summary: We believe in a world where data stimulates growth, creativity and inspiration. A world where people and technology work in concert to create new outcomes, new opportunities, and new customer connections. We believe that data, harnessed properly, can spark...Long term contractRemote work
$85k per year
...Junior Data Scientist The Wiley Edge banking team is currently seeking a Data Scientist to work across the Front Office Trading, Risk & Regulatory Compliance Trade Analytics group, using Machine Learning and Data Analytics techniques to design and develop complex data...- ...Join Our Journey in Transforming Data into Insights At CluedIn, we’re reshaping the future of data management with an Azure-native, graph-based Modern Master Data Management (MDM) platform that simplifies and accelerates how businesses manage their data—making it faster,...Full timeRemote workHome officeFlexible hours
- ...Description Job Opportunity: Specialist, Data Analytics, Internal Audit Role Overview Job Title: Specialist, Data Analytics, Internal Audit Company: Export Development Canada (EDC) Location: Ottawa (preferred), Montreal (preferred), or Toronto Work Arrangement...Contract workInternship2 days per week1 day per week
$114k - $164k per year
...advertising and marketing channels. The People Analytics team at StackAdapt is looking for a dynamic and experienced Senior People Data and Insights Analyst who thrives in the "gray area"—someone who can take messy, imperfect data and transform it into a clear narrative...Work at officeLocal areaRemote workWork from homeHome office$107k - $156k per year
...decommission legacy tracking tags, and configure clean client-side data collection containers. You will build real-time analytics... ...and server-side event routing. Required Adobe Experience: Expert, hands-on configuration mastery across Adobe Experience Platform...Work at officeLocal areaRemote workFlexible hours$76k - $104.5k per year
...advertising and marketing channels. StackAdapt’s Advertising Technology team is looking for a highly analytical and results-oriented Product Data Analyst to drive product and performance insights for our Mobile App User Acquisition program. In this role, you will work closely...Local areaRemote workWork from homeHome office$120k - $140k per year
...leading corporate and franchised retail spaces. With terminals across... ...for security, compliance, and data protection, proactively... ...databases such as MySQL, Postgres, Oracle DB, MSSQL ~ Proficient in Git... ...understanding about database-migration tools such as Flyway WHAT YOU...OracleInternshipWork at office2 days per week$120k - $130k per year
...a career Flynn is seeking an ERP Data Migration Developer to join the ERP project team... ...Rogers Preferred Program *Perkopolis Retailer Discounts Responsibilities:... ...~ Strong SQL skills with SQL Server, Oracle, or similar relational databases. ~ Hands...OracleFull timeFor contractorsWork at officeFlynn Group Of Companies
Mississauga, ON18 hours ago- ...level. What you Will Do Translate data from legacy and third-party systems into the... ...data cleansing, preparation, and migration activities aligned with approved mapping specifications... ..., or data migration projects ~ Expert or advanced skills in MS-SQL or PostgreSQL...Full timeWork at office
Catalis
Remote18 hours ago $79k - $85k per year
...Join us to do the best work of your career, solving meaningful problems with remarkable teams. Greenhouse is looking for a Data Migrations Engineer I to join our Data Migrations team! Reporting to the Manager, Data Migrations, you will work in tandem with Customers...Full timeFor contractorsWork at officeLocal areaRemote workGreen House As
Remote18 hours ago- ...services company. For nearly 30 years, our expert teams have helped our clients deliver... ...are seeking a Business Analyst to join our Data team. In this role, you will bridge the gap... ...solutions meet business requirements using Oracle SQL to interrogate datasets and confirm accuracy...OracleContract workInternshipImmediate start
- ...securely capture and preserve the communications data of the world’s most highly regulated firms... ...starting your career or are a seasoned expert, we have exciting opportunities in:... ...solving to ensure client success. Data Migration & Export Services: Enable data transitions...Work at office
- ...provider of cloud-based solutions for the utility sector. Our team of experts has extensive experience serving utilities across North America,... ...relationship management tools, as well as powerful analytics and data management capabilities. We are proud to have been recognized by...Full timeSummer workInternshipLocal areaRemote workHome officeFlexible hours
Sprypoint
Canada18 hours ago
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Oracle Retail Data Migration Expert -. Be the first to apply!
