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 Work with us arrow

Compare button icon Compare button icon Compare

Proud winner of ABECA 2025 - AmbitionBox Employee Choice Awards

zig zag pattern zig zag pattern

Filter interviews by

IDFC FIRST Bank Business Analyst Interview Questions and Answers

Updated 8 Jan 2025

IDFC FIRST Bank Business Analyst Interview Experiences

7 interviews found

Interview experience
4
Good
Difficulty level
Easy
Process Duration
2-4 weeks
Result
Selected Selected
Round 1 - One-on-one 

(2 Questions)

  • Q1. About previous project
  • Q2. Python code and some sql quries
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Er diagram in dbms
  • Ans. 

    ER diagram in DBMS is a visual representation of data relationships in a database.

    • ER diagram stands for Entity-Relationship diagram

    • It shows entities, attributes, and relationships between entities

    • Entities are represented as rectangles, attributes as ovals, and relationships as diamonds

    • Example: An ER diagram for a university database would show entities like Student, Course, and Department

  • Answered by AI
  • Q2. Coursor, views etc

Business Analyst Interview Questions Asked at Other Companies

asked in Evalueserve
Q1. You have 10 boxes of balls (each ball weighing exactly 10 gm) wit ... read more
Q2. There are 100 people standing in a circle, the first person has a ... read more
asked in EXL Service
Q3. Doors numbered 1 to 100 are initially closed. In the first step, ... read more
asked in Infosys
Q4. What is your strong point in terms of technical knowledge? Like J ... read more
asked in EXL Service
Q5. If you have 333 digits to number the pages of a book, how many pa ... read more

Business Analyst Interview Questions & Answers

user image Shahadha Begum

posted on 16 Nov 2023

Interview experience
5
Excellent
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before Nov 2022. There were 4 interview rounds.

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

It was very good exp6

Round 3 - Technical 

(4 Questions)

  • Q1. Regarding agile and water fall method
  • Q2. What is the process that you do in agilemethod
  • Ans. 

    In Agile methodology, the process involves iterative development, collaboration, and flexibility.

    • Agile methodology focuses on breaking down projects into smaller tasks called user stories.

    • Teams work in short iterations called sprints, typically 2-4 weeks long.

    • Daily stand-up meetings are held to discuss progress, challenges, and plans for the day.

    • Continuous feedback and adaptation are key principles in Agile methodology...

  • Answered by AI
  • Q3. What is scrum and what is the process
  • Ans. 

    Scrum is an agile framework for managing work on complex projects.

    • Scrum involves breaking down work into small, manageable tasks called user stories.

    • It includes roles like Product Owner, Scrum Master, and Development Team.

    • Scrum events include Sprint Planning, Daily Standups, Sprint Review, and Sprint Retrospective.

    • The process involves iterative development cycles called Sprints, typically 2-4 weeks long.

    • Scrum emphasize...

  • Answered by AI
  • Q4. What is the agile cycle to process
Round 4 - HR 

(1 Question)

  • Q1. Regarding salary 7

Skills evaluated in this interview

Business Analyst Interview Questions & Answers

user image Shubham Jaiswal

posted on 5 Oct 2023

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed before Oct 2022. There were 4 interview rounds.

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 

(2 Questions)

  • Q1. Questions were mostly on SQL, SSIS and DWH.
  • Q2. Performance tuning.
Round 3 - Technical 

(2 Questions)

  • Q1. About projects on which currently working.
  • Q2. Indexes, Parallelism, Scheduling, Stored Procedures
Round 4 - HR 

(1 Question)

  • Q1. Salary discussion .

Interview Preparation Tips

Interview preparation tips for other job seekers - Be thorough of your resume.

I applied via LinkedIn and was interviewed in Mar 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Questions were asked around Requirements Gathering process, Client interaction. In depth questions were asked around Agile and Agile Methodologies and Agile tools.

Interview Preparation Tips

Interview preparation tips for other job seekers - If you are applying for Business Analyst role always be thorough with your project management skills and agile terminologies if your project was following agile model.

Business Analyst Interview Questions & Answers

user image Shubham Jaiswal

posted on 18 Sep 2022

I applied via Naukri.com and was interviewed before Sep 2021. There were 5 interview rounds.

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 

(2 Questions)

  • Q1. Purely on SSIS and SQL server
  • Q2. Performance Tuning,Scheduling , Deployment related questions.
Round 3 - Technical 

(1 Question)

  • Q1. About Previous Projects and SSIS scenario based questions.
Round 4 - One-on-one 

(1 Question)

  • Q1. About the company policies
Round 5 - HR 

(1 Question)

  • Q1. Discussion on Salary Front.

Interview Preparation Tips

Topics to prepare for IDFC FIRST Bank Business Analyst interview:
  • Performance Tuning
Interview preparation tips for other job seekers - Prepare well for technical interview .
There will be direct questions and scenario based questions as well.

IDFC FIRST Bank HR Interview Questions

188 questions and answers

Q. Did you receive incentives in your previous organization?
Q. How much business will you do in a month?
Q. Why did you leave your previous organization?

Interview Questionnaire 

1 Question

  • Q1. What is company history
  • Ans. 

    The company has evolved through innovation, strategic acquisitions, and a commitment to customer satisfaction since its founding.

    • Founded in 1990, the company started as a small tech startup focused on software development.

    • In 2000, it acquired a competitor, which expanded its market reach and product offerings.

    • By 2010, the company had diversified into cloud computing, becoming a leader in the industry.

    • The company emphas...

  • Answered by AI
Are these interview questions helpful?

Top trending discussions

View All
Interview Hub
1w (edited)
anshitanegi
·
ex -
Planet Spark
When HR’s Chinese English made me drop the interview!
So, I talked to the HR yesterday about the interview. I asked Please send me the location But their English… bro I was shocked! It was like talking to someone jisne english nahi kuch ar hi seekh liya ho, if the HR’s English is this I can only imagine the rest of the company I decided to drop the interview with this chinese english😶‍🌫️
FeedCard Image
Got a question about IDFC FIRST Bank?
Ask anonymously on communities.

Interview questions from similar companies

I applied via Campus Placement and was interviewed before Jan 2021. There was 1 interview round.

Interview Questionnaire 

3 Questions

  • Q1. I was asked 3 Guesstimates. They weren't that difficult. They only wanted to see the process I took to get to the answer. The answer need not be correct.
  • Q2. They asked me what I thought about team work and how every team member's contribution is needed for the success of the project.
  • Q3. I talked about my work ex in Tableau so they asked what kind of work I did there.

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare few Guesstimates before going to the interview. Also it would benefit If you can provide an experience with the analytical tools you have mentioned in the resume. It really helps.

I applied via Campus Placement and was interviewed before Aug 2020. There were 4 interview rounds.

Interview Questionnaire 

6 Questions

  • Q1. SQL JOINS
  • Q2. Python Packages
  • Ans. 

    Python packages are pre-written code libraries that can be imported and used in Python programs.

    • Packages contain modules, which contain functions and classes

    • Packages can be installed using pip or conda

    • Popular packages include NumPy, Pandas, and Matplotlib

  • Answered by AI
  • Q3. Python Projects mentioned in the resume
  • Q4. Basic HR questions
  • Q5. Puzzles
  • Q6. Basics about loans default in banking

Interview Preparation Tips

Interview preparation tips for other job seekers - Be Calm and composed and go through your resume properly.
Revise SQL, SAS, and Python if you are targeting a role in the business intelligence unit of axis bank

I applied via Company Website and was interviewed in Sep 2020. There were 3 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Basel regulatory
  • Q2. Implementation knowledge

Interview Preparation Tips

Interview preparation tips for other job seekers - We need to be throw of Basel regulations with reporting template. End to end techno functional implementation knowledge

IDFC FIRST Bank Interview FAQs

How many rounds are there in IDFC FIRST Bank Business Analyst interview?
IDFC FIRST Bank interview process usually has 3 rounds. The most common rounds in the IDFC FIRST Bank interview process are Technical, HR and Resume Shortlist.
How to prepare for IDFC FIRST Bank Business 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 IDFC FIRST Bank. The most common topics and skills that interviewers at IDFC FIRST Bank expect are Business Analysis, Information Technology, Agile, Data Analysis and Test Cases.
What are the top questions asked in IDFC FIRST Bank Business Analyst interview?

Some of the top questions asked at the IDFC FIRST Bank Business Analyst interview -

  1. What is the process that you do in agilemet...read more
  2. What is scrum and what is the proc...read more
  3. What is the agile cycle to proc...read more

Tell us how to improve this page.

Overall Interview Experience Rating

4.5/5

based on 6 interview experiences

Difficulty level

Easy 40%
Moderate 40%
Hard 20%

Duration

Less than 2 weeks 80%
2-4 weeks 20%
View more
Join IDFC FIRST Bank Guided by ethics, powered by technology and a force for social good
IDFC FIRST Bank Business Analyst Salary
based on 244 salaries
₹10.8 L/yr - ₹18.6 L/yr
40% more than the average Business Analyst Salary in India
View more details

IDFC FIRST Bank Business Analyst Reviews and Ratings

based on 25 reviews

3.6/5

Rating in categories

3.6

Skill development

3.3

Work-life balance

3.6

Salary

3.3

Job security

3.4

Company culture

3.2

Promotions

3.4

Work satisfaction

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

₹3.6 L/yr - ₹8.2 L/yr

Assistant Manager
1.6k salaries
unlock blur

₹2.9 L/yr - ₹7.1 L/yr

Manager
1.5k salaries
unlock blur

₹5.5 L/yr - ₹13 L/yr

Sales Officer
1.5k salaries
unlock blur

₹1.5 L/yr - ₹4 L/yr

Senior Manager
1.4k salaries
unlock blur

₹11.3 L/yr - ₹21 L/yr

Explore more salaries
Compare IDFC FIRST Bank with

Axis Bank

3.7
Compare

HDFC Bank

3.8
Compare

Yes Bank

3.7
Compare

AU Small Finance Bank

4.2
Compare
write
Share an Interview