Data Engineer

Job title:

Data Engineer

Company

Royal Bank of Canada

Job description

Job Summary 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.Job DescriptionWhat 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 DetailsAddress: RBC WATERPARK PLACE, 88 QUEENS QUAY W:TORONTOCity: TORONTOCountry: CanadaWork hours/week: 37.5Employment Type: Full timePlatform: TECHNOLOGY AND OPERATIONSJob Type: RegularPay Type: SalariedPosted Date: 2024-10-15Application Deadline: 2024-10-29Inclusion and Equal Opportunity EmploymentAt 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 CommunityStay 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 .

Expected salary

Location

Toronto, ON

Job date

Thu, 17 Oct 2024 01:49:55 GMT

To help us track our recruitment effort, please indicate in your email/cover letter where (un-jobs.net) you saw this job posting.