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

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

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.

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 appeared for an interview in Jan 2021.

Interview Questionnaire 

3 Questions

  • Q1. Self intro
  • Q2. Experience
  • Q3. Weakness

Interview Preparation Tips

Interview preparation tips for other job seekers - Pls talk confidently
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

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

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
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Apr 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. About sed commands
  • Q2. Sql/Oracle syntax
Round 3 - One-on-one 

(3 Questions)

  • Q1. What i know about the organization BA Continuum India pvt. Ltd.
  • Ans. 

    BA Continuum India Pvt. Ltd. is a subsidiary of Bank of America that provides technology and operations services.

    • It was established in 2004 and has its headquarters in Mumbai.

    • It has over 15,000 employees and operates in multiple locations across India.

    • It provides services in areas such as finance, risk, compliance, technology, and operations.

    • It has won several awards for its innovative solutions and employee-friendly p...

  • Answered by AI
  • Q2. Why you want to join here?
  • Q3. Why you want to resign from your current organization
Round 4 - HR 

(2 Questions)

  • Q1. Discussion about my salary package
  • Q2. Negotiation for joining date

Interview Preparation Tips

Interview preparation tips for other job seekers - Which ever i shared is experience on 2015 in Recruitment drive. But in 2023, screening and recruitment has higher expectation on knowledge.

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
 • 70 Interviews
Kinara Capital Interview Questions
4.3
 • 68 Interviews
SBFC Finance Interview Questions
3.6
 • 58 Interviews
View all
IIFL Home Finance Data Analyst Salary
based on 8 salaries
₹6 L/yr - ₹8 L/yr
6% 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

Relationship Manager
87 salaries
unlock blur

₹3 L/yr - ₹5.7 L/yr

Credit Manager
86 salaries
unlock blur

₹2.6 L/yr - ₹7 L/yr

Resident Manager
82 salaries
unlock blur

₹2.4 L/yr - ₹7.2 L/yr

Sales Manager
73 salaries
unlock blur

₹2.8 L/yr - ₹10 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