Facebook data engineer interview case study and interview questions

Last updated: Dec. 19, 2023
1 mins read
Leon Wei
Leon

Here is a Facebook data engineer interview case study.

TLDR

Candidate: Jake

How it gets started: applied in May, a friend did an internal referral

Job level: E5

Year of Experience: 5 - 10

Degree: M.S & B.S. in CS

Offer: Yes

TC: ~450K USD

Location: Menlo Park, CA

Interview process: 2 months

Preparation: 2 months

Has a job: yes

Decide to join: Yes

 


Technical screen round 1:

Python and SQL


Technical screen round 2:

SQL


Final round (met 4 people)

Python

SQL

Data Modeling

Leadership/Behavioral questions


 

Sample Python questions (4 questions to be completed in one hour)

1. Fill the None values with the previous none None value

[1, None, 1, 2, None] --> [1, 1, 1, 2, 2]

 

Tips: You have to pay attention if there are consecutive Nones.

 

2. Write a function to return a list with words that don't have a match (case sensitive) between two strings

("Facebook is an awesome place", "Facebook Is an AWESOME place") --> ["is", "Is", "awesome", "AWESOME"]

 

3. Write a function that counts the frequency of a character 

('missisipi', 's') --> 3

 

4. Write a function that returns the key of the nth largest value in a dictionary 

Example: {'a': 1, 'b': 2, 'c': 100, 'd': 30}

n : 2 (2nd largest value)

output: 'd'


Sample SQL questions

  1. Percentage of paid customers who bought both product A and product B
  2. Percentage of sales attributed by promotion on the first day and last day of promotions.
  3. For each product A, find the top 5 other products that people also bought.

Sample data modeling interview questions

Design the backend datawarehouse of a ride-sharing app.



Begin Your SQL, R & Python Odyssey

Elevate Your Data Skills and Potential Earnings

Master 230 SQL, R & Python Coding Challenges: Elevate Your Data Skills to Professional Levels with Targeted Practice and Our Premium Course Offerings

🔥 Get My Dream Job Offer

Related Articles

All Articles