Twitter Interview Questions

Overview

Twitter is an online news and social networking service on which users post and interact with limited length messages known as tweets

Twitter Interview Guides

Click or hover over a slice to explore questions for that topic.
Data Structures & Algorithms
(74)
SQL
(60)
Product Sense & Metrics
(40)
Machine Learning
(39)
Analytics
(25)

Challenge

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

Twitter Interview Questions

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

QuestionTopicDifficulty
SQL
Hard

We’re given two tables, a table of notification_deliveries and a table of users with created and purchase conversion dates. If the user hasn’t purchased then the conversion_date column is NULL.

Write a query to get the distribution of total push notifications before a user converts.

Example:

Input:

notification_deliveries table

Column Type
notification VARCHAR
user_id INTEGER
created_at DATETIME

users table

Column Type
id INTEGER
created_at DATETIME
conversion_date DATETIME

Output:

Column Type
total_pushes INTEGER
frequency INTEGER
Machine Learning
Hard
SQL
Easy
Loading pricing options

View all Twitter questions

Twitter Salaries by Position

Product Analyst*
$200K
Product Analyst
Median: $200K
Mean (Average): $200K
Data points: 1
$117K
$262K
Product Manager
Median: $180K
Mean (Average): $183K
Data points: 40
$136K
$257K
ML Engineer
Median: $168K
Mean (Average): $178K
Data points: 75
$113K
$240K
Software Engineer
Median: $165K
Mean (Average): $166K
Data points: 1,258
$63K
$241K
Data Engineer
Median: $186K
Mean (Average): $164K
Data points: 7
$115K
$185K
Data Scientist
Median: $154K
Mean (Average): $154K
Data points: 204
$122K
$195K
Business Intelligence
Median: $145K
Mean (Average): $153K
Data points: 4
$117K
$177K
Data Analyst
Median: $145K
Mean (Average): $146K
Data points: 19
$112K
$166K
Marketing Analyst
Median: $135K
Mean (Average): $137K
Data points: 4
$96K
$146K
Business Analyst
Median: $139K
Mean (Average): $131K
Data points: 12

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 Analyst role pays the most with a $200,000 base salary while the Business Analyst role on average pays the least with a $130,667 base salary.

Discussion & Interview Experiences

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