I applied through a recruiter. The process took 1 week. I interviewed at QBurst (Cochin) in Aug 2019
Interview
I got a call from the company talent acquisition team. They got my profile from Naukri. The recruiter asked for a preferred location, I have chosen Kochi. I have opted Skype round as first round.
On the Skype interview, their architect was the interviewer. It was purely technical. It takes around 1 hour and 30 minutes to complete. On next day I got a call from the talent acquisition team to schedule next F2F round. Kochi operations manager was the interviewer. It was just casual discussion regarding my technical skillset and my experience. It takes around 15- 20 minutes.
On next day I got a call from the talent acquisition team to send the document to provide offers. After 4/5 days their talent acquisition head was called and asked for the expected salary and he told the features and benefits. I got an offer letter within 30 minutes after that call.
SQL Query for the following
DB schema like this
Movies --> id, name
Actors --> id, name
Movie_Actors --> id, movie_id, actor_id
Find all actor names who has acted in more than 5 movies
Find all actor names who has acted in more than 5 movies