I applied through a recruiter. The process took 3 weeks. I interviewed at Meta (San Jose, CA) in Feb 2019
Interview
The interview process is good, the recruiter is good at responding to reschedule and interviewer gave hints during the interview. The interviewer doesn't want to fail you but rather help you succeeded. I was given 4 SQL and 2 python questions. Although I prepared well and I'm good at coding, I felt during the interview I was in pressure. I took time for some of the edge cases during programming interview but be prepared to code fast, understand the hints from the interviewer faster and apply it.
Interview questions [1]
Question 1
Python Questions:
Avg length of words, some of the edge cases are having spaces in the beginning and end of the words, returning a float instead of int, returning None for blank input.
Valid ip address, edge case to remember is if there are alphanumeric characters.
SQL questions:
One SQL question was tricky because you have to look at the data to come up with the question, the question is to find the percent of valid promotion, condition to find valid promotion is not specified in the question, so you have to figure it from looking at the data.
Other SQL questions are based on a join, group by, top(3)
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.
It was a contractual job , so the contractors reached out , they needed only SQL & Python proficiency. They explained the requirement and arranged the interview based on my availability.They were pretty efficient.I
Top companies for "Compensation and Benefits" near you
