KPMG India Interview Questions, Process, and Tips

It’s was aptitude that has moderate level .

Easy topic given on current scenario.

Q1. What is cybersecurity
Add your answer
Q2. How to tackle challenges regarding cybersecurity.
Add your answer

Q1. Questions related to BI tools like PowerBI and Tableau , writing few dax for specific scenario. Then few theory questions in SQL followed by 3-4 not so queries. At last discussion on cloud technology,answe...read more
Add your answer

Q1. 1. What is columnar storage,parquet,delta? Why it is used
Ans. 
Columnar storage is a data storage format that stores data in columns rather than rows, improving query performance.
• Columnar storage stores data in a column-wise manner instead of row-wise.

• It improves query performance by reducing the amount of data that needs to be read from disk.

• Parquet is a columnar storage file format that is optimized for big data workloads.

• It is used in Apache Spark and other big data processing ...read more
Answered by AI
Add your answer
Q2. 2.list ,tuple,set in python 3.sql groupby and window function ,union
Add your answer
Q3. 3. Explain detail project architecture
Ans. 
The project architecture involves the design and organization of data pipelines and systems for efficient data processing and storage.
• The architecture includes components such as data sources, data processing frameworks, storage systems, and data delivery mechanisms.

• It focuses on scalability, reliability, and performance to handle large volumes of data.

• Example: A project architecture may involve using Apache Kafka for ...read more
Answered by AI
Add your answer
Q4. 4. How to connect SQL server to databricks
Ans. 
To connect SQL server to Databricks, use JDBC/ODBC drivers and configure the connection settings.
• Install the appropriate JDBC/ODBC driver for SQL server

• Configure the connection settings in Databricks

• Use the JDBC/ODBC driver to establish the connection
Answered by AI
Add your answer
Q5. Optimisation techniques used
Ans. 
Optimisation techniques used in data engineering
• Partitioning data to improve query performance

• Using indexing to speed up data retrieval

• Implementing caching mechanisms to reduce data access time

• Optimizing data storage formats for efficient storage and processing

• Parallel processing and distributed computing for faster data processing

• Using compression techniques to reduce storage space and improve data transfer

• Applying qu...read more
Answered by AI
Add your answer

Q1. All detailed explaination about RICEF concepts and how you manage pressure and work
Add your answer
Q2. Explain about technical settings in the data dictionary
Ans. 
Technical settings in the data dictionary are used to define the structure and behavior of database objects in SAP ABAP.
• Technical settings include attributes like data type, length, and decimal places for fields in database tables.

• They also include settings for key fields, indexes, and foreign key relationships.

• Technical settings can be used to enforce data integrity and optimize performance.

• Examples of technical setti...read more
Answered by AI
Add your answer
Q3. Explain interactive report and module pool report
Ans. 
An interactive report is a type of report in SAP ABAP that allows users to interact with the data displayed, while a module pool report is a collection of screens and flow logic used for creating interactive applications.
• Interactive report: Allows users to interact with the data displayed

• Module pool report: Collection of screens and flow logic for creating interactive applications

• Interactive report can have user input ...read more
Answered by AI
Add your answer
Q4. What is the requirement you worked in smartforms
Ans. 
Smartforms are used in SAP ABAP development to create and customize forms for printing.
• Smartforms are a tool in SAP ABAP used to design and generate forms for printing.

• They provide a graphical interface for designing the layout and content of the form.

• Smartforms support various output formats such as PDF, HTML, and print.

• They can be used to create invoices, purchase orders, delivery notes, and other business documents.

• ...read more
Answered by AI
Add your answer
Q5. What all the requirements you worked in enhancements
Ans. 
I have worked on various requirements in enhancements.
• Implemented custom logic to enhance standard SAP functionality

• Developed user exits and BAdIs to add additional functionality

• Enhanced existing reports and forms to meet specific business requirements

• Integrated external systems with SAP using enhancement techniques

• Worked on performance enhancements to optimize system performance
Answered by AI
Add your answer