Candidatei-me online. O processo levou 3 semanas. Fui entrevistado pela Paytm em abr. de 2024
Entrevista
There were 6 rounds (off-campus)
1) Resume Shortlisting
2) OA ( questions based on SQL , excel and python)
3)HR interview ( basic questions, stipend negotiations )
4) Technical round ( you will be asked to solve queries on spot ,mainly based on SQL and 1 case study based question at the end )
5) An assignment for competitive analysis to solve some real life problem.
6) Technical round 2 : 2-3 questions on advanced SQL ( good level queries that you have to solve on the spot)
Perguntas de entrevista [1]
Pergunta 1
On spot queries based on windows function and subqueries were asked .
Case study like if there is a continuous decrease in the no. of recharges done for airtel sim in the past 3 months what you will do achieve the same no. of recharges as before the decline in no. of airtel customers happened?
Candidatei-me online. O processo levou 2 dias. Fui entrevistado pela Paytm em abr. de 2024
Entrevista
The process was both challenging and rewarding, providing me with invaluable insights into the world of product analytics. The assessment and two interview rounds were meticulously structured, focusing primarily on SQL and Python proficiency. Throughout the interviews, I was tasked with solving real-world scenarios using these tools, which allowed me to showcase my technical skills and problem-solving abilities.
Perguntas de entrevista [1]
Pergunta 1
order of execution of Select,From,Where,Group by, having and others in the way of sql