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-Yafo) 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.
Phone interview first round for Senior Data Engineer. They asked 3 SQL and 3 Python coding questions and i coded all of them and all test cases passed. Not sure why they didnt comeback for next round. may be they expected for total of 10 questions