The HR department lacks professionalism - they would ask you to complete the assessments as soon as possible citing urgent hiring and then would keep you hanging for the results.
There were multiple rounds of assessment, around SQL and Data science. In the name of the case study round as well, they would ask you to use python to manipulate certain excel datasets. Overall, the hiring process is all unstructured and not appropriate as per the job role.