FB Guide
User Manual:
Open the PDF directly: View PDF 
.
Page Count: 2
5/9/2018 Mail - Ricardo Guzman - Outlook
https://outlook.live.com/mail/deeplink 1/2
Facebook On Site Interview Scheduling and Preparation
Fri 4/27/2018, 3:49 PM
To:Ricardo Guzman <rrguzman1976@hotmail.com>;
Hi,
I have great news for you. We would like to invite you on-site for an interview with the Data Engineering team!
Some things I need from you:
Availability for your onsite interview in Menlo Park. Here are the dates that are currently available: Monday May
21st, Friday June 1st, Monday June 4th and June 8th . We don’t have any other dates open yet if you want more
dates in mid-end of June I can send over once published.
The onsite interview will last approximately 4 hours total and generally start at 10:00 AM PST depending on
availability.
Availability for a 30 to 45-minute preparaon call with me (the prep call is not part of the interview, but it is
designed to maximize your readiness for the interview. For the call, please have the aached prep guide open and
be in a quiet place where you can focus while you take notes). Ideally, the call should take place at least 1.5 to 2+
weeks prior to the interview.
On-site Interview Preparaon Informaon:
Please review the informaon below that describes our Data Engineering interview format.
Please also reference the aached document prior to our prep call as a guide.
Onsite Interview Format:
You will be meeng with 5 different people. The interview structure is as follows (in no parcular order):
1x – Data Modeling problem (1 hour)
2x – ETL problems (1 hour each)
1x – Ownership discussion (30 minutes)
1x – Lunch (45-60 minutes)
Data Modeling
You will brainstorm the data needs of a user product. Then you will design a data mart to support analycs use cases and
write select SQL statements to produce specific results.
ETL
You will solve a complex ETL (extract transform load) problem. You will design source and target schemas and
write SQL and procedural code to transform and load the data.
Ownership
Data Engineers need to take iniave in their role, so we will ask quesons about your past experiences where you have
been able to demonstrate this.
Lunch
Lunch with one of our Data Engineers, which will be your chance to ask all quesons you have about what life is like as a
Data Engineer at Facebook.
Addional Resources:
Prema Bacani-Williams <premab@fb.com>
5/9/2018 Mail - Ricardo Guzman - Outlook
https://outlook.live.com/mail/deeplink 2/2
Here are some links that you might find helpful in preparing for the interview:
Data Modeling
hps://en.wikipedia.org/wiki/Data_model
hps://en.wikipedia.org/wiki/Data_mart
hps://en.wikipedia.org/wiki/Dimensional_modeling
hps://en.wikipedia.org/wiki/Denormalizaon
SQL
SQL Tutorial
Code - basic procedural concepts, Python, Java, or Scala (use the guide for the language you plan to use during the
interview)
Python Guide
Java Guide
Scala Guide
Below are some recently posted external bios for Data Engineers from the team. These will help give you a beer sense of
what drives the Data Engineers within Facebook Analycs.
An inside look at Data Engineering at Facebook
hps://.careers/DERohitBio
hps://.careers/MichaelBBSB
hps://.careers/ShawnaBSB
Please also be prepared to discuss Facebook products. If you are not a user of our products, we'd suggest you familiarize
yourself again with how Facebook works.
I hope this informaon is helpful. Let me know if you have any other quesons or need anything else. Thanks, and looking
forward to meeng you in person!
Kind regards,
Prema
Prema Bacani-Williams
Technical Recruiter|Data Engineering
Facebook | 1 Hacker Way, Menlo Park, CA 94025
mobile: 650-656-7717
Best Place to Work!
hp://www.thisisinsider.com/facebook-best-place-to-work-in-america-2017-12?op=1
