I applied through a recruiter. The process took 2 weeks. I interviewed at Meta
Interview
Recruiter Phone Screen, Online test in MySQL, and Coding in a language (Java, Scala, Python) of your choice, and 5 hr in-person interview (4 1 hr interviews and 1 hr lunch provided by company).
Interview questions [1]
Question 1
Phone: SQL qs are pretty basic on equi joins, outer joins, and self joins. Coding exercises are pretty basic like word search, etc. Time is a crunch (1hr). You have to keep explaining while coding so that the interviewer online understands your thought process. In Person: Some live coding exercise, tougher than phone qs, product sense, visualization.
I applied through a recruiter. The process took 6 weeks. I interviewed at Meta (Menlo Park, CA) in Jan 2019
Interview
The interview has two main parts a phone screen and an longer in person interview section full of longer questions.
The phone interview is pretty standard 1 hour, half SQL questions and half generic programming questions, follow the advice of the recruiter to prepare for these. The name of the game is being quick, the more questions you see the better off you will be.
The in person interview will consist of 3 problem solving interviews, in my experience you will be given a scenario of a data engineering problem (i.e how to be identify the metrics for performance for this specific feature) and you will be expected to write SQL and actual code for the context of the problem itself.
There will also be a more standard behavioural interview portion, asking you about your work experience, how you deal with interpersonal problems that sort of thing.
Finally there will be a casual lunch conversation where you can ask about the work culture and other day to day questions.
The interview was long but the questions were not unfair I think, and weren't your generic data structures and algorithm questions.
The interviewers themselves were very respectful and helpful and nice. I was sick the day of the interview and they allowed me to take quick breaks when needed.
Overall it was a pleasant process, no tricks to the interview you just have to prepare!
Interview questions [1]
Question 1
Given this data calculate this KPI
How would you design the data model for this scenario
I applied online. The process took 4 weeks. I interviewed at Meta (San Francisco, CA) in Sep 2018
Interview
1. Recruiter Call initial screening.
2. SQL and Python Programming interview, 30 min each, I was able to complete exact 3-3 questions from SQL and Python each. Last question in python needed some help.
One negative thing: for the programming interview interviewer didn't call me on the home phone number I provided to recruiter. They called on the cell number specified in the resume. I even two times asked recruiter before interview to make sure they call me on my home number. Recruiter confirmed but still they called on the cell number.
Interview questions [1]
Question 1
SQL: The names of salespeople that have 2 or more orders. When was the earliest and latest order made ? cumulative sum
Python: IP Address Binary Search, Facebook Friends Tree,