I had a very disappointing experience with the interview process. The culture felt poor and unwelcoming, which raised concerns about the work environment. If you have other options, I would recommend passing on this opportunity.

The first step is they send you a coding assessment with a SQL challenge and a coding challenge in your preferred language. The coding challenge was hard, I wont give it away, but I will just say that it would be best break down the challenge into a bunch of smaller problems to solve and then combine. The next step was a coding challenge with a tech lead, and a more casual interview. The tech lead responded to questions, offered some thoughts and subtle hints. The next phase was 4 back to back interviews with a HR person, two engineers, and then a relational database design challenge with and engineer and a PM. The interviews with the engineers went shorter than anticipated, they didnt have many questions between them. This may have been my weakest of the 4 interviews because I would consider making separate tables for things that may have made more sense to store in a single table. A day later after the 4 interviews, I got a rejection letter.