I applied through a recruiter. The process took 4 weeks. I interviewed at Meta (San Francisco, CA) in Sep 2020
Interview
I applied through an employee referral. I interviewed at Facebook United States in August 2020.
Interview
Data Engineer Phone Interview, most of them explained the process earlier, interview lasts for 1 hour.
I was able to answer 2 1/2 SQL and 3 Python question. most of time was spent to understand the schema and the data for sales and Promotions. the answers should be exactly matched with the expected value. I was stuck with second question and spend most of time. time is constraint. understand the data for all tables and start writing queries that would help you to complete the queries faster.
Interview questions [1]
Question 1
SQL questions on promotions, sales schema.
1. find top 5 sales products having promotions
3. what %age of sales happened on first and last day of the promotion
Python:-
1. [1,None,1,2,None} --> [1,1,1,2,2] Ensure you take care of case input[None] which means None object.
2. find s in missisipi.
3. Complete a function that returns a list containing all the mismatched words (case sensitive) between two given input strings # For example: # - string 1 : "Firstly this is the first string" # - string 2 : "Next is the second string" # # - output : ['Firstly', 'this', 'first', 'Next', 'second']
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.
