KPMG India Associate Consultant Interview Questions, Process, and Tips for Experienced

Q1. What are the fundamental concepts of security?
Ans. 
Fundamental concepts of security include confidentiality, integrity, availability, authentication, and authorization.
• Confidentiality: Ensuring that information is only accessible to those who are authorized to view it.

• Integrity: Ensuring that data is accurate, complete, and has not been tampered with.

• Availability: Ensuring that information and resources are accessible when needed.

• Authentication: Verifying the identity ...read more
Answered by AI
Add your answer

A news paper article involving money laundering and shell company issues were given to summarize. There were three paragraphs in total and we were asked to summarize it concisely

Q1. What is due diligence?
Ans. 
Due diligence is the process of investigating and evaluating a business or person before entering into a contract or agreement.
• Involves gathering and analyzing relevant information

• Helps in assessing risks and opportunities

• Ensures compliance with regulations and standards

• Common in mergers and acquisitions, investments, and partnerships
Answered by AI
Add your answer
Q2. What is money laundering?
Ans. 
Money laundering is the illegal process of making large amounts of money generated by a criminal activity, such as drug trafficking or terrorist funding, appear to have come from a legitimate source.
• Money laundering involves disguising the origins of illegally obtained money by passing it through a complex sequence of banking transfers or commercial transactions.

• It typically involves three stages: placement, layering, ...read more
Answered by AI
Add your answer
Q3. What do you mean by a shell company?
Ans. 
A shell company is a business that exists only on paper and has no significant assets or operations.
• Shell companies are often used for illegal activities such as money laundering or tax evasion.

• They can also be used for legitimate purposes such as holding assets or facilitating business transactions.

• Shell companies typically have minimal employees and physical presence.

• Examples of shell companies include those set up i...read more
Answered by AI
Add your answer
Q4. Why is due diligence necessary?
Ans. 
Due diligence is necessary to assess risks, verify information, and make informed decisions.
• To identify potential risks and liabilities associated with a business transaction or investment.

• To verify the accuracy of information provided by the other party.

• To evaluate the financial health and performance of a company.

• To ensure compliance with legal and regulatory requirements.

• To make informed decisions based on reliable ...read more
Answered by AI
Add your answer

Q1. Tell me about yourself
Ans. 
I am a highly motivated and detail-oriented individual with a strong background in consulting.
• Bachelor's degree in Business Administration

• Experience in analyzing data and providing strategic recommendations

• Strong communication and problem-solving skills

• Worked on a project that resulted in a 20% increase in client revenue
Answered by AI
Add your answer
Q2. What is due diligence?
Ans. 
Due diligence is a comprehensive investigation and analysis of a company or individual before entering into a business transaction.
• It involves gathering and reviewing relevant information about the company or individual.

• Due diligence helps identify potential risks, liabilities, and opportunities.

• It includes examining financial records, legal documents, contracts, and conducting interviews.

• Due diligence is crucial in me...read more
Answered by AI
Add your answer
Q3. Do you have good writing skills?
Add your answer
Q4. How good are you observation skills?
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. 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

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

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