Marsh Senior Manager Interview Questions and Answers

Q1. BM interview. Self introduction. About company details. Job profile. Job description
Add your answer

About pnb. Methamatics test, general knowledge

Q1. Self introduction, about privious company experience,
Add your answer

Q1. Technical Discussion about Product
Add your answer

Q1. Technical & General Discussion about possible product migration
Add your answer

Q1. Generic HR questions
Add your answer

Q1. The output of 4 joins and how the processing happens?
Ans. 
The output of 4 joins is a result set that combines data from multiple tables based on specified conditions.
• Joins are used to combine rows from two or more tables based on a related column between them.

• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

• Processing of joins involves matching rows from the tables based on the specified join condition.

• The output of 4 joins would involve combining data ...read more
Answered by AI
Add your answer
Q2. Spark Parameters calculation
Add your answer
Q3. Self Joins between the table with CTE
Ans. 
Self joins between tables with CTE are used to join a table to itself using Common Table Expressions.
• Self joins are used when you need to compare rows within the same table.

• CTE is used to create a temporary result set that can be referenced multiple times in a query.

• Example: SELECT e1.employee_id, e2.manager_id FROM employees e1 JOIN employees e2 ON e1.manager_id = e2.employee_id
Answered by AI
Add your answer
Q4. Optimizations in Spark
Ans. 
Optimizations in Spark involve tuning configurations, partitioning data, using efficient transformations, and caching intermediate results.
• Tune configurations for memory and parallelism

• Partition data to distribute workload evenly

• Use efficient transformations like map, filter, and reduce

• Cache intermediate results to avoid recomputation
Answered by AI
Add your answer

Q1. Explain your project and your role
Add your answer
Q2. Data Model Interview questions
Add your answer
Q3. Problem Solving Approach on few scenarios
Add your answer

Good

Good

Q1. Discussion about package and profile
Add your answer

Q1. Discussion about package and profile also documentation done
Add your answer

Q1. Practical use case was asked
Add your answer
Q2. Interviewer looking for details in solution
Add your answer

Q1. How was your day starts with
Ans. 
My day starts with a morning routine that includes exercise, meditation, and planning for the day ahead.
• I wake up early and start my day with some light stretching and exercise to energize my body.

• Afterwards, I spend a few minutes meditating to clear my mind and set a positive intention for the day.

• Once I feel centered, I review my schedule and prioritize tasks, making a to-do list to stay organized.

• I also take some ti...read more
Answered by AI
Add your answer
Q2. About Family and future plans
Add your answer

Zonal manger taken the interview along with Area manager

Q1. What motivates you to perform better?
Add your answer
Q2. What is your professional objective in Life?
Add your answer
Q3. What are the key habits you have for success?
Add your answer
Q4. What is your salary expectation?
Add your answer