I went for Clinical data associate role where they asked question on SQL. The questions includes introduction, window functions and joins. At first they asked about functions and its types and after that window functions .

1st round was Aptitude based on grammar logical reasoning and verbal reasoning.2nd round was Face to Face interview where question on clinical trial process, phases, clinical data management, query, gcp, prinicples of cdm were asked. Final round was HR round just introduction, why u need to join this company and some non-technical questions were asked to see our confidence and communication. After few days Virtual round was there.