I applied through an employee referral. The process took 3 months. I interviewed at Meta in Mar 2024
Interview
A screening round, a technical coding round and then 3 technical and 1 behavioral interview. The final 4 interviews are kind of a stress test and can be on the same day or two back to back days.
Interview questions [1]
Question 1
Leetcode medium which can be solved with hashmaps or dictionaries
First there was a Recruiter call to know about you and how are you fit for the job, then there was a coding round with 10 questions, the difficulty would be easy to medium but time is less and you have to pass the test cases and there will be follow up questions. After that you have to go through a loop round of 3 hours.
Even I answered everything I was rejected.
Interview questions [1]
Question 1
Asked to design a data model and to write queries on top of it
I applied online. I interviewed at Meta in Oct 2024
Interview
During the phone screen technical round, I was given a total of 5 SQL and 5 Python questions. For SQL, I successfully completed 3 out of the 5 SQL questions, starting with the easier ones and gradually facing more challenging ones. For Python, I was able to solve 2 out of the 5 questions, though I couldn’t pass all the test cases for the second one.
Unfortunately, I wasn’t able to complete 3 of the Python questions, which ultimately prevented me from advancing to the next round. However, it was a good learning experience that highlighted the areas I need to improve on.
For anyone preparing for this role, I recommend practicing timed coding challenges, especially in Python basics ( thinking about all edge cases ) and SQL topics like aggregate functions, joins, and CTEs. With consistent practice, you can improve your speed and accuracy, which will better position you to move forward in the interview process.
Overall, it was a valuable experience, and I’m confident that with more focused preparation, I’ll do better next time.
Interview questions [1]
Question 1
SQL Focus: Aggregate Functions, Joins, CTEs
Python Focus: Basic Data Structures ( HashMap, Strings etc. )