Very disengaged recruiters, did not give an idea on what to prepare for. Wasted my time preparing for 6 total rounds. I dont know what the interviewers were looking for but I did not enjoy.

Case Study and SQL round: Let me start by saying that I don't know yet if I am getting through to the next round. There were no concerns about the case study section. Just that when I asked about the company culture, the first thing they said was that everyone works independently. Take what you must from that. Next was the 30-minute live coding in SQL. There is no functionality provided to run your own code during the interview. In one of the questions, I was asked to calculate and report two metrics using two different tables. The interviewer does mention that they look for logic and not just syntax. However, expecting someone to imagine the data and perform a complex analysis does not really test the candidate's skills, only makes them nervous. One would think that, being a large company, they would be able to afford software that lets their candidates run their own code during an interview, testing their complete ability to understand data and generate insights from it. But maybe they are just looking for robots who can spew lines of code. It did not seem like an efficient way to test prospective talent.