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

Medium algo and multi threading questions

Algo and multi threading question

Q1. Implement thread safe singleton
Ans. 
Thread safe singleton can be implemented using double-checked locking or synchronized block.
• Use double-checked locking to ensure only one instance is created.

• Use synchronized block to make sure only one thread can access the creation of instance at a time.

• Example: public class ThreadSafeSingleton { private static volatile ThreadSafeSingleton instance; private ThreadSafeSingleton(){} public static ThreadSafeSingleton ge...read more
Answered by AI
Add your answer
Q2. Other lld questions
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

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