Home Credit Finance MIS Executive Interview Questions and Answers

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

Q1. What are your reasons for wanting to switch jobs?
Add your answer

Q1. Self introduction and work experience
Add your answer

Q1. Data analysis , v lookup, H look up
Add your answer

Q1. Profile related details
Add your answer

Q1. Excel formulas and dashboards
Add your answer

Q1. Tell me something about yourself
Ans. 
I am an experienced MIS Executive with a strong background in managing information systems and data analysis.
• I have a Bachelor's degree in Management Information Systems.

• I have worked for 5 years in a multinational company as an MIS Executive.

• I am proficient in using various data analysis tools such as Excel, SQL, and Tableau.

• I have successfully implemented automated reporting systems that improved efficiency and accur...read more
Answered by AI
Add your answer
Q2. Qualifications,Experience, salary Expectations,last salary
Add your answer

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...read more
Answered by AI
Add your answer
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...read more
Answered by AI
Add your answer
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 ...read more
Answered by AI
Add your answer

Q1. What about you?
Add your answer
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
Answered by AI
Add your answer

Excel formulas and practical this formulas