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.

Interview was 1 sql round and 1 case interview. SQL had group by, cte, lag, etc. case interview mentions a case then walking through defining success metrics, design experiment and diagnostic