Candidatei-me por meio de recrutador(a). O processo levou 4 semanas. Fui entrevistado pela Meta (San Francisco, CA) em set. de 2020
Entrevista
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.
Perguntas de entrevista [1]
Pergunta 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']
Candidatei-me online. Fiz uma entrevista na empresa Meta (New York, NY).
Entrevista
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.
Candidatei-me online. Fiz uma entrevista na empresa Meta.
Entrevista
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.