Talk to the recruiter and then the system design interview. I just don't know where I went wrong; honestly, it was one of my best technical interviews because I prepared quite a bit. I wonder whether the in-person requirement made a difference, as I cannot relocate. I wish companies would share a lot more feedback on what went wrong in the interviews so people can learn and prepare for the next time they interview.

Coding interview with with data manipulation questions, can use either SQL or PySpark, started with easy manipulations building to harder ones, domain related problem focused on manipulating clinical data to find returning patients