First round will be HR. They want to know about your previous projects and overall experience, your salary expectations and your collaboration skills with other teams. Second round will be Technical round with 2 persons; Technical Lead and Senior Data Analyst. They will ask you certain questions on SQL, Python, Visualization and Statistics including SQL queries and Python programs. Third round will be with Hiring manager who will ask you questions related to previous projects in detail; your strengths and weakness; results you have achieved in the past based on your analytical skills and tools you have used to complete the tasks. I answered all the questions right in Technical interview other than DAX functions but got rejected.

1st Round - Amazing recruiter that completely sold me on the company. She was so friendly and made the process very pleasant! 2nd Round - 30 minutes with a senior director. He only started a few weeks prior to hosting the interview so he didn’t really have much to say about the company. Asked questions about management style and personality. 3rd Round - 30 minutes with 2 managers on the data team. They asked very specific questions related to MMM and modeling. Felt like they were trying to find holes in my experience and it was overall bad vibes. They did not have many good things to say about the company. 4th Round - 30 minute interview with someone in the same position. He asked questions about my experience and a few statistical questions. He seemed really bored and uninterested. I did get a job offer, but ultimately decided to go with another company. The bad reviews here and the bad vibes I got from my multiple interviewers felt like too many red flags.