Upload Button Icon Add office photos
Premium Employer

i

This company page is being actively managed by Deloitte Team. If you also belong to the team, you can get access from here

Deloitte Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Deloitte Interview Questions, Process, and Tips

Updated 6 Mar 2025

Top Deloitte Interview Questions and Answers

View all 1.7k questions

Deloitte Interview Experiences

Popular Designations

2.8k interviews found

Analyst Interview Questions & Answers

user image Anonymous

posted on 4 Jul 2015

Interview Questionnaire 

18 Questions

  • Q1. A Telecommunication company starting a new scheme and they have approached Deloitte for consulting. How and what will we guide?
  • Q2. Is JavaScript clientside or serverside?
  • Ans. 

    JavaScript is both clientside and serverside.

    • JavaScript is primarily used for clientside scripting in web browsers.

    • However, it can also be used for serverside scripting with Node.js.

    • Clientside JavaScript is executed by the user's browser.

    • Serverside JavaScript is executed by the server.

    • JavaScript can be used for both front-end and back-end development.

  • Answered by AI
  • Q3. Explain your B.E.Project
  • Q4. Difference between C and Java?
  • Ans. 

    C is a low-level programming language while Java is a high-level programming language.

    • C is compiled while Java is interpreted

    • C has pointers while Java does not

    • C is closer to the hardware while Java is platform-independent

    • C is used for system programming while Java is used for web and mobile app development

  • Answered by AI
  • Q5. Are you okay with relocation?
  • Q6. What are your weaknesses and how did you overcome it while coordinating in team projects?
  • Ans. 

    My weakness is time management, but I improved by setting clear deadlines and prioritizing tasks.

    • Identified time management as a weakness

    • Started setting clear deadlines for tasks

    • Learned to prioritize tasks based on importance and urgency

    • Utilized tools like calendars and task lists to stay organized

    • Sought feedback from team members on time management improvements

  • Answered by AI
  • Q7. What do u mean by DNS?
  • Ans. 

    DNS stands for Domain Name System, which is a system that translates domain names into IP addresses.

    • DNS is used to locate websites and other resources on the internet.

    • It works by translating human-readable domain names into machine-readable IP addresses.

    • DNS servers store information about domain names and their corresponding IP addresses.

    • Examples of DNS servers include Google DNS, OpenDNS, and Cloudflare DNS.

  • Answered by AI
  • Q8. What are the 7 layers in OSI model of Networking?
  • Ans. 

    The OSI model has 7 layers that define how data is transmitted over a network.

    • The layers are: Physical, Data Link, Network, Transport, Session, Presentation, and Application.

    • Each layer has a specific function and communicates with the layers above and below it.

    • For example, the Physical layer deals with the physical transmission of data, while the Application layer deals with user interfaces and applications.

    • The OSI mod...

  • Answered by AI
  • Q9. Is it possible to convert bytecode in Java back to original code and how to do it?
  • Ans. 

    Yes, it is possible to decompile bytecode in Java back to the original code.

    • Decompilation is the process of converting bytecode back to its original source code.

    • There are several tools available for decompiling Java bytecode, such as JD-GUI, FernFlower, and Procyon.

    • Decompiling bytecode can be useful for understanding how a program works, reverse engineering, or debugging.

    • However, the decompiled code may not be an exact...

  • Answered by AI
  • Q10. What is the use of JVM in Java?
  • Ans. 

    JVM is the virtual machine that executes Java bytecode. It provides platform independence and memory management.

    • JVM stands for Java Virtual Machine

    • It interprets compiled Java code into machine language

    • JVM provides platform independence by executing bytecode on any platform

    • It manages memory allocation and garbage collection

    • Examples of JVM-based languages include Kotlin and Scala

  • Answered by AI
  • Q11. What’s the relation between pointers and Security?
  • Ans. 

    Pointers are used in programming to manage memory and can be a potential security vulnerability if not handled properly.

    • Pointers allow direct access to memory locations, making it possible to manipulate data or execute arbitrary code.

    • Improper use of pointers can lead to buffer overflows, memory leaks, and other security vulnerabilities.

    • Pointers can be exploited by attackers to gain unauthorized access, execute maliciou...

  • Answered by AI
  • Q12. Explain the concept of inheritance in Java .What is its use?
  • Ans. 

    Inheritance in Java allows a class to inherit properties and methods from another class, promoting code reuse.

    • Inheritance is achieved using the 'extends' keyword in Java.

    • The class that is being inherited from is called the superclass or parent class.

    • The class that inherits from the superclass is called the subclass or child class.

    • The subclass can access the public and protected members of the superclass.

    • Inheritance pro...

  • Answered by AI
  • Q13. What is Abstraction?
  • Ans. 

    Abstraction is the process of simplifying complex systems by focusing on the essential details.

    • Abstraction involves hiding unnecessary details and exposing only the relevant information.

    • It allows us to create models or representations that capture the important aspects of a system.

    • Abstraction helps in managing complexity and improving understanding and communication.

    • For example, in programming, object-oriented abstract...

  • Answered by AI
  • Q14. You have to design a database for library. Which language will u prefer?
  • Ans. 

    I would prefer using SQL for designing a database for a library.

    • SQL is a widely used language for managing relational databases.

    • It provides a structured and efficient way to store, retrieve, and manipulate data.

    • SQL allows for easy querying and joining of tables, which is essential for library operations.

    • It supports transactions and ensures data integrity.

    • SQL also offers various security features to protect sensitive li

  • Answered by AI
  • Q15. Tell us about Firewall?
  • Ans. 

    A firewall is a network security system that monitors and controls incoming and outgoing network traffic.

    • Firewalls can be hardware or software-based

    • They can be configured to block or allow specific types of traffic

    • Firewalls can also be used to create virtual private networks (VPNs)

    • Examples of popular firewall software include Norton, McAfee, and Windows Firewall

  • Answered by AI
  • Q16. Why Deloitte?
  • Q17. 1 Reason why we shouldn’t hire you?
  • Q18. What is your biggest achievement since you joined engineering?

Interview Preparation Tips

Round: Test
Experience: Aptitude consisted of Quants, Logical and Verbal…All three were manageable..Around 68 people got shortlisted from 200.

Round: Case Study Interview
Experience: Here the quality as well as quantity of points mattered.. Our group consisted of 7 people..4 got shortlistedTotal around 30 got shortlisted.

Round: HR Interview
Experience: So it started with tell me about yourself?your academic achievements?Why computer engineering?Which projects did you do in these 4 years…(the main projects)

Round: Technical Interview
Experience: at the end 7 people got selected in Deloitte.

College Name: IIT MADRAS

Skills evaluated in this interview

Top Deloitte Analyst Interview Questions and Answers

Q1. Reverse a Number Problem Statement Given an integer 'N', write a program to generate the reverse of the number and print the resulting reversed number. The reversed number should not include any leading zeros that may appear. Example: Input... read more
View answer (3)

Analyst Interview Questions asked at other Companies

Q1. N-th Fibonacci Number Problem Statement Given an integer ‘N’, your task is to find and return the N’th Fibonacci number using matrix exponentiation. Since the answer can be very large, return the answer modulo 10^9 + 7. Formula: F(n) = F(n-... read more
View answer (1)

Interview Questions & Answers

user image Anonymous

posted on 4 Feb 2025

Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I was interviewed in Jan 2025.

Round 1 - HR 

(2 Questions)

  • Q1. Current CTC, Expected CTC, Notice Period, Skill set
  • Q2. Open for Fixed term hire? Open for working from client location at Gurgaon? (3 days from office)
  • Ans. 

    Yes, open for fixed term hire and working from client location at Gurgaon for 3 days a week.

    • Open for fixed term hire

    • Willing to work from client location at Gurgaon for 3 days a week

  • Answered by AI
Round 2 - Technical 

(10 Questions)

  • Q1. Introduction, Current role and responsibilities
  • Q2. List out the achievements in current project, Tools used
  • Ans. 

    Implemented automated testing using Selenium WebDriver and JUnit in Agile environment

    • Implemented automated testing framework using Selenium WebDriver

    • Utilized JUnit for test case management

    • Worked in Agile environment to ensure continuous testing and integration

  • Answered by AI
  • Q3. Pilot vs Beta testing. How can newly developed functionality be tested via automation rather doing it manually?
  • Ans. 

    Pilot testing is done by a small group of users before the full release, while beta testing is done by a larger group of users. Automation testing can be used for regression testing, smoke testing, and performance testing.

    • Pilot testing involves a small group of users testing the functionality in a controlled environment.

    • Beta testing involves a larger group of users testing the functionality in a real-world environment.

    • ...

  • Answered by AI
  • Q4. Primary key vs Unique key in SQL, Query to find row having last id in sql
  • Ans. 

    Primary key uniquely identifies a record, while unique key allows only one instance of a value in a column. Query to find last id involves using ORDER BY and LIMIT.

    • Primary key enforces uniqueness and not null constraint on a column

    • Unique key enforces uniqueness but allows null values

    • To find row with last id, use ORDER BY id DESC LIMIT 1 in SQL query

  • Answered by AI
  • Q5. Explain Software Testing Life Cycle, Defect Life Cycle
  • Ans. 

    Software Testing Life Cycle (STLC) involves planning, designing, executing, and reporting on tests. Defect Life Cycle includes identification, logging, fixing, and retesting defects.

    • STLC includes requirements analysis, test planning, test design, test execution, and test closure.

    • Defect Life Cycle involves defect identification, defect logging, defect fixing, defect retesting, and defect closure.

    • STLC ensures that the so...

  • Answered by AI
  • Q6. What's the meaning of 303 status code in API? Put vs Delete method in API What is 3 point estimation technique in Agile?
  • Ans. 

    303 status code in API means 'See Other'. PUT method is used to update data, while DELETE method is used to remove data. 3 point estimation technique in Agile is used to estimate tasks.

    • 303 status code indicates that the resource can be found at a different URI and should be retrieved from there

    • PUT method is used to update an existing resource in the API

    • DELETE method is used to remove a resource from the API

    • 3 point esti...

  • Answered by AI
  • Q7. What kind of links and labels can be tagged to a bug in jira?
  • Ans. 

    Links and labels that can be tagged to a bug in Jira

    • Links: related issues, documents, websites

    • Labels: priority, severity, type, status

  • Answered by AI
  • Q8. Have you done shell scripting? What does grep, href commands do in unix?
  • Ans. 

    Shell scripting is a way to automate tasks in Unix/Linux systems. Grep is used to search for specific patterns in text files. Href is not a standard Unix command.

    • Shell scripting automates tasks by writing scripts in a Unix/Linux environment

    • Grep command is used to search for specific patterns in text files

    • Example: grep 'search_pattern' file.txt

    • Href is not a standard Unix command, it may be a typo or a custom script

  • Answered by AI
  • Q9. As a lead, how would you resolve conflict with a team member? As a lead, if you are given plenty of tasks to be completed with in a limited time frame. What would be your approach in doing them?
  • Ans. 

    To resolve conflict with a team member, communication is key. Prioritize understanding, address the issue calmly, find common ground, and work towards a solution together.

    • Listen to the team member's perspective and concerns

    • Communicate openly and calmly about the issue

    • Find common ground and areas of agreement

    • Work together to find a solution that benefits both parties

    • Seek input from other team members or a mediator if ne

  • Answered by AI
  • Q10. Open for relocating to Bangalore and working from client's office? (with no relocation bonus) Open for working in night / rotational shift? (with no additional compensation) Open for working in long exten...
  • Ans. 

    Open to relocating to Bangalore, working in night shifts, long hours, and 24X7 culture. Goal is to excel in automation testing.

    • Yes, open to relocating to Bangalore and working from client's office

    • Yes, open to working in night/rotational shifts

    • Yes, open to working in long extendable hours or 24X7 culture

    • Goal is to excel in automation testing

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Not a good experience. Some recruiters are very arrogant and have no respect for the people interviewing with them. They consider as themselves dummy kings, because they are working in Deloitte USI. I interacted with 4-5 recruiters for one opening (from Gurgaon / Hyderabad). One HR even said to me that I was not the only person interviewing with them, they have bunch of people to chose, also various other things were said in a very unprofessional and rude manner. She had no ethics of talking to an experienced resource, when I escalated this to the seniors, they immediately apologized for her behavior and I was then handled by another Senior HR

I applied via referral in Deloitte USI but to save their referral bonus (I guess), they rejected my profile on the portal and called me through Naukri.com. When I asked them the reason, they said its for a different profile them. however it was for the same one.
Also on their career site, it was not mentioned that role is of fixed term hire (for 2 years), but HR disclosed it later, during the conversation. (another discrepancy)

During my initial conversation, HR clearly said there won't be any night shifts and I would have to work from client's location in Gurgaon office. Although it is 2 year contractual role.
But during my technical interview, the person clearly said to me that I would have to relocate to Bangalore for working from client's secured ODC in office. Also there would be rotational/ night shifts (without any extra pay). Basically they were looking for someone who would devote his 24X7 time to the company for a minimal salary and does not demand for work life balance or weekends off

Neither the HR nor the interviewer opened their web camera during the video call. But HR kept asking me to keep my camera open, even during the waiting time
Deloitte Interview Questions and Answers for Freshers
illustration image

Interview Questions & Answers

user image Anonymous

posted on 25 Feb 2025

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I was interviewed in Jan 2025.

Round 1 - Technical 

(14 Questions)

  • Q1. What is the code to read a CSV file into a DataFrame using PySpark?
  • Ans. 

    Code to read a CSV file into a DataFrame using PySpark

    • Import necessary libraries: from pyspark.sql import SparkSession

    • Create a Spark session: spark = SparkSession.builder.appName('example').getOrCreate()

    • Read CSV file into DataFrame: df = spark.read.csv('file.csv', header=True, inferSchema=True)

  • Answered by AI
  • Q2. What is your approach to refactoring code?
  • Ans. 

    I approach refactoring code by breaking it down into smaller tasks, identifying areas for improvement, and testing changes incrementally.

    • Break down the code into smaller, manageable tasks

    • Identify areas for improvement such as performance, readability, and maintainability

    • Test changes incrementally to ensure functionality is not compromised

  • Answered by AI
  • Q3. How do you optimize pyspark code, how is peer review done,
  • Ans. 

    Optimizing pyspark code involves tuning configurations, using efficient transformations/actions, caching data, and leveraging partitioning.

    • Tune configurations such as adjusting memory allocation, parallelism, and executor cores.

    • Use efficient transformations/actions like map, filter, reduceByKey instead of groupByKey.

    • Cache intermediate data using persist() or cache() to avoid recomputation.

    • Leverage partitioning to optim...

  • Answered by AI
  • Q4. What is the SQL query to join employee departments along with the count of employees in each department?
  • Ans. 

    SQL query to join employee departments with count of employees in each department

    • Use JOIN to combine employee and department tables

    • Use GROUP BY to group by department and COUNT() to get employee count

    • Include department name and employee count in SELECT statement

  • Answered by AI
  • Q5. What is lazy evaluation in PySpark, and can you provide examples to illustrate this concept?
  • Ans. 

    Lazy evaluation in PySpark delays the execution of transformations until an action is called.

    • Lazy evaluation allows PySpark to optimize the execution plan by combining multiple transformations before executing them.

    • Transformations in PySpark are not executed immediately, but are stored as a directed acyclic graph (DAG) until an action is triggered.

    • Examples of transformations in PySpark include map, filter, and reduceBy...

  • Answered by AI
  • Q6. How do you write SQL queries using PySpark code?
  • Ans. 

    SQL queries can be written in PySpark code using the Spark SQL module.

    • Use the SparkSession object to create DataFrames from data sources.

    • Register the DataFrames as temporary tables using the createOrReplaceTempView method.

    • Write SQL queries using the sql method of the SparkSession object.

    • Execute the SQL queries using the DataFrame API or collect the results as a DataFrame.

  • Answered by AI
  • Q7. What are the methods used to load data into a database?
  • Ans. 

    Various methods include bulk insert, ETL tools, APIs, and manual entry.

    • Bulk insert: Loading large amounts of data at once using SQL commands like BULK INSERT.

    • ETL tools: Extract, Transform, Load tools like Informatica or Talend for automated data loading.

    • APIs: Using application programming interfaces to transfer data from external sources.

    • Manual entry: Manually inputting data into the database through forms or interface

  • Answered by AI
  • Q8. What is the redshift spectrum?
  • Ans. 

    Redshift Spectrum is a feature in Amazon Redshift that allows users to run queries against data stored in Amazon S3.

    • Redshift Spectrum extends Redshift's querying capabilities to include data stored in S3

    • It allows users to query and join data across Redshift tables and S3 data lakes

    • Redshift Spectrum uses Redshift's SQL engine to query data directly in S3 without the need to load it into Redshift

    • It can be used to query s...

  • Answered by AI
  • Q9. What are the different types of indexing used in databases?
  • Ans. 

    Different types of indexing in databases include B-tree, hash, bitmap, and full-text indexing.

    • B-tree indexing is commonly used for range queries and sorting data efficiently.

    • Hash indexing is used for quick lookups but not suitable for range queries.

    • Bitmap indexing is efficient for low cardinality columns with repetitive values.

    • Full-text indexing is used for searching text fields with natural language queries.

  • Answered by AI
  • Q10. Could you describe your experience with sharing your screen to write PySpark code during scenarios in a Teams call, especially when you were using a mobile device?
  • Ans. 

    Experience sharing PySpark code on mobile device in Teams call

    • I have experience sharing my screen on a mobile device to write PySpark code during Teams calls

    • I have used the screen sharing feature in Teams to collaborate with team members on PySpark code

    • I have successfully troubleshooted code issues while sharing my screen on a mobile device

  • Answered by AI
  • Q11. What types of documentation are typically created during a project, and how is this documentation prepared?
  • Ans. 

    Various types of documentation are created during a project, such as design documents, technical specifications, user manuals, and test plans.

    • Design documents outline the architecture and functionality of the system.

    • Technical specifications detail the technical requirements and constraints of the project.

    • User manuals provide instructions on how to use the system.

    • Test plans outline the testing strategy and procedures to

  • Answered by AI
  • Q12. How do you ensure that your code is written optimally, and how do you evaluate, debug, and test it for various scenarios?
  • Ans. 

    I ensure optimal code quality through code reviews, performance testing, and continuous learning.

    • Conduct code reviews with team members to identify and address any inefficiencies or errors

    • Utilize performance testing tools to analyze code performance and make necessary optimizations

    • Stay updated on best practices and new technologies through continuous learning and training sessions

  • Answered by AI
  • Q13. What kind of documentation is written for pyspark code
  • Ans. 

    Documentation for pyspark code includes code comments, README files, and API documentation.

    • Code comments should explain the purpose of each function, class, and major code block.

    • README files should provide an overview of the project, installation instructions, and usage examples.

    • API documentation should detail the input/output parameters, data types, and usage guidelines.

  • Answered by AI
  • Q14. What are the best practices that you follow?
  • Ans. 

    Some best practices include data governance, scalability, security, and performance optimization.

    • Implement data governance policies to ensure data quality and compliance.

    • Design for scalability to handle growing data volumes and user loads.

    • Prioritize security measures to protect sensitive data from breaches.

    • Optimize performance through indexing, query optimization, and data partitioning.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - 1. The role would have client round and the candidate will have to write code and solve issues immediately in client interview call, this is what interviewer said
2. As a data platform architect, the role requires extreme level understanding of pyspark and sql not just overview as in other data architect role.
3. Docu
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
-
Result
No response

I was interviewed in Dec 2024.

Round 1 - Technical 

(27 Questions)

  • Q1. Tell me about yourself
  • Ans. 

    Experienced Senior Analyst with a background in financial analysis and data interpretation.

    • Over 5 years of experience in analyzing financial data and providing insights to drive business decisions

    • Proficient in using various analytical tools and software such as Excel, Tableau, and SQL

    • Strong communication skills to effectively present findings to stakeholders and senior management

    • Ability to work independently and in a t...

  • Answered by AI
  • Q2. Have you ever worked on devops
  • Ans. 

    Yes, I have experience working on devops.

    • Implemented CI/CD pipelines using tools like Jenkins and GitLab

    • Automated infrastructure provisioning with tools like Terraform

    • Managed containerized applications with Docker and Kubernetes

  • Answered by AI
  • Q3. How do you deploy tags in Jenkins and UCD
  • Ans. 

    Tags can be deployed in Jenkins using the Git plugin and in UCD using the version control system integration.

    • In Jenkins, tags can be deployed by configuring the Git plugin to fetch tags from the repository.

    • In UCD, tags can be deployed by integrating with the version control system and selecting the specific tag to deploy.

    • Tags can be used to mark specific versions of code for deployment and tracking purposes.

  • Answered by AI
  • Q4. What you will do if you get a production issue
  • Ans. 

    I will first analyze the issue, identify the root cause, implement a temporary fix if needed, and then work on a permanent solution.

    • Analyze the issue to understand the impact and severity

    • Identify the root cause by checking logs, code, and configurations

    • Implement a temporary fix to restore service if necessary

    • Work on a permanent solution to prevent future occurrences

  • Answered by AI
  • 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
  • Ans. 

    I would communicate with the team to understand their priorities and try to find a solution that addresses both the issue and their priorities.

    • Communicate with the team to understand their priorities and constraints

    • Highlight the impact of the issue on the overall project or organization

    • Collaborate with team members to find a mutually beneficial solution

    • Escalate the issue to higher management if necessary

  • Answered by AI
  • Q6. What is .Net Framework
  • Ans. 

    The .NET Framework is a software framework developed by Microsoft that provides a large library of pre-coded solutions to common programming problems.

    • Developed by Microsoft

    • Provides a large library of pre-coded solutions

    • Supports multiple programming languages like C#, VB.NET, F#

    • Used for building Windows applications, web applications, and services

  • Answered by AI
  • Q7. What is c#
  • Ans. 

    C# is a programming language developed by Microsoft for building a wide range of applications on the .NET framework.

    • Developed by Microsoft

    • Used for building applications on the .NET framework

    • Object-oriented language

    • Supports modern programming features like generics, LINQ, and async/await

    • Similar to Java and C++

  • Answered by AI
  • Q8. Page life cycle of ASP.NET and explanation
  • Ans. 

    ASP.NET page life cycle is a series of events that occur when a page is requested, processed, and rendered.

    • Page request is received by the server

    • Page is initialized, controls are created and properties are set

    • Page is loaded with data and events are handled

    • Page is rendered to HTML and sent to the client

    • Page is unloaded and resources are released

  • Answered by AI
  • Q9. OOPS Concept and Encapsulation Example
  • Ans. 

    Encapsulation is the concept of bundling data and methods that operate on the data into a single unit.

    • Encapsulation helps in hiding the internal state of an object and only exposing the necessary functionalities.

    • It allows for better control over the data by preventing direct access from outside the class.

    • Example: A class 'Car' encapsulating variables like 'model', 'year', and methods like 'startEngine()', 'accelerate()

  • Answered by AI
  • Q10. Value type and Ref Types
  • Q11. Constant and ReadOnly
  • Q12. How can you delete the duplicate values in a table
  • Ans. 

    Duplicate values in a table can be deleted by using the DELETE statement with a subquery.

    • Use the DELETE statement with a subquery to remove duplicate values.

    • Identify the duplicate values using a SELECT statement with GROUP BY and HAVING clauses.

    • Ensure to keep at least one unique record for each duplicate value.

  • Answered by AI
  • Q13. Difference between group by and having/ union and union all
  • Ans. 

    Group by is used to group rows that have the same values into summary rows, while having is used to filter groups based on a specified condition. Union combines the result sets of two or more SELECT statements, while Union All includes duplicates.

    • Group by is used with aggregate functions to group rows based on one or more columns.

    • Having is used to filter groups based on a specified condition after the group by operatio...

  • Answered by AI
  • Q14. Query to select last 5 records in a table
  • Ans. 

    Use SQL query with ORDER BY and LIMIT to select last 5 records in a table

    • Use SELECT statement to retrieve data from the table

    • Use ORDER BY clause to sort the records in descending order based on a column

    • Use LIMIT clause to limit the number of records returned to 5

  • Answered by AI
  • Q15. What is SMTP and what is the name space for that
  • Ans. 

    SMTP stands for Simple Mail Transfer Protocol, used for sending emails.

    • SMTP is a protocol used for sending emails over the internet

    • It works by using a series of commands between the email client and the email server

    • The namespace for SMTP is defined by RFC 5321

    • Examples of SMTP servers include Gmail's smtp.gmail.com and Outlook's smtp.live.com

  • Answered by AI
  • Q16. Mention few name spaces you have used in your code
  • Ans. 

    I have used namespaces such as std, boost, and Eigen in my code.

    • std

    • boost

    • Eigen

  • Answered by AI
  • Q17. What is WEB API
  • Ans. 

    Web API is a set of rules and protocols that allow different software applications to communicate with each other over the internet.

    • Web API allows different software applications to interact with each other over the internet

    • It defines the methods and data formats that applications can use to request and exchange information

    • Examples include RESTful APIs like Twitter API, Google Maps API, etc.

  • Answered by AI
  • Q18. Why WEB API is crucial over Web Services
  • Ans. 

    Web API allows for more flexibility, scalability, and ease of use compared to traditional web services.

    • Web API supports multiple data formats like JSON, XML, etc., making it easier to work with different clients.

    • Web API is more lightweight and faster compared to SOAP-based web services.

    • Web API allows for better security through the use of tokens and authentication mechanisms.

    • Web API is easier to integrate with modern w...

  • Answered by AI
  • Q19. How do you provide Security to your WEB API
  • Ans. 

    Securing a WEB API involves using authentication, authorization, encryption, and monitoring.

    • Implement authentication mechanisms such as OAuth, JWT, or API keys to verify the identity of clients accessing the API.

    • Use authorization to control access to different parts of the API based on roles and permissions.

    • Encrypt sensitive data transmitted between clients and the API using HTTPS or TLS.

    • Implement rate limiting, input ...

  • Answered by AI
  • Q20. What is Authentication and Authorization
  • Ans. 

    Authentication verifies the identity of a user, while authorization determines what actions they are allowed to perform.

    • Authentication confirms the identity of a user through credentials like passwords, biometrics, or security tokens.

    • Authorization controls access to resources based on the authenticated user's permissions.

    • Examples include logging into a website with a username and password (authentication) and then acce...

  • Answered by AI
  • Q21. What is difference between JSON and XML
  • Ans. 

    JSON is lightweight, easy to read, and primarily used for web APIs. XML is more verbose, structured, and commonly used for data storage and configuration.

    • JSON stands for JavaScript Object Notation, while XML stands for eXtensible Markup Language.

    • JSON is more lightweight and easier to read compared to XML.

    • JSON is commonly used for web APIs, while XML is often used for data storage and configuration files.

    • JSON uses key-v...

  • Answered by AI
  • Q22. Filters in MVC
  • Ans. 

    Filters in MVC are used to perform logic before or after an action method is executed.

    • Filters can be used for authorization, logging, caching, error handling, etc.

    • They can be applied globally, at controller level, or at action level.

    • Examples include Authorize filter for authentication, OutputCache filter for caching.

    • Filters can be created by implementing specific filter interfaces or by inheriting from FilterAttribute

  • Answered by AI
  • Q23. What is MVC
  • Ans. 

    MVC stands for Model-View-Controller, a software design pattern used for organizing code in a structured way.

    • MVC separates the application into three main components: Model (data), View (UI), and Controller (logic).

    • Model represents the data and business logic, View displays the data to the user, and Controller handles user input and updates the Model.

    • MVC helps in achieving separation of concerns, making code more modul...

  • Answered by AI
  • Q24. What is Routing in MVC
  • Ans. 

    Routing in MVC is the process of mapping URLs to controller actions in order to handle incoming requests.

    • Routing determines which controller and action should handle a request based on the URL

    • Routes are defined in the RouteConfig.cs file in ASP.NET MVC applications

    • Routes can include parameters that are passed to the controller action

    • Routing can be used to create user-friendly URLs

  • Answered by AI
  • Q25. How an application Interact with API
  • Ans. 

    An application interacts with an API by sending requests and receiving responses containing data or actions.

    • The application sends a request to the API specifying the desired action or data

    • The API processes the request and sends back a response containing the requested information

    • The application then uses the data or performs the action based on the response received

    • Examples: a weather app fetching current weather data ...

  • Answered by AI
  • Q26. Architecture of API
  • Ans. 

    API architecture refers to the design and structure of the application programming interface.

    • API architecture defines how different components of the API interact with each other

    • It includes the endpoints, data formats, authentication methods, and communication protocols used

    • Well-designed API architecture ensures scalability, security, and ease of use

    • Examples of API architectures include REST, SOAP, and GraphQL

  • Answered by AI
  • Q27. What is HTTP
  • Ans. 

    HTTP stands for Hypertext Transfer Protocol, a protocol used for transmitting data over the internet.

    • HTTP is the foundation of data communication on the World Wide Web.

    • It is a request-response protocol, where a client sends a request to a server and the server responds with the requested data.

    • HTTP uses TCP/IP as the underlying transport protocol.

    • Common HTTP methods include GET (retrieve data), POST (submit data), PUT (

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Go through the job description and find out what are they expecting from you, Prepare based on that.
I would say covering most of the topics in terms of definition would be the first thing we have to do, Then if you are sure about the definitions add example program for every definition by understanding the usage and functionality

Top Deloitte Senior Analyst Interview Questions and Answers

Q1. How do you do reports, and how do you consolidate reports from different sources?
View answer (1)

Senior Analyst Interview Questions asked at other Companies

Q1. Explain 3 statement financial model Calculating discount rate Could you walk me through the DCF model? Other valuation methods. What PE is ideal? What is the other matrix to value the company? Difference between IRR and CAGR. What is Bond Y... read more
View answer (1)

Deloitte interview questions for popular designations

 Consultant

 (456)

 Analyst

 (353)

 Senior Consultant

 (115)

 Assistant Manager

 (73)

 Associate Analyst

 (70)

 Tax Consultant

 (68)

 Business Analyst

 (63)

 Data Analyst

 (42)

Interview Questions & Answers

user image Anonymous

posted on 17 Feb 2025

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected
Round 1 - Technical 

(6 Questions)

  • Q1. Tell me about yourself.
  • Q2. How do you secure your cloud environment?
  • Ans. 

    Securing a cloud environment involves implementing strong IAM policies, encryption, monitoring, and regular security audits.

    • Implement strong IAM policies to control access to resources

    • Enable encryption for data at rest and in transit

    • Set up monitoring and logging to detect and respond to security incidents

    • Regularly conduct security audits and assessments to identify vulnerabilities

    • Use security groups and network ACLs to

  • Answered by AI
  • Q3. Types of policies in IAM
  • Ans. 

    Types of policies in IAM include identity-based policies, resource-based policies, permissions boundaries, and service control policies.

    • Identity-based policies: attached to IAM identities such as users, groups, and roles

    • Resource-based policies: attached to AWS resources such as S3 buckets or Lambda functions

    • Permissions boundaries: used to delegate permissions to IAM entities within an organization

    • Service control polici...

  • Answered by AI
  • Q4. What is the syntax for using JSON to provide permissions?
  • Ans. 

    JSON syntax for providing permissions

    • Use 'Effect' key to specify whether the permission is 'Allow' or 'Deny'

    • Use 'Action' key to specify the actions allowed or denied

    • Use 'Resource' key to specify the AWS resource to which the permission applies

  • Answered by AI
  • Q5. How can you deny permission to a specific user for a particular S3 bucket?
  • Ans. 

    To deny permission to a specific user for a particular S3 bucket, you can use IAM policies.

    • Create a custom IAM policy that explicitly denies access to the specific user for the S3 bucket

    • Attach the custom IAM policy to the user or a group the user belongs to

    • Ensure that the deny permission takes precedence over any allow permissions in other policies

    • Test the permissions to verify that the user is denied access to the S3

  • Answered by AI
  • Q6. How do you provide cross-account role access in an AWS account?
  • Ans. 

    Cross-account role access in AWS can be provided through IAM roles and trust relationships.

    • Create an IAM role in the target account with the necessary permissions.

    • Define a trust relationship in the target account's IAM role that allows the source account to assume the role.

    • In the source account, create an IAM policy that grants the necessary permissions to assume the role in the target account.

    • Attach the IAM policy to ...

  • Answered by AI

Get interview-ready with Top Deloitte Interview Questions

Consultant Interview Questions & Answers

user image PRAVEEN PATEL

posted on 22 Feb 2025

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(5 Questions)

  • Q1. Explain the structure of microservices architecture
  • Ans. 

    Microservices architecture is a design approach where an application is composed of small, independent services that communicate with each other.

    • Each service is responsible for a specific function or feature

    • Services are loosely coupled and can be developed, deployed, and scaled independently

    • Communication between services is typically done through APIs

    • Each service can be developed using different technologies or program...

  • Answered by AI
  • Q2. How to implement SQS and SNS in AWS cloud
  • Ans. 

    Implementing SQS and SNS in AWS cloud involves creating queues and topics, setting up permissions, and configuring subscriptions.

    • Create an SQS queue and configure its settings

    • Create an SNS topic and configure its settings

    • Set up permissions to allow SQS to send messages to SNS

    • Configure subscriptions to connect the SQS queue to the SNS topic

  • Answered by AI
  • Q3. What are the things which we need to be aware before we start migrating monolith into microservices
  • Ans. 

    Considerations before migrating monolith into microservices

    • Understand the current monolith architecture and dependencies

    • Identify the boundaries for microservices and plan the decomposition

    • Ensure proper testing and monitoring strategies are in place

    • Address data management and consistency challenges

    • Prepare for potential performance overhead and increased complexity

  • Answered by AI
  • Q4. How to provide security to apis without using spring security
  • Ans. 

    Implement API security using token-based authentication and authorization

    • Use token-based authentication like JWT (JSON Web Tokens)

    • Implement custom authentication and authorization logic in the API endpoints

    • Utilize API keys for access control and rate limiting

    • Implement OAuth for secure authorization and delegation of access

  • Answered by AI
  • Q5. What is API gateway
  • Ans. 

    API gateway is a server that acts as an API front-end, receiving API requests, enforcing throttling and security policies, passing requests to the back-end service, and then passing the response back to the requester.

    • API gateway acts as a single entry point for all API requests

    • It can handle tasks like authentication, authorization, rate limiting, and caching

    • Examples of API gateways include Amazon API Gateway, Apigee, a

  • Answered by AI
Round 2 - Technical 

(5 Questions)

  • Q1. Functional interface
  • Q2. Object oriented concepts
  • Q3. Stream api
  • Q4. Synchronization
  • Q5. While loop exceptions
  • Ans. 

    While loop exceptions are errors that occur during the execution of a while loop.

    • Common while loop exceptions include infinite loops, where the loop never terminates.

    • Another exception is when the loop condition is never met, causing the loop to never execute.

    • Handling exceptions in while loops can be done using try-catch blocks to catch and handle errors.

  • Answered by AI

Top Deloitte Consultant Interview Questions and Answers

Q1. How would you pass an entry for travel expenses incurred and paid by employee and was reimbursed? How would the end to end flow happens
View answer (8)

Consultant Interview Questions asked at other Companies

Q1. How would you pass an entry for travel expenses incurred and paid by employee and was reimbursed? How would the end to end flow happens
View answer (8)

Jobs at Deloitte

View all
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I was interviewed in Sep 2024.

Round 1 - Technical 

(2 Questions)

  • Q1. What are risk assertions
  • Q2. What are the risks in pharma sector
Round 2 - Technical 

(1 Question)

  • Q1. General discussion about experience

Deputy Manager Interview Questions asked at other Companies

Q1. 1.WHAT IS SPECIAL OF UR HOME TOWN 2.Who is Main compitetor with us and which products...3.what is main business in your area and its functions...4 Previous comoany achevements 5.Your strengts and weakness.
View answer (69)

Consultant Interview Questions & Answers

user image Anonymous

posted on 16 Jan 2025

Interview experience
3
Average
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via LinkedIn and was interviewed in Dec 2024. There was 1 interview round.

Round 1 - One-on-one 

(10 Questions)

  • Q1. Tell me about yourself
  • Ans. 

    I am a dedicated and experienced consultant with a strong background in problem-solving and client management.

    • Over 5 years of experience in consulting roles

    • Skilled in analyzing data and providing strategic recommendations

    • Proven track record of successfully managing client relationships

    • Strong communication and presentation skills

    • Certified in relevant consulting methodologies

  • Answered by AI
  • Q2. Write program to check string is palindrom
  • Ans. 

    Program to check if a string is a palindrome

    • Create a function that takes a string as input

    • Remove all non-alphanumeric characters and convert to lowercase

    • Compare the string with its reverse to check if it's a palindrome

  • Answered by AI
  • Q3. Write programm to Remove number from array who occur more than once
  • Ans. 

    Program to remove duplicate numbers from array of strings

    • Iterate through the array and keep track of the count of each number

    • Remove numbers with count greater than 1 from the array

  • Answered by AI
  • Q4. String Buffer vs String Builder
  • Ans. 

    String Buffer is synchronized and thread-safe, while String Builder is not synchronized.

    • String Buffer is slower due to synchronization, while String Builder is faster.

    • String Builder should be used in single-threaded scenarios for better performance.

    • String Buffer should be used in multi-threaded scenarios to ensure thread safety.

  • Answered by AI
  • Q5. If String s="Deloitte"; and String s2=new String("Deloitte"); what will be s1.equals(s2) and if(s1==s2)
  • Ans. 

    s1.equals(s2) will return true as both strings have the same value. s1==s2 will return false as they are different objects.

    • s1.equals(s2) compares the values of the strings, not the memory addresses

    • s1==s2 compares the memory addresses of the strings, not their values

    • Example: s1.equals(s2) will return true in this case because both s1 and s2 have the same value 'Deloitte'

  • Answered by AI
  • Q6. Why spring boot is better than spring ? Annotations of spring
  • Ans. 

    Spring Boot is better than Spring because it simplifies the development process by providing out-of-the-box configurations and reducing boilerplate code.

    • Spring Boot provides a pre-configured environment for application development, reducing the need for manual configurations.

    • It includes embedded servers like Tomcat, Jetty, or Undertow, making it easier to deploy applications.

    • Spring Boot auto-configures components based...

  • Answered by AI
  • Q7. Query for count employee in each department
  • Ans. 

    Query to count employees in each department

    • Use SQL query with GROUP BY clause on department column

    • Count the number of employees in each department

    • Retrieve the department name and the count of employees

  • Answered by AI
  • Q8. How to create react app ? npm commands to create react app
  • Ans. 

    To create a React app using npm commands

    • Use 'npx create-react-app my-app' to create a new React app

    • Navigate into the newly created app directory using 'cd my-app'

    • Start the development server with 'npm start'

  • Answered by AI
  • Q9. How routing works in react
  • Ans. 

    React routing allows for navigation between different components in a single-page application.

    • React Router is a popular library for handling routing in React applications

    • Routes are defined using <Route> components and nested within a <Router> component

    • Navigation between routes is typically done using <Link> components or programmatic navigation with history object

  • Answered by AI
  • Q10. Dml dcl and ddl command

Interview Preparation Tips

Interview preparation tips for other job seekers - basic java 8 and spring boot .. I was given almost all answer right except q3 still got rejected

Top Deloitte Consultant Interview Questions and Answers

Q1. How would you pass an entry for travel expenses incurred and paid by employee and was reimbursed? How would the end to end flow happens
View answer (8)

Consultant Interview Questions asked at other Companies

Q1. How would you pass an entry for travel expenses incurred and paid by employee and was reimbursed? How would the end to end flow happens
View answer (8)
Interview experience
2
Poor
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I was interviewed in Jan 2025.

Round 1 - Technical 

(2 Questions)

  • Q1. Sql and python related questions
  • Q2. Informatica and daily work realted questions
Round 2 - Technical 

(2 Questions)

  • Q1. Sql queries were asked
  • Q2. Concept based questions were asked

Interview Preparation Tips

Interview preparation tips for other job seekers - 2nd round interviewer was rude. Even after explaining the details she was saying I am not satisfied with your answer. I wrote the queries without any errors, Even I checked later
As if she had in mind whom to select

Data Migration Consultant Interview Questions asked at other Companies

Q1. Explain how to migrate on premise application on to cloud
View answer (1)

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 22 Jan 2025

Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

I was interviewed in Dec 2024.

Round 1 - Technical 

(6 Questions)

  • Q1. Tell me About Yourself
  • Ans. 

    I am a data analyst with a background in statistics and experience in analyzing large datasets.

    • Background in statistics

    • Experience in analyzing large datasets

    • Proficient in data visualization tools like Tableau

    • Strong problem-solving skills

    • Excellent communication skills

  • Answered by AI
  • Q2. Project working and day to day activities I do
  • Q3. Rate Yourself In SQL out of 5
  • Ans. 

    I would rate myself a 4 out of 5 in SQL proficiency.

    • Proficient in writing complex SQL queries

    • Experienced in optimizing database performance

    • Familiar with data manipulation and analysis functions

    • Comfortable working with large datasets

  • Answered by AI
  • Q4. Sql 3 question based on windows function
  • Q5. Very basic python 2 Question
  • Q6. What You do on power bi in your work Explain with full details workflow
  • Ans. 

    I use Power BI to analyze and visualize data for insights and decision-making in my work.

    • Connect to data sources to import data

    • Transform and clean data using Power Query Editor

    • Create relationships between different data tables

    • Design interactive reports and dashboards

    • Use DAX formulas for calculations and measures

    • Share reports with stakeholders and collaborate on insights

  • Answered by AI
Round 2 - Technical 

(1 Question)

  • Q1. All 3 sql Questions very simple Round but they didn't provide any Data tables just tell this and that so it may get confusing I slove 2 out of three but rejected on this Round questions Are intermidate

Interview Preparation Tips

Interview preparation tips for other job seekers - Overall interview Is Very simple just listen there Questions Clearly on sql You Will Crack Deloitte

Top Deloitte Data Analyst Interview Questions and Answers

Q1. Suppose there is a room in the office and X people enter room throughout the day, Y people leave throughout the day [continuously people are entering the room, some are staying there, and rest are going out] .. so tell me the code to calcul... read more
View answer (11)

Data Analyst Interview Questions asked at other Companies

Q1. Suppose there is a room in the office and X people enter room throughout the day, Y people leave throughout the day [continuously people are entering the room, some are staying there, and rest are going out] .. so tell me the code to calcul... read more
View answer (11)

Senior QA Analyst Interview Questions & Answers

user image Aswini Reddy

posted on 19 Jan 2025

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Dec 2024. There were 3 interview rounds.

Round 1 - Technical 

(4 Questions)

  • Q1. Functional testing related questions + Tech techniques+ Bug life cycle
  • Q2. Scenario based questions
  • Q3. Test planning+ other few lead level questions
  • Q4. Automation testing related questions
Round 2 - Technical 

(2 Questions)

  • Q1. Functional testing related questions
  • Q2. Scenario based questions
Round 3 - HR 

(1 Question)

  • Q1. CTC + Experience+ notice period+ expected CTC+ etc

Senior QA Analyst Interview Questions asked at other Companies

Q1. Can you convert lead if all required fields of contact or opportunity are not available on lead
View answer (1)
Contribute & help others!
anonymous
You can choose to be anonymous

Deloitte Interview FAQs

How many rounds are there in Deloitte interview?
Deloitte interview process usually has 2-3 rounds. The most common rounds in the Deloitte interview process are Technical, One-on-one Round and HR.
How to prepare for Deloitte interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Deloitte. The most common topics and skills that interviewers at Deloitte expect are Risk Management, Project Management, Finance, SQL and Accounting.
What are the top questions asked in Deloitte interview?

Some of the top questions asked at the Deloitte interview -

  1. Suppose there is a room in the office and X people enter room throughout the da...read more
  2. If you are given an array of 6 numbers 123345 give the logic for finding the d...read more
  3. Suppose you are testing an application and you find a bug and now you assigned ...read more
How long is the Deloitte interview process?

The duration of Deloitte interview process can vary, but typically it takes about less than 2 weeks to complete.

Recently Viewed

INTERVIEWS

Bank of America

No Interviews

SALARIES

Agumentik Software

DESIGNATION

DESIGNATION

DESIGNATION

INTERVIEWS

Cognizant

No Interviews

INTERVIEWS

Deloitte

No Interviews

INTERVIEWS

Deloitte

No Interviews

INTERVIEWS

Bank of America

No Interviews

DESIGNATION

Tell us how to improve this page.

Deloitte Interview Process

based on 2.1k interviews

Interview experience

4.1
  
Good
View more

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.4k Interviews
Accenture Interview Questions
3.8
 • 8.1k Interviews
Capgemini Interview Questions
3.7
 • 4.7k Interviews
IBM Interview Questions
4.0
 • 2.3k Interviews
PwC Interview Questions
3.4
 • 1.4k Interviews
Ernst & Young Interview Questions
3.4
 • 1.1k Interviews
KPMG India Interview Questions
3.5
 • 789 Interviews
BCG Interview Questions
3.7
 • 196 Interviews
Bain & Company Interview Questions
3.8
 • 103 Interviews
View all

Deloitte Reviews and Ratings

based on 17.8k reviews

3.8/5

Rating in categories

3.8

Skill development

3.3

Work-life balance

3.8

Salary

3.8

Job security

3.7

Company culture

3.4

Promotions

3.4

Work satisfaction

Explore 17.8k Reviews and Ratings
Snowflake Data Engineer

Bangalore / Bengaluru

4-9 Yrs

Not Disclosed

NetSuite Functional (Senior/ Manager)

Hyderabad / Secunderabad,

Bangalore / Bengaluru

6-11 Yrs

₹ 16-48 LPA

Java Fullstack Angular developer

Hyderabad / Secunderabad,

Gurgaon / Gurugram

+1

3-9 Yrs

Not Disclosed

Explore more jobs
Consultant
33.4k salaries
unlock blur Lock Unlock

₹0 L/yr - ₹0 L/yr

Senior Consultant
21k salaries
unlock blur Lock Unlock

₹0 L/yr - ₹0 L/yr

Analyst
14.3k salaries
unlock blur Lock Unlock

₹0 L/yr - ₹0 L/yr

Assistant Manager
10.1k salaries
unlock blur Lock Unlock

₹0 L/yr - ₹0 L/yr

Manager
7.1k salaries
unlock blur Lock Unlock

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Deloitte with

Accenture

3.8
Compare

PwC

3.4
Compare

Ernst & Young

3.4
Compare

Cognizant

3.7
Compare
Did you find this page helpful?
Yes No
write
Share an Interview
Rate your experience using AmbitionBox
Terrible
Terrible
Poor
Poor
Average
Average
Good
Good
Excellent
Excellent