Deloitte Senior Analyst Interview Questions, Process, and Tips

English test

Q1. How do you do reports, and how do you consolidate reports from different sources?
Ans. 
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.

• ...read more
Answered by AI
Add your answer
Q2. How do you provide residual risk ratings?
Ans. 
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
Answered by AI
Add your answer

Q1. What is risk management?
Ans. 
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
Answered by AI
Add your answer
Q2. How do you manage situations with top level management?
Add your answer

Deloitte India

Q1. Tell me about yourself
Add your answer
Q2. Have you ever worked on devops
Add your answer
Q3. How do you deploy tags in Jenkins and UCD
Add your answer
Q4. What you will do if you get a production issue
Add your answer
Q5. If the respective team is responsible to resolve an issue and they are not supporting you because of their priority items what you will do
Add your answer
Q6. What is .Net Framework
Add your answer
Q7. What is c#
Add your answer
Q8. Page life cycle of ASP.NET and explanation
Add your answer
Q9. OOPS Concept and Encapsulation Example
Add your answer
Q10. Value type and Ref Types
Add your answer
Q11. Constant and ReadOnly
Add your answer
Q12. How can you delete the duplicate values in a table
Add your answer
Q13. Difference between group by and having/ union and union all
Add your answer
Q14. Query to select last 5 records in a table
Add your answer
Q15. What is SMTP and what is the name space for that
Add your answer
Q16. Mention few name spaces you have used in your code
Add your answer
Q17. What is WEB API
Add your answer
Q18. Why WEB API is crucial over Web Services
Add your answer
Q19. How do you provide Security to your WEB API
Add your answer
Q20. What is Authentication and Authorization
Add your answer
Q21. What is difference between JSON and XML
Add your answer
Q22. Filters in MVC
Add your answer
Q23. What is MVC
Add your answer
Q24. What is Routing in MVC
Add your answer
Q25. How an application Interact with API
Add your answer
Q26. Architecture of API
Add your answer
Q27. What is HTTP
Add your answer

Q1. How would an organisation which is dealing with thousands of transactions daily implement iso27001
Ans. 
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...read more
Answered by AI
Add your answer
Q2. What do you know about BCP/DR
Ans. 
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...read more
Answered by AI
Add your answer

Q1. Risk,threat, vulnerability ,CIA,cyber security and information security fundamentals (can ask situation based on these topics)
Add your answer

Q1. Conatiners in SSIS
Ans. 
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...read more
Answered by AI
Add your answer
Q2. What is provider in SSIS
Ans. 
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.
Answered by AI
Add your answer