Deloitte Senior Analyst Interview Questions, Process, and Tips for Experienced

Q1. Difference between stored proc and functions?
Ans. 
Stored procedures are precompiled and stored in the database, while functions are compiled and executed at runtime.
• Stored procedures are used to perform a set of operations and can return multiple values, while functions are used to compute a single value.

• Stored procedures can contain DML and DDL statements, while functions can only contain DML statements.

• Stored procedures can call functions, but functions cannot call ...read more
Answered by AI
Add your answer
Q2. Explain partial classes?
Ans. 
Partial classes allow a class's members to be split into multiple files.
• Partial classes are used in C# to split a class's definition into multiple files.

• Each part of the partial class must use the 'partial' keyword.

• All parts of the partial class must be in the same namespace and assembly.

• Partial classes are commonly used in large projects to organize and manage code more effectively.
Answered by AI
Add your answer
Q3. Explain solid principles?
Ans. 
SOLID principles are a set of five design principles that help make software designs more understandable, flexible, and maintainable.
• Single Responsibility Principle (SRP) - A class should have only one reason to change.

• Open/Closed Principle (OCP) - Software entities should be open for extension but closed for modification.

• Liskov Substitution Principle (LSP) - Objects of a superclass should be replaceable with objects o...read more
Answered by AI
Add your answer
Q4. Difference between abstract class and interface?
Ans. 
Abstract class can have both abstract and non-abstract methods, while interface can only have abstract methods.
• Abstract class can have constructors, fields, and methods, while interface cannot have any implementation.

• A class can implement multiple interfaces but can only inherit from one abstract class.

• Abstract classes are used to define a common behavior for subclasses, while interfaces are used to define a contract f...read more
Answered by AI
Add your answer

Q1. Internal audit discussion
Add your answer

Q1. 2nd round with partner asked me to say diff taxation ways for an company or manufacturing industry
Add your answer

Q1. Person analysis
Add your answer

Q1. Salary discussion
Add your answer

Basic coding round with manager and lead dev

Q1. Director round held virtually
Add your answer

Q1. Face to face interview at the office
Add your answer

Q1. Tell me about yourself
Ans. 
Experienced Senior Analyst with a background in data analysis and strategic planning.
• Over 5 years of experience in analyzing complex data sets

• Skilled in developing actionable insights and recommendations

• Proficient in using data visualization tools such as Tableau

• Strong background in financial analysis and forecasting

• Excellent communication and presentation skills
Answered by AI
Add your answer
Q2. Why did you apply to this role and how do you think you are a best for?
Ans. 
I applied to this role because of my strong analytical skills and experience in data analysis. I believe my background makes me a great fit for the position.
• I have a proven track record of analyzing complex data sets and providing valuable insights.

• I possess strong technical skills in data manipulation and visualization tools such as SQL, Python, and Tableau.

• I have experience in conducting market research and competiti...read more
Answered by AI
Add your answer

Q1. All c# .net related fundamentals
Add your answer

Q1. Advanced like async await microservices linq
Add your answer

Q1. How would you handle situations like these... Your manager makes a mistake You are wrongly accused for a task which is not completed
Ans. 
Addressing mistakes and accusations requires communication, accountability, and problem-solving skills.
• Acknowledge the mistake: If my manager makes a mistake, I would approach them privately, express my concerns, and suggest solutions.

• Provide evidence: If wrongly accused, I would gather documentation or emails to clarify my role and present it to my manager calmly.

• Focus on resolution: In both cases, I would emphasize f...read more
Answered by AI
Add your answer

Q1. Speaking reading writing listening skills test
Add your answer

Q1. Package discussions
Add your answer

Q1. 1. Tell me about yourself 2. Give a detailed explanations of the role from previous organisations. 3. Scenario based questions
Add your answer

Q1. 1. Scenario based questions on how you’ll deal with clients and meet their expectations. 2. More of self character based questions with this or that . 3. How will you convince your client if they are not r...read more
Add your answer

Q1. Discussion about salary expectations and job location.
Add your answer