KPMG India Interview Questions, Process, and Tips

Q1. Top and Bottom in one sheet
Ans. 
Use LOD calculations to display top and bottom values in one sheet in Tableau.
• Use Level of Detail (LOD) calculations to create separate calculated fields for top and bottom values.

• Use these calculated fields in the same sheet to display both top and bottom values.

• For example, create a calculated field for top values using {FIXED [Dimension]: MAX([Measure])} and another for bottom values using {FIXED [Dimension]: MIN([M
Answered by AI
Add your answer
Q2. Usage of parameter and filters
Ans. 
Parameters and filters are key features in Tableau for dynamic data analysis and visualization.
• Parameters allow users to input values that can be used in calculations, filters, and reference lines.

• Filters are used to limit the data displayed in a visualization based on specified criteria.

• Parameters can be used to create dynamic filters that allow users to interact with the data in real-time.

• Combining parameters and fil...read more
Answered by AI
Add your answer
Q3. Types of LOD and its use case
Ans. 
Types of LOD include Fixed, Include, and Exclude LOD calculations for different use cases.
• Fixed LOD: Used to ignore the level of detail in the view and compute an aggregate value.

• Include LOD: Used to compute an aggregate value at a higher level of detail than the view.

• Exclude LOD: Used to compute an aggregate value at a lower level of detail than the view.
Answered by AI
Add your answer
Q4. Performance Optimization
Add your answer

Q1. Project Overview and Size
Add your answer
Q2. Performance Optimization
Add your answer
Q3. Open for work in different technologies
Add your answer

Q1. Introduction and Role
Add your answer
Q2. Tableau Prep and its usage
Ans. 
Tableau Prep is a data preparation tool that allows users to clean, combine, and shape data for analysis in Tableau.
• Tableau Prep helps in cleaning and transforming data before visualizing it in Tableau Desktop.

• It allows users to easily combine multiple data sources and perform data cleaning tasks like removing duplicates, splitting columns, and aggregating data.

• Tableau Prep also provides a visual interface for creating...read more
Answered by AI
Add your answer
Q3. Snowflake vs Star Schema
Ans. 
Snowflake schema is a normalized form of Star schema with multiple levels of dimension tables.
• Snowflake schema has normalized dimension tables, while Star schema has denormalized dimension tables.

• Snowflake schema is more complex and requires more joins compared to Star schema.

• Star schema is easier to understand and query, making it more suitable for smaller datasets.

• Snowflake schema is more suitable for larger datasets
Answered by AI
Add your answer

Some multiple choice, 2 sql and 2 python questions were asked

Q1. Tell me about you project
Ans. 
Developed a real-time data processing system for analyzing customer behavior
• Used Apache Kafka for streaming data ingestion

• Implemented data pipelines using Apache Spark for processing and analysis

• Utilized Elasticsearch for storing and querying large volumes of data

• Developed custom machine learning models for predictive analytics
Answered by AI
Add your answer
Q2. Optimising technique that you have used
Ans. 
I have used partitioning and indexing to optimize query performance.
• Implemented partitioning on large tables to improve query performance by limiting the data scanned

• Created indexes on frequently queried columns to speed up data retrieval

• Utilized clustering keys to physically organize data on disk for faster access
Answered by AI
Add your answer

Q1. Window partition question was asked
Add your answer
Q2. Project related question
Add your answer

Q1. Write a program to print a pattern.
Add your answer
Q2. Wite a program to check fibonaaci.
Add your answer
Q3. Write a program to find a subarray
Add your answer

Q1. What is Medallion Architecture
Ans. 
Medallion Architecture is a data processing architecture that involves breaking down data into smaller pieces for easier processing.
• Medallion Architecture involves breaking down data into smaller pieces for easier processing

• It allows for parallel processing of data to improve performance

• Commonly used in big data processing systems like Hadoop and Spark
Answered by AI
Add your answer
Q2. What is Spark Architecture
Ans. 
Spark Architecture is a distributed computing framework that provides an efficient way to process large datasets.
• Spark Architecture consists of a driver program, cluster manager, and worker nodes.

• It uses Resilient Distributed Datasets (RDDs) for fault-tolerant distributed data processing.

• Spark supports various programming languages like Scala, Java, Python, and SQL.

• It includes components like Spark Core, Spark SQL, Spa...read more
Answered by AI
Add your answer
Q3. Find the second highest salary in employee table
Ans. 
Use SQL query to find the second highest salary in employee table
• Use SQL query with ORDER BY and LIMIT to get the second highest salary

• Example: SELECT DISTINCT salary FROM employee ORDER BY salary DESC LIMIT 1, 1
Answered by AI
Add your answer

Q1. How do you perform Partitioning
Ans. 
Partitioning in Azure Data Engineer involves dividing data into smaller chunks for better performance and manageability.
• Partitioning can be done based on a specific column or key in the dataset

• It helps in distributing data across multiple nodes for parallel processing

• Partitioning can improve query performance by reducing the amount of data that needs to be scanned

• In Azure Synapse Analytics, you can use ROUND_ROBIN or H
Answered by AI
Add your answer
Q2. What are your current responsibilities as Azure Data Engineer
Ans. 
As an Azure Data Engineer, my current responsibilities include designing and implementing data solutions on Azure, optimizing data storage and processing, and ensuring data security and compliance.
• Designing and implementing data solutions on Azure

• Optimizing data storage and processing for performance and cost efficiency

• Ensuring data security and compliance with regulations

• Collaborating with data scientists and analysts
Answered by AI
Add your answer

It was not easy and less time

Q1. What do you know about Kpmg
Add your answer
Q2. What do you know about servicenow
Ans. 
ServiceNow is a cloud-based platform that provides IT service management, IT operations management, and IT business management solutions.
• ServiceNow offers a range of products and services for IT professionals to streamline and automate their workflows.

• It helps organizations manage their IT infrastructure, services, and operations more efficiently.

• ServiceNow's platform includes modules for IT service management, IT oper...read more
Answered by AI
Add your answer