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
(73)
SQL
(60)
Product Sense & Metrics
(39)
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
Easy

The events table tracks every time a user performs a certain action (like, post_enter, etc.) on a platform.

Write a query to determine the top 5 actions performed during the week of Thanksgiving (11/22/2020 - 11/28/2020), and rank them based on number of times performed.

The output should include the action performed and their rank in ascending order. If two actions were performed equally, they should have the same rank. 

Example:

Input:

events table

Column type
user_id INTEGER
created_at DATETIME
action VARCHAR
platform VARCHAR

Output:

Column Type
action VARCHAR
ranks INTEGER
SQL
Hard
Machine Learning
Hard
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.