Upload Button Icon Add office photos
Engaged Employer

i

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

AGS Health Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

AGS Health MIS Executive Interview Questions and Answers

Updated 6 Oct 2024

AGS Health MIS Executive Interview Experiences

1 interview found

MIS Executive Interview Questions & Answers

user image Soniya . Venkatesan

posted on 6 Oct 2024

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

(2 Questions)

  • Q1. What is vlookup
  • Ans. 

    VLOOKUP is a function in Excel used to search for a value in a table and return a corresponding value from another column.

    • Used in Excel to search for a value in the first column of a table and return a value in the same row from another column

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

    • Example: =VLOOKUP(A2, B2:D10, 3, FALSE) - searches for the value in cell A2 in the first column of the ra...

  • Answered by AI
  • Q2. What is hlookup
  • Ans. 

    HLOOKUP is a function in Excel used to search for a value in the top row of a table and return a value in the same column from a specified row.

    • Used in Excel to search for a value in the top row of a table

    • Returns a value in the same column from a specified row

    • Syntax: =HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])

    • Example: =HLOOKUP(123, A1:D4, 3, FALSE) - searches for 123 in the top row of the table A1

  • Answered by AI

Skills evaluated in this interview

Interview questions from similar companies

I applied via Campus Placement

Interview Preparation Tips

Round: Other Interview
Experience: Q1.Tell me about yourself.
Then I was asked about my past internship, PoRs
Then I was asked why I wanted to do a non core internship.
After that, I was asked a puzzle (Similar to a puzzle in the book "Heard on the Street".
Then I was asked a guesstimate question. It was: Estimate the amount of Surf (washing powder) used in India everyday.
It lasted for around half an hour. It was a telephonic round
Tips: Be thorough with your resume. They mainly asked resume based questions in this round.

Regarding puzzles and guesstimates, walk your interviewer through your answer.

General Tips: Be thorough with your resume.
Practice puzzles and guesstimates.
Practice a few cases.
Skills: Presentation Of Facts In Resume, Project And Internship, Guesstimate Skills, Case Solving Ability, Quantitative Aptitude
Duration: 2
College Name: IIT Madras

I was interviewed before Jun 2016.

Interview Questionnaire 

6 Questions

  • Q1. What is a bond? What are different types of bonds?
  • Ans. 

    A bond is a debt security that represents a loan made by an investor to a borrower.

    • Bonds are issued by governments, municipalities, and corporations.

    • They are used to raise capital and finance projects.

    • Different types of bonds include government bonds, corporate bonds, municipal bonds, and convertible bonds.

    • Government bonds are issued by national governments and are considered low-risk.

    • Corporate bonds are issued by comp...

  • Answered by AI
  • Q2. Tell us something about your specialisation subjects of BBA
  • Ans. 

    My specialisation subjects in BBA include marketing, finance, human resource management, and operations management.

    • Marketing involves understanding consumer behavior and creating strategies to promote products or services.

    • Finance focuses on managing funds, investments, and financial planning.

    • Human resource management deals with recruiting, training, and managing employees.

    • Operations management involves overseeing produ...

  • Answered by AI
  • Q3. Which is your favourite subject? Describe about it
  • Ans. 

    My favorite subject is history because I enjoy learning about past events and how they have shaped the world we live in today.

    • I find studying different time periods and cultures fascinating

    • I enjoy analyzing historical documents and artifacts

    • I like understanding how historical events have influenced current societies and politics

  • Answered by AI
  • Q4. Are you comfortable in night shifts
  • Ans. 

    Yes, I am comfortable with night shifts as I have prior experience working in night shifts.

    • I have previous experience working night shifts in my previous job.

    • I am able to adjust my sleep schedule to accommodate night shifts.

    • I understand the importance of being alert and focused during night shifts.

    • I am willing to work night shifts if required for the role.

  • Answered by AI
  • Q5. What are your hobbies
  • Ans. 

    My hobbies include hiking, painting, and playing the guitar.

    • Hiking: I enjoy exploring nature trails and challenging myself physically.

    • Painting: I find relaxation and creativity in expressing myself through art.

    • Playing the guitar: I love learning new songs and improving my musical skills.

  • Answered by AI
  • Q6. Where do your parents and siblings work
  • Ans. 

    My parents work in education and my siblings work in finance and healthcare.

    • Parents work in education

    • Siblings work in finance and healthcare

  • Answered by AI

Interview Preparation Tips

Round: Test
Experience: In this round there was an online test which had objective and subjective questions regarding the mentioned sections.
Duration: 1 hour
Total Questions: 30

Round: Technical Interview
Experience: The interviewer asked such questions about my graduation subjects and a little about how familiar I am of the work the company deals in.

Round: HR Interview
Experience: This round had the HR person ask general questions about my hobbies and about my family background and also told me about the company, its culture and the salary structure

College Name: Maharaja Surajmal Institute Of Technology

I was interviewed in Dec 2016.

Interview Questionnaire 

5 Questions

  • Q1. Number of 0s in 1 to 1000
  • Ans. 

    The number of 0s in 1 to 1000 is 192.

    • There are 1000 numbers from 1 to 1000.

    • Every 10 numbers have one 0 in the units place.

    • Every 100 numbers have ten 0s in the tens place.

    • Every 1000 numbers have one hundred 0s in the hundreds place.

    • Therefore, there are 1 + 10 + 100 + 81 = 192 0s in total.

  • Answered by AI
  • Q2. A simple question which can be converted to an easy linear equation. I don't remember the exact question though.
  • Q3. How to cut a cake in 8 equal parts
  • Ans. 

    Cut the cake in half, then cut each half in half again. Repeat once more to get 8 equal parts.

    • Use a long, sharp knife to make clean cuts.

    • Start by cutting the cake in half vertically.

    • Then cut each half in half horizontally.

    • Repeat the process once more to get 8 equal parts.

    • Use a cake divider or toothpicks to mark where to cut for even slices.

  • Answered by AI
  • Q4. HR questions based on resume
  • Q5. Why not core?
  • Ans. 

    Core is not the best fit for our current needs and goals.

    • Our current focus is on expanding our reach to new markets.

    • Core may not have the necessary features to support our growth plans.

    • We have evaluated multiple options and found a better fit for our requirements.

  • Answered by AI

Interview Preparation Tips

Round: Resume Shortlist
Experience: Everyone with CGPA > 6.5 were shortlisted.

Round: Test
Experience: Questions were not too difficult. You just need practice to solve them within the time limit.
Tips: Solve level 1 of all the chapters of Arun Sharma's Quantitative Aptitude. Also, take part in the weekly tests organized by pariksha.co .
Duration: 1 hour
Total Questions: 45

Round: HR Interview
Experience: Standard HR questions and resume based questions.

College Name: IIT Kanpur

Interview Questionnaire 

2 Questions

  • Q1. Tell me about yourself?
  • Q2. Why did you apply for this company?

Interview Preparation Tips

Round: Test
Experience: Questions were similar to that in CAT. Question based on logic, reasoning and English were asked with every section having 20 questions. Shortlisted students were selected for interviews.
Duration: 60 minutes

Round: HR Interview
Experience: A case was given which had to be analysed and I was to suggest different solutions and justify them.

Round: HR Interview
Experience: Consisted of HR questions and guess estimate questions.Also a few analytics question were asked.

Skill Tips: My projects related to analytics,basic knowledge on engineering, spontaneity was tested. The PDF's uploaded by the BC,solving puzzles from the Internet helped.Also I talked to my seniors which gave me a good idea as to what to expect of the interview. Basic preparation on all the core courses. Reading from the materials provided by the BC. Reading TIME material,brushing up on coding concepts (from NPTEL lectures), learning R(analytics software) from coursera helped.
Skills: Analytics
College Name: IIT MADRAS

Interview Preparation Tips

General Tips: Do’s :
• PREPARE FOR APTITUDE TESTS. Many of us believe that our profile will lead us getting
shortlisted on resume basis. That may be true, but I have not seen a process as random as
placements. It might happen that you are getting closely rejected in 3-4 firms for which you have
prepared. In such a case, having a good aptitude will give you more no. of shortlists, which will give
you a psychological security to fall back. APTITUDE PREPARATION IS BORING, so you may start it
and then leave it. Don’t do it. It is the only thing that is going to be with you in case something
unexpected happens.
• Be prepared for random and unexpected events like unexpected shortlisting results, irregularities in interview procedures etc.
• Prepare in a group, and help each other. The entire placement preparation phase is very taxing,
and support from people around you helps.

Dont’s :
• Don’t leave things for the end.
• Don’t underestimate yourself. Don’t overestimate yourself too.
• Don’t have pre-conceived notions about anything: no. of people a company is going to hire, who is
better than you, who is worse than you etc. Let the company decide what they want.

Final Tips :
• Prioritize the sectors and analyse your chances.
• Don’t keep too high or too low expectations from yourself.
• PREPARE APTITUDE. If you don’t get placed in big firms, aptitude is your only fall back.
• Be prepared for unexpected outcomes.
• Trust yourself for what you know, because there are a lot of things and you cant know everything.
The interview is driven by what you write on your resume. Know what you write. 
• In all preparation aspects, one never gets a feeling of satisfaction. Due to paucity of time and so
much pressure around, we are unable to do things as per our expectations. So don’t worry too
much. Give ample time to things, but don’t overdo them.
• Go to the interview empty-headed. Thinking too much about things makes you feel nervous. An empty mind works most efficiently.
College Name: IIT Kanpur

Interview Preparation Tips

Round: Test
Experience: It was held couple of days before their interview process. Test consisted of Quant, Logical reasoning and Verbal Ability, similar to CAT pattern but was comparatively easy. They shortlisted approximately 80 students for interview process.


Round: Other Interview
Experience: It was a mix of mostly HR + few probability questions. It was a 40min interview. It was a good interview as I was able to answer all his question and could easily solve the probability questions.


Round: Technical Interview
Experience: It was all technical wherein the interviewer asked me 4-5 puzzles and some probability questions. I was able to answer most of the puzzles correctly but got stuck in one of the probability questions.


Round: HR Interview
Experience: Final HR round. Here the interviewer was continuously grilling me by stating that my profile is not coherent with their job description. I maintained my composure and was able to handle the situation with ease.


General Tips: Do’s :
Apart from all preparation :
• Take proper sleep whenever given a chance to. Do not skip meals.
• Prepare about the company in advance, last minute preparation might lead to a panic situation. Ask your friends (not sitting in placements) to help you prepare.
• Take someone to the interviews. He/She will manage your interviews accordingly. It’s also a motivating factor.
• Always carry a smile when going to an interview. You should not appear stressed.

Don’ts :
• Don’t try to delay things. Prepare a timeline for preparation. Don’t accumulate things post end sem, because you will have to appear for a lot of tests after that. Hence you get limited time for preparation.
• Don’t be in a false assumption that if you possess a strong profile (PORs, Extra currics etc.) you will make it through the interviews. It can only help you fetch an interview. You have to work hard to clear that interview.

College Name: IIT Kanpur

Interview Preparation Tips

Round: stress interview
Experience: During EXL, the first interview was a totally stressful one. The interviewer was interrupting me all the time and countering me when I was answering him. Then he gave me a puzzle, which seemed fairly easy to me. But as I started on the puzzle, he started asking me about my hobbies to interrupt me again. I patiently answered the question and then solved the puzzle. He gave me 2 more puzzles, which again I was able to solve. Then, he asked me to give an approach for a guess estimate, which I was able to do easily. My preparation on Cases, Puzzles and Guesstimates was fairly low as compared to others. But I was able to solve them because I was very relaxed in the interview.
Tips: Keeping calm is imperative.


Round: HR interview
Experience: The second round was a complete HR interview. All the questions were either from my resume or about my interest in EXL. Once, he was through with them, he asked me a puzzle which I’d never heard before. But I was able to solve it with a small hint from the interviewer.
Tips: It is important to think loud and let the interviewer know what is going through your mind.

General Tips: Do’s –
Manage Time well, try to attend all classes so that you don’t have to study too much before the exams (or simply choose such courses).
Try to keep your personal database of which companies you’ve applied for, which day are they coming and what your status of preparation for them is etc.
If you have more than 1 interview in a slot, try to take a friend along with you who can attend your calls when you’re in an interview. Even if you have 1 interview, still I’d recommend taking a friend along with you. Talking with a friend always eases pressure.
Stay Relaxed. You might have to wait for 2-3 hours for your interview slot.

Don'ts-
Don’t waste time in the semester. Prepare.
Don’t get nervous in the interview. You might not be able to solve a puzzle or a case if you are nervous. Try to be as normal as you can be.
Don’t rely heavily on one company. A company might reject you on the basis of a small mistake. Prepare for more than one.

College Name: IIT Kanpur

Interview Preparation Tips

Round: Test
Duration: 45 minutes minutes
Total Questions: 40

Round: guesstimate interview
Experience: As I belong to the Civil Engineering background, I was initially asked to justify how I am suited for analytics. I had an intern on marketing so he asked few simple questions on that. After that he gave me guesstimate. As I was solving the guesstimate, the interviewer was constantly questioning my approach and asking me to specify the source of every data (for eg. Population of India 1.2 bn, Source: Census report 2%) and he also kept questioning my approach and made me do the same guesstimate by three approach. After that he asked few puzzles which were simple and I was able to solve them.

Round: hr interview
Experience: Initially some HR questions and some simple probability questions. This was a very friendly and easy interview.

Round: hr interview
Experience: It was with the partner and it was a short interview (10 mins) and was entirely HR and he also asked few questions on my resume. It was more of a normal chit chat that an interview. I was given the offer.

General Tips: Do’s :
1. Practice in groups (aptitude, cases, guesstimates).
2. For HR preparation, if you are not sure about your communication skills it is good to practice aloud in your room or record while rehearsing.
3. Be energetic in the interview, try to drive the interview on your own.

Don’ts :
1. Take HR for granted if you have good soft skills.
2. For cases its better to practice mock rather than just reading through the case books.

College Name: IIT Kanpur

I applied via Campus Placement

Interview Preparation Tips

Round: Resume Shortlist
Experience: 15 people were short listed from the entire lot.
Tips: High CGPA or course in R programming will be helpful in getting shortlisted.

Round: Telephonic interview
Experience: general HR questions like describe yourself was asked. I was questioned on my tennis knowledge (extra curricular) and detailed description of intern too.
Tips: Be thorough with your resume from start to end and you should be able to explain what you did in interview.

Round: Test
Experience: Difficult questions related to data interpretation mixed with probability were asked to solve within 7 minutes. One guess-estimate question and one case study type problem were asked to be solved within 23 minutes.
Tips: calculations should be done fast and assumptions properly written.
Duration: 30 minutes
Total Questions: 6

General Tips: Be very thorough with your resume and some general HR questions.
Skill Tips: Be calm and not get tensed is a must,
Skills: Analyzing And Problem Solving Skills
Duration: 2
College Name: IIT Madras
Motivation: This is a very diverse company and major attraction is that it applies decision analytics to solve business problems. Being interested in a finance and coding a bit, this profile seemed the right fit.
Funny Moments: I was quizzed on my knowledge of tennis like how many Grand slam has Leander paes won and what was the semi final score of US open.
Contribute & help others!
anonymous
You can choose to be anonymous

AGS Health Interview FAQs

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

Some of the top questions asked at the AGS Health MIS Executive interview -

  1. What is vloo...read more
  2. What is hloo...read more

Recently Viewed

SALARIES

CommLab India

SALARIES

State Street Corporation

INTERVIEWS

Schoolnet India

No Interviews

INTERVIEWS

Ahadu Group

No Interviews

DESIGNATION

DESIGNATION

INTERVIEWS

AGS Health

No Interviews

REVIEWS

State Street Corporation

No Reviews

SALARIES

State Street Corporation

REVIEWS

State Street Corporation

No Reviews

Tell us how to improve this page.

AGS Health MIS Executive Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more

Interview Questions from Similar Companies

EXL Service Interview Questions
3.7
 • 736 Interviews
Omega Healthcare Interview Questions
3.7
 • 435 Interviews
S&P Global Interview Questions
4.1
 • 275 Interviews
Mu Sigma Interview Questions
2.6
 • 229 Interviews
Access Healthcare Interview Questions
3.9
 • 207 Interviews
Straive Interview Questions
3.4
 • 174 Interviews
Indegene Interview Questions
3.4
 • 151 Interviews
CorroHealth Interview Questions
3.3
 • 145 Interviews
Nielsen Interview Questions
3.7
 • 117 Interviews
View all
AGS Health MIS Executive Salary
based on 16 salaries
₹2.4 L/yr - ₹5.8 L/yr
25% more than the average MIS Executive Salary in India
View more details

AGS Health MIS Executive Reviews and Ratings

based on 7 reviews

1.9/5

Rating in categories

2.3

Skill development

1.7

Work-life balance

2.4

Salary

3.5

Job security

3.1

Company culture

1.8

Promotions

2.1

Work satisfaction

Explore 7 Reviews and Ratings
Process Associate
1.2k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Medical Coder
933 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

AR Caller
686 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Team Lead
524 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Quality Analyst
491 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare AGS Health with

Omega Healthcare

3.7
Compare

GeBBS Healthcare Solutions

3.7
Compare

VeeTechnologies

3.7
Compare

Vidal Health Tpa

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