First round is a recruiter screen. Friendly conversation asking about your work experience. Second round is a technical assessment asking 5 SQL questions and 5 Python/DSA style questions. This was particularly hard because you have to answer all 10 in under an hour. Did not answer all of them and as a result did not move on to any subsequent rounds.
While the time constraints were difficult, I don't think they are impossible. A lot of the questions asked are already here on Glassdoor. Had I practiced for a couple more weeks, I think I could have had a better chance to pass. Unfortunately, I only had 1 week between the recruiter screen and the technical round.
Recommendation: Look at all the SQL / Python questions on Glassdoor and practice answering them in under 5 minutes each. Focus on explaining your thought process.
Interview questions [1]
Question 1
Write a function to return a list with words that don’t have a match (case sensitive) between two strings
(“Facebook is an awesome place”, “Facebook Is an AWESOME place”) → [“is”, “Is”, “awesome”, “AWESOME”]
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.
