Upload Button Icon Add office photos

Kotak Mahindra Bank

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

Kotak Mahindra Bank Data Analyst Interview Questions and Answers

Updated 17 Oct 2024

Kotak Mahindra Bank Data Analyst Interview Experiences

2 interviews found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 17 Oct 2024

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
Not Selected
Round 1 - Coding Test 

Python, sql was asked

Interview Preparation Tips

Interview preparation tips for other job seekers - prepare well for interviews as they go in deep

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 1 May 2024

Interview experience
3
Average
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed before May 2023. There were 2 interview rounds.

Round 1 - Aptitude Test 

Basic aptitude questions on time, distance, some sql questions on joins

Round 2 - Technical 

(1 Question)

  • Q1. Questions were based upon resume projects, some basic queries, joins

Interview Preparation Tips

Interview preparation tips for other job seekers - Revising basics of SQL and DBMS concepts should be enough

Data Analyst Interview Questions Asked at Other Companies

asked in Deloitte
Q1. Suppose there is a room in the office and X people enter room thr ... read more
asked in Wipro
Q2. Chocolate Distribution Problem You are given an array/list CHOCOL ... read more
asked in Wipro
Q3. Ninja and Substrings Problem Statement Ninja has to determine all ... read more
asked in Capgemini
Q4. Ninja and His Secret Information Encoding Problem Ninja, a new me ... read more
Q5. Sliding Window Maximum Problem Statement You are given an array/l ... read more

Interview questions from similar companies

I applied via Walk-in and was interviewed in Apr 2021. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. About your self

Interview Preparation Tips

Interview preparation tips for other job seekers - please select my profile

Interview Questionnaire 

1 Question

  • Q1. Explain about self introduction

I applied via Referral and was interviewed before Jun 2021. There were 3 interview rounds.

Round 1 - Coding Test 

SQL server

Round 2 - Coding Test 

SQL DBA

Round 3 - HR 

(1 Question)

  • Q1. Salary discussed, Appts test

Interview Preparation Tips

Interview preparation tips for other job seekers - All the best... be prepared question
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Walk-in and was interviewed in Oct 2024. There were 2 interview rounds.

Round 1 - Assignment 

Easy on cyber security

Round 2 - One-on-one 

(2 Questions)

  • Q1. Introduce yourself this is
  • Q2. What is your work experience

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Good went well nicce process

Round 2 - Coding Test 

Medium level questions

Round 3 - HR 

(2 Questions)

  • Q1. Asked about core subjects
  • Q2. Asked about my project

Interview Preparation Tips

Interview preparation tips for other job seekers - nice process
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all Resume tips
Round 2 - Technical 

(4 Questions)

  • Q1. Base on SQL and tableau
  • Q2. How join work share in detail with examples
  • Q3. How to get nth salary
  • Q4. How to delete duplicates
  • Ans. 

    To delete duplicates, use SQL query with DISTINCT keyword or remove duplicates programmatically in Python using sets.

    • Use SQL query with DISTINCT keyword to remove duplicates from a database table

    • In Python, remove duplicates from a list using sets: list(set(original_list))

    • For pandas DataFrame, drop duplicates using df.drop_duplicates()

  • Answered by AI
Round 3 - One-on-one 

(1 Question)

  • Q1. Live coding on the platform

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. SQL Basics and Good Communication
  • Q2. Structured Profile Summary

Interview Preparation Tips

Interview preparation tips for other job seekers - My teams is focus on SQL server and referral works there

I applied via Naukri.com and was interviewed in Dec 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. What is Data Analytics ?
  • Ans. 

    Data Analytics is the process of examining and interpreting data to extract meaningful insights.

    • It involves collecting, cleaning, and transforming data

    • Applying statistical and machine learning techniques to analyze data

    • Visualizing and communicating insights to stakeholders

    • Examples include predicting customer behavior, optimizing business processes, and identifying trends in healthcare data

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Great Experience, HR & technical department are asking logical questions.

Skills evaluated in this interview

Contribute & help others!
anonymous
You can choose to be anonymous

Kotak Mahindra Bank Interview FAQs

How many rounds are there in Kotak Mahindra Bank Data Analyst interview?
Kotak Mahindra Bank interview process usually has 1-2 rounds. The most common rounds in the Kotak Mahindra Bank interview process are Aptitude Test, Technical and Coding Test.
How to prepare for Kotak Mahindra Bank Data Analyst interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Kotak Mahindra Bank. The most common topics and skills that interviewers at Kotak Mahindra Bank expect are Auditing, Data Analysis, Data Analytics, Internal Audit and Process Audit.

Recently Viewed

INTERVIEWS

Crisil

No Interviews

INTERVIEWS

EY Global Delivery Services ( EY GDS)

No Interviews

INTERVIEWS

Croma

No Interviews

INTERVIEWS

H&R Block

No Interviews

SALARIES

HYUNDAI TRANSYS INDIA

INTERVIEWS

Visible Alpha Solutions

No Interviews

SALARIES

HPCL Rajasthan Refinery

SALARIES

Visible Alpha Solutions

INTERVIEWS

RDC Concrete (India)

No Interviews

JOBS

RDC Concrete (India)

No Jobs

Tell us how to improve this page.

Kotak Mahindra Bank Data Analyst Interview Process

based on 2 interviews

Interview experience

3
  
Average
View more
Kotak Mahindra Bank Data Analyst Salary
based on 93 salaries
₹2.1 L/yr - ₹11.6 L/yr
At par with the average Data Analyst Salary in India
View more details

Kotak Mahindra Bank Data Analyst Reviews and Ratings

based on 8 reviews

4.0/5

Rating in categories

3.2

Skill development

3.4

Work-life balance

3.0

Salary

4.5

Job security

3.3

Company culture

2.6

Promotions

3.7

Work satisfaction

Explore 8 Reviews and Ratings
Assistant Manager
12.6k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Deputy Manager
11.3k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Manager
5.4k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Manager
3.5k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Relationship Manager
2.5k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Kotak Mahindra Bank with

HDFC Bank

3.9
Compare

ICICI Bank

4.0
Compare

Axis Bank

3.8
Compare

State Bank of India

3.8
Compare
Did you find this page helpful?
Yes No
write
Share an Interview