Ameriprise Financial Interview Questions

Ameriprise Financial Interview Guides

Click or hover over a slice to explore questions for that topic.
Machine Learning
(20)
SQL
(6)
Statistics
(6)
Probability
(5)
Product Sense & Metrics
(5)

Ameriprise Financial Interview Questions

Practice for the Ameriprise Financial 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
Machine Learning
Easy
Loading pricing options

View all Ameriprise financial questions

Challenge

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

Ameriprise Financial Salaries by Position

$60K
$170K
Software Engineer
Median: $92K
Mean (Average): $99K
Data points: 320
Business Intelligence*
$94K
Business Intelligence
Median: $94K
Mean (Average): $94K
Data points: 1
Data Engineer*
$92K
Data Engineer
Median: $92K
Mean (Average): $92K
Data points: 2
$88K
$90K
Data Scientist
Median: $88K
Mean (Average): $89K
Data points: 3
$52K
$93K
Business Analyst
Median: $70K
Mean (Average): $72K
Data points: 3

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

From the graph we can see that on average the Software Engineer role pays the most with a $99,319 base salary while the Business Analyst role on average pays the least with a $72,112 base salary.

Discussion & Interview Experiences

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