Meta

Social media and metaverse company behind Facebook, Instagram, and WhatsApp.

4 Rounds ~21 Days Very 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 Analyst 10 Data Engineer 11 Data Scientist 7 Product Manager 1

All Topics Statistics 9 SQL 7 Experimentation 7 Deep Learning 5 Machine Learning 5 Product Sense 4 ML Systems 3 NLP 3

Data Scientist • Coding • hard

Write a SQL query to calculate 30-day user retention.

#Retention #Analytics

Data Scientist • Coding • hard

How would you write a funnel analysis query in SQL?

#Funnel #Analytics

Data Scientist • Coding • medium

Write a query to identify duplicate records and deduplicate them.

#Deduplication #Data Quality

Data Scientist • Coding • medium

Given two tables: `ad_campaigns` (campaign_id, advertiser_id, spend) and `ad_clicks` (click_id, campaign_id, user_id, timestamp), write a SQL query to find the top 5 advertisers with the highest number of clicks per dollar spent who have spent at least $10,000 in the last 30 days.

#Joins #Aggregations #Date Functions

Data Scientist • Coding • hard

Given a table `friend_requests` (sender_id, receiver_id, date, status), write a SQL query to calculate the overall friend acceptance rate for each day. Note that a request sent on day 1 might be accepted on day 3.

#Self Joins #Window Functions #Ratio Calculation

Data Scientist • Coding • medium

Write a SQL query to calculate the 7-day rolling retention rate of users who signed up through a specific marketing campaign. You have a `users` table (user_id, signup_date, campaign_id) and a `user_activity` table (user_id, activity_date).

#Retention #Rolling Metrics #Joins

Data Scientist • Technical • easy

Explain the difference between INNER JOIN, LEFT JOIN, and CROSS JOIN.

#Joins #SQL

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.

Unwritten Rules

Think Out Loud

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