Ho presentato la mia candidatura online. La procedura ha richiesto 2 giorni. Ho sostenuto un colloquio presso Paytm nel mese di apr 2024
Colloquio nella media
Candidatura
Ho presentato la mia candidatura online. La procedura ha richiesto 3 settimane. Ho sostenuto un colloquio presso Paytm nel mese di apr 2024
Colloquio
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)
Domande di colloquio [1]
Domanda 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?
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.
Domande di colloquio [1]
Domanda 1
order of execution of Select,From,Where,Group by, having and others in the way of sql