I applied online. The process took 1+ week. I interviewed at Disney+ Hotstar (Bangalore Rural)
Interview
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 ,
I applied through other source. The process took 1 week. I interviewed at Disney+ Hotstar in May 2024
Interview
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
I applied through a recruiter. The process took 3 days. I interviewed at Disney+ Hotstar (Bengaluru) in Oct 2021
Interview
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.
Interview questions [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?
