Ho presentato la mia candidatura tramite un selezionatore. La procedura ha richiesto una settimana. Ho sostenuto un colloquio presso Chewy (Boston, MA) nel mese di mag 2021
Colloquio
Technical assessment was sent via email. Questions were mostly pertaining to web development and Java. The assessment only gave around 20 minutes to complete. The questions were not difficult, it only took around 15 minutes to complete.
Ho sostenuto un colloquio presso Chewy (Boston, MA)
Colloquio
The interview was fairly straightforward, the interviewer asked questions relating to my experience and background, along with some generic technical questions relating to SQL and OOP. Nothing out of the ordinary.
Domande di colloquio [1]
Domanda 1
Let’s say we have a table with an id and name fields. The table holds over 100 million rows and we want to sample a random row in the table without throttling the database.
Write a query to randomly sample a row from this table.
Input:
big_table table
Columns Type
id INTEGER
name VARCHAR