Hotwire Interview Questions

Hotwire Interview Guides

Click or hover over a slice to explore questions for that topic.
Data Structures & Algorithms
(68)
SQL
(61)
Machine Learning
(59)
Probability
(30)
A/B Testing
(23)

Hotwire Interview Questions

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

QuestionTopicDifficulty
SQL
Easy

We’re given two tables, a users table with demographic information and the neighborhood they live in and a neighborhoods table.

Write a query that returns all neighborhoods that have 0 users. 

Example:

Input:

users table

Columns Type
id INTEGER
name VARCHAR
neighborhood_id INTEGER
created_at DATETIME

neighborhoods table

Columns Type
id INTEGER
name VARCHAR
city_id INTEGER

Output:

Columns Type
name VARCHAR
SQL
Easy
SQL
Medium
Loading pricing options

View all Hotwire questions

Challenge

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

Hotwire Salaries by Position

$122K
$165K
Software Engineer
Median: $145K
Mean (Average): $144K
Data points: 7
$97K
$118K
Business Intelligence
Median: $113K
Mean (Average): $110K
Data points: 4
Data Analyst*
$107K
Data Analyst
Median: $107K
Mean (Average): $107K
Data points: 1
$93K
$110K
Product Analyst
Median: $109K
Mean (Average): $105K
Data points: 4
ML Engineer*
$99K
ML Engineer
Median: $99K
Mean (Average): $99K
Data points: 1
$64K
$132K
Data Scientist
Median: $87K
Mean (Average): $97K
Data points: 14
Business Analyst*
$66K
$85K
Business Analyst
Median: $75K
Mean (Average): $75K
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 Software Engineer role pays the most with a $143,616 base salary while the Business Analyst role on average pays the least with a $75,390 base salary.

Hotwire Opening Jobs

Budget Data Analyst - Construction Growth
Budget Data Analyst - Construction Growth

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