Staging Database Developer

RBC - Toronto, ON (30+ days ago)

Apply Now

What is the opportunity?

RBC is getting ready to implement a full-scale Human Capital Management system globally. This initiative will redefine the employee experience and the strategic role of HR at RBC, taking a transformational step forward in our ability to help our clients thrive and communities prosper.

From strategy to execution, you’ll have the career-defining opportunity to play an integral role in rolling out the program and implementing a complex technical solution for one of the country’s largest employers.

We are looking for a Workday technical specialist with specific experience in legacy system data conversions. Contribute to the integration of Workday with the end-to-end legacy SAP system retrofit.

This program - over its four year implementation - will replace several Core HR systems within the current Global HR footprint.

What will you do?

Contribute to development of the data cleansing strategy, conversion plan and extraction programs
Execution of data cleansing activates, data extraction, data harmonization and data validation activities
Focus will be primarily on SAP CORE HCM (North American) system and international HCM system and 3rd party vendor solutions
Responsible for navigating technical landscape and driving related data conversion activities for all Workday environments
Responsible for all Data Masking and Data Scrambling strategy for workday Tenants
Contribute to and perform tasks on the conversion work related to the HCM project plan
Coordinate with related data stewards on employee data access requirements
Lead data validation activities and all activities related to Enterprise changes, 3rd party internal or external applications and vendors

What do you need to succeed?

Must have:
Must have past experience with enterprise HR conversions from legacy systems to Workday
Strong in SQL Development skills and has used them as part of data conversion.
Experience with Microsoft SQL and it’s ETL tool set.


Workday hands on experience with iloads, advanced loads, EIBs, Foundation Recipes & Migration Recipes & translations
Experience with integrating Workday with ADP and PeopleSoft will be an asset
Experience with integrating Workday with legacy HR HCM system such as SAP

What’s in it for you?

We thrive on the challenge to be our best, progressive thinking to keep growing, and working together to deliver trusted advice to help our clients thrive and communities prosper. We care about each other, reaching our potential, making a difference to our communities, and achieving success that is mutual.

A comprehensive Total Rewards Program including bonuses and flexible benefits, competitive compensation,
Commissions, and stock where applicable
Leaders who support your development through coaching and managing opportunities
Ability to make a difference and lasting impact
Work in a dynamic, collaborative, progressive, and high-performing team
Opportunities to do challenging work

Learn more about RBC Tech Jobs

Join our Talent Community
Stay in-the-know about great career opportunities at RBC. Sign up and get customized info on our latest jobs, career tips and Recruitment events that matter to you.

Expand your limits and create a new future together at RBC. Find out how we use our passion and drive to enhance the well-being of our clients and communities at

City: Toronto
Address: 20 King St W
Work Hours/Week: 37.5
Work Environment: Office
Employment Type: Permanent
Career Level: Experienced Hire/Professional
Pay Type: Salary + Variable Bonus
Required Travel(%): 0-25
Exempt/Non-Exempt: N/A
People Manager: No
Application Deadline: 01/31/2020
Platform: Technology and Operations
Req ID: 214456

Ad Code(s):