Senior Quality Engineer, ETL
City : TORONTO, Ontario, Canada
Category : Technology | Analytics | Research
Industry : Financial/Banking
Employer : RBC
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 ToolsAdditional Job Details
Address:
City:
Country:
Work hours/week:
Employment Type:
Platform:
Job Type:
Pay Type:
Posted Date:
Application Deadline:
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.