KPMG India Interview Questions, Process, and Tips

It was a MCQ test to intepret codes and its outcomes.

Q1. Given a dictionary, find out the greatest number for same key in Python.
Ans. 
Find the greatest number for same key in a Python dictionary.
• Use max() function with key parameter to find the maximum value for each key in the dictionary.

• Iterate through the dictionary and apply max() function on each key.

• If the dictionary is nested, use recursion to iterate through all the keys.
Answered by AI
Add your answer
Q2. Write Pyspark code to read csv file and show top 10 records.
Ans. 
Pyspark code to read csv file and show top 10 records.
• Import the necessary libraries

• Create a SparkSession

• Read the CSV file using the SparkSession

• Display the top 10 records using the show() method
Answered by AI
View 1 more answer
Q3. Write pyspark code to change column name, divide one column by another column.
Ans. 
Pyspark code to change column name and divide one column by another column.
• Use 'withColumnRenamed' method to change column name

• Use 'withColumn' method to divide one column by another column

• Example: df = df.withColumnRenamed('old_col_name', 'new_col_name').withColumn('new_col_name', df['col1']/df['col2'])
Answered by AI
Add your answer
Q4. What are the optimization techniques applied in pyspark code?
Ans. 
Optimization techniques in PySpark code include partitioning, caching, and using broadcast variables.
• Partitioning data based on key columns to optimize join operations

• Caching frequently accessed data in memory to avoid recomputation

• Using broadcast variables to efficiently share small data across nodes

• Using appropriate data types and avoiding unnecessary type conversions

• Avoiding shuffling of data by using appropriate tr...read more
Answered by AI
View 2 more answers

Q1. How do you handle changing schema from source. What are the common issues faced in hadoop and how did you resolve it?
Ans. 
Handling changing schema from source in Hadoop
• Use schema evolution techniques like Avro or Parquet to handle schema changes

• Implement a flexible ETL pipeline that can handle schema changes

• Use tools like Apache NiFi to dynamically adjust schema during ingestion

• Common issues include data loss, data corruption, and performance degradation

• Resolve issues by implementing proper testing, monitoring, and backup strategies
Answered by AI
Add your answer

Q1. Mostly it was salary negotiation
Add your answer

Q1. They ask about your projects at college. few questions regarding maths and aptitude. Be cheerful and confident.
Add your answer
Q2. Few case studies as well
Add your answer

Q1. Tell me about your self?
Add your answer
Q2. Are you proficient in EXCEL
Add your answer

ABOUT EXCEL BASIC FORMULAS, SUMIF, COUNTIF, VLOOKUP

Q1. WHERE DO WE USE CONDITIONAL FORMATIING
Ans. 
Conditional formatting is used in spreadsheets and databases to highlight data based on specified conditions.
• In Excel, conditional formatting can be used to highlight cells that meet certain criteria, such as values above or below a certain threshold.

• In databases, conditional formatting can be used to visually distinguish data that meets specific conditions, such as overdue tasks or high-priority items.

• Conditional form...read more
Answered by AI
Add your answer
Q2. WHY DO YOU WANT TO JOIN US
Ans. 
I am excited about the opportunity to apply my analytical skills and contribute to the success of your organization.
• I have a strong background in data analysis and problem-solving.

• I am impressed by your company's reputation for innovation and growth.

• I believe my experience aligns well with the requirements of the MIS Analyst role.

• I am eager to work with a talented team and make a positive impact.
Answered by AI
Add your answer

Basic logical & resoning questions

Q1. Sort the given array
Add your answer
Q2. Sum of the given number
Add your answer