Deloitte Senior Manager Interview Questions and Answers

Q1. About LLM Finetuning projects
Add your answer

Q1. About Generative AI, RAG
Add your answer

They asked a few questions about a case study and they asked for a presentation

Q1. How would you improve the claims process an Insurance clients?
Ans. 
Implementing automation, streamlining processes, enhancing communication with clients.
• Implement automation to reduce manual errors and speed up processing times

• Streamline processes to eliminate unnecessary steps and improve efficiency

• Enhance communication with clients through regular updates and personalized interactions
Answered by AI
Add your answer

Hacker rank test for 2 hours. Language of your choice and problem solving and sql and data structures

Q1. Handling different types of data. Sql functions Design considerations Performance optimization
Ans. 
Handling different types of data, SQL functions, design considerations, and performance optimization.
• Understand the data types and their limitations

• Use appropriate SQL functions for data manipulation

• Consider normalization and denormalization for database design

• Optimize queries and indexes for better performance

• Use caching and partitioning for large datasets

• Examples: DATE functions, JOINs, indexing, partitioning
Answered by AI
Add your answer
Q2. How to handle data skewness in spark. What are the different performance optimization techniques in hive
Ans. 
Handling data skewness in Spark and performance optimization techniques in Hive
• For data skewness in Spark, use techniques like partitioning, bucketing, and salting

• In Hive, use techniques like partitioning, bucketing, and indexing for performance optimization

• Other techniques include using appropriate data types, optimizing queries, and using compression

• Example: In Spark, partitioning can be done based on a column with h...read more
Answered by AI
Add your answer

Q1. Data skewness Stake holder Management Hands on capabilities
Add your answer

Q1. More about culture and compensation and company policy
Add your answer

Q1. How do you perform IT audit
Ans. 
I perform IT audits by conducting risk assessments, evaluating controls, testing compliance, and providing recommendations for improvement.
• Conduct risk assessments to identify potential vulnerabilities

• Evaluate existing controls to determine effectiveness

• Test compliance with policies, regulations, and industry standards

• Provide recommendations for improvement based on findings

• Document audit findings and communicate resul
Answered by AI
Add your answer
Q2. Explain IT SoX 404 control
Ans. 
IT SoX 404 control is a set of regulations and guidelines designed to ensure the accuracy and reliability of financial reporting in IT systems.
• IT SoX 404 control refers to the Sarbanes-Oxley Act section 404, which requires companies to establish internal controls over financial reporting.

• It involves documenting and testing controls to ensure the accuracy and reliability of financial information generated by IT systems.

• ...read more
Answered by AI
Add your answer
Q3. What are the key elements of audit report
Ans. 
Key elements of an audit report include executive summary, scope, findings, recommendations, and conclusion.
• Executive summary provides a brief overview of the audit process and key findings.

• Scope outlines the objectives, criteria, and limitations of the audit.

• Findings detail the specific issues identified during the audit.

• Recommendations suggest actions to address the findings and improve processes.

• Conclusion summarize...read more
Answered by AI
Add your answer

Q1. About experience and what you will be doing.
Add your answer
Q2. How will you manage pressure
Add your answer
Q3. Why do you want to join Mercer?
Add your answer

Q1. General round as all HR rounds
Add your answer

Q1. Current role and responsibilities
Add your answer
Q2. Salary expectations and location
Add your answer

Q1. About project you worked and outcomes
Add your answer
Q2. Leadership qualities
Add your answer