Twitter / X
Real-time social platform with petabyte-scale data and ML ranking systems.
4 Rounds
~14 Days
Hard
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
Data Engineer
•
Technical
•
medium
Write a SQL query to calculate the 7-day rolling average of tweets per user.
#Window Functions
#Aggregations
#Time Series
Data Engineer
•
Technical
•
medium
Write a SQL query to find the top 3 trending hashtags per country on a given day using window functions.
#Window Functions
#Ranking
#CTEs
Data Engineer
•
Technical
•
medium
Write a SQL query to find users who have retweeted a specific tweet but do not follow the original author.
#Joins
#Subqueries
#Set Operations
Data Engineer
•
Technical
•
hard
Write a SQL query to calculate the conversion rate of ad impressions to clicks within a 1-hour window for each ad campaign.
#Time-based Joins
#Aggregations
#Performance Tuning
Data Engineer
•
Technical
•
easy
Write a SQL query to identify potential bots by finding users who tweeted more than 100 times in a single minute.
#GROUP BY
#HAVING
#Date Truncation
Data Engineer
•
Technical
•
medium
Write a SQL query to find the median number of followers for users who joined X in 2023.
#Percentiles
#Window Functions
#Statistics
Data Engineer
•
Technical
•
medium
Given a table of user follows, write a SQL query to find all mutuals (users who follow each other).
#Self Joins
#Filtering
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
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
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
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
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
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
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
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
Product Manager
•
Coding
•
medium
Write a SQL query to find the top 5% of users by tweet volume over the last 30 days who are NOT subscribed to X Premium.
#Data Analysis
#SQL
#Monetization
Product Manager
•
Coding
•
hard
Write a SQL query to calculate the week-over-week retention rate of Community Notes contributors.
#Retention
#SQL
#Cohort Analysis
Product Manager
•
Coding
•
medium
Write a SQL query to identify potential bot accounts based on tweet frequency (>100 per day) and a follower-to-following ratio of less than 0.1.
#Trust & Safety
#SQL
#Data Analysis
Product Manager
•
Coding
•
medium
Write a SQL query to find the average time it takes for a Community Note to be published after a tweet is created.
#SQL
#Performance Metrics
#Data Analysis
Difficulty Radar
Based on recent AI-sourced data.
Meet Your Interviewers
The "Standard" Interviewer
Senior EngineerFocuses on core competencies, system constraints, and clear communication.
SimulateUnwritten Rules
Think Out Loud
Always explain your thought process before writing code or drawing architecture.