RBC Capital Markets Interview Questions

RBC Capital Markets Interview Guides

Click or hover over a slice to explore questions for that topic.
Data Structures & Algorithms
(81)
SQL
(46)
Machine Learning
(38)
Probability
(25)
Business Case
(16)

RBC Capital Markets Interview Questions

Practice for the RBC Capital Markets interview with these recently asked interview questions.

QuestionTopicDifficulty
SQL
Hard

We’re given a table of bank transactions with three columns, user_id, a deposit or withdrawal value (determined if the value is positive or negative), and created_at time for each transaction.

Write a query to get the total three-day rolling average for deposits by day.

Note: Please use the format '%Y-%m-%d' for the date in the outout

Example:

Input:

bank_transactions table

Column Type
user_id INTEGER
created_at DATETIME
transaction_value FLOAT

Output:

Column Type
dt VARCHAR
rolling_three_day FLOAT
SQL
Medium
Behavioral
Medium
Loading pricing options

View all Rbc questions

Challenge

Check your skills...
How prepared are you for working at Rbc?

RBC Capital Markets Salaries by Position

Business Intelligence*
$145K
Business Intelligence
Median: $145K
Mean (Average): $145K
Data points: 1
$64K
$161K
Business Analyst
Median: $135K
Mean (Average): $121K
Data points: 9
$77K
$180K
Data Scientist
Median: $110K
Mean (Average): $117K
Data points: 13
ML Engineer*
$105K
ML Engineer
Median: $105K
Mean (Average): $105K
Data points: 1
$90K
$126K
Product Manager
Median: $94K
Mean (Average): $105K
Data points: 3
$70K
$146K
Data Analyst
Median: $90K
Mean (Average): $102K
Data points: 16
$66K
$132K
Data Engineer
Median: $98K
Mean (Average): $101K
Data points: 12
$66K
$150K
Software Engineer
Median: $95K
Mean (Average): $97K
Data points: 31

Most data science positions fall under different position titles depending on the actual role.

From the graph we can see that on average the Business Intelligence role pays the most with a $145,000 base salary while the Software Engineer role on average pays the least with a $97,311 base salary.

Discussion & Interview Experiences

?
There are no comments yet. Start the conversation by leaving a comment.