Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Muthoot Microfin Team. If you also belong to the team, you can get access from here

Muthoot Microfin Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Muthoot Microfin MIS Executive Interview Questions and Answers for Experienced

Updated 15 Jun 2024

Muthoot Microfin MIS Executive Interview Experiences for Experienced

1 interview found

MIS Executive Interview Questions & Answers

user image NASRIN K.K

posted on 15 Jun 2024

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Dec 2023. There were 2 interview rounds.

Round 1 - HR 

(1 Question)

  • Q1. Self introduction and work experience
Round 2 - Technical 

(1 Question)

  • Q1. Data analysis , v lookup, H look up

Interview questions from similar companies

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

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

Round 1 - Assignment 

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

Topics to prepare for Mahindra Finance MIS Executive interview:
  • Advanced Excel
Interview preparation tips for other job seekers - Normal about yourself, salary expectation there budget is around 3 lacs as per my assumption. mon to fri day shifts and need to extend the shift as well.

I applied via Walk-in and was interviewed in May 2022. There were 2 interview rounds.

Round 1 - HR 

(1 Question)

  • Q1. Profile related details
Round 2 - Technical 

(1 Question)

  • Q1. Excel formulas and dashboards

Interview Preparation Tips

Interview preparation tips for other job seekers - Good platform to work and they expected who the person works lyk smart and clean
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

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

Round 1 - Aptitude Test 

Apptitude test conducted where there are 60 question in 60 min

Round 2 - Aptitude Test 

Python, Verbal , Apptitude

Round 3 - Group Discussion 

Last one is interview round

Interview Preparation Tips

Interview preparation tips for other job seekers - Just clear your basics
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Data frame making in python
  • Ans. 

    Data frame making in Python involves creating a structured table-like data structure using the pandas library.

    • Use the pandas library to create a data frame

    • Data frames are 2-dimensional labeled data structures with columns of potentially different types

    • Data frames can be created from dictionaries, lists, numpy arrays, or other data frames

    • Example: df = pd.DataFrame({'A': [1, 2, 3], 'B': ['a', 'b', 'c']})

  • Answered by AI
  • Q2. Random forest basic questions

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Naaaghuuiii hgdtyhb uii7yfghh uyddbkiydd
  • Q2. NAahjuutyijhg guihhftu dfyikhh fujgx
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. About Excel like VLOOKUP index match pivot table
  • Q2. Communication is not important you attitude is matter
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed before Nov 2023. There were 2 interview rounds.

Round 1 - Aptitude Test 

Multiple Choice Questions

Round 2 - HR 

(1 Question)

  • Q1. Why do you want to join us

Interview Preparation Tips

Interview preparation tips for other job seekers - Very good company

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

  • Answered by AI
  • 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...

  • Answered by AI
  • 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

  • Answered by AI
  • 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.

  • Answered by AI

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
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 - HR 

(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

  • Answered by AI
Round 3 - Assignment 

Excel formulas and practical this formulas

Interview Preparation Tips

Interview preparation tips for other job seekers - Going to fearless attend and confidential discuss than do not over things

Muthoot Microfin Interview FAQs

How many rounds are there in Muthoot Microfin MIS Executive interview for experienced candidates?
Muthoot Microfin interview process for experienced candidates usually has 2 rounds. The most common rounds in the Muthoot Microfin interview process for experienced candidates are Technical and HR.
How to prepare for Muthoot Microfin MIS Executive interview for experienced candidates?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Muthoot Microfin. The most common topics and skills that interviewers at Muthoot Microfin expect are Advanced Excel, Back Office, Back Office Operations, Backend Operations and MIS Reporting.

Tell us how to improve this page.

Muthoot Microfin MIS Executive Interview Process for Experienced

based on 1 interview

Interview experience

5
  
Excellent
View more

Muthoot Microfin MIS Executive Reviews and Ratings

based on 1 review

5.0/5

Rating in categories

4.0

Skill development

3.0

Work-life balance

4.0

Salary

3.0

Job security

4.0

Company culture

4.0

Promotions

4.0

Work satisfaction

Explore 1 Review and Rating
Relationship Officer
242 salaries
unlock blur

₹1.5 L/yr - ₹3.5 L/yr

Branch Credit Manager
164 salaries
unlock blur

₹1.8 L/yr - ₹3.5 L/yr

Internal Auditor
109 salaries
unlock blur

₹1.8 L/yr - ₹3.8 L/yr

Branch Manager
104 salaries
unlock blur

₹2 L/yr - ₹4.5 L/yr

Assistant Manager
67 salaries
unlock blur

₹1.9 L/yr - ₹5.5 L/yr

Explore more salaries
Compare Muthoot Microfin with

HDB Financial Services

3.9
Compare

Shriram Finance

4.1
Compare

Muthoot Fincorp

4.5
Compare

Bajaj Finance

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