Twitter / X

Real-time social platform with petabyte-scale data and ML ranking systems.

4 Rounds ~14 Days Hard

Start Mock Interview

The Interview Loop

Recruiter Screen (30 min)

Standard fit check, behavioral questions, and resume overview.

Technical Loop (3-4 Rounds)

Deep dive into domain knowledge, coding, and system design.

Interview Question Bank

All Roles Data Engineer 7 Data Scientist 8 Product Manager 4

All Topics SQL 8 Machine Learning 7 Algorithms 5 Culture Fit 4 Experimentation 3 Product Sense 3 Statistics 2 Root Cause Analysis 1

Data Scientist • Coding • medium

Write a SQL query to calculate the 3-day rolling average of tweet impressions for each user over the past month.

#Window Functions #Aggregation #Time Series

Practice

Data Scientist • Coding • medium

Write a SQL query to find the top 3 creators by ad revenue payout in each geographic region for the last quarter.

#Ranking #Window Functions #Joins

Practice

Data Scientist • Coding • hard

Write a SQL query to calculate the Day 1 and Day 7 retention rates for users who recently subscribed to X Premium.

#Cohort Analysis #Self Joins #Date Functions

Practice

Data Scientist • Coding • easy

Write a SQL query to find users who liked a specific tweet but do not follow the author of that tweet.

#Joins #Filtering #Set Operations

Practice

Data Scientist • Coding • hard

Write a SQL query to calculate the median time between a user's account creation and their first tweet.

#Percentiles #Date Math #CTEs

Practice

Data Scientist • Coding • medium

Write a SQL query to find the percentage of tweets that receive at least one reply within 5 minutes of being posted.

#Date/Time Functions #Joins #Aggregation

Practice

Data Scientist • Coding • hard

Write a SQL query to identify 'bot rings'—groups of 5 or more users who have retweeted the exact same set of 10 tweets within a 1-hour window.

#Complex Joins #Grouping #Anomaly Detection

Practice

Data Scientist • Coding • hard

Write a SQL query to calculate the 'viral coefficient' of a tweet (average number of new retweets generated by each retweet).

#Graph Data #Recursive CTEs #Aggregation

Practice

Difficulty Radar

Based on recent AI-sourced data.

Meet Your Interviewers

The "Standard" Interviewer

Senior Engineer

Focuses on core competencies, system constraints, and clear communication.

Simulate

Unwritten Rules

Think Out Loud

Always explain your thought process before writing code or drawing architecture.

Practice Now