I applied through college campus. There was online coding round at the campus. Question was fairly easy. Shortlisted candidates were invited to office. Interview went on for 45-60 mins. Even if I did not know the answer, the interviewer wanted to understand my thought process throughout.
Interview questions [1]
Question 1
Questions about projects undertaken at college, technical implementation
String manipulation, sorting, trees
SQL queries, joins etc
I applied through an employee referral. The process took 2 days. I interviewed at Media.net (Mumbai)
Interview
It was a walk-in I went for, 0-2 years experience people. With I am having nearly 1.7 years experience in database.
1st round Apti : Questions will based on database, logical q and data structure.
2nd Round Technical interview : Nearly 1 and half hour of interview for me. Will tell you to write queries for particular output to display. Most probably queries based on joins. Some theory questions and questions on Data structures like searching, sorting algo. They expect atleast algo you should write if not code.
10 min break
3rd Round Technical interview : Again 1 and half hour interview for me and same whatever they asked in 2nd round. Add on will be some puzzle and will ask You to optimise the query.
4th Round Technical Interview : 1 hour interview for me. And difficulty level might be lil bit high as compare to other 2 rounds. But will ask you to write queries and some theory q.
Interview questions [1]
Question 1
What is Indexes? And there types.
Difference between truncate and delete.
Local and global temperory table.
Recursive cte.
Find 2nd highest salary.
Find 2nd highest no in array .(Data structure)
Difference between stored procedure and function.
What are the types of stored function?
Basically this questions depends upon person to person.
Anything they can ask.
But there main interest was in data structures algo and query optimisation.
Although you have sound knowledge of Database you should know Data structure and query optimisation.
