Deloitte hires freshers in India mainly as analysts for its consulting, technology, risk and audit teams, including Deloitte US-India (USI), which supports US clients from Indian offices. The process usually includes an online test, sometimes a group discussion, a technical interview and a final HR or partner round. These Deloitte interview questions cover technical basics, case-style questions and the HR round, with model answers.
20 questions · Updated
Programming, OOP, DBMS, operating systems and your project, the core of most Deloitte fresher interviews.
A database (OLTP system) handles day-to-day transactions, such as orders and payments, with many small reads and writes and normalised tables.
A data warehouse (OLAP system) stores historical data from many sources, organised for analysis and reporting, often in star or snowflake schemas, and is optimised for large read queries.
Examples of warehouses include Snowflake, Amazon Redshift and Google BigQuery.
ETL stands for Extract, Transform, Load: data is extracted from source systems, transformed (cleaned, validated, joined and aggregated) and loaded into a target such as a data warehouse.
In ELT, raw data is loaded first and transformed inside the warehouse, which modern cloud warehouses make practical.
Tools include Informatica, Azure Data Factory, SSIS and dbt.
VLOOKUP searches the first column of a range and returns a value from a column to the right by number, defaults to approximate match unless you set FALSE, and breaks if columns are inserted.
XLOOKUP, available in newer Excel versions, takes separate lookup and return ranges, can look left, defaults to exact match, and can return a custom value if nothing is found.
INDEX with MATCH is the older flexible alternative.
A pivot table summarises large data sets by grouping and aggregating them, such as total sales by region and month, without writing formulas.
You drag fields into rows, columns, values and filters.
Use it to explore data quickly, find trends and build summary reports.
Pivot charts and slicers make the summary visual and interactive.
Unit testing checks individual functions or classes, usually by developers.
Integration testing checks that modules work together, such as an API with a database.
System testing checks the complete application against requirements.
User acceptance testing (UAT) is done by the client or users to confirm the system meets business needs before go-live.
Regression testing re-checks existing features after changes.
Symmetric encryption uses the same secret key to encrypt and decrypt, such as AES; it is fast but the key must be shared securely.
Asymmetric encryption uses a public key to encrypt and a private key to decrypt, such as RSA; it solves key sharing but is slower.
HTTPS uses both: asymmetric cryptography to agree on a key, then symmetric encryption for the data.
Phishing is a social engineering attack where attackers send fake emails, messages or websites that look genuine to trick people into revealing passwords, clicking malicious links or transferring money. Prevention includes security awareness training, email filtering, multi-factor authentication, verifying payment requests through a second channel, and checking sender addresses and links carefully.
Use a window function to rank employees within each department by salary and keep rank one. Using RANK keeps ties; ROW_NUMBER would keep only one employee per department.
SELECT department, name, salary
FROM (
SELECT department, name, salary,
RANK() OVER (PARTITION BY department ORDER BY salary DESC) AS rnk
FROM employees
) ranked
WHERE rnk = 1;Both are leading business intelligence tools for building interactive dashboards.
Power BI is from Microsoft, integrates closely with Excel, Azure and Microsoft 365, uses DAX for calculations and is generally cheaper for organisations already using Microsoft.
Tableau, owned by Salesforce, is known for flexible, polished visualisations and strong handling of large data.
The choice usually depends on the client's existing tools.
In a statutory audit, the auditor independently examines a company's financial statements and gives an opinion on whether they present a true and fair view, following auditing standards, and must remain independent.
In consulting, the firm advises or helps the client improve something, such as processes, technology or strategy.
Firms cannot provide certain consulting services to their audit clients, to protect independence.
Situations at work, attitude and flexibility. Sometimes combined with the technical or HR round.
Interviewers judge the structure, not the exact number.
For example: India has about 140 crore people; assume around 70% are in the age group that uses smartphones, about 100 crore; assume about 75% of those own one, about 75 crore users; if people replace phones every 2.5 to 3 years, around 25 to 30 crore phones are needed a year, plus first-time buyers.
State assumptions clearly and sanity-check against what you know.
Clarify the facts first: which products, regions and customers, and over what period.
Then split the problem: is it fewer customers or lower spending per customer, and is the cause internal (pricing, product quality, sales team, distribution) or external (competitors, market demand, regulation)?
Use data to test each hypothesis, prioritise the biggest drivers and recommend actions.
Summarise your approach at the end.
Understand why the date changed and what is most important to them. Assess what can realistically be delivered by the new date, then propose options with my manager, such as delivering the most important part first or adding resources, rather than promising everything and compromising quality.
Focus on the business impact and the solution, use simple language and analogies, avoid jargon, and check understanding. For example, instead of describing a database deadlock, say "two parts of the system were waiting for each other, which caused delays; we changed the order they work in, so it will not happen again."
Describe the situation, how you tried to understand their perspective, the steps you took to improve working together, and the outcome. Consulting work is highly team-based, so show maturity and focus on the result.
Questions about Deloitte, its hiring programmes, relocation, shifts and your plans.
Be specific: "Deloitte works with leading clients across industries and combines consulting, technology, risk and audit, so I can learn how businesses work from many angles. Its training, global exposure through USI, and culture of learning appeal to me." Mention which business you are applying to and why.
Deloitte is one of the Big Four professional services networks, along with PwC, EY and KPMG, providing audit and assurance, consulting, financial advisory, risk advisory and tax services.
Deloitte Touche Tohmatsu Limited is the UK-based umbrella organisation of independent member firms, including the large US firm, which works with Indian offices through Deloitte US-India (USI).
Read about the business you are applying to and a recent Deloitte initiative.
Show genuine interest: "I enjoy solving different problems, working with people and learning quickly. Consulting lets me work on varied projects across industries early in my career, and build skills in problem-solving, communication and technology that are valuable for a long-term career."
Be honest.
Consulting can involve demanding periods and client travel or shifts aligned to US clients.
A good answer: "Yes, I understand there are busy periods close to deadlines.
I manage my time well and I am comfortable with travel and working with US time zones when the project needs it."
Show growth in the firm: "I see myself as a consultant with deep expertise in one area, such as data analytics or cybersecurity, managing parts of client engagements and mentoring new analysts."
Company names are trademarks of their respective owners. Interview Ready is an independent practice site and is not affiliated with or endorsed by any company listed here.