I applied through a recruiter. I interviewed at magicpin (New Delhi) in Mar 2026
Interview
I have to go to their office for the offline interview process, which takes up to 3-4 hours. You have to be formally dressed for an interview. Give an interview with full confidence to have more chances of being selected
There were 3 interview rounds, the first round consisted of 2 easy-medium dsa questions related to LCA and trees, the second round consisted of one medium dsa question related to greedy algorithm, and a detailed discussion about projects mentioned in resume. The final round revolved around basis low level system design, and more resume discussion.
My interview experience at Magicpin for the Data Analyst role was smooth and insightful. The process included aptitude questions, SQL queries, and case-based problem solving. Interviewers focused on analytical thinking, data interpretation, and business understanding. Overall, it was a positive experience with practical, real-world discussion scenarios.
Interview questions [1]
Question 1
asked me a simple query based on Sql window function