I applied through a recruiter. I interviewed at Meta (Menlo Park, CA) in Jul 2020
Interview
Recruiter(reached me over linkedin) called me to understand my work experience and how comfortable I am with SQL and Python.Asked some 5 sql and 5 python question to qualify for next round.Then He forgot to schedule my telephone interview for 3 days. I had to chase him over linkedin. finally it got scheduled after 3 weeks of time. I was able to solve 4 SQL /3 coding will all cases passed. It is been more than a week , the recruiter is no longer responding and I have no idea what happened .(I am assuming I am rejected but no formal email). I am really surprised with Facebook interview structure or may be I was out of luck.
Interview questions [2]
Question 1
SQL : questions are already on glassdoor can be solved using AVG, COUNT , LEFT JOIN , MULTI table join. Mostly focus on %age type questions
I applied online. The process took 3 weeks. I interviewed at Meta in Jun 2020
Interview
Found a FB recruiter on linkedin and send her a connection request. Next day got a reply back asking for contact details and if I am interested in positions in Data Engineer.
3 days later got a call with another recruiter who asked 5 sql and 5 python questions. Sql question on left join, having clause etc and python on linked list, stack (what data structure is FIFO) true/false type questions.
Post that was given 14 days to prepare for telephonic interview - same as 30 mins SQL and 30 mins python.
Telephonic interview was nice but again its matter of how comfortable and fast you are. I was able to answer 3 out of 3 sql and 2 out of 3 python. Was short of time so interviewer gladly asked to close the call.
I think I can do better in direct interviews where they ask design questions but these coding interviews with timer make me nervous. Please focus on that part and you can easily be able to go past this round. Most of the questions are same as in glassdoor.
Interview questions [1]
Question 1
SQL questions on promotions, sales schema.
what %age of products have both non fat and trans fat.
find top 5 sales products having promotions
what %age of sales happened on first and last day of the promotion
Mysql was used and interviewer asked to if this can be done without subquery.
Python:-
[1,None,1,2,None} --> [1,1,1,2,2]
Ensure you take care of case input[None] which means None object.
find s in missisipi.
I applied through a recruiter. The process took 4 weeks. I interviewed at Meta (Tel Aviv) in Nov 2018
Interview
30 minutes recruiter screen and 1 hour technical screen, 5 SQL + 5 python, I managed to solve all python questions and 4 out of 5 SQL questions. They were super nice and I think I didn't got an offer because I was a little bit stressed.