Candidatei-me por indicação de um funcionário. O processo levou 4 semanas. Fiz uma entrevista na empresa Meta.
Entrevista
Technical Coding interview after phone screening
Using coderpad
SQL, Python and Data Model - 15 mins each. 5 questions each. Enough time!
very friendly - expectations set clearly ahead of time.
If you prepare using glassdoor questions, you can crack it for sure.
Perguntas de entrevista [1]
Pergunta 1
Data Model:
LinkedIn data model - model for 1st degree connection
Python:
1. Dedup items in the list - retaining the order of items. ==> cannot use dict/set since order will not be retained. Follow up question on this - How would you handle nested lists? (they are looking for recursion)
2. Find the number of words in a sentence /avg length of word
SQL
On the product-sales-customers data model that is preloaded in coderpad.io, write the following queries
1. Count of stores in OR state with area_sqft > 25000
2. avg number of Female Customers group by state
3. Customer FirstName, Last Name and count of unqiue products purchased by state
followup question - Return the top customer by state based on diverse product purchased (diverse = count(distinct product_id))
