Scotiabank Interview Questions

Scotiabank Interview Guides

Click or hover over a slice to explore questions for that topic.
Data Structures & Algorithms
(76)
SQL
(40)
Machine Learning
(29)
Probability
(20)
Statistics
(14)

Scotiabank Interview Questions

Practice for the Scotiabank interview with these recently asked interview questions.

QuestionTopicDifficulty
SQL
Easy

Write a SQL query to select the 2nd highest salary in the engineering department.

Note: If more than one person shares the highest salary, the query should select the next highest salary.

Example:

Input:

employees table

Column Type
id INTEGER
first_name VARCHAR
last_name VARCHAR
salary INTEGER
department_id INTEGER

departments table

Column Type
id INTEGER
name VARCHAR

Output:

Column Type
salary INTEGER
SQL
Medium
Data Modeling
Medium
Loading pricing options

View all Scotiabank questions

Challenge

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

Scotiabank Salaries by Position

Business Analyst*
$97K
$100K
Business Analyst
Median: $99K
Mean (Average): $99K
Data points: 2
Data Engineer*
$98K
Data Engineer
Median: $98K
Mean (Average): $98K
Data points: 1
Product Manager*
$84K
$85K
Product Manager
Median: $84K
Mean (Average): $84K
Data points: 2
$62K
$128K
Software Engineer
Median: $76K
Mean (Average): $84K
Data points: 15
Data Analyst*
$83K
Data Analyst
Median: $83K
Mean (Average): $83K
Data points: 1
Data Scientist*
$72K
$81K
Data Scientist
Median: $77K
Mean (Average): $77K
Data points: 2
Business Intelligence*
$67K
Business Intelligence
Median: $67K
Mean (Average): $67K
Data points: 1

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 Analyst role pays the most with a $98,500 base salary while the Business Intelligence role on average pays the least with a $67,000 base salary.

Discussion & Interview Experiences

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