Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by L&T Finance Team. If you also belong to the team, you can get access from here

L&T Finance Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

L&T Finance MIS Executive Interview Questions and Answers

Updated 25 Jun 2024

L&T Finance MIS Executive Interview Experiences

1 interview found

MIS Executive Interview Questions & Answers

user image Saquib Jawed

posted on 25 Jun 2024

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 questions from similar companies

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referal and was interviewed before Dec 2021. There were 2 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 - One-on-one 

(5 Questions)

  • Q1. It was about customer service and need to know multilingual languages was asked about to speak about my family in Hindi and talk on the recent movie I watched .. it was cool and easy
  • Q2. Why would you like to join the company
  • Ans. 

    I would like to join the company because of its strong reputation, opportunities for growth, and alignment with my career goals.

    • The company has a strong reputation in the industry, which is appealing to me as it indicates stability and success.

    • I believe that the company offers great opportunities for growth and development, which is important to me as I am looking to advance my career.

    • The company's values and mission a...

  • Answered by AI
  • Q3. How come you knew abt the openings
  • Ans. 

    I regularly keep myself updated about job openings through various sources.

    • I actively search for job openings on job portals and company websites.

    • I network with professionals in my field who may inform me about job opportunities.

    • I subscribe to email alerts and newsletters from job search platforms.

    • I follow social media pages and groups related to job postings.

    • I attend career fairs and industry events where companies of

  • Answered by AI
  • Q4. How can you deal with a frustrated client
  • Ans. 

    To deal with a frustrated client, it is important to remain calm, empathize with their concerns, actively listen, offer solutions, and follow up to ensure satisfaction.

    • Stay calm and composed

    • Empathize with the client's frustrations

    • Listen actively and attentively to their concerns

    • Offer solutions or alternatives to address their issues

    • Follow up to ensure their satisfaction

    • Maintain a professional and positive attitude thro

  • Answered by AI
  • Q5. No questions asked further winded

Interview Preparation Tips

Interview preparation tips for other job seekers - It’s a good company if you want to make money and keep personal life aside coz this company produces money making machines
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. Reportings applicable to function
  • Ans. 

    Reportings are essential for any function to track progress and identify areas of improvement.

    • Regular reports should be generated to track progress and identify areas of improvement.

    • Reports should be customized to the specific function and its goals.

    • Reports should be easily understandable and actionable.

    • Examples of reportings applicable to functions include sales reports, performance reports, and budget reports.

  • Answered by AI
  • Q2. Regulatory updates going on business environment
  • Ans. 

    Regulatory updates are constantly shaping the business environment, impacting industries and companies in various ways.

    • Regulations can affect everything from product development to marketing and sales strategies

    • Changes in regulations can create new opportunities or pose challenges for businesses

    • Industries such as healthcare, finance, and technology are particularly affected by regulatory updates

    • Examples of recent regul...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - be calm and confident and answer to the point.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
No response

I applied via Company Website and was interviewed in Feb 2024. There were 2 interview rounds.

Round 1 - Aptitude Test 

Reasoning , SQL and probability

Round 2 - Technical 

(2 Questions)

  • Q1. SQL queries and python
  • Q2. Reasoning and guesstimate

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
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 Naukri.com and was interviewed in Jun 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Techical skill

Interview Preparation Tips

Interview preparation tips for other job seekers - Nice
Interview experience
3
Average
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

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

Round 1 - HR 

(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

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

I applied via Company Website and was interviewed in Jun 2022. There were 2 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 - One-on-one 

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

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

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

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - It is easy to crack not too hard. Backend work is easy to crack.

L&T Finance Interview FAQs

How many rounds are there in L&T Finance MIS Executive interview?
L&T Finance interview process usually has 1 rounds. The most common rounds in the L&T Finance interview process are Technical.
How to prepare for L&T Finance MIS Executive interview?
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 L&T Finance. The most common topics and skills that interviewers at L&T Finance expect are MIS Reporting, MIS, Advanced Excel, Cash Flow Management and Data Analysis.
What are the top questions asked in L&T Finance MIS Executive interview?

Some of the top questions asked at the L&T Finance MIS Executive interview -

  1. Communication is not important you attitude is mat...read more
  2. About Excel like VLOOKUP index match pivot ta...read more

Tell us how to improve this page.

L&T Finance MIS Executive Interview Process

based on 1 interview

Interview experience

4
  
Good
View more
L&T Finance MIS Executive Salary
based on 10 salaries
₹1.8 L/yr - ₹4 L/yr
8% less than the average MIS Executive Salary in India
View more details

L&T Finance MIS Executive Reviews and Ratings

based on 1 review

1.0/5

Rating in categories

1.0

Skill development

1.0

Work-life balance

1.0

Salary

4.0

Job security

1.0

Company culture

1.0

Promotions

1.0

Work satisfaction

Explore 1 Review and Rating
Senior Manager
386 salaries
unlock blur

₹8.1 L/yr - ₹26 L/yr

Area Sales Manager
361 salaries
unlock blur

₹4 L/yr - ₹15 L/yr

Manager
358 salaries
unlock blur

₹4.4 L/yr - ₹16.1 L/yr

Assistant Manager
306 salaries
unlock blur

₹2 L/yr - ₹10 L/yr

Collection Officer
292 salaries
unlock blur

₹1.2 L/yr - ₹3.8 L/yr

Explore more salaries
Compare L&T Finance with

Muthoot Fincorp

4.5
Compare

IIFL Finance

4.0
Compare

Muthoot Finance

3.6
Compare

Mahindra Finance

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