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
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.
Begins with an application review and recruiter screening, followed by a technical phone interview that assesses SQL, data modeling, data warehousing, ETL processes, and coding skills in languages such as Python or Java. Successful candidates then proceed to onsite or virtual interviews, which include multiple rounds covering coding, system design, data architecture, problem solving, and behavioral questions.
Interview questions [1]
Question 1
Tell us about yourself and why you want to work for us
I applied online. I interviewed at Meta (New York, NY)
Interview
Prepare technical concepts, and practice previously asked questions as much as you can find online. 4 rounds in the total process. It's easy as long as you just practice a LOT.