Premium Employer

i

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

HCLTech Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

HCLTech MIS Executive Interview Questions, Process, and Tips

Updated 3 Oct 2024

Top HCLTech MIS Executive Interview Questions and Answers

HCLTech MIS Executive Interview Experiences

2 interviews found

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. Salary expectation
  • Q2. Prev ofz experience
  • Ans. 

    I have 3 years of experience as a MIS Executive in a multinational company.

    • Managed databases to ensure accurate and timely reporting

    • Developed automated reports using Excel and SQL

    • Collaborated with cross-functional teams to analyze data and improve processes

  • Answered by AI

MIS Executive Interview Questions & Answers

user image Anonymous

posted on 29 Jun 2020

I applied via Recruitment Consultant and was interviewed in May 2020. There were 3 interview rounds.

Interview Questionnaire 

5 Questions

  • Q1. How to create reports by pivot table?
  • Ans. 

    Pivot tables are used to create reports by summarizing and analyzing data.

    • Select the data range that you want to analyze

    • Go to the 'Insert' tab and click on 'PivotTable'

    • Choose the location where you want to place the pivot table

    • Drag and drop the fields you want to analyze into the 'Rows' and 'Columns' areas

    • Add any additional fields to the 'Values' area to calculate summaries

    • Customize the pivot table by applying filters,...

  • Answered by AI
  • Q2. What is the advantages of Data validation and why we use it?
  • Ans. 

    Data validation ensures accuracy and completeness of data. It helps in preventing errors and improving data quality.

    • Data validation ensures that the data entered is accurate and complete.

    • It helps in preventing errors and improving data quality.

    • It ensures that the data is consistent and conforms to predefined standards.

    • It helps in identifying and correcting errors before they cause problems.

    • Examples of data validation i...

  • Answered by AI
  • Q3. How advance filter works?
  • Ans. 

    Advance filter is a feature that allows users to apply complex criteria to filter data in a more precise way.

    • Advance filter allows users to filter data based on multiple criteria.

    • It provides options to filter data using logical operators such as AND, OR, and NOT.

    • Users can filter data based on specific values, text, dates, or even formulas.

    • Advance filter can be used in various applications like spreadsheets, databases, ...

  • Answered by AI
  • Q4. Some Formulas like Vlookup Index Match and others
  • Q5. Conditional Formatting

Interview Preparation Tips

Interview preparation tips for other job seekers - MIS profile is based on reporting profile job in this profile you do data analysis and create reports based on management requirements. Every company have their own requirements so for best candidate for this profile you must have good knowledge of Excel and you must have some skill of data analysis. So keep work hard and learn many things of Excel as much you can and do hard work untill you get a offer letter in your hand
...

MIS Executive Interview Questions Asked at Other Companies

Q1. HOW TO CREATING PIVOT TABLE IN EXCEL. HOW MANY PIVOT TABLES YOU W ... read more
Q2. Excel function explain Pivot table. Vlookup.hole look-up.xlook-up ... read more
asked in HCLTech
Q3. What is the advantages of Data validation and why we use it?
Q4. WHAT YOU KNOW ABOUT ADVANCED EXCEL .AND EXPLAIN ABOUT THE CONDITI ... read more
Q5. Which formula do you know in excel Get this value usinhlg vlookup ... read more

Interview questions from similar companies

I applied via Naukri.com and was interviewed before Apr 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 Resume tips
Round 2 - Aptitude Test 

Interview Preparation Tips

Interview preparation tips for other job seekers - Nothing as such. Overall experience was good

I applied via Company Website and was interviewed before Apr 2021. There were 3 interview rounds.

Round 1 - Aptitude Test 
Round 2 - Group Discussion 
Pro Tip by AmbitionBox:
Don’t treat group discussions as an argument. Group discussion is about reaching a meaningful conclusion.
View all GD tips
Round 3 - Technical 

(1 Question)

  • Q1. Oops About c++ Dbms Data structures

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident during interviews

Analyst Interview Questions & Answers

TCS user image Anonymous

posted on 9 May 2022

I applied via Walk-in and was interviewed before May 2021. There were 3 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 Resume tips
Round 2 - Technical 

(1 Question)

  • Q1. Basic tech questions to medium hard
Round 3 - HR 

(1 Question)

  • Q1. Negotiation is the main part of you have a offer it's better

Interview Preparation Tips

Interview preparation tips for other job seekers - Questions from resume and walk-ins have more chance

I was interviewed in May 2017.

Interview Preparation Tips

Round: Test
Experience: Selected for round 2

Round: Group Discussion
Experience: Selected for round 2
Duration: 15 minutes

Skills: Communication
College Name: SJRCW

Interview Preparation Tips

Round: Test
Experience: Each section consisted of 15 questions.If you have a thorough practise on aptitude,the LR and the basic apti part would be not of much problem.The coding part mainly consisted of data structure basic.
Tips: The only tip which can be given is a thorough practise for all the sessions.The practise should be done taking the time into account.
Duration: 1 hour
Total Questions: 60

Round: Technical Interview
Experience: Fortunately for me,they asked me my AIEEE and IITJEE scores rather than only concentrating on my CGPA which was an advantage for me.Training related questions,questions on basic science(fission,fusion etc) were asked.Also my coding knowledge was being tested by asking basic data structure questions.
Tips: Always carry a smile whether its going wrong or right.Be apologetic on your mistakes and tell them you can improve yourself.The confidence you carry is the thing they are searching for in any interview.

College Name: NIT Durgapur

Interview Preparation Tips

Round: Test
Experience: English skill based test, it was more like a basic clearance test. There were two different rounds one of them was to listen/read and then fill up questions (approx. 45min) other one was the Telephonic test (computer generated test, approx. 15min).
Tips: Aptitude is a must, so practise
Duration: 60 minutes

Round: Group Discussion
Experience: Here the way you interact in a group and essence of your points. Personally I felt that they didn’t concentrate much on speaking skills as such.
Tips: Practise to talk in groups, current affairs  and even random topics
Duration: 15 minutes

Round: HR Interview
Experience: I was tested on basic understanding of Big Data and tested on enthusiasm
Tips: Puzzles (for most startups) and HR & resume based for others mostly.prepare things very much related to the company.

Skill Tips: Starting earlier helps . Aptitude requires some time and it is better to start atleast during summer vacation. Last two months before placements can be spent for other preparations.
College Name: IIT MADRAS

Interview Preparation Tips

Round: Test
Experience: I performed well in the written test, and there was a speaking and listening test too.  I felt quant was most important for the tests, fast mathematics, then technical questions. Technical questions generally asked by core companies. Some programming based companies also ask such technical questions.



Puzzles can help you in answering quant questions also. The tests were mostly MCQ. Some tests were there which had subjective question papers. None of the core companies had subjective type, but coding companies had such questions. 





They were write a program to do *task* type questions. The programming language to write the code in, was our choice. The language options were C, C++, Python, Java. Python was rarely asked, though.
Duration: 3 hours minutes

Round: Group Discussion
Experience: Don't quite actually remember those topics. But, skills they wanted to test was to see how well they were able to express their ideas, but without outwardly disrupting others while talking.

Round: HR Interview
Experience: The interview was at least 40 minutes, with 5 minutes of HR interview for my current work profile. 

The HR usually starts with “Tell me about yourself”. Then they go through the resume, and ask about the project (DDP, in my case) and internship. This was done by the HR team, just to see how the candidate is putting forth his ideas and contributions clearly.
Tips: Since I cleared the tests, I was allowed to appear for the interviews, but after that, the CGPA played a major role in the final selection. Hence people with low CGPA had to perform exceptionally well to compensate for the low CGPA. However, I don’t know of the internal mechanism of shortlisting, so I was of the opinion that CGPA did not result in elimination of candidates, (except for the candidates who were eliminated due to the cutoff CGPA). But it played a role in the final selection.

For managerial positions, PoRs like coordships, coreships etc can be used to pitch your leadership qualities. They can start a chain of conversation that involves the work you did, on how you managed to execute the task efficiently, which ends up working in your favour.

Round: Puzzle Interview
Experience: Two puzzles were given in the interview. I did well in both, hence got selected. Another puzzle was to measure 45 minutes of time elapsed by using two candles, both of which take 1 hour to burn out completely.

General Tips: I was weak in thermodynamics, so he covered that course revision, for core placements. I prepared from the material sent by Shruti. That was all I prepared. The Coursera for R language was not that useful for me as I was looking for a managerial position.In case of resume shortlists, students who had done management, operations research or economics courses were preferred.
Otherwise, one has to justify your selection through good pitching. Finance companies are sort of open minded; they are looking for people who would do the job. Anyways, they will be providing training, so the knowledge in finance gained through independent means is not quite significant. It will, however, give an edge in the tests, as finance and quant based questions will be asked. They won’t go deep info finance.
I also suggest to freshies and second years to complete the core credited intern in the second year itself so that they can take up an intern of their choice, be it either research intern or core intern in their 3rd year summer. It offers much greater flexibility to the students. It will be useful, especially for non-core placements. I started preparing for the interviews late. I did not put pen to paper, to write down his answer for the ice-breaking questions like “Introduce yourself”. It would be better to write those answers down and get them polished, rather than trying to remember it and/or make it up spontaneously.
Skill Tips: For handling pressure, I suggest that after the interviews are over, just eat and get a good night’s sleep. Preparing/analyzing about the performance in the interview would only make you more anxious, affects sleep, and this would affect your performance in the interviews the next day. The additional one hour of preparation is not going to make a big difference.
Skills: Speaking Ability, Ability to express your ideas, Capable of managing things efficiently
College Name: IIT MADRAS

Interview Preparation Tips

Round: Resume Shortlist
Experience: A balanced resume is preferred. It helped me in the further stages of the selection process, as everything was quite based on how was my resume.

Round: Test
Experience: It was actually and English skill based test, more like a basic clearance test. Two different rounds were there:(i)Listen/read and then fill up questions (approx. 45min) (ii) Telephonic test (computer generated test, approx. 15min).

I also appeared for other companies like Auctus and Reliance. Auctus had direct interview SL and Reliance had Aptitude and Technical (Mech) approx. 30 minutes each.
Tips: Aptitude is a must, so practice.
Duration: 1 hour minute

Round: Group Discussion
Experience: They actually tested the skills of the way you interact in a group and essence of your points. Felt that they didn’t concentrate much on speaking skills as such.
Tips: Practice to talk in groups, current affairs  and even random topics.
Duration: 10-15 minutes minutes

Round: Technical Interview
Experience: Basic understanding of Big Data and tested on enthusiasm. 
For others: 

Reliance – Corrosion & welding based questions; it was mainly a technical round
Auctus – Only HR was taken
Housing – Puzzles and HR (same round)
Deloitte – Basic consult based questions on whatever was given in JD.


For core:Reliance – Corrosion engineering, welding courses and a bit of 1st year metallurgy. BTP was related to Corrosion and discussion about BTP happened.
Tips: Puzzles (for most startups) and HR & resume based for others mostly.

General Tips: Aptitude and puzzle preparation is a must. For interviews prepare things very much related to the company. (For startups knowledge related to their field might be a plus point)If people are looking for Non-Core: better that they do some good and useful non-core intern atleast once, taking part in competitions will also help.



2ndyears can learn ‘R’ or any other technical stuffs which can be useful for non-core (mainly, Fin or analytics)Case studies are good to prepare for one month atleast.
Skill Tips: Starting earlier helps and I started around October. Aptitude requires some time and it is better to start atleast during summer vacation. Last two months before placements can be spent for other preparations.
Skills: English based skills, How to interact with people, Aptitude
College Name: IIT MADRAS
Motivation: Mostly based on the enthusiasm towards the field of work and the basic understanding of it.
Contribute & help others!
anonymous
You can choose to be anonymous

HCLTech Interview FAQs

How many rounds are there in HCLTech MIS Executive interview?
HCLTech interview process usually has 1 rounds. The most common rounds in the HCLTech interview process are One-on-one Round.
How to prepare for HCLTech 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 HCLTech. The most common topics and skills that interviewers at HCLTech expect are MIS Reporting, Advanced Excel, MIS, VLOOKUP and Excel.
What are the top questions asked in HCLTech MIS Executive interview?

Some of the top questions asked at the HCLTech MIS Executive interview -

  1. What is the advantages of Data validation and why we use ...read more
  2. How to create reports by pivot tab...read more
  3. How advance filter wor...read more

Recently Viewed

INTERVIEWS

Bharti Airtel

No Interviews

INTERVIEWS

Goldman Sachs

No Interviews

INTERVIEWS

RITES

No Interviews

SALARIES

American Tower Corporation

INTERVIEWS

Delhivery

No Interviews

LIST OF COMPANIES

American Tower Corporation

Overview

SALARIES

American Tower Corporation

INTERVIEWS

Leadec India

No Interviews

INTERVIEWS

Kent

No Interviews

INTERVIEWS

Rebel Foods

No Interviews

Tell us how to improve this page.

HCLTech MIS Executive Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more
Join HCLTech Find your spark and discover what drives you forward
HCLTech MIS Executive Salary
based on 84 salaries
₹1.9 L/yr - ₹5 L/yr
8% more than the average MIS Executive Salary in India
View more details

HCLTech MIS Executive Reviews and Ratings

based on 24 reviews

3.9/5

Rating in categories

3.5

Skill development

3.5

Work-life balance

3.0

Salary

3.4

Job security

3.9

Company culture

2.9

Promotions

3.3

Work satisfaction

Explore 24 Reviews and Ratings
Software Engineer
23.4k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Technical Lead
21.2k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Software Engineer
15.8k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Lead Engineer
15k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Analyst
14.5k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare HCLTech with

TCS

3.7
Compare

Wipro

3.7
Compare

Accenture

3.8
Compare

Cognizant

3.7
Compare
Did you find this page helpful?
Yes No
write
Share an Interview
Rate your experience using AmbitionBox
Terrible
Terrible
Poor
Poor
Average
Average
Good
Good
Excellent
Excellent