I had an interview call with recruiter which is pretty basic: She asked about my SQL, Python experience, Visa status, Location preference and interview availability. Next round is Technical round: 2 People interviewed me. They gave a SQL coding questions (medium), Asked SQL technical theory questions about join, UNION, and also statistics, Some machine learning model questions as well, and one behavioral question (disagreed with colleague) Final round is with Lead director: She asked me about my experience, projects, What I learned from them, Most challenging project, a ML case study.

The first call was an HR screening phone call, followed by a technical test in SQL, then a case study interview with a manager on the team, then a call with the Hiring Leader. The first three people I met were really nice and said all the right things that you would want in an employer. But by the time I get to the extremely rude Hiring leader, he pretty much decided before the call that I wouldn't be a good fit because of marketing experience, which is not required in the job application. But why waste everyone's time over the span of two months if you are just going to base your decisions on something like that. A completely disrespectful waste of my time and energy.