Upload Button Icon Add office photos

Kotak Mahindra Bank

Compare button icon Compare button icon Compare

Filter interviews by

Kotak Mahindra Bank MIS Executive Interview Questions and Answers

Updated 26 Jul 2024

Kotak Mahindra Bank MIS Executive Interview Experiences

1 interview found

MIS Executive Interview Questions & Answers

user image Shabani Mistry

posted on 26 Jul 2024

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

(2 Questions)

  • Q1. Do you know vlookup?
  • Ans. 

    Yes, vlookup is a function in Excel used to search for a value in a table and return a corresponding value.

    • Vlookup stands for 'vertical lookup'

    • It is commonly used in Excel to search for a value in the leftmost column of a table and return a value in the same row from a specified column

    • Syntax: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

    • Example: =VLOOKUP(A2, B2:D10, 3, FALSE) - searches for the val...

  • Answered by AI
  • Q2. Do you know pivot table
  • Ans. 

    Yes, pivot tables are used in Excel to summarize and analyze data.

    • Pivot tables are used to summarize large amounts of data in Excel.

    • They allow users to reorganize and summarize selected columns and rows of data.

    • Users can easily create different views of the data by dragging and dropping fields.

    • Pivot tables can also perform calculations and display results in a clear and organized manner.

    • For example, you can use a pivot...

  • Answered by AI

Interview questions from similar companies

I applied via Recruitment Consultant and was interviewed in Dec 2019. There was 1 interview round.

Interview Questionnaire 

7 Questions

  • Q1. Tell me about your self in description?
  • Ans. 

    Experienced manager with a proven track record in leading teams and achieving results.

    • 10+ years of management experience

    • Strong leadership and communication skills

    • Proven ability to motivate and inspire teams

    • Track record of achieving targets and driving growth

    • Experience in strategic planning and decision-making

    • Ability to adapt to changing environments and handle challenges

    • Excellent problem-solving and decision-making ski...

  • Answered by AI
  • Q2. Tell me article 3,17,28 in UCP 600?
  • Ans. 

    Article 3, 17, 28 in UCP 600

    • Article 3: Examines documents for compliance with terms of credit

    • Article 17: Bank is not liable for consequences of delay or error in transmission

    • Article 28: Discrepancies in documents must be notified within 5 banking days

  • Answered by AI
  • Q3. What is FDI ,procedure how to settle the fund & why FDI need to report to RBI?
  • Ans. 

    FDI stands for Foreign Direct Investment. It is the process of investing in a foreign country and establishing business operations there.

    • FDI refers to the investment made by a company or individual from one country into another country.

    • The procedure to settle the fund involves various steps such as obtaining necessary approvals, opening a bank account, and complying with regulatory requirements.

    • For example, if a compan...

  • Answered by AI
  • Q4. What is EDPMS & IDPMS ?
  • Ans. 

    EDPMS & IDPMS are software systems used in Indian government for monitoring and evaluation of development projects.

    • EDPMS stands for Electronic Development Project Monitoring System

    • IDPMS stands for Integrated Development Project Monitoring System

    • Both systems are used by Indian government for monitoring and evaluation of development projects

    • EDPMS is used for monitoring centrally sponsored schemes while IDPMS is used for

  • Answered by AI
  • Q5. What is BG ,tell me section 28,& countineous clause ?
  • Ans. 

    The question is related to legal terms and refers to BG, Section 28, and continuous clause.

    • BG stands for 'Bonded Guarantee' which is a type of financial guarantee provided by a bank or insurance company to a contractor.

    • Section 28 refers to a specific section in the Indian Contract Act, 1872 which deals with the rights and obligations of parties in a contract.

    • Continuous clause is a legal provision that allows a contract...

  • Answered by AI
  • Q6. When we called overdue bill of entry & caution listed shipping bill?
  • Ans. 

    Overdue bill of entry & caution listed shipping bill are called when...

    • Overdue bill of entry is called when the importer fails to submit the bill of entry within the prescribed time limit.

    • Caution listed shipping bill is called when the importer fails to pay the customs duty within the prescribed time limit.

    • Both are called to remind the importer to complete the necessary formalities to clear the goods from customs.

    • Failu...

  • Answered by AI
  • Q7. What is GR waiver
  • Ans. 

    GR waiver is a document that allows a company to import goods without paying customs duty.

    • GR stands for 'Goods Received'

    • Waiver is granted by the Reserve Bank of India

    • It is applicable for goods imported for display or use in trade fairs, exhibitions, etc.

    • It is also applicable for goods imported for repair or replacement under warranty

    • GR waiver is not applicable for goods imported for sale or for personal use

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Try to answer in full confidence & attempt only those answers that you have idea about ,don't try to make them fool.

I applied via Recruitment Consultant and was interviewed in Nov 2019. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Na

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident and stay focused, everything will be good

I applied via Company Website and was interviewed in Feb 2021. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Regarding your previous job nothing else

Interview Preparation Tips

Interview preparation tips for other job seekers - Know about job role also ask to hr which role provide by them

I applied via Approached by Company and was interviewed before Jul 2020. There were 2 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. What do you know about operations
  • Ans. 

    Operations refer to the processes and activities involved in running a business or organization.

    • Operations include production, logistics, supply chain management, and customer service.

    • Efficient operations can lead to cost savings, increased productivity, and improved customer satisfaction.

    • Examples of operational strategies include lean manufacturing, Six Sigma, and total quality management.

    • Operations can be measured an...

  • Answered by AI
  • Q2. Tell us about customer service
  • Ans. 

    Customer service is the provision of assistance and support to customers before, during, and after a purchase.

    • Customer service involves listening to and addressing customer concerns and needs

    • It includes providing accurate and timely information about products or services

    • It also involves resolving customer complaints and issues in a timely and satisfactory manner

    • Examples of good customer service include personalized att...

  • Answered by AI
  • Q3. WHY YOU WANT THIS ROLE

Interview Preparation Tips

Interview preparation tips for other job seekers - Great place to work but scope of salary increment is less growth wise not that good

I applied via Referral and was interviewed in Apr 2021. There were 4 interview rounds.

Interview Preparation Tips

Interview preparation tips for other job seekers - Most of questions asked to me were related to my last work experience.

I applied via Referral and was interviewed in Jun 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. About previous organisation and Job role related qus

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident and positive

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

Interview Questionnaire 

1 Question

  • Q1. Educational background , work experinces and job role in detail ,family background and salary discussion

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident and dont hesitate to share ur views and experiences

I applied via Company Website and was interviewed before Jul 2020. There were 3 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. What Do yo mean by Banking
  • Ans. 

    Banking refers to the business of accepting deposits and lending money.

    • Banking involves financial institutions that accept deposits from customers and use those funds to make loans to other customers.

    • Banks also offer a range of other financial services, such as credit cards, investment products, and insurance.

    • Banking is regulated by government agencies to ensure the safety and soundness of the financial system.

    • Examples...

  • Answered by AI
  • Q2. Banking is a Process of Accepting deposits and lending it to the public in form of loans.

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview was at moderate level.Normal Questions were asked

Interview Questionnaire 

1 Question

  • Q1. Trade and non trade guidelines

Interview Preparation Tips

Interview preparation tips for other job seekers - Be well prepared on technical ground, keep your tone positive and enthusiastic

Kotak Mahindra Bank Interview FAQs

How many rounds are there in Kotak Mahindra Bank MIS Executive interview?
Kotak Mahindra Bank interview process usually has 1 rounds. The most common rounds in the Kotak Mahindra Bank interview process are Technical.
How to prepare for Kotak Mahindra Bank 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 Kotak Mahindra Bank. The most common topics and skills that interviewers at Kotak Mahindra Bank expect are Excel, MIS Reporting, MIS, Pivot Table and VLOOKUP.

Tell us how to improve this page.

Kotak Mahindra Bank MIS Executive Interview Process

based on 2 interviews

Interview experience

5
  
Excellent
View more
Kotak Mahindra Bank MIS Executive Salary
based on 190 salaries
₹1.5 L/yr - ₹4 L/yr
11% less than the average MIS Executive Salary in India
View more details

Kotak Mahindra Bank MIS Executive Reviews and Ratings

based on 28 reviews

4.1/5

Rating in categories

4.3

Skill development

4.0

Work-life balance

3.5

Salary

3.9

Job security

4.2

Company culture

3.3

Promotions

3.8

Work satisfaction

Explore 28 Reviews and Ratings
Assistant Manager
12.6k salaries
unlock blur

₹1.2 L/yr - ₹5 L/yr

Deputy Manager
11.3k salaries
unlock blur

₹1.6 L/yr - ₹8.5 L/yr

Manager
5.4k salaries
unlock blur

₹4 L/yr - ₹12 L/yr

Senior Manager
3.5k salaries
unlock blur

₹6.5 L/yr - ₹19 L/yr

Relationship Manager
2.3k salaries
unlock blur

₹1.5 L/yr - ₹10 L/yr

Explore more salaries
Compare Kotak Mahindra Bank with

ICICI Bank

4.0
Compare

HDFC Bank

3.9
Compare

Axis Bank

3.8
Compare

IndusInd Bank

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