CVS Health Sr. Data Engineer interview questions

I got a call from recruiter around June 19th and scheduled interview round with multiple people in the next two weeks to discuss about experience, behavioral questions, technical questions, API development, live coding of Python and SQL in multiple rounds, Cloud architecture and had a very positive feedback. Later, he said the final round with hiring manager and was completed on July 21st and mentioned that hiring manager is very happy with overall feedback and one week later, got an email saying that other person was selected. I was shocked and reached out for feedback and the recruiter simply said everything was perfect but the hiring manager thought the other candidate is better fit,

Interview presses for contract role, included vendor screening. Implementing partner technical round. And 3 rounds of client interview. First 2 client interviews were one hour each and the last interview was 30 mins call with director. First round involved whiteboard on simple Python and SQL. They looked for approach and pseudo code rather than syntax.