i
Deloitte
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
I applied via Naukri.com and was interviewed in Nov 2021. There were 4 interview rounds.
English test
I use a standardized format for reports and consolidate data using tools like Excel or Tableau.
I use a consistent format for all reports to ensure clarity and ease of understanding.
I gather data from various sources and use tools like Excel or Tableau to consolidate it.
I ensure that all data is accurate and up-to-date before consolidating it.
I create visualizations to help convey the data in a clear and concise manner.
...
Residual risk ratings are provided by assessing the likelihood and impact of potential risks after implementing controls.
Assess the likelihood and impact of potential risks
Identify and implement controls to mitigate risks
Reassess the likelihood and impact of risks after controls are in place
Assign a residual risk rating based on the remaining level of risk
Communicate the residual risk rating to stakeholders
Risk management is the process of identifying, assessing, and controlling potential risks that could affect an organization's objectives.
Identifying potential risks
Assessing the likelihood and impact of each risk
Developing strategies to control or mitigate risks
Monitoring and reviewing risk management processes
Examples include financial risk, operational risk, and reputational risk
Deloitte India
I was interviewed in Dec 2024.
I applied via Approached by Company and was interviewed in Apr 2024. There were 2 interview rounds.
An organisation dealing with thousands of transactions daily can implement ISO27001 by following a structured approach to information security management.
Conduct a thorough risk assessment to identify potential security threats and vulnerabilities in the organization's systems and processes.
Develop and implement information security policies and procedures based on the requirements of ISO27001 standards.
Provide regular...
BCP/DR stands for Business Continuity Planning/Disaster Recovery. It involves creating strategies to ensure a company can continue operating during and after a disaster.
BCP focuses on preventing and minimizing the impact of disruptions to business operations.
DR focuses on restoring operations after a disaster has occurred.
Examples of BCP/DR strategies include data backup and recovery plans, emergency response procedure...
What people are saying about Deloitte
Containers in SSIS are objects that allow you to group and manage tasks and workflows in a package.
Containers help organize and control the flow of tasks in SSIS packages.
Common types of containers include Sequence Container, For Loop Container, and Foreach Loop Container.
Containers can be nested within each other to create complex workflows.
They can be used to handle errors, transactions, and looping logic.
Example: Us...
In SSIS, a provider is a software component that allows SSIS to connect to different types of data sources.
Providers are used to establish connections to databases, files, and other data sources in SSIS.
Examples of providers include OLE DB provider, ODBC provider, and ADO.NET provider.
Providers are selected in SSIS connection managers when setting up connections to data sources.
Deloitte interview questions for designations
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
Get interview-ready with Top Deloitte Interview Questions
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 ...
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.
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...
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...
I applied via Approached by Company and was interviewed in Jan 2024. There were 2 interview rounds.
I applied via Company Website and was interviewed in Dec 2023. There were 3 interview rounds.
Basic coding round with manager and lead dev
I applied via Naukri.com and was interviewed before Aug 2023. There was 1 interview round.
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
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...
I applied via Recruitment Consulltant and was interviewed before Oct 2023. There were 2 interview rounds.
Three tasks shared with a fixed timeline
Some of the top questions asked at the Deloitte Senior Analyst interview -
The duration of Deloitte Senior Analyst interview process can vary, but typically it takes about less than 2 weeks to complete.
based on 32 interviews
4 Interview rounds
based on 479 reviews
Rating in categories
Consultant
33.4k
salaries
| ₹6.3 L/yr - ₹23.2 L/yr |
Senior Consultant
21k
salaries
| ₹11 L/yr - ₹42 L/yr |
Analyst
14.3k
salaries
| ₹3.8 L/yr - ₹12.6 L/yr |
Assistant Manager
10.1k
salaries
| ₹7.8 L/yr - ₹24 L/yr |
Manager
7.1k
salaries
| ₹16 L/yr - ₹53 L/yr |
Accenture
PwC
Ernst & Young
Cognizant