Upload Button Icon Add office photos

KPMG India

Compare button icon Compare button icon Compare

Filter interviews by

KPMG India MSBI and Power BI Developer Interview Questions and Answers

Updated 22 Nov 2024

KPMG India MSBI and Power BI Developer Interview Experiences

1 interview found

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. What is power query?
  • Ans. 

    Power Query is a data connection technology that enables you to discover, connect, combine, and refine data across a wide variety of sources.

    • Power Query is a tool in Microsoft Excel and Power BI used for data transformation and manipulation.

    • It allows users to import data from various sources, clean and transform the data, and load it into the desired destination.

    • Power Query uses a graphical user interface to simplify t...

  • Answered by AI

Interview questions from similar companies

I appeared for an interview before Sep 2020.

Round 1 - Coding Test 

(2 Questions)

Round duration - 90 minutes
Round difficulty - Medium

This test consists of two coding questions and some MCQ regarding computer fundamentals.

  • Q1. 

    Kevin and His Cards Problem Statement

    Kevin has two packs of cards. The first pack contains N cards, and the second contains M cards. Each card has an integer written on it. Determine two results: the tot...

  • Ans. 

    Find total distinct card types and common card types between two packs of cards.

    • Create a set to store distinct card types when combining both packs.

    • Iterate through each pack and add card types to the set.

    • Find the intersection of card types between the two packs to get common card types.

  • Answered by AI
  • Q2. 

    Allocate Books Problem Statement

    Given an array of integers arr, where arr[i] represents the number of pages in the i-th book, and an integer m representing the number of students, allocate all the books ...

  • Ans. 

    Allocate books to students in a way that minimizes the maximum number of pages assigned to a student.

    • Iterate through all possible allocations of books to students.

    • Calculate the maximum number of pages assigned to a student for each allocation.

    • Return the minimum of these maximums as the result.

  • Answered by AI
Round 2 - Video Call 

(2 Questions)

Round duration - 40 minutes
Round difficulty - Easy

It was a technical round that is based on DSA and computer fundamentals.

  • Q1. 

    Reverse Linked List Problem Statement

    Given a singly linked list of integers, return the head of the reversed linked list.

    Example:

    Initial linked list: 1 -> 2 -> 3 -> 4 -> NULL
    Reversed link...
  • Ans. 

    Reverse a singly linked list of integers and return the head of the reversed linked list.

    • Iterate through the linked list and reverse the pointers to point to the previous node instead of the next node.

    • Use three pointers - prev, current, and next to reverse the linked list in O(N) time and O(1) space complexity.

    • Update the head of the reversed linked list as the last node encountered during the reversal process.

  • Answered by AI
  • Q2. 

    Sort 0 1 2 Problem Statement

    Given an integer array arr of size 'N' containing only 0s, 1s, and 2s, write an algorithm to sort the array.

    Input:

    The first line contains an integer 'T' representing the n...
  • Ans. 

    Sort an array of 0s, 1s, and 2s in linear time complexity.

    • Use three pointers to keep track of 0s, 1s, and 2s while traversing the array.

    • Swap elements based on the values encountered to sort the array in-place.

    • Time complexity should be O(N) and space complexity should be O(1).

  • Answered by AI

Interview Preparation Tips

Professional and academic backgroundI applied for the job as SDE - 1 in PuneEligibility criteria10- above 60% 12- ABove 60 percentZS Associates interview preparation:Topics to prepare for the interview - Data Structures and Algorithms, DBMS, OOPS, Operating System , System DesignTime required to prepare for the interview - 3 monthsInterview preparation tips for other job seekers

Tip 1 : If you are not able to complete something in-depth, clearly mention that to the interviewer.
Tip 2 : Practice DSA well.
Tip 3 : Try to think analytically and more logically,Your thinking skills matters a lot.

Application resume tips for other job seekers

Tip 1 : Try to mention max no of projects
Tip 2 : DO not fake in your resume.

Final outcome of the interviewRejected

Skills evaluated in this interview

I applied via Campus Placement and was interviewed before Nov 2020. There was 1 interview round.

Interview Questionnaire 

4 Questions

  • Q1. SQL Queries
  • Q2. OOPS Concepts
  • Q3. Program to calculate factorial
  • Ans. 

    Program to calculate factorial

    • Use a loop to multiply the numbers from 1 to n

    • Handle edge cases like 0 and negative numbers

    • Use recursion for a more elegant solution

  • Answered by AI
  • Q4. Projects- Major , Minor , Internship

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident, should have good communication skills.

Skills evaluated in this interview

I applied via Naukri.com and was interviewed in Apr 2020. There was 1 interview round.

Interview Questionnaire 

2 Questions

  • Q1. What synchronous and asynchronous means??
  • Ans. 

    Synchronous means happening at the same time, while asynchronous means not happening at the same time.

    • Synchronous operations occur in real-time, while asynchronous operations can be delayed or queued.

    • Synchronous operations block the program until they are completed, while asynchronous operations allow the program to continue running.

    • Examples of synchronous operations include function calls and loops, while examples of ...

  • Answered by AI
  • Q2. When to use CTE and temp table.
  • Ans. 

    CTE and temp table usage in SQL

    • Use CTE for recursive queries and complex subqueries

    • Use temp tables for large data sets and complex queries

    • CTE is more efficient for small data sets

    • Temp tables can be indexed for faster performance

    • Consider the scope and lifespan of the data when choosing between CTE and temp table

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Understand question first and answer.
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed before May 2023. There were 2 interview rounds.

Round 1 - Aptitude Test 

Clear basic programming fundamentals

Round 2 - Technical 

(1 Question)

  • Q1. All basic to advance concepts oops, SDLC, C3, asp.net, angular etc.

Interview Preparation Tips

Topics to prepare for Gartner Software Developer interview:
  • oops
  • c#
  • .net
  • angular
  • aws
Interview preparation tips for other job seekers - - make sure to have clear understanding of programming fundamentals
Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

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

Round 1 - HR 

(2 Questions)

  • Q1. When have you had a conflict with someone.
  • Ans. 

    I had a conflict with a team member over project priorities.

    • Miscommunication led to conflicting priorities

    • Discussed the issue openly and found a compromise

    • Learned the importance of clear communication in team projects

  • Answered by AI
  • Q2. Tell me you greatest project
  • Ans. 

    Developed a web-based project management tool for tracking tasks and deadlines

    • Used React for front-end development

    • Implemented user authentication and authorization using JWT tokens

    • Utilized Node.js and Express for back-end development

    • Integrated MongoDB for database storage

  • Answered by AI
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed before Apr 2023. There were 2 interview rounds.

Round 1 - Coding Test 

1 20 mark easy ques and 1 50 mark med ques, time : 1h 30 mins i guess

Round 2 - Technical 

(2 Questions)

  • Q1. Common elemnts two list , oops
  • Q2. Case study and oops sql

Interview Preparation Tips

Interview preparation tips for other job seekers - be confident

Software Developer Interview Questions & Answers

ZS user image Rahul Yamsani 010

posted on 22 Dec 2024

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Challenging questions in mathematics.

Round 2 - Group Discussion 

A constructive discussion about the significance of various topics and additional aspects.

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

I applied via LinkedIn and was interviewed before Jul 2023. There were 5 interview rounds.

Round 1 - Coding Test 

Hackerrank online assessment

Round 2 - Case Study 

Case study with a little bit of math for scenario based questions

Round 3 - Coding Test 

2 questions of coding with a live interviewer

Round 4 - Coding Test 

Behavioral and coding with a senior engineer

Round 5 - Behavioral interview 

(2 Questions)

  • Q1. How do you handle conflicts
  • Ans. 

    I handle conflicts by actively listening, seeking common ground, and finding mutually beneficial solutions.

    • Actively listen to all parties involved to understand their perspectives

    • Seek common ground and areas of agreement to build upon

    • Find mutually beneficial solutions that address the concerns of all parties

    • Communicate openly and transparently to resolve conflicts effectively

  • Answered by AI
  • Q2. What was the most challenging problem you had to solve so far
  • Ans. 

    Developing a real-time data synchronization system across multiple servers

    • Designing a scalable architecture to handle high volume of data

    • Implementing efficient algorithms for data synchronization

    • Handling conflicts and ensuring data consistency

    • Testing the system under various load conditions

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Focus on DSA, do a little bit of case studies with back of the envelope estimations and prepare thoroughly for behavioral interviews as they could be tricky

Interview Questionnaire 

1 Question

  • Q1. Questions regarding design patterns, Java Concepts, Questions on Hibernate and Springboot, My previous company work.

KPMG India Interview FAQs

How many rounds are there in KPMG India MSBI and Power BI Developer interview?
KPMG India interview process usually has 1 rounds. The most common rounds in the KPMG India interview process are Technical.

Tell us how to improve this page.

KPMG India MSBI and Power BI Developer Interview Process

based on 1 interview

Interview experience

4
  
Good
View more

Interview Questions from Similar Companies

Deloitte Interview Questions
3.8
 • 2.9k Interviews
PwC Interview Questions
3.4
 • 1.4k Interviews
Ernst & Young Interview Questions
3.4
 • 1.2k Interviews
ZS Interview Questions
3.3
 • 454 Interviews
BCG Interview Questions
3.7
 • 197 Interviews
Bain & Company Interview Questions
3.8
 • 107 Interviews
WSP Interview Questions
4.2
 • 95 Interviews
Mercer Interview Questions
3.7
 • 81 Interviews
View all
KPMG India MSBI and Power BI Developer Salary
based on 4 salaries
₹13.5 L/yr - ₹16 L/yr
135% more than the average MSBI and Power BI Developer Salary in India
View more details
Consultant
7.9k salaries
unlock blur

₹7 L/yr - ₹24 L/yr

Assistant Manager
7.2k salaries
unlock blur

₹10.2 L/yr - ₹31.3 L/yr

Associate Consultant
4.8k salaries
unlock blur

₹4.5 L/yr - ₹16 L/yr

Analyst
3.5k salaries
unlock blur

₹1 L/yr - ₹8 L/yr

Manager
2.9k salaries
unlock blur

₹15.5 L/yr - ₹46 L/yr

Explore more salaries
Compare KPMG India with

Cognizant

3.7
Compare

PwC

3.4
Compare

Capgemini

3.7
Compare

Google

4.4
Compare
Did you find this page helpful?
Yes No
write
Share an Interview