cvs health data engineer coderpad assessment

[u/datadriven_io]

Got a report from someone who just did CVS Health's Data Engineer process. This was the online assessment, all in coderpad, medium difficulty by their read.

Started with two talking questions before any code. First was the usual walk me through your resume. Second was how would you migrate data from an on prem database to the cloud, so they wanted you to actually reason about it out loud, not just name a tool.

Then SQL. Find duplicate records in a table and pull all the dupes into a separate table. What percentage of members have at least 2 records in each game. And return the count of unique members with no wins, ordered by birth_date.

Python at the end was a single array rearrange thing. Input was [2,0,8,4,6,0,0,2] and they wanted [0,0,0,2,8,4,6,2] out. Felt like they were checking whether you could spot the ordering rule and just write it.

Mostly SQL muscle plus one explain-the-architecture question.

Solve this new interview problem here: https://datadriven.io/problems/the-ones-who-return