I applied through a recruiter. The process took 4 weeks. I interviewed at Meta (San Francisco, CA) in Sept 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']
Begins with an application review and recruiter screening, followed by a technical phone interview that assesses SQL, data modeling, data warehousing, ETL processes, and coding skills in languages such as Python or Java. Successful candidates then proceed to onsite or virtual interviews, which include multiple rounds covering coding, system design, data architecture, problem solving, and behavioral questions.
Interview questions [1]
Question 1
Tell us about yourself and why you want to work for us
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.
