Mercer Lead Analyst Interview Questions and Answers

Q1. Tell me about yourself
Add your answer
Q2. Have you ever worked on devops
Add your answer
Q3. How do you deploy tags in Jenkins and UCD
Add your answer
Q4. What you will do if you get a production issue
Add your answer
Q5. If the respective team is responsible to resolve an issue and they are not supporting you because of their priority items what you will do
Add your answer
Q6. What is .Net Framework
Add your answer
Q7. What is c#
Add your answer
Q8. Page life cycle of ASP.NET and explanation
Add your answer
Q9. OOPS Concept and Encapsulation Example
Add your answer
Q10. Value type and Ref Types
Add your answer
Q11. Constant and ReadOnly
Add your answer
Q12. How can you delete the duplicate values in a table
Add your answer
Q13. Difference between group by and having/ union and union all
Add your answer
Q14. Query to select last 5 records in a table
Add your answer
Q15. What is SMTP and what is the name space for that
Add your answer
Q16. Mention few name spaces you have used in your code
Add your answer
Q17. What is WEB API
Add your answer
Q18. Why WEB API is crucial over Web Services
Add your answer
Q19. How do you provide Security to your WEB API
Add your answer
Q20. What is Authentication and Authorization
Add your answer
Q21. What is difference between JSON and XML
Add your answer
Q22. Filters in MVC
Add your answer
Q23. What is MVC
Add your answer
Q24. What is Routing in MVC
Add your answer
Q25. How an application Interact with API
Add your answer
Q26. Architecture of API
Add your answer
Q27. What is HTTP
Add your answer

Q1. Tell me about yourself
Add your answer
Q2. Why you want to join kpmg?
Add your answer
Q3. What you understand about the job?
Add your answer
Q4. What is your work experience?
Add your answer
Q5. How will you see yourself within 5 years?
Add your answer

Leetcode easy medium

Q1. About frameworks and core java
Add your answer
Q2. Technical ques related to JD
Add your answer

Q1. Coding round on java
Add your answer

Excel test
Logical Reasoning test
Quantitative aptitude test

An extensive case study for the corporate tax team that includes knowledge of US GAAP and transfer pricing.

Q1. What are the fundamental accounting concepts, accounting entries, and the applicable tax rates for various services?
Add your answer
Q2. What is your understanding of transfer pricing and its applicability?
Add your answer

Q1. What is the amount of data you have managed in your previous roles?
Add your answer
Q2. Which ERP software have you worked with?
Add your answer

Q1. What are your salary expectations and how do you approach negotiations?
Add your answer
Q2. What is your preferred joining date and the notice period required by your current organization?
Add your answer

Set of questions on english , aptitude , all are at easy level

Sql basics and some query questions

Q1. Why do u want to join zs ; what do u know about zs; where do u see urself after 5 years ; question on real life scenarios ;
Add your answer
Q2. Question on real life scenarios
Add your answer

Q1. Salary expectation
Add your answer
Q2. When can u join
Add your answer

It was a 1 hour test. It consists of two sections (i) 8 ques were of Business case studies (ii) 12 ques were of quantitative aptitude.

Q1. What is the difference between where and having clause ?
Ans. 
Where clause is used to filter rows before grouping, while having clause is used to filter groups after grouping.
• Where clause is used with SELECT, UPDATE, DELETE statements to filter rows based on a condition.

• Having clause is used with GROUP BY statement to filter groups based on a condition.

• Where clause is applied before grouping, while having clause is applied after grouping.

• Example: SELECT * FROM table_name WHERE co...read more
Answered by AI
Add your answer
Q2. One ques was a guesstimate problem.
Add your answer

Q1. Self Introduction.
Add your answer
Q2. Business case problem which was to be solved in 15 minutes.
Add your answer