Noom Interview Questions

Noom Interview Guides

Click or hover over a slice to explore questions for that topic.
Data Structures & Algorithms
(77)
SQL
(60)
Machine Learning
(55)
Probability
(31)
Statistics
(23)

Noom Interview Questions

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

QuestionTopicDifficulty
SQL
Medium

Let’s say we have a table representing a company payroll schema.

Due to an ETL error, the employees table, instead of updating the salaries every year when doing compensation adjustments, did an insert instead. The head of HR still needs the current salary of each employee.

Write a query to get the current salary for each employee.

Note: Assume no duplicate combination of first and last names (I.E. No two John Smiths). Assume the INSERT operation works with ID autoincrement.

Example:

Input:

employees table

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

Output:

Column Types
first_name VARCHAR
last_name VARCHAR
salary INTEGER
SQL
Easy
A/B Testing
Medium
Loading pricing options

View all Noom questions

Challenge

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

Noom Salaries by Position

$159K
$279K
Software Engineer
Median: $240K
Mean (Average): $227K
Data points: 12
$147K
$210K
Data Scientist
Median: $165K
Mean (Average): $172K
Data points: 5
Product Manager*
$125K
Product Manager
Median: $125K
Mean (Average): $125K
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 Software Engineer role pays the most with a $227,083 base salary while the Product Manager role on average pays the least with a $125,000 base salary.

Discussion & Interview Experiences

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