Upload Button Icon Add office photos

ICICI Home Finance

Compare button icon Compare button icon Compare

Filter interviews by

ICICI Home Finance Data Analyst Interview Questions and Answers

Updated 9 Apr 2024

ICICI Home Finance Data Analyst Interview Experiences

1 interview found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 9 Apr 2024

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. SQL related PL SQL , Stored PRocedures

Interview questions from similar companies

I applied via Referral and was interviewed before Jan 2020. There were 6 interview rounds.

Interview Questionnaire 

8 Questions

  • Q1. What is amortization?
  • Ans. 

    Amortization is the process of spreading out a loan into smaller, regular payments over a period of time.

    • It is used to pay off a debt over time with regular payments

    • Each payment includes both principal and interest

    • The amount of interest decreases over time as the principal is paid off

    • Examples include mortgages, car loans, and student loans

  • Answered by AI
  • Q2. What is WASO, TSO and EPS?
  • Ans. 

    WASO is Wake After Sleep Onset, TSO is Total Sleep Time, and EPS is Earnings Per Share.

    • WASO is the amount of time spent awake after initially falling asleep.

    • TSO is the total amount of time spent sleeping, including both REM and non-REM sleep.

    • EPS is a financial metric that represents the portion of a company's profit allocated to each outstanding share of common stock.

    • WASO and TSO are commonly used in sleep studies, whi

  • Answered by AI
  • Q3. What are the elements which are present in all the financial statements like BS,IS and CF.
  • Ans. 

    The financial statements (BS, IS, CF) have common elements such as assets, liabilities, equity, revenue, expenses, and cash flows.

    • Assets: resources owned by the company

    • Liabilities: obligations owed by the company

    • Equity: residual interest in the assets of the company

    • Revenue: income generated by the company

    • Expenses: costs incurred by the company

    • Cash flows: inflows and outflows of cash

  • Answered by AI
  • Q4. What is the effect of stock split on market capitalisation of a company?
  • Ans. 

    A stock split increases the number of shares outstanding and decreases the price per share, but does not affect the market capitalisation.

    • Stock split does not affect the total value of the company

    • Market capitalisation remains the same after a stock split

    • Stock split increases the number of shares outstanding and decreases the price per share

    • For example, if a company has 1 million shares outstanding and the stock splits ...

  • Answered by AI
  • Q5. Components of Cash flow statements?
  • Ans. 

    Cash flow statements have three main components: operating activities, investing activities, and financing activities.

    • Operating activities: cash inflows and outflows from the company's core business operations.

    • Investing activities: cash inflows and outflows from buying or selling long-term assets.

    • Financing activities: cash inflows and outflows from borrowing or repaying debt, issuing or buying back stock, and paying di...

  • Answered by AI
  • Q6. How is EPS caluclated?
  • Ans. 

    EPS is calculated by dividing the company's net income by the number of outstanding shares.

    • EPS = Net Income / Outstanding Shares

    • Net Income is the company's total earnings after expenses and taxes

    • Outstanding Shares are the total number of shares issued by the company

    • EPS is an important metric for investors to evaluate a company's profitability

    • Higher EPS indicates better profitability and potential for higher dividends

  • Answered by AI
  • Q7. About your last company and role? Why you want to leave the company?
  • Q8. Abou the role,. Any info on the role that you are applying?

Interview Preparation Tips

Interview preparation tips for other job seekers - Go through the financial statements. Check all ratios with respect to statements. Be clear about the job profile. Read about the company.

Skills evaluated in this interview

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

I applied via LinkedIn and was interviewed in Aug 2023. There were 2 interview rounds.

Round 1 - Coding Test 

Simple and basic coding knowledge is enough to clear this round

Round 2 - Technical 

(2 Questions)

  • Q1. Technical questions
  • Q2. Varied based on person

Interview Preparation Tips

Topics to prepare for Mr Cooper Data Analyst interview:
  • Python
  • C++
  • Java
  • Communication Skills
Interview preparation tips for other job seekers - Coding skills are mandatory to get recruited in the company. Communication skills are must.

Interview Questionnaire 

1 Question

  • Q1. Finance questions, account concepts,ifrs
Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Apr 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Join and window functions
  • Q2. Python questions and puzzles
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

English, quant, logical reasoning

Round 2 - Technical 

(2 Questions)

  • Q1. Wacc, coc, beta
  • Q2. Coc, equity, capm

I applied via Referral and was interviewed in Jun 2021. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Financial statements , What are corporate actions, income statement

Interview Preparation Tips

Interview preparation tips for other job seekers - You need to know the accounting basics and be upto date about the market.

Data Analyst Interview Questions & Answers

Morningstar user image Prashant Chourasiya

posted on 12 Oct 2022

I applied via Naukri.com and was interviewed in Sep 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 

Equity related then aptitude and grammer

Round 3 - Technical 

(3 Questions)

  • Q1. What is promissory note?
  • Ans. 

    A promissory note is a written promise to pay a specific amount of money at a certain time.

    • It is a legal document that outlines the terms of a loan or debt.

    • It includes the amount borrowed, interest rate, repayment schedule, and consequences of default.

    • Examples include personal loans, student loans, and business loans.

    • Promissory notes can be bought and sold as a form of investment.

    • They are enforceable by law and can be

  • Answered by AI
  • Q2. What is bank reconciliation statement?
  • Ans. 

    Bank reconciliation statement is a document that compares the bank statement with the company's accounting records.

    • It helps to identify any discrepancies between the two records.

    • It includes details of deposits, withdrawals, and bank charges.

    • It ensures the accuracy of the company's financial records.

    • It is usually prepared monthly.

    • Example: If the bank statement shows a withdrawal of $100 but the company's records show a ...

  • Answered by AI
  • Q3. What do you mean by Payables turnover ratio?
  • Ans. 

    Payables turnover ratio is a financial metric that measures how quickly a company pays off its suppliers.

    • It is calculated by dividing the cost of goods sold by the average accounts payable balance.

    • A high ratio indicates that a company is paying off its suppliers quickly, while a low ratio suggests that it is taking longer to pay its bills.

    • The ratio can be used to assess a company's liquidity and its ability to manage i...

  • Answered by AI
Round 4 - Technical 

(2 Questions)

  • Q1. How do you deal with monotonous work?
  • Q2. Features of promissory note.
  • Ans. 

    A promissory note is a legal document that contains a promise to pay a specific amount of money to a person or entity.

    • It is a written promise to pay a debt

    • It includes the names of the parties involved

    • It specifies the amount of money to be paid

    • It outlines the terms of repayment, including interest rates and due dates

    • It can be secured or unsecured

    • It can be negotiable or non-negotiable

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be Prepared with financial statements.
Stay calm.
Test was easy.

Interview Questionnaire 

1 Question

  • Q1. Tell me about yourself

Interview Preparation Tips

Interview preparation tips for other job seekers - be confident and be technically sound

Interview Questionnaire 

1 Question

  • Q1. What are the financial statements? How cost sheet of bank different from cost sheet of manufacturing company? What is debt to equity ratio? What is stock option? What is Stock split? What is lease financin...
  • Ans. 

    Financial statements, cost sheet, debt to equity ratio, stock option, stock split, lease financing, profitability ratios.

    • Financial statements are reports that show the financial performance of a company.

    • Cost sheet of a bank includes interest expenses and income, while cost sheet of a manufacturing company includes direct and indirect costs.

    • Debt to equity ratio is a financial ratio that shows the proportion of debt and ...

  • Answered by AI

ICICI Home Finance Interview FAQs

How many rounds are there in ICICI Home Finance Data Analyst interview?
ICICI Home Finance interview process usually has 1 rounds. The most common rounds in the ICICI Home Finance interview process are Technical.

Tell us how to improve this page.

ICICI Home Finance Data Analyst Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more
ICICI Home Finance Data Analyst Salary
based on 4 salaries
₹4.5 L/yr - ₹5.8 L/yr
21% less than the average Data Analyst Salary in India
View more details
Sales Manager
804 salaries
unlock blur

₹2 L/yr - ₹5.2 L/yr

Territory Business Manager
218 salaries
unlock blur

₹6.5 L/yr - ₹16.5 L/yr

Territory Portfolio Manager
196 salaries
unlock blur

₹5.5 L/yr - ₹15 L/yr

Portfolio Manager
165 salaries
unlock blur

₹2.8 L/yr - ₹9 L/yr

Operations Associate
130 salaries
unlock blur

₹2.2 L/yr - ₹4.6 L/yr

Explore more salaries
Compare ICICI Home Finance with

SBI Cards & Payment Services

3.7
Compare

Axis Direct

3.8
Compare

Kotak Securities

3.6
Compare

Aadhar Housing Finance

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