I applied through an employee referral. The process took 3 weeks. I interviewed at Meta in Oct 2018
Interview
First round: Short technical screen with recruiter. The recruiter is not a technology expert, they have 20 questions with 20 answers in front of them. These are usually simple questions like "What do you call a function that calls itself?" (Recursive function). The 20 questions from this round are split: 10 programming and 10 SQL. Very easy if you know the basics!
The next round is a technical interview with an experienced Data Engineer on Coderpad. Here, speed is of the essence. They'll ask you to choose which questions you want to start with first (Programming or SQL) and immediately start off! Try to be quick, take into account all test cases and get all test cases to pass! (Easier said than done, I know, but that's what they're looking for!) I got 3 programming questions and 3 SQL questions in the 1 hour. I was able to solve all 3 programming questions and also all the 3 SQL questions. However, I got stuck for like 10 mins on one of the slightly tricky SQL questions involving a sub-query join. This was probably why I got chucked out! :(
Also, the prep. material they give is VERY basic and not really helpful for the kinds of questions they ask. I'd say look through the prep material once because it's really simple stuff, but practice programming and SQL on a service like LeetCode or HackerRank.
Interview questions [3]
Question 1
You have a 2-D array of friends like [[A,B],[A,C],[B,D],[B,C],[R,M], [S],[P], [A]]
Write a function that creates a dictionary of how many friends each person has. People can have 0 to many friends. However, there won't be repeat relationships like [A,B] and [B,A] and neither will there be more than 2 people in a relationship
I had Python and SQL round for 30 minutes each. The interview was for 1 hour 30 minutes for SQL and 30 mins for python coding.
Completed 5 questions each but still got rejection email the next day.
It was a contractual job , so the contractors reached out , they needed only SQL & Python proficiency. They explained the requirement and arranged the interview based on my availability.They were pretty efficient.I
Top companies for "Compensation and Benefits" near you