I applied in-person. The process took 1 day. I interviewed at Meta in Apr 2025
Interview
The entire interview was supposed to be one hour, with 5 SQL and 5 Python questions. While the questions were generally available online, there were slight differences in the details, possibly due to minor tweaks. The interviewer was Indian, a senior Data Engineer with 10 years of experience. I mentioned that I wasn’t familiar with Codepad, and he gave me a short demo — but it was counted within the timer for my first SQL question (???).
When I got stuck and asked if he could give me a hint, I noticed he seemed completely disengaged, so I had to figure things out on my own. Later during the Python portion, he said there was a web tech issue and couldn’t give me the question immediately. He had to restart his computer, and it took more than 10 minutes to get the question. In the end, the whole interview dragged from one hour to an hour and a half.
Interview questions [1]
Question 1
Group by payment type to calculate total sales and the number of unique customers.
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.
I had Python and SQL round for 30 minutes each. The interview was for 1 hour 30 minutes for SQL and 30 mins for python coding.
Completed 5 questions each but still got rejection email the next day.