MSCI Interview Questions

MSCI Interview Guides

Click or hover over a slice to explore questions for that topic.
Data Structures & Algorithms
(28)
Behavioral
(3)
Machine Learning
(3)
Statistics
(2)
Concurrent & Distributed Systems
(1)

MSCI Interview Questions

Practice for the MSCI 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
Data Structures & Algorithms
Medium
Data Structures & Algorithms
Easy
Loading pricing options

View all Msci questions

Challenge

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

MSCI Salaries by Position

Data Engineer*
$125K
Data Engineer
Median: $125K
Mean (Average): $125K
Data points: 1
Software Engineer*
$102K
Software Engineer
Median: $102K
Mean (Average): $102K
Data points: 2

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

From the graph we can see that on average the Data Engineer role pays the most with a $125,000 base salary while the Software Engineer role on average pays the least with a $102,000 base salary.

Discussion & Interview Experiences

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

Discussion & Interview Experiences

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

Jump to Discussion