One of the most horrible interview process I have ever been through. The recruiter didn't have an idea of what the interview is going to be like. Rescheduled the interview at least 6 times. 1st round: submit a document answering given questions (why cvs, why DE etc) 2nd round: online AMCAT test with 72 questions about data modeling, spark, SQL and python (took me almost 3 hrs to complete the test) 3rd round: with a department head of Enterprise Analytics, I was informed by the recruiter that the round is going to be business-based behavioral round. It was anything but behavioral, he asked me scenario based questions and case studies round 4: Again, I was told this will be case study very basic questions but, the round was completely technical with questions about spark, AWS, SQL, SCD etc round 5: leadership skills interview with the department head P.S. the interviewers of round 3 and 4 did not even greet or asked my name or introduced themselves. They jumped right into the questions. I guess it is very important to build a rapport with the candidate. Interviewers/recruiters shouldn't forget that they wouldn't have anyone to work in the company if they don't treat the candidates well

The process included an initial HR screening call, followed by two technical interview rounds with live coding and technical discussions. The final round was with the hiring manager and focused on role fit, technical experience, project background, and behavioral questions.