Premium Employer

i

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

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

IDFC FIRST Bank Data Analyst Interview Questions and Answers for Experienced

Updated 14 Jan 2025

IDFC FIRST Bank Data Analyst Interview Experiences for Experienced

1 interview found

Data Analyst Interview Questions & Answers

user image Iftekhar Alam

posted on 26 Oct 2023

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

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

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
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Joins,Where,having
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Group Discussion 

Future of work and us of artificial intelligence

Round 2 - One-on-one 

(2 Questions)

  • Q1. Tell me abouf yourself
  • Ans. 

    I am a data analyst with a strong background in statistics and data visualization.

    • Graduated with a degree in Statistics

    • Proficient in programming languages like Python and R

    • Experience with data visualization tools such as Tableau

    • Strong analytical skills and attention to detail

  • Answered by AI
  • Q2. Machine learning modelling, stats ecotrix

Interview Preparation Tips

Interview preparation tips for other job seekers - Focus on your CV
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
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Campus Placement

Round 1 - Aptitude Test 

Basic apt questions. Can easily practice online

Round 2 - HR 

(2 Questions)

  • Q1. Few hypothetical questions to check your analysis knowledge
  • Q2. How much flowers were to be accumulated at the end of the day if each person offered 5 flowers a day at the temple.
  • Ans. 

    The total number of flowers accumulated at the end of the day can be calculated by multiplying the number of people by the number of flowers each person offers.

    • Multiply the number of people by 5 to get the total number of flowers accumulated

    • For example, if there are 10 people, the total number of flowers accumulated would be 10 * 5 = 50

  • Answered by AI
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Questions mainly involved window function, recursion, some puzzels
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in Nov 2023. There was 1 interview round.

Round 1 - Technical 

(3 Questions)

  • Q1. 1. Introduction
  • Q2. 2. Project description
  • Ans. 

    Developed a predictive model to forecast sales based on historical data

    • Used machine learning algorithms to analyze sales trends

    • Incorporated external factors like seasonality and promotions into the model

    • Validated the model using cross-validation techniques

  • Answered by AI
  • Q3. Basics for spark and scala

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare your current project thoroughly.
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(1 Question)

  • Q1. What is indexing
  • Ans. 

    Indexing is a technique used to optimize the performance of databases by creating a data structure that allows for quick retrieval of data.

    • Indexing involves creating a data structure that maps the values of a particular column in a database table to their physical storage locations on disk.

    • It helps in speeding up data retrieval operations by allowing the database to quickly locate the rows that satisfy a certain condit...

  • Answered by AI

IDFC FIRST Bank Interview FAQs

How many rounds are there in IDFC FIRST Bank Data Analyst interview for experienced candidates?
IDFC FIRST Bank interview process for experienced candidates usually has 3 rounds. The most common rounds in the IDFC FIRST Bank interview process for experienced candidates are Resume Shortlist, Technical and One-on-one Round.
How to prepare for IDFC FIRST Bank Data Analyst interview for experienced candidates?
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 IDFC FIRST Bank. The most common topics and skills that interviewers at IDFC FIRST Bank expect are Data Analysis, Analytics, Banking, Analytical and Data Analytics.
What are the top questions asked in IDFC FIRST Bank Data Analyst interview for experienced candidates?

Some of the top questions asked at the IDFC FIRST Bank Data Analyst interview for experienced candidates -

  1. How to delete duplica...read more
  2. asked regarding sql to make a table and given some queries to solve over the ta...read more
  3. given easy code to solve before them very e...read more

Tell us how to improve this page.

IDFC FIRST Bank Data Analyst Interview Process for Experienced

based on 1 interview

Interview experience

3
  
Average
View more
Join IDFC FIRST Bank Guided by ethics, powered by technology and a force for social good
IDFC FIRST Bank Data Analyst Salary
based on 135 salaries
₹4 L/yr - ₹10.6 L/yr
55% more than the average Data Analyst Salary in India
View more details

IDFC FIRST Bank Data Analyst Reviews and Ratings

based on 14 reviews

4.2/5

Rating in categories

4.1

Skill development

3.9

Work-life balance

4.0

Salary

4.3

Job security

3.6

Company culture

3.8

Promotions

3.7

Work satisfaction

Explore 14 Reviews and Ratings
Deputy Manager
2.7k salaries
unlock blur

₹2.2 L/yr - ₹9.5 L/yr

Assistant Manager
1.6k salaries
unlock blur

₹2 L/yr - ₹7.1 L/yr

Senior Officer
1.4k salaries
unlock blur

₹2 L/yr - ₹5.4 L/yr

Manager
1.4k salaries
unlock blur

₹3.5 L/yr - ₹12.1 L/yr

Sales Officer
1.4k salaries
unlock blur

₹1 L/yr - ₹5 L/yr

Explore more salaries
Compare IDFC FIRST Bank with

HDFC Bank

3.9
Compare

ICICI Bank

4.0
Compare

Axis Bank

3.7
Compare

Kotak Mahindra Bank

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