I applied through a recruiter. I interviewed at Meta (Seattle, WA) in Oct 2021
Interview
Phone screen a week go.
I was able to complete 3 SQL and the 4th one I was able to get the pseudo code done, the interviewer was ok.
I was able to complete 3 python.
I got an email later to set up the onsite.
I did not get any questions from glassdoor. But the questions were not that difficult, but not as straightforward too. Even thought I was able to complete only 3 questions SQL/Python I was able to explain my thought process and debug the code when there was an error and the interviewer was very helpful and friendly.
I don't think they expect you to solve all 5 from each and neither to write one line codes for all the problems. Be clear and have a discussion with the interviewer and listen to the hints.
Good luck, will update this after my onsite.
Interview questions [1]
Question 1
Easy to medium SQL/Python questions. lists/strings manipulation.
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.
