J'ai postulé en ligne. Le processus a pris plus d'une semaine. J'ai passé un entretien chez Disney+ Hotstar (Bangalore Rural)
Entretien
I got shortlisted and a that Hr send a mail for my availability for initial phone discussion . I opted for a time . When that time came I waited and after 30 mins the hr changes the time to next date . It was 31/05/2024 . Then after 6 days she called me without any notice and I missed the call . From that I am trying to reach her through msg and she is not at all responding ,
J'ai postulé via une autre source. Le processus a pris 1 semaine. J'ai passé un entretien chez Disney+ Hotstar en mai 2024
Entretien
Quick and efficient
1 hour rounds, done in a week
HR was helpful, explained well about the rounds.
Pay is also very nice, gives decent hikes
Questions were to the point but could have been more flexible in approach
J'ai postulé via un recruteur. Le processus a pris 3 jours. J'ai passé un entretien chez Disney+ Hotstar (Bengaluru) en oct. 2021
Entretien
There will be 3 interviews. I was got rejected in 1st technical interview. The questions are on SQL and it was very easy. But the interviewer has very limited knowledge. Actually, they even don't know the different syntaxes of doing joins. They don't have even much experience, I don't know how HOTSTAR is allowing these interviewers with much less experience to take interviews.
Questions d'entretien [1]
Question 1
1. Window functions - Rank v/s Dense_Rank. Syntax of DENSE_RANK?
2. Difference b/w WHERE AND HAVING clause?
3. Given a table:
User_id Date Title Watch_Time(in mts)
Write a query to find Top 10 title in last week.
4. Given a table:
User_id Date Title Watch_Time(in mts) State
Write a query to find User_id whose last month watch time is greater than the average watch time of his state?