Interview process
It was good overall, and in order to clear any stage of the process, one need's have a solid understanding of SQL, Statistics, and Business Case studies.
- Online assessment
- Technical interview
- Final round
Interview rounds
7 questions across 3 roundsOnline assessment
1 questionSpecific questions asked
Total of 27 questions, 20 MCQ (statistics + aptitude), and 7 SQL questions (medium - hard level)
Technical interview
5 questionsSpecific questions asked
SQL: was asked a question whose solution involved using CTEs, dense_rank, aggregation, basically, on the tougher side.
A few questions regarding my project and ML fundamentals were asked.
2-3 questions regarding the number of outputs from LEFT JOIN, RIGHT JOIN, etc.
RCA question: The number of orders has suddenly dropped.
RCA question: The return of orders has increased.
Final round
1 questionSpecific questions asked
Statistics-focused round. Central-limit-theory, p-value were the main focus of the interview. Basically, they want to test how much core understanding of statistics the candidate has.
Interview tips
Could have prepared better on the statistics. Overall, it was medium-level difficulty, but the SQL side was tougher.
Get full access with a membership, or share your experience to try it free.
