AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Home Credit Finance
Compare
Filter interviews by
Home Credit Finance MIS Executive Interview Questions and Answers
Home Credit Finance MIS Executive Interview Experiences
2 interviews found
Anonymous
Selected
I applied via WorkIndia and was interviewed in Oct 2023. There was 1 interview round.
Present Working & Personal Information
Selected
I applied via Referral and was interviewed before Oct 2022. There were 3 interview rounds.
How to collect money from Debt customer
(1 Question)
- Q1. Why we should hire you
Interview Preparation Tips
Interview questions from similar companies
I applied via Naukri.com and was interviewed in Jun 2021. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. Techical skill
Interview Preparation Tips
I applied via Walk-in and was interviewed in Apr 2024. There was 1 interview round.
An Excel file was given which had 2 sheets, sheet1 with raw data and sheet2 with task. There were 5-6 questions in Task. This tasks can be done by formulas such as CONCAT, Textjoin, Age calculation using Datedif, Vlookup, age band creation eg: 10-30,30-40 based on age I used nested IF, PIVOT Table
Interview Preparation Tips
- Advanced Excel
Saquib Jawed
(2 Questions)
- Q1. About Excel like VLOOKUP index match pivot table
- Q2. Communication is not important you attitude is matter
I applied via Naukri.com and was interviewed in Jul 2021. There were 3 interview rounds.
Interview Questionnaire
4 Questions
- Q1. What is the V-lookup formula?
- Ans.
VLOOKUP is a function in Excel that allows you to search for a value in a column and return a corresponding value from another column.
VLOOKUP stands for vertical lookup.
It is commonly used to find specific data in large datasets.
The formula takes four arguments: lookup value, table array, column index number, and range lookup.
Example: =VLOOKUP(A2, B2:D10, 3, FALSE) will search for the value in cell A2 in the range B2:D...
- Q2. What is the use of pivot table?
- Ans.
A pivot table is a data summarization tool used in spreadsheet programs to organize and analyze large amounts of data.
Pivot tables allow users to quickly summarize and analyze data from different perspectives.
They can be used to group and aggregate data based on different criteria.
Pivot tables provide flexibility in rearranging and reorganizing data to gain insights.
They help in identifying patterns, trends, and outlie...
- Q3. How to remove duplicate value?
- Ans.
Duplicate values can be removed using various methods.
Use a hashset to store unique values and remove duplicates
Sort the array and remove adjacent duplicates
Use a loop to compare each element with all other elements and remove duplicates
Use the distinct() method in LINQ for C#
Use the set() method in Python
- Q4. How to use if formula?
- Ans.
IF formula is used to test a condition and return a value based on the result.
Syntax: =IF(condition, value_if_true, value_if_false)
Example: =IF(A1>10, "Yes", "No")
Nested IF statements can be used for multiple conditions.
Skills evaluated in this interview
I applied via Walk-in and was interviewed in May 2022. There were 2 interview rounds.
(1 Question)
- Q1. Profile related details
(1 Question)
- Q1. Excel formulas and dashboards
Interview Preparation Tips
Selected
I applied via Referral and was interviewed in Jun 2024. There was 1 interview round.
(1 Question)
- Q1. What are your reasons for wanting to switch jobs?
- Ans.
I am seeking new challenges and opportunities for growth in my career.
Looking for a more challenging role to further develop my skills
Seeking opportunities for career advancement
Interested in working in a different industry to broaden my experience
(2 Questions)
- Q1. What about you?
- Q2. What's experiance do you have?
- Ans.
I have 5 years of experience in managing and analyzing data for various projects.
Managed databases and data systems for efficient data retrieval and analysis
Developed reports and dashboards to track key performance indicators
Implemented data quality processes to ensure accuracy and consistency
Collaborated with cross-functional teams to identify and address data-related issues
Excel formulas and practical this formulas
Interview Preparation Tips
Selected
I applied via Company Website and was interviewed in Jun 2022. There were 2 interview rounds.
(3 Questions)
- Q1. What is Kyc & how it's work?
- Ans.
KYC stands for Know Your Customer. It is a process of verifying the identity of customers to prevent fraud and money laundering.
KYC is a mandatory process for banks, financial institutions, and other regulated entities.
It involves collecting personal information and documents from customers to verify their identity.
The collected information is then verified against government-issued identity documents like Aadhaar, PAN...
- Q2. What is bank and how it earn money?
- Ans.
A bank is a financial institution that accepts deposits from customers and uses those funds to make loans and investments.
Banks earn money through interest charged on loans and credit cards
They also earn money through fees for services such as ATM withdrawals and overdraft protection
Banks may invest in stocks, bonds, and other financial instruments to earn additional income
Some banks also offer investment services to c...
- Q3. Prepare your introduction?
- Ans.
Experienced MIS Executive with strong analytical skills and expertise in managing data and information systems.
Over 5 years of experience in MIS management and data analysis
Proficient in using various MIS tools and software
Expertise in generating reports, analyzing data, and providing insights for decision-making
Strong problem-solving and communication skills
Managed and optimized data systems to improve efficiency and ...
Interview Preparation Tips
Home Credit Finance Interview FAQs
Tell us how to improve this page.
Home Credit Finance Interviews By Designations
- Home Credit Finance Sales Associate Interview Questions
- Home Credit Finance Collections Executive Interview Questions
- Home Credit Finance Sales Trainer Interview Questions
- Home Credit Finance Junior Operator Interview Questions
- Home Credit Finance Senior Sales Associate Interview Questions
- Home Credit Finance Senior Analyst Interview Questions
- Home Credit Finance Sales Officer Interview Questions
- Home Credit Finance Senior Executive Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior MIS Executive Interview Questions
- MIS Executive and Analyst Interview Questions
- MIS Executive and Coordinator Interview Questions
- Executive Interview Questions
- Sales Executive Interview Questions
- Senior Executive Interview Questions
- Accounts and MIS Executive Interview Questions
- MIS and Back Office Executive Interview Questions
- Show more
Home Credit Finance MIS Executive Interview Process
based on 2 interviews
Interview experience
MIS Executive Interview Questions from Similar Companies
Home Credit Finance MIS Executive Reviews and Ratings
based on 5 reviews
Rating in categories
|
Sales Executive
389
salaries
|  ₹1 L/yr - ₹4.2 L/yr |
|
District Sales Manager
309
salaries
| ₹1.2 L/yr - ₹5 L/yr |
|
Operator
269
salaries
| ₹1.1 L/yr - ₹3.6 L/yr |
|
Assistant Manager
267
salaries
| ₹4.5 L/yr - ₹16 L/yr |
|
Collections Executive
267
salaries
| ₹1.1 L/yr - ₹4.5 L/yr |
HDB Financial Services
Shriram Finance
Muthoot Fincorp
Bajaj Finance
- Home >
- Interviews >
- Home Credit Finance Interview Questions >
- Home Credit Finance MIS Executive Interview Questions
