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.

Question

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.

Anonymous · Accepted Answer

I did my best and managed to solve 2  SQL queries with full explanations, though it took me around 20 minutes and over the allotted 15 minutes. As a result, I had very limited time left for the Python and  ML based question.

CVS Health

CVS Health interview question

Interview Answer

Want the inside scoop on your own company?

Bowls

Followed companies

Job searches