I applied online. I interviewed at Meta (New York, NY) in Sep 2020
Interview
Phone interview, two minutes introduction , 25 min sql and 25 min python questions. For python there were test cases that needed to pass with edge cases. Interviewer was reasonable and provided guidance.
Interview questions [1]
Question 1
Calculating percentage of sales percentage of non dat and regular products
Calculating percentage of sales that matched the start date and end date of the promotion
Fill the none values in a list with the previous non none value
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']
great,it was 60 min coding interview using codera ,30 min sql and 30 min python. each section has three to five question needed to be answered, both parts are very fundemental