Interview comprised of 5 rounds,
1) HR phone screen for role alignment
2)Technical discussion with Senior Consultant (tools, data engineering/SQL)
3)Hiring Manager round (technical + behavioral)
4)Project presentation on an end-to-end pipeline (with Senior Manager & Associate Principal)
5) Final discussion with Principal
Interview questions [1]
Question 1
Tell me about the project you worked on where you created an end-to-end data pipeline
Went through the typical HR call in the initial stage; I felt that the interviewer was disinterested, but still proceeded to mention that the team will schedule an interview with me by end of the week.
I followed up a week after when they initially mentioned I can anticipate to hear back from the team. The process entailed 2 stages, with the initial stage online, and the second stage in person.
It was very streamlined and structured. Three rounds and the first round was the most difficult one, this was followed by a case study and two rounds testing my technical capability followed by a fitment round.
