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
5 sql
5 data structure and algorithms
25 mins each
They won't go to the next problem until one is done and expected results are met
Interviewer was very professional and tried to guide to think through the problem
Wen through standard screening call then the TA. The TA was a much higher difficulty then the prep guide. Not so much the difficulty of the question from a technical perspective, but understanding what the question was actually asking for. Example would be a problem like bookstore checkout system, but the explanation of it was sort of vague and the interviewer didn't really help me clear it up.
Starts with a screen, followed by leetcode style SQL+Python questions, Full loop of SQL, Python, SQL plus Python and lastly behavioural round. Every round is also an architecture round in some sense.
Data Engineer applicants have rated the interview process at Meta with 3.2 out of 5 (where 5 is the highest level of difficulty) and assessed their interview experience as 65% positive. To compare, the company-average is 56.5% positive. This is according to Glassdoor user ratings.
Candidates applying for Data Engineer roles take an average of 35 days to get hired, when considering 365 user submitted interviews for this role. To compare, the hiring process at Meta overall takes an average of 31 days.
Common stages of the interview process at Meta as a Data Engineer according to 365 Glassdoor interviews include:
Phone interview: 41%
One on one interview: 20%
Skills test: 16%
Presentation: 9%
Group panel interview: 5%
Other: 3%
IQ intelligence test: 2%
Background check: 2%
Personality test: 2%
Drug test: 1%
Here are the most commonly searched roles for interview reports -