Marsh McLennan Analytics Consultant Interview Questions and Answers

Q1. SQL hard questions
Add your answer

Q1. What projects I worked before
Add your answer
Q2. Behavioural questions
Add your answer

Q1. Explain end to end data solution and how did you handle a challenging or difficult situation in current role ?
Ans. 
End to end data solution involves collecting, processing, analyzing, and presenting data to address business needs.
• Collecting data from various sources such as databases, APIs, and files

• Cleaning and processing data to ensure accuracy and consistency

• Analyzing data using statistical methods and machine learning algorithms

• Presenting insights and recommendations to stakeholders

• Handling a challenging situation: Resolving di...read more
Answered by AI
Add your answer
Q2. Thoroughly explain the project, process, platform, components, integrations and development life cycle followed. With an example, explain how you handled a complex technical problem/implementation or may ...read more
Ans. 
I led a project to develop a predictive analytics platform for a retail company, integrating various data sources and implementing machine learning models.
• Developed project scope and requirements with stakeholders

• Designed data architecture and selected appropriate tools and technologies

• Integrated data from multiple sources including CRM, POS, and online platforms

• Implemented machine learning models for demand forecastin...read more
Answered by AI
Add your answer

Q1. Regarding skill set and intro
Add your answer
Q2. Basic intro question on experience
Add your answer

Q1. Technical skill questions advanced category
Add your answer

Q1. Questions related to relocation if you want to relocate and why would you look to join this org and salary
Add your answer

Q1. 1. Macro quoting functions in SAS 2. ways to create macro variable in Data step 3. date functions-intck() and intnx() 4.situational scenario based questions 5.Automatic variables in SAS
Ans. 
The interview questions cover topics such as macro quoting functions, creating macro variables, date functions, situational scenario-based questions, and automatic variables in SAS.
• Macro quoting functions in SAS allow for the creation of macro variables with special characters.

• Macro variables can be created in the data step using the %LET statement or by using the CALL SYMPUTX routine.

• The date functions INTCK() and INT...read more
Answered by AI
Add your answer

General altitude with MAT level question

Q1. Questions from CV, guesstimates, data science questions
Add your answer
Q2. What is Random forest
Ans. 
Random forest is an ensemble learning method used for classification and regression tasks.
• Random forest is made up of multiple decision trees

• Each tree in the forest is built using a subset of the training data and a random selection of features

• The final prediction is made by averaging the predictions of all the individual trees

• Random forest is known for its high accuracy and ability to handle large datasets

• It is a popu...read more
Answered by AI
Add your answer
Q3. Hypothesis testing
Add your answer
Q4. Guesstimates Question on no.of marriage in a year
Add your answer

Q1. Introduction, why Wells, strength, what do I know about it.
Add your answer

Q1. About Roles and Responsibilities
Add your answer
Q2. Tableau Application
Add your answer
Q3. Powerbi Application
Add your answer

Q1. Salary Discussion
Add your answer

Q1. SQL , Oracle SQL, distinct
Add your answer
Q2. SQL, analytical SQL query
Add your answer