IHS Markit Interview Questions

IHS Markit 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)
Probability
(1)

IHS Markit Interview Questions

Practice for the IHS Markit 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 Ihs questions

Challenge

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

IHS Markit Salaries by Position

Product Manager*
$130K
Product Manager
Median: $130K
Mean (Average): $130K
Data points: 1
$58K
$144K
Software Engineer
Median: $95K
Mean (Average): $98K
Data points: 54
$73K
$109K
ML Engineer
Median: $81K
Mean (Average): $88K
Data points: 5
Data Engineer*
$80K
$85K
Data Engineer
Median: $83K
Mean (Average): $83K
Data points: 2
$55K
$103K
Business Analyst
Median: $81K
Mean (Average): $83K
Data points: 7
Data Scientist*
$75K
Data Scientist
Median: $75K
Mean (Average): $75K
Data points: 1
$49K
$95K
Data Analyst
Median: $72K
Mean (Average): $72K
Data points: 23
$62K
$93K
Product Analyst
Median: $65K
Mean (Average): $71K
Data points: 8
Business Intelligence*
$58K
Business Intelligence
Median: $58K
Mean (Average): $58K
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 Product Manager role pays the most with a $130,000 base salary while the Business Intelligence role on average pays the least with a $58,178 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