FB Guide

User Manual:

Open the PDF directly: View PDF .
Page Count: 2

Download
Open PDF In Browser	View PDF

5/9/2018

Mail - Ricardo Guzman - Outlook

Facebook On Site Interview Scheduling and Preparation
Prema Bacani-Williams 

Fri 4/27/2018, 3:49 PM
To:Ricardo Guzman ;

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 prepara on 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 a ached 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 Prepara on Informa on:
Please review the informa on below that describes our Data Engineering interview format.
Please also reference the a ached document prior to our prep call as a guide.
Onsite Interview Format:
You will be mee ng with 5 different people. The interview structure is as follows (in no par cular 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 analy cs 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 ini a ve in their role, so we will ask ques ons 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 ques ons you have about what life is like as a
Data Engineer at Facebook.
Addi onal Resources:
https://outlook.live.com/mail/deeplink

1/2

5/9/2018

Mail - Ricardo Guzman - Outlook

Here are some links that you might find helpful in preparing for the interview:
Data Modeling
h ps://en.wikipedia.org/wiki/Data_model
h ps://en.wikipedia.org/wiki/Data_mart
h ps://en.wikipedia.org/wiki/Dimensional_modeling
h ps://en.wikipedia.org/wiki/Denormaliza on
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 be er sense of
what drives the Data Engineers within Facebook Analy cs.
An inside look at Data Engineering at Facebook
h ps:// .careers/DERohitBio
h ps:// .careers/MichaelBBSB
h ps:// .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 informa on is helpful. Let me know if you have any other ques ons or need anything else. Thanks, and looking
forward to mee ng 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!
h p://www.thisisinsider.com/facebook-best-place-to-work-in-america-2017-12?op=1

https://outlook.live.com/mail/deeplink

2/2



---

Source Exif Data:

File Type                       : PDF
File Type Extension             : pdf
MIME Type                       : application/pdf
PDF Version                     : 1.4
Linearized                      : No
Page Count                      : 2
Creator                         : Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/66.0.3359.139 Safari/537.36
Producer                        : Skia/PDF m66
Create Date                     : 2018:05:10 00:29:24+00:00
Modify Date                     : 2018:05:10 00:29:24+00:00

EXIF Metadata provided by EXIF.tools