Dataford
Dataford
Top 35
Prep plan
Updated weekly · Last refresh Oct 17

Facebook Data Engineer Interview Questions

The questions to prepare for a Facebook Data Engineer interview. Questions from real interview reports rank first. Updated daily.

35questions
~5htotal time
Track your progressSign up free to work through all 35 questions and resume where you left off.
Start practicing free →
1
CodingStart here. 11 questions · ~99 min
Most Common Element Across CategoriesEasy
Practice

Find the most frequent item across Facebook surfaces using a frequency map, counting duplicates and breaking ties lexicographically.

frequency countData StructurespythonFacebook
Maximum Points From CategoriesMedium

Evaluates dynamic programming or combinatorial reasoning for an optimization coding problem.

pythonFacebook
Python and SQL Streaming or BatchMedium

Assesses practical data engineering skills for streaming versus batch processing in Python.

streamingBatch ProcessingpythonFacebook
More Coding questions with a free account
2
SQL & Data Manipulation12 questions + 3 drills · ~138 min
Bookstore Schema SQL PracticeMedium

Tests SQL ability to compute common business metrics from a consistent schema.

sqlpythonFacebook
SQL and Window FunctionsMedium

Evaluates SQL proficiency with window functions and correct aggregation semantics.

Window FunctionssqlFacebook
SQL Case Statements and JoinsMedium

Evaluates SQL proficiency with case logic and join correctness.

JoinssqlFacebook
SQL for Self-Comments in 24 HoursMedium
Practice
Practice drill

Use timestamp filtering and joins to find users who commented on their own posts within 24 hours.

Date FunctionsJoinssqlFacebook
Analyze Signup Funnel Drop-OffHard
Practice
Practice drill

Use CTEs, joins, and aggregations to measure user drop-off across a multi-step signup funnel.

JoinsCase WhenAggregationsFacebookIntuitAsana
SQL Day-Over-Day GrowthMedium
Practice
Practice drill

Calculate daily active Instagram Creators and day-over-day growth using a date spine, aggregation, and LAG.

Date FunctionsAggregationsFacebook
More SQL & Data Manipulation questions with a free account
3
Behavioral & Leadership10 questions · ~90 min
More Behavioral & Leadership questions with a free account
4
More topics2 questions · ~18 min
System Architecture DesignHard

Assesses architecture thinking, tradeoffs, and validation for building data systems.

system designarchitectureFacebook
Bookstore Checkout System DesignHard

Evaluates end-to-end system design for a transactional data model and analytics-ready schema.

system designFacebook

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
The finish line: interview-readyComplete all 35 questions plus 3 hands-on drills to finish this plan.