Vantage Data Engineer Virtual Onsite

phone screen - they told me to download a dataset (nyc taxi data) and then come to interview with it ready to be queried in whatever data system I wanted to use. they asked a series of questions with increasing SQL complexity. note: the dataset needs to be cleaned beforehand.

system design interview - ahead of the interview, they gave me a a feature that they wanted me to design. they gave me some scaling characteristics, but also left some things ambiguous. this was a fairly standard system design interview.

behavioral - all the normal behavioral questions you expect to get.