Preparing for Dimension Modeling round of Data Engineering Interview at Facebook

September 6, 2020September 18, 2020 by Raghav

Let’s create dimensional model for the stories feature of Facebook. There are two different processes related to Facebook stories – one is the story creation…

Data Engineering

Preparing for Data Engineering Interview at Facebook – creating an automated process in Python to mimic Facebook activity on your local database and answering relevant metrics using SQL – Part 3

September 4, 2020September 18, 2020 by Raghav

In part 1 and part 2, I described how to mimic and calculate metrics for photo upload process on Facebook. This is in relation to…

Data Engineering

Preparing for Data Engineering Interview at Facebook – creating an automated process in Python to mimic Facebook activity on your local database and answering relevant metrics using SQL – Part 2

September 3, 2020September 18, 2020 by Raghav

This is in continuation to my previous post here. By the end of the first post I had created the user_activity_log mimicry process which logged…

Data Engineering

Preparing for Data Engineering Interview at Facebook – creating an automated process in Python to mimic Facebook activity on your local database and answering relevant metrics using SQL – Part 1

September 3, 2020September 18, 2020 by Raghav

I am writing this blog post while preparing for the Facebook Data Engineering interview. The onsite round consists of various scenario based questions which largely…