Senior Quality Engineer, ETL

Posted 8 Days Ago
Be an Early Applicant
Toronto, ON
Mid level
Fintech • Insurance
The Role
As a Salesforce QE Lead, you will plan and execute testing for the CRM program. This includes validating data accuracy through ETL validation, collaborating with stakeholders to understand requirements, and ensuring adherence to quality assurance processes. You'll manage QE Analysts and conduct complex test scenarios for Salesforce integrations, while leveraging tools and methodologies for effective testing.
Summary Generated by Built In

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

Country:

Canada

Work hours/week:

37.5

Employment Type:

Full time

Platform:

TECHNOLOGY AND OPERATIONS

Job Type:

Regular

Pay Type:

Salaried

Posted Date:

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

Inclusion 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.

Top Skills

SQL
The Company
HQ: Toronto, Ontario
88,000 Employees
On-site Workplace

What We Do

Royal Bank of Canada is a global financial institution with a purpose-driven, principles-led approach to delivering leading performance. Our success comes from the 88,000+ employees who leverage their imaginations and insights to bring our vision, values and strategy to life so we can help our clients thrive and communities prosper. As Canada’s biggest bank, and one of the largest in the world based on market capitalization, we have a diversified business model with a focus on innovation and providing exceptional experiences to our 17 million clients in Canada, the U.S. and 27 other countries. Learn more at rbc.com.‎

We are proud to support a broad range of community initiatives through donations, community investments and employee volunteer activities.

Similar Jobs

Capital One Logo Capital One

Associate, Business Analyst - New Grad 2025

Fintech • Machine Learning • Payments • Software • Financial Services
Hybrid
Toronto, ON, CAN
55000 Employees

TransUnion Logo TransUnion

Analyst, Batch Processing (8-month Maternity Leave Contract)

Big Data • Fintech • Information Technology • Business Intelligence • Financial Services • Cybersecurity • Big Data Analytics
Hybrid
Burlington, ON, CAN
13000 Employees

TransUnion Logo TransUnion

Analyst, Batch Implementation (6 month contract)

Big Data • Fintech • Information Technology • Business Intelligence • Financial Services • Cybersecurity • Big Data Analytics
Hybrid
Burlington, ON, CAN
13000 Employees

General Motors Logo General Motors

Field Action Execution Analyst

Automotive • Big Data • Information Technology • Robotics • Software • Transportation • Manufacturing
Hybrid
Oshawa, ON, CAN
165000 Employees

Similar Companies Hiring

iCapital Thumbnail
Fintech • Financial Services
New York, NY
1500 Employees
Morningstar Thumbnail
Fintech • Financial Services • Enterprise Web
Chicago, IL
12700 Employees
Affirm Thumbnail
Fintech
San Francisco , CA
2200 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account