KPMG India Interview Questions, Process, and Tips

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

Q1. What are the fundamental concepts of security?
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

Q1. Explain Machine learning lifecycle and what are the deployment options?
Ans. 
Machine learning lifecycle involves data collection, model training, evaluation, and deployment. Deployment options include cloud, on-premise, and edge computing.
• Machine learning lifecycle stages: data collection, data preprocessing, model training, model evaluation, model deployment

• Deployment options: cloud (e.g. AWS, Azure), on-premise servers, edge computing devices (e.g. IoT devices)

• Deployment considerations: scala...read more
Answered by AI
Add your answer
Q2. Questions on NLP covering text preprocessing, word embeddings, sequence based models, RAG workflow.
Add your answer

Q1. What are the frameworks we can use to train machine learning models?
Ans. 
Frameworks for training machine learning models
• TensorFlow

• PyTorch

• Scikit-learn

• Keras

• MXNet
Answered by AI
Add your answer
Q2. What is your current and expected salary?
Ans. 
I am currently earning $60,000 per year and I am looking for a salary in the range of $70,000 to $80,000 for this position.
• Current salary: $60,000 per year

• Expected salary range: $70,000 - $80,000 per year
Answered by AI
Add your answer

A GD on any daily affairs topic was taken

Q1. Difference between information security and cyber security?
Ans. 
Information security focuses on protecting all forms of data, while cyber security specifically deals with protecting digital information from cyber threats.
• Information security encompasses all aspects of data protection, including physical and digital forms.

• Cyber security specifically deals with protecting digital information from cyber threats such as hacking, malware, and phishing attacks.

• Examples of information sec...read more
Answered by AI
Add your answer
Q2. Questions regarding projects
Add your answer

Q1. Behavioural questions
Add your answer

Q1. Team lead vs team member experience
Ans. 
Team lead experience involves managing and guiding a team, while team member experience focuses on executing tasks and following instructions.
• Team lead experience involves managing team members, setting goals, and providing guidance.

• Team member experience involves executing tasks, following instructions, and collaborating with team members.

• Team leads are responsible for decision-making and ensuring the team meets its o...read more
Answered by AI
Add your answer

Q1. Technical questions on Python
Add your answer
Q2. Technical questions on Python
Add your answer