Mercer Lead Implementation Analyst interview questions
based on 2 ratings - Updated Dec 17, 2020
Averageinterview difficulty
Very positiveinterview experience
How others got an interview
100%
Staffing Agency
Staffing Agency
Interview search
2 interviews
Mercer interviews FAQs
Lead Implementation Analyst applicants have rated the interview process at Mercer with 3 out of 5 (where 5 is the highest level of difficulty) and assessed their interview experience as 100% positive. To compare, the company-average is 68.2% positive. This is according to Glassdoor user ratings.
Candidates applying for Lead Implementation Analyst roles take an average of 1 day to get hired, when considering 1 user submitted interviews for this role. To compare, the hiring process at Mercer overall takes an average of 28 days.
Common stages of the interview process at Mercer as a Lead Implementation Analyst according to 1 Glassdoor interviews include:
One on one interview: 33%
Phone interview: 33%
Background check: 33%
Here are the most commonly searched roles for interview reports -
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.