Protiviti Senior Data Analytics Manager Interview Questions and Answers

Basic coding questions such as Fibonacci series and Minimum odd integer in a list. SQL questions based on window functions and tableau theoretical questions

A common English speaking test

Q1. Why do you want to join deloitte
Add your answer
Q2. Salary expectations and reason for leaving current company
Add your answer
Q3. What was your salary when you started working and how much it has changed since then
Add your answer
Q4. How will you resolve conflict within your team if there's a critical deadline
Add your answer

Q1. Mostly related to current profile, and skills for using excel, PowerPoint, and aptitude skills.
Add your answer

Q1. Somewhat similar questions but detailed and this was with the team manager
Add your answer

Aptitude test was quite tough but limited time

Data interpretation type case study will be there. Follow some youtube videos and get the crux of the kind of question that would be asked

Q1. SQL and Excel walkthrough. Explain the project that you have done in college or company
Ans. 
I worked on a project in college that involved using SQL and Excel for data analysis.
• Used SQL to extract data from a database

• Imported the data into Excel for further analysis

• Performed various calculations and manipulations in Excel

• Created charts and visualizations to present the findings

• Generated reports based on the analyzed data
Answered by AI
Add your answer

Q1. Mostly they would grill on questions pertinent to team work. How are you going to align yourself to this firm system
Add your answer

The Aptitude test was mid level CAT questions. Time Constraint was the only issue in Aptitude test.

Was given with a very detailed Pharma case study and then there was 5 questions based on it. The questions consisted of quant and qualitative part. The question language was somewhat confusing for people not used to Case studies. I managed to solve all 5 correctly in an hour but people who did 3 or 4 also passed. As long as you can justify your logic and understand the part you did wrong while presenting.

Q1. 10 coins. 5 Heads up. Make 2 piles blindfolded with equal number of heads up
Ans. 
Divide 10 coins with 5 heads up into 2 piles with equal number of heads up while blindfolded.
• Divide the coins into two equal piles of 5 coins each.

• Ensure that each pile has the same number of heads up coins.

• Since you are blindfolded, you can't rely on visual cues, so use your sense of touch to determine which coins are heads up.

• You can also flip the coins over and feel for the heads to ensure equal distribution.

• Alterna...read more
Answered by AI
View 1 more answer
Q2. Ants on corners of equilateral triangle. Probability they will not collide moving along the edges
Ans. 
Probability of non-collision of ants on corners of equilateral triangle.
• The ants can move in two directions along each edge.

• The probability of collision is 1/3.

• The probability of non-collision is 2/3.
Answered by AI
View 1 more answer
Q3. Cutting a Cake into 8 pieces with minimum moves
Add your answer
Q4. General discussion about Branch and College
Add your answer

Q1. Why do you want to join ZS?
Ans. 
I want to join ZS because of its reputation for excellence in decision analytics and its focus on driving meaningful impact for clients.
• ZS is known for its expertise in decision analytics, which aligns with my passion for data-driven problem-solving.

• I am impressed by ZS's track record of delivering impactful solutions to clients across various industries.

• ZS's collaborative and inclusive culture appeals to me, as it fos...read more
Answered by AI
Add your answer
Q2. What is your biggest accomplishment till now?
Ans. 
My biggest accomplishment till now is successfully leading a team to implement a data-driven decision-making system that resulted in a 20% increase in company revenue.
• Successfully led a team to implement a data-driven decision-making system

• Resulted in a 20% increase in company revenue

• Utilized analytics tools and techniques to identify key areas for improvement

• Developed and executed a strategic plan to optimize decision...read more
Answered by AI
Add your answer