Add office photos
Filter interviews by
KPMG India Senior Itms Analyst Interview Questions and Answers
KPMG India Senior Itms Analyst Interview Experiences
1 interview found
Anonymous
I applied via Recruitment Consulltant and was interviewed in Sep 2024. There was 1 interview round.
(2 Questions)
- Q1. Coding questions were asked
- Q2. Basic questions were asked
Interview questions from similar companies
I applied via Naukri.com and was interviewed in Nov 2024. There was 1 interview round.
(4 Questions)
- Q1. Was Given two small tables and was asked the total no of rows returned for each kind of join.
- Q2. In Tableau if the underlining table columns keep on changing than what can be done so that it wont affect on the view level.
- Ans.
Create calculated fields in Tableau to dynamically adjust to changing table columns.
Use calculated fields to reference specific columns by name instead of position.
Utilize parameters to allow users to select which columns to display.
Consider using custom SQL queries to dynamically adjust to changing table structure.
- Q3. Row level security
- Q4. Tell me about your project
- Ans.
Developed a predictive model to forecast customer churn for a telecommunications company.
Utilized machine learning algorithms such as logistic regression and random forest
Performed data preprocessing and feature engineering to improve model performance
Collaborated with business stakeholders to understand key drivers of churn
Achieved 85% accuracy in predicting customer churn
Interview Preparation Tips
I was interviewed in Oct 2024.
(2 Questions)
- Q1. Tell me about yourself ?
- Q2. What are few major projects that you had in your work ?
(2 Questions)
- Q1. Questions related to your work domain ?
- Q2. Any software that you used (Although they will ask opposite of the software you have experience with)
Interview Preparation Tips
I applied via Naukri.com and was interviewed in Dec 2024. There were 4 interview rounds.
Set of questions on english , aptitude , all are at easy level
Sql basics and some query questions
(2 Questions)
- Q1. Why do u want to join zs ; what do u know about zs; where do u see urself after 5 years ; question on real life scenarios ;
- Q2. Question on real life scenarios
(2 Questions)
- Q1. Salary expectation
- Q2. When can u join
Interview Preparation Tips
(3 Questions)
- Q1. Some OOPs questions
- Q2. SQL Questions were asked basic sql
- Q3. Project related questions
(2 Questions)
- Q1. Basic introduction
- Q2. Some basic hr questions
Selected
I applied via Referral and was interviewed in Oct 2024. There were 2 interview rounds.
The aptitude test was interesting, Had a bunch of fun puzzles
(2 Questions)
- Q1. Tell me about yourself
- Ans.
I am a detail-oriented business analyst with a strong background in data analysis and problem-solving.
Experienced in gathering and analyzing business requirements
Skilled in creating data models and visualizations
Proficient in using tools like SQL, Excel, and Tableau
Strong communication and presentation skills
Certified in business analysis (e.g. CBAP)
- Q2. Where do you see yourself in 5 years
Interview Preparation Tips
I applied via Company Website and was interviewed in Jul 2024. There was 1 interview round.
(5 Questions)
- Q1. How to measure risk & returns
- Q2. Investment due diligence and performance calculation
- Q3. Why we should hire you
- Q4. Why you want to switch job
- Q5. Fixed income valuation methods
Niharika Gupta
(1 Question)
- Q1. What is an interface is Java?
(1 Question)
- Q1. How would you handle a situation where 2 people are fighting
Mayur Kumar
I applied via campus placement at Delhi College of Engineering (DCE), Delhi and was interviewed in Jul 2024. There were 3 interview rounds.
It was a 1 hour test. It consists of two sections (i) 8 ques were of Business case studies (ii) 12 ques were of quantitative aptitude.
(2 Questions)
- Q1. What is the difference between where and having clause ?
- Ans.
Where clause is used to filter rows before grouping, while having clause is used to filter groups after grouping.
Where clause is used with SELECT, UPDATE, DELETE statements to filter rows based on a condition.
Having clause is used with GROUP BY statement to filter groups based on a condition.
Where clause is applied before grouping, while having clause is applied after grouping.
Example: SELECT * FROM table_name WHERE co...
- Q2. One ques was a guesstimate problem.
(2 Questions)
- Q1. Self Introduction.
- Q2. Business case problem which was to be solved in 15 minutes.
Interview Preparation Tips
- SQL
- Maths
Skills evaluated in this interview
I applied via Referral and was interviewed in Sep 2024. There was 1 interview round.
(2 Questions)
- Q1. Provide SOP for Account Payables.
- Ans.
SOP for Account Payables involves verifying invoices, obtaining approvals, processing payments, and reconciling accounts.
Verify invoices against purchase orders and receipts
Obtain necessary approvals for payment
Process payments accurately and timely
Reconcile accounts to ensure accuracy
Maintain proper documentation for audit purposes
- Q2. What is turnover discount?
- Ans.
Turnover discount is a reduction in price offered to customers who purchase a large quantity of goods or services.
Turnover discount is commonly used in retail and wholesale industries to incentivize bulk purchases.
The discount amount typically increases with the quantity purchased.
For example, a supplier may offer a 10% turnover discount for customers who buy 100 units of a product.
Turnover discount helps businesses in...
KPMG India Interview FAQs
Tell us how to improve this page.
KPMG India Interviews By Designations
- KPMG India Consultant Interview Questions
- KPMG India Analyst Interview Questions
- KPMG India Associate Consultant Interview Questions
- KPMG India Assistant Manager Interview Questions
- KPMG India Associate Interview Questions
- KPMG India Senior Consultant Interview Questions
- KPMG India Audit Associate Interview Questions
- KPMG India Manager Interview Questions
- Show more
Interview Questions for Popular Designations
Interview Questions from Similar Companies
Fast track your campus placements
|
Consultant
7.5k
salaries
|  ₹6.9 L/yr - ₹27 L/yr |
|
Assistant Manager
6.8k
salaries
| ₹10.5 L/yr - ₹32 L/yr |
|
Associate Consultant
4.5k
salaries
| ₹4.4 L/yr - ₹15.5 L/yr |
|
Analyst
3.4k
salaries
| ₹1 L/yr - ₹10 L/yr |
|
Manager
2.8k
salaries
| ₹12 L/yr - ₹46 L/yr |
Cognizant
PwC
Capgemini
Calculate your in-hand salary
- Home >
- Interviews >
- KPMG India Interview Questions >
- KPMG India Senior Itms Analyst Interview Questions
