KPMG India Associate Consultant Interview Questions, Process, and Tips

Q1. Introduce yourself and your experience
Ans. 
I am a dedicated professional with 5 years of experience in consulting, specializing in data analysis and project management.
• 5 years of experience in consulting

• Specialize in data analysis and project management

• Strong communication and problem-solving skills
Answered by AI
Add your answer
Q2. Explain the Software Testing Lifecycle
Ans. 
The Software Testing Lifecycle is a process that includes planning, designing, executing, and evaluating tests to ensure software quality.
• 1. Planning phase involves defining test objectives, scope, and resources.

• 2. Design phase includes creating test cases, test data, and test environment setup.

• 3. Execution phase involves running tests, reporting defects, and retesting.

• 4. Evaluation phase includes analyzing test result...read more
Answered by AI
Add your answer
Q3. Explain SQL joins
Ans. 
SQL joins are used to combine rows from two or more tables based on a related column between them.
• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• INNER JOIN returns rows when there is at least one match in both tables

• LEFT JOIN returns all rows from the left table and the matched rows from the right table

• RIGHT JOIN returns all rows from the right table and the matched rows from the left table

• FULL ...read more
Answered by AI
Add your answer
Q4. Which python libraries do you use for data analysis and visualization and why?
Ans. 
I use pandas for data analysis and matplotlib/seaborn for data visualization.
• I use pandas for data manipulation, data cleaning, and data analysis due to its powerful data structures and functions.

• I use matplotlib and seaborn for data visualization as they provide a wide range of plotting options and customization.

• I also use numpy for numerical computations and scipy for scientific computing when needed.
Answered by AI
Add your answer

Was shared a dataset and had to answer the following questions:
Q1. Write a query to calculate the recovery rate and mortality rate.
Q2. Find out the top 5 states with 20% active cases and declining new cases in Feb 2022, July 2022, and Sept 2022.
Q3. Write a query to obtain relevant records from the state name table ordered by state name in ascending order and date in descending order.
q4. When did the cases in India cross 30 Lakhs?
Q5. Create a dashboard for recovered case trends and mortality death trends

Q1. Introduce yourself and your experience.
Ans. 
I am a dedicated and experienced professional with a background in consulting and project management.
• Over 5 years of experience in consulting and project management

• Strong analytical and problem-solving skills

• Excellent communication and interpersonal skills

• Managed multiple projects simultaneously, ensuring timely delivery

• Worked with diverse teams to achieve project goals
Answered by AI
Add your answer
Q2. Are you comfortable relocating to Delhi Location?
Ans. 
Yes, I am comfortable relocating to Delhi as I am excited about the opportunity to work in a new location.
• I am open to new experiences and challenges

• I have researched about Delhi and am excited about the cultural diversity and professional opportunities it offers

• I have a support system in place to help with the relocation process
Answered by AI
Add your answer

Q1. Introduce yourself and your experience.
Ans. 
I am a dedicated professional with 5 years of experience in consulting, specializing in data analysis and project management.
• 5 years of experience in consulting

• Specialize in data analysis and project management

• Strong communication and problem-solving skills
Answered by AI
Add your answer
Q2. Do you know how to build a dashboard?
Ans. 
Yes, I know how to build a dashboard.
• Identify key metrics and data sources

• Choose appropriate visualization tools

• Design layout for easy understanding

• Include interactive elements for user engagement
Answered by AI
Add your answer
Q3. Are you an immediate joiner?
Ans. 
Yes, I am available to join immediately.
• I am currently not committed to any other projects.

• I have completed all necessary notice periods at my current job.

• I am excited about the opportunity to start right away.
Answered by AI
Add your answer

Q1. Oracle Cloud Payroll core concepts like payroll setups, elements working/setup, Calculation cards, costing, Fast formula.
Add your answer
Q2. US payroll taxes (employee and employer)and 401k rules and types.
Ans. 
US payroll taxes and 401k rules and types.
• US payroll taxes include Social Security tax, Medicare tax, and federal income tax.

• Employers are responsible for withholding and paying payroll taxes on behalf of their employees.

• 401k plans are retirement savings plans that allow employees to contribute a portion of their pre-tax income.

• There are two types of 401k plans: traditional and Roth.

• Traditional 401k plans allow for pre...read more
Answered by AI
Add your answer
Q3. US legislative rule and state tax rules
Add your answer
Q4. Employee W2 and year end processing in US.
Add your answer
Q5. Real time projects requirements questions and we have to propose solutions.
Add your answer

I gave my interview during Campus Placement for Associate Consultant in Deal Advisory Services at KPMG Global Services.
First round which was before Resume screening was aptitude test.
Not very difficult basic Maths, English and Logical reasoning.

Q1. Walk me through your CV.
Ans. 
I have a diverse background with experience in consulting, project management, and data analysis.
• Bachelor's degree in Business Administration with a focus on Management

• Worked as a consultant at XYZ Consulting, where I helped clients improve their operational efficiency

• Managed multiple projects simultaneously, ensuring timely delivery and client satisfaction

• Analyzed data to identify trends and provide insights for decis...read more
Answered by AI
Add your answer
Q2. Without the help of internet help me calculate the no. of white cars sold in Mumbai every year. Not the method as to how you calculate the figure.
Ans. 
It is not possible to calculate the number of white cars sold in Mumbai every year without the help of internet.
• Without internet, it is impossible to access the necessary data and statistics.

• The number of white cars sold in Mumbai can vary greatly from year to year.

• Data on car sales is typically collected and analyzed using online platforms and databases.

• Without internet, it is difficult to gather information from car ...read more
Answered by AI
View 2 more answers
Q3. Tell me how many Reynolds pen are sold in Gurgaon every year.
Ans. 
It is not possible to accurately determine the number of Reynolds pens sold in Gurgaon every year without specific sales data.
• The sales data of Reynolds pens in Gurgaon is not publicly available.

• The number of Reynolds pens sold can vary each year due to factors such as market demand and competition.

• To determine the exact number, one would need access to sales records or conduct a market research study.

• Without specific ...read more
Answered by AI
View 1 more answer
Q4. What is financial modelling and why do you require it?
Ans. 
Financial modelling is the process of creating a mathematical representation of a financial situation or decision.
• It involves using various financial tools and techniques to analyze and forecast financial performance.

• It helps in making informed decisions about investments, budgeting, and financial planning.

• Examples include creating a cash flow statement, calculating return on investment, and building a financial model
Answered by AI
Add your answer

Q1. While working late at night, you figure out that the data available with you has something missing. You've been working on the data for the last 2 weeks. You don't see any senior around in office to help y...read more
Ans. 
Assess the situation, try to find the missing data, and if not possible, inform the client and senior management.
• Check if the missing data can be retrieved from any other source or system

• If not, assess the impact of missing data on the project and client's requirements

• If the impact is significant, inform the client and senior management immediately

• If the impact is minimal, complete the project with available data and i...read more
Answered by AI
View 1 more answer
Q2. Once you've tackled this situation you understand that the missing data was a fault of the client. How do you convey it to them?
Ans. 
I would approach the situation with empathy and tact, while clearly communicating the issue and offering solutions.
• Acknowledge the client's frustration and apologize for any inconvenience caused.

• Explain the issue in a clear and concise manner, without placing blame.

• Offer solutions or alternatives to obtain the missing data, such as requesting it from another source or using estimates.

• Ensure the client understands the i...read more
Answered by AI
Add your answer
Q3. What if it was your own mistake?
Ans. 
I would take responsibility for my mistake and take immediate action to rectify it.
• Acknowledge the mistake and take ownership

• Apologize and communicate the mistake to relevant parties

• Analyze the mistake to understand the root cause

• Develop a plan to rectify the mistake

• Implement the plan and monitor progress

• Learn from the mistake to prevent it from happening again
Answered by AI
Add your answer
Q4. What if it was your boss's mistake?
Ans. 
I would approach the situation professionally and respectfully address the mistake with my boss.
• Acknowledge the mistake and gather all relevant information

• Discuss the issue privately with my boss

• Offer potential solutions or suggestions to rectify the mistake

• Maintain a positive and collaborative attitude throughout the conversation
Answered by AI
Add your answer

Q1. Will you be comfortable working in Mumbai?
Ans. 
Yes, I will be comfortable working in Mumbai.
• I am familiar with the city and its culture.

• I have previously worked in Mumbai and enjoyed the experience.

• I am open to new opportunities and challenges in different locations.
Answered by AI
Add your answer
Q2. How do you see your career path at our firm?
Ans. 
I see my career path at your firm as a journey of continuous growth and development.
• I envision myself starting as an Associate Consultant and gradually progressing to higher roles such as Senior Consultant or Manager.

• I am eager to take on new challenges and responsibilities, and I believe your firm provides ample opportunities for professional advancement.

• I plan to enhance my skills and knowledge through training progr...read more
Answered by AI
Add your answer

Q1. Work experience
Add your answer

Q1. What did you do in your all previous company
Add your answer
Q2. Question Sap T codes
Add your answer

Most of the questions were about verbal ability and 20 questions will be from auditing and accountancy.

You will be given with general topics of discuss. If u are confident and can little knowledge about the topic you will crack it.

Q1. Tell me about yourself. Why should we hier you? What makes you different from others?
Ans. 
I am a highly motivated and experienced professional with a strong track record in consulting. I bring a unique combination of skills and expertise that sets me apart from others.
• Extensive experience in consulting, with a proven track record of delivering successful projects

• Strong analytical and problem-solving skills, which enable me to identify and address complex business challenges

• Excellent communication and interp...read more
Answered by AI
Add your answer
Q2. Are you a hardworker or smart worker?
Ans. 
I am both a hardworker and a smart worker.
• I believe in putting in the effort and working diligently to achieve my goals.

• I also believe in working smart by finding efficient ways to complete tasks and solve problems.

• For example, in my previous role, I was assigned a project with a tight deadline. Instead of working long hours without a plan, I analyzed the requirements, prioritized tasks, and delegated some responsibili...read more
Answered by AI
Add your answer

Q1. Tell about yourself and internal audit experience you possess and why do you career gaps.
Ans. Honest and short career joruney would make a great answer.
Answered Anonymously
Add your answer
Q2. Where do u see yourself in coming years.
Add your answer

Q1. Case study based question on internal audit
Add your answer