Marsh McLennan Manager Interview Questions and Answers

Q1. How to optimize SQL Joins
Ans. 
Optimizing SQL Joins involves using proper indexing, limiting the result set, and avoiding unnecessary joins.
• Use indexes on columns involved in join conditions to improve performance

• Limit the result set by using WHERE clause to filter out unnecessary rows before joining

• Avoid unnecessary joins by only joining the tables that are needed for the query
Answered by AI
Add your answer
Q2. How to optimize performance
Ans. 
Optimizing performance involves setting clear goals, providing feedback, offering training and development opportunities, and fostering a positive work environment.
• Set clear goals and expectations for employees

• Provide regular feedback and recognition for good performance

• Offer training and development opportunities to help employees improve their skills

• Create a positive work environment that promotes collaboration and c...read more
Answered by AI
Add your answer

Q1. Roles and responsibilities in the current role
Add your answer
Q2. Situational questions to check different approaches to solve a problem
Add your answer

Q1. Accrual and Difference between US gaap and IFRS
Ans. 
Accrual and difference between US GAAP and IFRS
• Accrual accounting recognizes revenue and expenses when they are incurred, regardless of when cash is received or paid

• US GAAP and IFRS differ in their treatment of certain accounting principles, such as revenue recognition, inventory valuation, and lease accounting

• Under US GAAP, revenue recognition is generally more prescriptive, while IFRS allows more judgment and flexibi...read more
Answered by AI
Add your answer

Q1. Deferred and Accrual difference and Cash Flow Statement and Management Fees
Add your answer

APTA assessments with basic scenario based questions

Q1. Job description, explain your projects, SAS and excel basic questions
Add your answer

Q1. Achievements from your last experience
Add your answer

Q1. Introduction with Us teams, resume review, time series forecasting
Add your answer

It was a HackerRank test with 2 java/dsa questions and 1 sql question.

Q1. In this round I was asked to solve 2 logical program. Then they asked few questions related to the program why I have used that data structure or stream what are the other approaches and all. Then 1 scena...read more
Add your answer

Q1. Again some dsa programs and scenario based questions I was asked.
Add your answer

Q1. I was asked few questions about my previous project. And normal discussion about the tools and technologies I had worked.
Add your answer

Q1. Salary discussion+ organization related discussion
Add your answer

General Discussion and Experience

Q1. Questions on experience, work, resume related, Confidence etc
Add your answer

Q1. Discussion with Other Business heads.
Add your answer

Q1. General Questions related to understanding and leadership
Add your answer

Q1. Process (kyc) related queries
Add your answer

Q1. Leadership questions
Add your answer

Q1. What is portfolio management
Ans. 
Portfolio management involves managing a collection of investments to achieve a specific financial goal.
• Involves selecting and monitoring a mix of assets such as stocks, bonds, and mutual funds

• Balancing risk and return based on investor's objectives

• Rebalancing the portfolio periodically to maintain desired asset allocation

• Examples include creating a diversified portfolio to minimize risk and maximize returns
Answered by AI
Add your answer

Q1. What keeps you motivated
Add your answer