I applied online. I interviewed at Newton School in Sept 2024
Interview
There is total of 3 rounds
1st - HR screening
2nd - Technical Round
The round started with a self-introduction, followed by a detailed discussion of my projects. Based on my project explanation, the interviewer asked three follow-up questions to assess my problem-solving approach, technical understanding, and the impact of my work.
After that, the interview moved towards SQL concepts and queries, where questions were asked on joins, window functions, aggregations, query optimization, and scenario-based problem solving
3rd - Managerial round
Interview questions [1]
Question 1
SQL question - (Joins & Window Function)
Problem Solving
3 rounds of interview including AI interview, AI will keep asking questions in depth. Topics asked in interview - 4-5 Puzzles, 2 Guesstimates, 1 Case Studies, 1 RCA, 2-3 Behavioral questions, and general product role and company clarifications. Where the guesstimates were brief and case studies were in depth
Interview questions [1]
Question 1
How will you analyse if an investment for a furniture company is profitable.
Friendly interviewer, but very vague questions. Focused on marketing aspect and previous experience mostly. First round was an AI interview with guesstimates, scenario analysis and resume based questions; difficult to gauge since it’s ai