One of the most horrible interview processes I have ever been through.

The recruiter didn't have an idea of what the interview was 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 hours to complete the test).

3rd round: With a department head of Enterprise Analytics, I was informed by the recruiter that the round was going to be business-based behavioral. It was anything but behavioral; he asked me scenario-based questions and case studies.

Round 4: Again, I was told this would be a case study with 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 me, ask my name, or introduce 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.

What is Lineage?

What is Lambda?

How is Spark fault tolerant?

Broadcast join

What is persist?

What kind of join is done when you broadcast a variable?