There were 3 rounds -
Technical where Sql/ domain knowledge/ configuration and testing questions were asked
Managerial round was more about previous experience. Bit of Sql and project discussion.
HR round
I applied through a staffing agency. The process took 1 day. I interviewed at Mercer (New York, NY) in Jan 2018
Interview
I got a call from a consulting company and they asked me to go for interview for implementation profile.
It took a day in DLF location Gurgaon for all the process.
1- 1st round was about Testing questions and Health and Welfare questions like, Unit Testing, Integration Testing, Regression, Re-Testing, COBRA, Medicare, and most important "How to find 3rd Highest salary in SQL- Code"
2- He asked me, why you want to change from your previous employer- Gave the genuine reason and all the basic principal of testing.
3- Now we leave that day saying that HR will connect to you.
I got an email from consultancy - Congratulations you make it.....
Waited for more then 2 month and finally HR call me about Salary discussion and end of the day the release the offer letter with good hike.
Interview questions [3]
Question 1
What is difference between Unit, Integration, Regression, Re-Testing, Bug Life Cycle, Primary, Secondary, Join, Difference between Primary key and unique key, 3rd highest salary
SQL query from a table.