I applied online. The process took 1 week. I interviewed at CityMall (Gurgaon, Haryana) in Aug 2023
Interview
1st Round - Technical Round : Questions were mainly focused on basic to advance sql. Specifically about window functions. Basic python About python lambda functions and difference between rank and dense rank. About company and the role.
Interview questions [1]
Question 1
Difference between rank and dense rank? About window functions.
I applied through an employee referral. The process took 4 days. I interviewed at CityMall (Gurgaon, Haryana) in Dec 2022
Interview
I applied through referral from LinkedIn post. Got the call quickly. There were two rounds - one was more cultural which talked about the responsibilities in the different verticals that the company has, and other one was technical - SQL based (which had average to difficult questions). Overall I found the people to be smart and chill.
Interview questions [1]
Question 1
SQL programming basic and a little advance questions.
I applied online. The process took 2 weeks. I interviewed at CityMall (Gurgaon, Haryana) in Jan 2022
Interview
It was a 2 round process. It wasn't too technical but was more focused on how you think and analyse the problems they stated. Later HR negotiated salary on the call.
Interview questions [1]
Question 1
Resume related questions and a case study related to what's causing the downfall in average cart value.
