I applied through college or university. I interviewed at Meta
Interview
The on-campus interview (OCI) consist of one hour coding interview with half hour for SQL and the other half hour for python. For SQL, they ask you to write queries that requires the use of SUM, COUNT function and HAVING, WHERE clause. For python, you have to write a function that returns the number of words from a string or a function that returns the substring from a string.
I applied through a recruiter. The process took 3 weeks. I interviewed at Meta in Aug 2017
Interview
HR found my profile in Linked in and called up for a discussion. There was the usual background discussion and very simple sql questions. Then they scheduled a phone screen for a sql and python interview. They gave some prep materials as well. In the phone screen, it was all coding. I had assumed it would be a combination of sql and python but it wasnt. I didnt move past this stage.
Interview questions [1]
Question 1
Dot Product with Sparse Vectors, Dot product of sparse vectors stored as hashmaps
I applied through a recruiter. The process took 1 day. I interviewed at Meta in Sep 2017
Interview
it was a phone screen with Data Engineer. He was very polite and even helpful. When I stumbled he was gently suggesting a correct approach. I was stressed out regardless. :)
Interview questions [1]
Question 1
30 min for 3 SQL questions: all of them used group by and outer joins
30 min for 3 Java questions: all of them are covered here at GlassDoor ( single array loop; strings & substrings)