CVS Health Data Engineer interview questions

TBH I was not very well prepared for it and the hiring manager was very nice and patient. There were 2 sections - 1. SQL 2. Python SQL questions were easy like questions using to rank, dense_rank, lead, lag window functions functions. In python he asked a simple question and I made a mistake there.

Business case focused on a real world data engineering scenario and required to solve an analytical problem. Technical included SQL(Medium to hard) and python questions(I was asked to code in pandas to clean a dataset).