Pearson Interview Questions

Pearson Interview Guides

Click or hover over a slice to explore questions for that topic.
Data Structures & Algorithms
(18)
Behavioral
(7)
Machine Learning
(7)
A/B Testing
(5)
Statistics
(5)

Pearson Interview Questions

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

QuestionTopicDifficulty
SQL
Hard

Given a table of product subscriptions with a subscription start date and end date for each user, write a query that returns true or false whether or not each user has a subscription date range that overlaps with any other completed subscription.

Completed subscriptions have end_date recorded.

Example:

Input:

subscriptions table

Column Type
user_id INTEGER
start_date DATETIME
end_date DATETIME
user_id start_date end_date
1 2019-01-01 2019-01-31
2 2019-01-15 2019-01-17
3 2019-01-29 2019-02-04
4 2019-02-05 2019-02-10

Output:

user_id overlap
1 1
2 1
3 1
4 0
SQL
Medium
A/B Testing
Medium
Loading pricing options

View all Pearson questions

Challenge

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

Pearson Salaries by Position

$118K
$149K
Product Manager
Median: $140K
Mean (Average): $135K
Data points: 3
$65K
$175K
Software Engineer
Median: $125K
Mean (Average): $128K
Data points: 24
$111K
$115K
ML Engineer
Median: $115K
Mean (Average): $113K
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 Product Manager role pays the most with a $135,000 base salary while the ML Engineer role on average pays the least with a $113,333 base salary.

Discussion & Interview Experiences

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