Upload Button Icon Add office photos

Filter interviews by

IIFL Home Finance Data Analyst Interview Questions and Answers

Updated 17 Sep 2024

IIFL Home Finance Data Analyst Interview Experiences

1 interview found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 17 Sep 2024

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

I appeared for an interview before Sep 2023.

Round 1 - Technical 

(2 Questions)

  • Q1. Sql and advance excel
  • Q2. Vlookup, xlookup

Interview questions from similar companies

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

I applied via itvedant and was interviewed in Aug 2024. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. What are types of joins in SQL
  • Ans. 

    Types of joins in SQL include inner join, left join, right join, and full outer join.

    • Inner join: returns rows when there is a match in both tables

    • Left join: returns all rows from the left table and the matched rows from the right table

    • Right join: returns all rows from the right table and the matched rows from the left table

    • Full outer join: returns rows when there is a match in either table

  • Answered by AI

Skills evaluated in this interview

Interview experience
2
Poor
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Walk-in and was interviewed in Oct 2024. There was 1 interview round.

Round 1 - Coding Test 

SQL questions were asked

I applied via Walk-in and was interviewed before Dec 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Job role, salary, dpoc

Interview Preparation Tips

Interview preparation tips for other job seekers - Speak truth, clarity of thoughts, mindful.

I applied via Campus Placement and was interviewed in Nov 2020. There were 6 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. General knowledge questions
  • Q2. Company details
  • Q3. Who do work
  • Ans. 

    Business Analysts work with various stakeholders to analyze business processes and identify opportunities for improvement.

    • Business Analysts work with stakeholders from different departments to gather requirements and understand business needs.

    • They analyze data and conduct research to identify trends and patterns.

    • They document business processes and create models to visualize workflows.

    • They collaborate with IT teams to ...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Vijayawada
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. Tell me about yourself
  • Q2. Tell me about the projects you have worked on
Round 2 - One-on-one 

(2 Questions)

  • Q1. Tell me about yourself
  • Q2. Why do you want to join BofA?
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed in Jul 2024. There were 3 interview rounds.

Round 1 - Aptitude Test 

Logical reasoning with mathematics and interpretation

Round 2 - Coding Test 

LC easy and medium questions based on stack and dp

Round 3 - HR 

(1 Question)

  • Q1. General questions about how I work, hobbies

Analyst Interview Questions & Answers

BA Continuum user image Ashis Kumar Sahoo

posted on 23 Feb 2024

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

I appeared for an interview before Feb 2023.

Round 1 - Technical 

(3 Questions)

  • Q1. What is the sdlc process?
  • Ans. 

    SDLC stands for Software Development Life Cycle, a process used by software development teams to design, develop, and test high-quality software.

    • SDLC is a structured process that consists of several phases including planning, analysis, design, implementation, testing, and maintenance.

    • Each phase has its own set of activities and deliverables that must be completed before moving on to the next phase.

    • Examples of SDLC mode...

  • Answered by AI
  • Q2. What is agile methodologies
  • Ans. 

    Agile methodologies are a set of principles and practices that prioritize flexibility, collaboration, and iterative development in project management.

    • Focus on adaptive planning and continuous improvement

    • Emphasize collaboration between cross-functional teams

    • Prioritize delivering working software in short iterations

    • Encourage frequent feedback and adaptation to changes

    • Common frameworks include Scrum, Kanban, and Extreme P

  • Answered by AI
  • Q3. Difference between agile and waterfall
  • Ans. 

    Agile is iterative and flexible, while waterfall is sequential and rigid.

    • Agile involves continuous feedback and adaptation, while waterfall follows a linear approach.

    • Agile allows for changes throughout the project, while waterfall requires detailed planning upfront.

    • Agile promotes collaboration and communication among team members, while waterfall has distinct phases with limited interaction.

    • Agile is better suited for p...

  • Answered by AI
Round 2 - HR 

(1 Question)

  • Q1. Why you want to join our organization?

Skills evaluated in this interview

I applied via Naukri.com and was interviewed in Nov 2021. There were 5 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. Basic HR Questions
  • Q2. Advanced SQL
  • Q3. Power BI Questions, DAX

Interview Preparation Tips

Interview preparation tips for other job seekers - Had an aptitude round and then an technical interview with the manager

I applied via Naukri.com and was interviewed before Feb 2020. There were 3 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. Describe about your Change Management process. Brief me about the CAB/TAB practices as well.
  • Q2. Brief me about the Ticket Management SLAs and OLAs set. How should the metrics be measured to ensure the numbers around 100%?
  • Ans. 

    Ticket Management SLAs and OLAs should be measured using relevant metrics to ensure 100% compliance.

    • Define clear and specific SLAs and OLAs for ticket management

    • Identify relevant metrics such as response time, resolution time, etc.

    • Monitor and track the metrics regularly

    • Analyze the data to identify areas of improvement

    • Implement corrective actions to improve compliance

    • Continuously review and update the SLAs and OLAs as n

  • Answered by AI
  • Q3. Is a play book for the production support teams be enough? Do you need any other document to ensure the productivity is higher?

Interview Preparation Tips

Interview preparation tips for other job seekers - Ensure you are aware of the processes followed for a project. This is a key expectation set by the interviewers from global locations, not just within India.

IIFL Home Finance Interview FAQs

How many rounds are there in IIFL Home Finance Data Analyst interview?
IIFL Home Finance interview process usually has 1 rounds. The most common rounds in the IIFL Home Finance interview process are Technical.
What are the top questions asked in IIFL Home Finance Data Analyst interview?

Some of the top questions asked at the IIFL Home Finance Data Analyst interview -

  1. Sql and advance ex...read more
  2. Vlookup, xloo...read more

Tell us how to improve this page.

IIFL Home Finance Data Analyst Interview Process

based on 3 interviews

Interview experience

4.7
  
Excellent
View more

Interview Questions from Similar Companies

BA Continuum Interview Questions
4.1
 • 100 Interviews
Hero FinCorp Interview Questions
4.0
 • 90 Interviews
mPokket Interview Questions
3.8
 • 71 Interviews
Kinara Capital Interview Questions
4.3
 • 68 Interviews
SBFC Finance Interview Questions
3.6
 • 61 Interviews
View all
IIFL Home Finance Data Analyst Salary
based on 8 salaries
₹6 L/yr - ₹8 L/yr
7% more than the average Data Analyst Salary in India
View more details

IIFL Home Finance Data Analyst Reviews and Ratings

based on 2 reviews

1.5/5

Rating in categories

2.5

Skill development

1.5

Work-life balance

1.0

Salary

2.0

Job security

1.0

Company culture

1.5

Promotions

1.0

Work satisfaction

Explore 2 Reviews and Ratings
Senior Sales Officer
194 salaries
unlock blur

₹2.2 L/yr - ₹4 L/yr

Credit Manager
88 salaries
unlock blur

₹2.6 L/yr - ₹7 L/yr

Relationship Manager
87 salaries
unlock blur

₹3 L/yr - ₹5.7 L/yr

Resident Manager
85 salaries
unlock blur

₹3.3 L/yr - ₹7.2 L/yr

Location Head
73 salaries
unlock blur

₹6.6 L/yr - ₹18 L/yr

Explore more salaries
Compare IIFL Home Finance with

Home Credit Finance

4.1
Compare

Kogta Financial India Limited

4.7
Compare

Sammaan Capital Limited

3.7
Compare

Hero FinCorp

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