It was a well organized process, will be given enough time for preperation. Involves a recruiter call followed by the coderpad technical screening and finally the virtual interview. You will get opportunity to collaborate with the people who are interviewing you and they would give hints if you are stuck during coding sessions or analysis
I applied online. I interviewed at Meta (New York, NY) in Oct 2020
Interview
Through HR,
First-round is as usual, SQL and Coding(Python I chose)
The interviewer gave some tips to solve both SQL and coding parts.
I was a little nervous initially and came out of it as she was talking nicely
Interview questions [1]
Question 1
SQL ==> Sales, promotions, products DB I was able to complete only 3 questions.
Python ==> solved only 3 questions.
find giving letter in a string
Replace None with previous element from List, there was some challenges
[None]
[None,1,2] ==> [None,1,2]
[1,None,2] ==> [1,2,2]
[1,4,None,None,3]===> [1,4,4,4,3]
Forgot one question
In the SQL part, please make sure you learn how to calculate %
First round is HR pre-screen, Then we need to do a Online Assessment, and schedule a Screening interview with a data engineer who currently work at facebook. For the further information, you need to pass this round.
Interview questions [1]
Question 1
Basic data structure and sql statement at a very high level short answers