Two rounds of interviews are planned: one technical, covering coding, algorithms, and problem-solving; and one hiring manager (HM) round, focusing on leadership, teamwork, motivation, and alignment with company goals and culture.
I applied through career page. I got the call from HR after two days and got shortlisted, the recruiter reach out to me for scheduling interview process. The overall interview process was good.
Interview questions [1]
Question 1
Some Python and SQL questions
List employees who earn above their department’s average salary.
Pretty smooth. First an online test, then a couple of case interviews where they mainly checked how I think and break down problems. One technical round with SQL/stats basics. Final HR chat about my interest and past experiences. Overall structured and focused on problem solving + communication.
Interview questions [1]
Question 1
What is difference between INNER JOIN and LEFT JOIN
