The interview was fairly straightforward. The interviewer asked questions relating to my experience and background, along with some generic technical questions regarding SQL and OOP.
Nothing was out of the ordinary.
Let's say we have a table with id and name fields. The table holds over 100 million rows, and we want to sample a random row 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 |
The following metrics were computed from 2 interview experiences for the Chewy Junior Software Engineer role in Boston, Massachusetts.
Chewy's interview process for their Junior Software Engineer roles in Boston, Massachusetts is extremely selective, failing the vast majority of engineers.
Candidates reported having very good feelings for Chewy's Junior Software Engineer interview process in Boston, Massachusetts.