CVS Health Data Scientist interview questions

The tech round felt unrealistic (45 mins, 15 min for each round sql, python, ML). SQL included five hard-level queries to be solved in just 15 minutes. My mind froze as soon I saw depth and complexity of it. Even before I could finish first SQL questio, which involved UNION, JOIN, window functions and overall include 3 cte with very large query time was already slipping away. It felt more like a setup to filter candidates out than fair evaluation.

Analyze an A/B test for in-store promotion