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
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.