I applied online. I interviewed at Meta (Menlo Park, CA) in Nov 2020
Interview
First a screening call with the recruiter where she described the role and culture followed by 5 easy questions on SQL and Data structures. 3 weeks later, a technical screening with a data engineer over BlueJeans where I had to solve 5 SQL and 5 Python problems in CoderPad. 4 weeks later, virtual onsite that included 4 rounds - Ownership, Data modeling and 2 ETL rounds. Data modeling and ETL begin with 15-20 mins discussion on a product (success metrics etc). I did pretty well in all rounds, except the second ETL round where I couldn't connect with the interviewer. He kept interrupting and his communication wasn't great due to which I had to clarify the questions couple of times. Overall the experience was great and I learnt a lot while preparing for the interviews. In the end, one bad interview led to a No Offer :(
Interview questions [1]
Question 1
Product Sense, Data Modeling, SQL, Python, Ownership
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 %