VMware interview questions

Had total of 4 rounds. 2 rounds were codepair where you have to write code on laptop. 3rd round again coding face to face. 4th managerial round. Asked questions from ds/algorithm and multithreading. They just waste your time by taking more and more round. They could have rejected me during codepair round itself if they wanted.But they took 2 more rounds wasted my time and rejected me

One on One Discussion with team members. Four of them had taken the interview. The role was for Data Scientist but not even a single question on how to approach a Data Science problem statement. Expectation was to write the entire SQL code with syntax.