KPMG interview questions and answers
Last updated 2026-11-19
KPMG is a professional-services firm, so fresher interviews for its technology and advisory roles tend to mix a little technical depth with a lot of judgement and communication. Candidates commonly report questions on SQL and Excel, on controls and risk for technology audit roles, and on projects and teamwork.
This page works through that mix with worked answers. KPMG has not published a fixed fresher process that we can cite, so the round description is what candidates commonly report. For the test side see KPMG coding round questions.
| Typical tracks | Technology consulting, IT audit and risk, data and analytics |
|---|---|
| Rounds (commonly reported) | Aptitude or online test, technical interview, HR or partner round |
| Frequent topics | SQL, Excel, controls, cyber basics, projects |
Rounds as commonly reported
Candidates commonly describe an online test with aptitude and verbal sections, and for technology tracks some technical questions, followed by a technical or functional interview and a final HR or senior round. The details change by track and by year, and KPMG does not publish a single national fresher process, so use this as a sketch and trust your invitation.
Technology audit and risk panels ask about how systems are controlled: access, change management, backups and logging. Technology consulting panels lean more on data, cloud and delivery. In both, expect to be asked to explain your own projects clearly.
Topics worth revising
- SQL joins, GROUP BY, subqueries and window functions.
- Excel: VLOOKUP or XLOOKUP, pivot tables, IF and SUMIFS.
- IT general controls: access, change, operations and backup.
- Cyber basics: CIA triad, phishing, multi-factor authentication.
- Cloud basics: IaaS, PaaS, SaaS and shared responsibility.
Hiring status
There is no KPMG hiring page on this site, and we hold no sourced KPMG statement on fresher numbers, dates or packages, so none are quoted. Check KPMG India's own careers site for current openings and eligibility, and treat third-party posts about packages and cutoffs with caution.
KPMG interview questions and answers: questions with worked answers
1 What are IT general controls (ITGC), and why do auditors test them?
mediumITGCs are controls over the environment in which applications run: logical access (who can log in and with what rights), change management (how code and configuration changes are approved and tested), computer operations (job scheduling, backups, incident handling) and sometimes program development. Auditors test them because if they are weak, automated controls and system-generated reports cannot be relied upon.
2 Explain segregation of duties with an example.
easyNo single person should be able to complete a risky process end to end. For example, the person who creates a vendor should not also approve payments to it, and the developer who writes a change should not be the one who deploys it to production. This reduces fraud and error. If staffing makes full separation impossible, compensating controls such as independent review are used.
3 Write a SQL query to find customers with no orders.
easyLEFT JOIN customers to orders and keep rows where the order key is NULL, or use NOT EXISTS. Beware of NOT IN, because a single NULL in the subquery makes the whole condition unknown and returns no rows. This anti-join pattern is also how analysts find missing records, such as invoices without receipts.
sqlSELECT c.name FROM Customers c LEFT JOIN Orders o ON o.customer_id = c.id WHERE o.id IS NULL;4 How does VLOOKUP work, and what are its limits?
easyVLOOKUP searches the first column of a range for a value and returns a value from a column to the right in the same row. Use FALSE (or 0) for exact match. Limits: it cannot look to the left, breaks if columns are inserted when a hard-coded column index is used, and defaults to approximate matching if the last argument is omitted. XLOOKUP or INDEX with MATCH avoid these problems.
5 What is phishing and how can an organisation defend against it?
easyPhishing is deceiving people into revealing credentials or running malware, usually through email or messages that imitate a trusted sender. Defences are layered: email filtering, multi-factor authentication so stolen passwords are not enough, user awareness training and simulated phishing, clear reporting channels and rapid response to compromised accounts. Training alone is not sufficient because someone will eventually click.
6 What is the difference between a left join and a full outer join, and when is each used in reconciliation?
mediumA left join keeps all rows from the left table and matches from the right, useful to find left-side items that are missing on the right. A full outer join keeps unmatched rows from both sides, which is what a two-way reconciliation needs: items in system A not in B and items in B not in A. Filter on NULL keys on either side to list the exceptions.
7 What are the main data analytics steps in an audit or consulting engagement?
mediumDefine the question, obtain and validate the data (completeness and accuracy checks against control totals), clean and transform it, analyse with queries or scripts (trends, outliers, duplicates, rule tests), and report findings in a clear visual or table with caveats. Validating the data before analysing it is the step juniors skip and clients ask about first.
8 What is the shared responsibility model in cloud security?
mediumThe cloud provider is responsible for security of the cloud (physical data centres, hardware, the virtualisation layer), while the customer is responsible for security in the cloud (data, identity and access, configuration, and the operating system and applications on IaaS). The split moves toward the provider as you go from IaaS to SaaS. Most cloud breaches reported publicly involve customer misconfiguration.
9 Explain a Python dictionary and one use in data work.
easyA dictionary maps keys to values with average O(1) lookup, using hashing, and keys must be hashable. In data work it is used to count frequencies, group records by a key and join two datasets by an identifier without nested loops. Counting words with counts[w] = counts.get(w, 0) + 1 is the standard idiom.
10 How would you present a bad finding to a client who may be defensive?
hardPrepare facts and evidence first, check them with the team, then share privately before any wider meeting. Lead with the objective, state the finding and its impact neutrally, avoid blame, acknowledge what works, and come with options for remediation. Listening to the client context and agreeing next steps matters as much as the finding.
11 Tell me about yourself and why you chose technology within a professional-services firm.
easyGive a 60 to 90 second summary: education, one or two strengths with evidence, and what drew you to technology work that supports business processes, such as data, controls or systems. Link that to the role. See tell me about yourself for freshers for a template. Avoid reciting your resume line by line.
12 Describe a time you made a mistake and what you did about it.
mediumChoose a real, modest mistake, such as a wrong formula in a project report. Explain how you discovered it, that you told the affected people promptly, what you fixed and what check you added afterwards. Interviewers want ownership and learning, not a disguised strength.
Frequently asked questions
Is the KPMG interview technical?
For technology tracks, at a fundamentals level (SQL, Excel, controls, cloud, projects), with behavioural questions too.
What is the KPMG selection process for freshers?
Commonly reported as an online test, a technical or functional interview and an HR or senior round. KPMG publishes no single fixed process we can cite; confirm on your invitation.
Do I need to know coding for KPMG?
Technology roles may include basic coding or SQL. Audit and advisory roles lean more on aptitude, Excel and communication.
Where are KPMG openings listed?
On KPMG India's own careers site.
What salary does KPMG offer freshers?
We do not quote packages because we hold no KPMG source for them; check your offer letter and the official listing.
Related guides
More in Company Interview Questions
- L&T Technology Services interview questions
- LatentView Analytics Interview Questions with Answers
- LatentView Coding Round Questions
- LinkedIn Coding Round Questions With Solutions
- LinkedIn Interview Questions and Answers
- Lowe's Coding Round Questions
- Lowe's Interview Questions with Answers
- LTIMindtree Coding Round Questions with Solutions
- LTIMindtree Interview Questions for Freshers
- LTTS coding round questions
- MakeMyTrip Coding Round Questions
- MakeMyTrip Interview Questions with Answers