Senior Quality Engineer, ETL

Job Summary

Job Description

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

Address :

RBC WATERPARK PLACE, 88 QUEENS QUAY W : TORONTO

City : TORONTO

TORONTO

Country : Canada

Canada

Work hours / week : 37.5

37.5

Employment Type : Full time

Full time

Platform :

TECHNOLOGY AND OPERATIONS

Job Type : Regular

Regular

Pay Type : Salaried

Salaried

Posted Date : 2024-10-15

2024-10-15

Application Deadline :

2024-12-04

Note : Applications will be accepted until 11 : 59 PM on the day prior to the application deadline date above

I nclusion and Equal Opportunity Employment

At RBC, we embrace diversity and inclusion for innovation and growth. We are committed to building inclusive teams and an equitable workplace for our employees to bring their true selves to work.

We are taking actions to tackle issues of inequity and systemic bias to support our diverse talent, clients and communities.

We also strive to provide an accessible candidate experience for our prospective employees with different abilities. Please let us know if you need any accommodations during the recruitment process.

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 jobs.rbc.com .