KPMG India Technology Consultant Interview: Rounds, Questions and Preparation

What the job involves

Technology Consultants at GCCs, consulting firms, and Big 4 outfits help clients design, implement, and optimise technology solutions that solve business problems. Day to day, they gather requirements, map processes, support testing and deployment, and translate between business users and technical teams. Freshers typically start on one workstream of a larger engagement, such as data migration, ERP support, or automation, and grow into owning modules or small teams.

Role and Technical Knowledge

1. 1

   Walk me through the phases of the Software Development Life Cycle (SDLC) and where a technology consultant adds the most value.

   Cover requirements, design, development, testing, deployment, and maintenance. Highlight that consultants add value in requirements gathering, process design, and bridging business and technical teams.

2. 2

   How would you explain the difference between a functional and a technical consultant to a client?

   Explain that functional consultants focus on business processes, configuration, and user needs, while technical consultants handle coding, integrations, and system architecture. Show that you understand both roles collaborate closely.

3. 3

   What is the difference between on-premise and cloud deployment? When would you recommend each?

   Discuss cost, scalability, security, maintenance, and compliance. Recommend cloud for agility and lower upfront cost, on-premise for strict data residency or legacy integration needs.

4. 4

   Explain primary key, foreign key, and index in a relational database with a simple example.

   Use a customer and orders example. Primary key uniquely identifies a row, foreign key links tables, and an index speeds up queries. Mention that indexes trade off write speed for read speed.

Practical Scenarios

1. 5

   A client's legacy system is slow and they want to migrate to a new ERP. What are the first three things you would do?

   Start with as-is process mapping, data quality assessment, and stakeholder interviews. Mention creating a migration roadmap with clear milestones and risk mitigation.

2. 6

   You are asked to automate a repetitive invoice processing task for a client. How would you approach it?

   Suggest process discovery, rule-based vs cognitive automation assessment, tool selection (e.g., RPA), and a pilot before scaling. Include exception handling and audit trails.

3. 7

   During UAT, users report that a critical report is showing incorrect totals. How do you handle it?

   Reproduce the issue, check data lineage and transformation logic, log a defect with clear steps, and communicate impact and workaround to stakeholders. Follow up with root cause analysis.

4. 8

   A client wants a dashboard to track sales performance across regions. What data and metrics would you include?

   Mention revenue, target vs actual, conversion rates, top products, and regional trends. Discuss data sources, refresh frequency, and user-friendly visualisation choices.

Behavioural and HR

1. 9

   Tell me about a time you worked in a team to solve a problem under a tight deadline.

   Use STAR format. Focus on your specific contribution, how you prioritised tasks, and the outcome. Show calmness and collaboration.

2. 10

   Why do you want to join a consulting firm like KPMG India rather than a product company?

   Talk about variety of projects, client exposure, structured learning, and the chance to solve business problems across industries. Avoid saying you want a product company later.

3. 11

   Describe a situation where you had to learn a new tool or technology quickly.

   Pick a real example from college projects or internships. Explain your learning approach, resources used, and how you applied it successfully.

4. 12

   How do you handle feedback or criticism from a senior or client?

   Show that you listen without being defensive, ask clarifying questions, and act on the feedback. Give a brief example of improvement.

Consulting and Sector Awareness

1. 13

   What do you understand by the term 'GCC' and how is it different from a traditional IT services company?

   GCC stands for Global Capability Centre, an offshore or nearshore unit of a global company. It differs by being an extension of the parent, often with more ownership and specialised roles than typical outsourced IT services.

2. 14

   Pick a recent technology trend (e.g., AI, blockchain, IoT) and explain how it could help a retail client.

   Choose one trend, give a concrete use case like demand forecasting with AI or supply chain tracking with blockchain, and mention business benefits like cost reduction or better customer experience.

3. 15

   How would you explain the value of digital transformation to a sceptical client?

   Focus on ROI, competitive advantage, and customer expectations. Suggest starting with a small pilot to demonstrate quick wins and build trust.

4. 16

   What are the key risks in a technology consulting project and how can a consultant mitigate them?

   Mention scope creep, data security, change resistance, and integration issues. Mitigate with clear scope documents, security protocols, training, and phased rollouts.