There were two interviews, both with the managers of the team. The first was your pretty standard interview, basic HR questions, diving deeper into a few projects from the resume, etc. The second interview had three parts. The first were some more HR questions, the second was a SQL case study, where I got data 30 min before the interview and had to write code to answer a question. We went over the code as well as a few other things related to the data. The third part was a case study. Didn't end up getting an offer as they told me they stopped hiring for the position.