Video interview consisted of some personality/ scenario questions and SQL test. Was a good process but I had not brushed up on SQL prior to the interview. Make sure that your SQL knowledge is there before doing the interview, timing wasn't also much of an issue in this interview

4 online assessments - 2 fit-based, one technical SQL, one technical Excel the fit / decision making based assesments incluse more like less like questions and prioritization questions + delegating / focussing questions. The technical SQL interview relates to in depth SQL questions on how to optimize queries for shorter runtimes aswell as writing your own queries to achieve desired outcomes. Finally, there are 2, 45 minute interviews.