Data Engineer

What is the opportunity?
RBC is re-imagining the experience for our Advisors so that they can deliver the best in class customer service. We have partnered with Salesforce to buildout our next generation CRM Advisor Platform, that will enable them to support customer journey's like never before.
We're in search for Salesforce QE Lead to lead and execute testing for CRM program. You'll be joining a diverse and inclusive agile lab delivering solutions on integrating RBC systems with Salesforce's Financial Services Cloud and Lighting platform.

What will you do?

• Overall planning and execution of QE work within the assigned LAB, including managing QE Analysts assigned to the LAB
• Design, plan, and execute test cases, scenarios, and scripts for ETL validation and regression testing.
• Verify and validate data accuracy, completeness, and consistency using ETL tools and SQL queries.
• Collaborate with developers, data analysts, and business stakeholders to understand business and technical requirements for ETL testing
• Develop deep domain knowledge and business logic, processes, flows, data flows and rules, for areas in scope along with hands-on test case creation and test execution
• Review test artifacts, ensuring QE processes and best practices are followed
• Utilize service virtualization, salesforce mock tools to enable early testing

What do you need to succeed?

Must have:

• 3+ years of experience in testing data migration. Strong SQL skills and experience working with ETL tools such as Informatica, Talend or DataStage.
• Salesforce Certified Administrator preferred with experience in using Salesforce myTrailhead platform
• Minimum 5 years of experience in a QE Lead role with proven track record in creating and executing test suites for salesforce integration projects.
• Solid experience writing complex E2E test scenarios for complex use cases/business requirements, involving multiple data sources and system interfaces
• Bachelor degree in Computer Science, Computer Engineering or related (technical) degree/diploma
• Technical testing using experience using APIs, events, logs, batch etc. Test Automation for UI and APIs.
• Strong technical background in a variety of environments (cloud, distributed, business workflows, web services/APIs, SQL and non-SQL databases) and proven ability to successfully deal with complex issues in cross-functional projects

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
• Flexible work/life balance options
• Opportunities to do challenging work
• Opportunities to take on progressively greater accountabilities
• Opportunities to building close relationships with clients

Job Skills

Application Testing, Decision Making, Detail-Oriented, Group Problem Solving, IBM InfoSphere DataStage, IT Quality Assurance, Long Term Planning, Predictive Analytics, Programming Languages, Salesforce Sales Cloud, Software Product Testing, Software Testing, Structured Query Language (SQL), Test Automation, Test Automation Tools

Additional Job Details

RBC WATERPARK PLACE, 88 QUEENS QUAY W:TORONTOTORONTOCanada37.5Full timeTECHNOLOGY AND OPERATIONSRegularSalaried2024-10-152024-10-29