I applied through a recruiter. The process took 3 weeks. I interviewed at Meta (Menlo Park, CA) in Sep 2016
Interview
1) Recruiter reached out via LinkedIn, 2) Initial chat with recruiter, 3) Two phone interviews - one focused on SQL, one focused on coding, 4) Onsite interviews - three full-stack case interviews, one behavioral lunch interview
The entire process was very well-coordinated, and everyone I met was very nice and professional. The onsite case interviews were full-stack and tested your product sense, data modeling/warehousing knowledge, SQL, and general coding. It focused more on breadth than width.
Interview questions [1]
Question 1
Given a raw data table, how would you write the SQL to perform the ETL to get data into a desired format?
Technical recruiter contacted me for a phone interview, then we scheduled a meeting in Tel Aviv offices.
45 minutes talk with head of analysts. talked about 20 min. about my background, and then asked a question.
Don't know why I didn't pass, since the position was for data eng. and not an analyst.
Interview questions [1]
Question 1
asked about on how to check if facebook should change something in the newsfeed, and how I suggest to test it. most of the interview dealt with definition of the KPI.
I applied through a recruiter. The process took 2 weeks. I interviewed at Meta (San Francisco, CA) in May 2016
Interview
A recruiter reached on linkedin and set up an initial call to discuss about background.
Next was two phone screens - 1) SQL 2) Any preferred language (I picked Python)
Each phone screen is 45 minutes and you are asked about 6-7 questions. The questions are relatively straightforward if you are comfortable with basics.
In coding interview, they are trying to see if you can approach the same program in two different ways - one using inbuilt methods and one without using in built methods
Interview questions [2]
Question 1
SQL questions -
A table schema with tables like employee, department, employee_to_projects, projects
1) Select employee from departments where max salary of the department is 40k
2) Select employee assigned to projects
3) Select employee which have the max salary in a given department
4) Select employee with second highest salary
5) Table has two data entries every day for # of apples and oranges sold. write a query to get the difference between the apples and oranges sold on a given day
Python Questions -
1) Print Max element of a given list
2) Print median of a given list
3) Print the first nonrecurring element in a list
4) Print the most recurring element in a list
5) Greatest common Factor