Deloitte Senior Analyst Interview Questions, Process, and Tips

Q1. How you approach the sprint planning
Ans. 
I approach sprint planning by collaborating with the team to prioritize tasks, estimate effort, and create a realistic plan.
• Collaborate with team members to understand their capacity and availability

• Prioritize tasks based on business value and dependencies

• Estimate effort for each task using techniques like story points or time-based estimates

• Create a realistic plan considering team velocity and potential risks

• Review an
Answered by AI
Add your answer

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

Q1. Recruiter called me on Saturday and scheduled the interview on following Wednesday. I had both T1 and T2 interviews on the same day. The interviewer in T1 was polite and asked basic .NET, Software engineer...read more
Add your answer

Q1. The interviewer in T2 was literally rude and had no knowledge of the domain at all. His name was Galam, Hari Krishna Yadav. If you ever meet him, trust me, you are doomed. First he joined the call 2 hours ...read more
Add your answer
Q2. Simple .NET questions
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

Three tasks shared with a fixed timeline

Q1. Based on assignment
Add your answer
Q2. Resume discussion
Add your answer