Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by DCB Bank Team. If you also belong to the team, you can get access from here

DCB Bank Verified Tick

Compare button icon Compare button icon Compare

Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards

zig zag pattern zig zag pattern

Filter interviews by

DCB Bank Data Analyst Interview Questions and Answers

Updated 7 Sep 2024

DCB Bank Data Analyst Interview Experiences

1 interview found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 7 Sep 2024

Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed before Sep 2023. There were 2 interview rounds.

Round 1 - Coding Test 

Basic python ,sql questions

Round 2 - Technical 

(2 Questions)

  • Q1. What is list,tuple,set,dict comprehension
  • Ans. 

    List, tuple, set, and dict comprehensions are concise ways to create these data structures in Python.

    • List comprehension: [x for x in range(10)]

    • Tuple comprehension does not exist in Python, as tuples are immutable.

    • Set comprehension: {x for x in range(10)}

    • Dict comprehension: {x: x**2 for x in range(10)}

  • Answered by AI
  • Q2. What is Dax query
  • Ans. 

    DAX (Data Analysis Expressions) is a formula language used in Power BI, Excel, and other Microsoft tools for data analysis.

    • DAX is used to create custom calculations, measures, and columns in data models.

    • It is similar to Excel formulas but optimized for data analysis.

    • DAX functions can be used to manipulate and analyze data in Power BI reports.

    • Examples of DAX functions include SUM, AVERAGE, CALCULATE, and RELATED.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Learn basic fundamentals

Skills evaluated in this interview

Interview questions from similar companies

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 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

Data Analyst Interview Questions & Answers

HDFC Bank user image Nandhini Sinilkumar

posted on 26 Jul 2023

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

I applied via Referral and was interviewed before Jul 2022. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Double-check your resume for any spelling mistakes. The recruiter may consider spelling mistakes as careless behavior or poor communication skills.
View all tips
Round 2 - Coding Test 

Related to programming language python SQL .net

Round 3 - Technical 

(1 Question)

  • Q1. Technical questions about the tools
Round 4 - One-on-one 

(1 Question)

  • Q1. Normal discussion about their policy salary
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
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
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
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Company Website and was interviewed before Jun 2023. There were 2 interview rounds.

Round 1 - Coding Test 

Coding and aptitude asked and very good questions

Round 2 - One-on-one 

(2 Questions)

  • Q1. Tuples used for
  • Ans. 

    Tuples are used for grouping related data together in a single entity.

    • Tuples are immutable, meaning their values cannot be changed once they are created.

    • They are commonly used in database systems to represent a single record or row of data.

    • Tuples can contain a mix of data types, such as integers, strings, and floats.

    • Example: ('John', 25, 'Male') could represent a tuple for a person's name, age, and gender.

  • Answered by AI
  • Q2. SQL is which language
  • Ans. 

    SQL is a programming language used for managing and manipulating databases.

    • SQL stands for Structured Query Language

    • It is used to communicate with databases to perform tasks such as querying data, updating records, and creating tables

    • Common SQL commands include SELECT, INSERT, UPDATE, DELETE

    • Example: SELECT * FROM table_name WHERE condition;

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Axis Bank Data Analyst interview:
  • SQL

Skills evaluated in this interview

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

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

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

DCB Bank Interview FAQs

How many rounds are there in DCB Bank Data Analyst interview?
DCB Bank interview process usually has 2 rounds. The most common rounds in the DCB Bank interview process are Coding Test and Technical.
How to prepare for DCB 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 DCB Bank. The most common topics and skills that interviewers at DCB Bank expect are Data Analysis, Core banking, Management, Relationship and Big Data.
What are the top questions asked in DCB Bank Data Analyst interview?

Some of the top questions asked at the DCB Bank Data Analyst interview -

  1. What is list,tuple,set,dict comprehens...read more
  2. What is Dax qu...read more

Tell us how to improve this page.

DCB Bank Data Analyst Interview Process

based on 1 interview

Interview experience

4
  
Good
View more
DCB Bank Data Analyst Salary
based on 58 salaries
₹3 L/yr - ₹10.3 L/yr
At par with the average Data Analyst Salary in India
View more details

DCB Bank Data Analyst Reviews and Ratings

based on 5 reviews

3.0/5

Rating in categories

2.6

Skill development

2.9

Work-life balance

2.6

Salary

4.2

Job security

3.6

Company culture

2.4

Promotions

2.9

Work satisfaction

Explore 5 Reviews and Ratings
Relationship Manager
877 salaries
unlock blur

₹2 L/yr - ₹6.5 L/yr

Assistant Manager
600 salaries
unlock blur

₹1.6 L/yr - ₹5.7 L/yr

Deputy Manager
405 salaries
unlock blur

₹2.3 L/yr - ₹9 L/yr

Credit Manager
305 salaries
unlock blur

₹3 L/yr - ₹11.5 L/yr

Sales Manager
281 salaries
unlock blur

₹3.5 L/yr - ₹11.5 L/yr

Explore more salaries
Compare DCB Bank with

HDFC Bank

3.9
Compare

ICICI Bank

4.0
Compare

Axis Bank

3.8
Compare

Kotak Mahindra Bank

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