Kearney Junior Research Analyst Interview Questions and Answers

The topic of GD was Social media pros and cons

Q1. If USD1 equals to INR1, then what will be its impact on the Indian economy?
Ans. 
If USD1 equals INR1, it will impact the Indian economy by affecting exports, imports, inflation, and foreign investments.
• Exports will become expensive, making Indian goods less competitive in the global market.

• Imports will become cheaper, leading to increased demand for foreign goods.

• Inflation may rise due to increased demand for foreign goods and higher import costs for raw materials.

• Foreign investments may decrease a...read more
Answered by AI
Add your answer
Q2. What happens if cigarette banned by the govt. in India?
Ans. 
If cigarettes are banned by the government in India, it would have significant social, economic, and health implications.
• Reduction in smoking-related health issues and diseases

• Decrease in tobacco-related deaths

• Positive impact on public health and healthcare costs

• Potential increase in illicit tobacco trade

• Loss of revenue for the government

• Impact on tobacco farmers and related industries

• Changes in social behavior and cul
Answered by AI
Add your answer

Q1. Since, I am a Mechanical engineer, so, there were questions related to different engines; questions related to my project, internships, etc.
Add your answer

Q1. Guess estimation questions
Add your answer
Q2. How many blue cars in jaipur
Ans. 
It is not possible to determine the exact number of blue cars in Jaipur without specific data.
• The number of blue cars in Jaipur can vary depending on various factors such as time, location, and population.

• To determine the number of blue cars, a comprehensive survey or data collection is required.

• Without available data or specific information, it is impossible to provide an accurate answer.
Answered by AI
Add your answer

Q1. Tell me about yourself
Add your answer
Q2. Describe your professional journey
Add your answer

Q1. Challenges faced in professional journey
Add your answer

Hacker rank test for 2 hours. Language of your choice and problem solving and sql and data structures

Q1. Handling different types of data. Sql functions Design considerations Performance optimization
Ans. 
Handling different types of data, SQL functions, design considerations, and performance optimization.
• Understand the data types and their limitations

• Use appropriate SQL functions for data manipulation

• Consider normalization and denormalization for database design

• Optimize queries and indexes for better performance

• Use caching and partitioning for large datasets

• Examples: DATE functions, JOINs, indexing, partitioning
Answered by AI
Add your answer
Q2. How to handle data skewness in spark. What are the different performance optimization techniques in hive
Ans. 
Handling data skewness in Spark and performance optimization techniques in Hive
• For data skewness in Spark, use techniques like partitioning, bucketing, and salting

• In Hive, use techniques like partitioning, bucketing, and indexing for performance optimization

• Other techniques include using appropriate data types, optimizing queries, and using compression

• Example: In Spark, partitioning can be done based on a column with h...read more
Answered by AI
Add your answer

Q1. Data skewness Stake holder Management Hands on capabilities
Add your answer

Q1. More about culture and compensation and company policy
Add your answer

30 mins time.. 25 questions

Q1. Self introduction etc
Add your answer

Q1. Tell me about your past experiences
Add your answer

30MCQ Questions and it is easy to moderate one

Q1. Tell me something about yourself.
Add your answer
Q2. Asked to walk through all the projects in work experience. Some cross questions on the same lines.
Add your answer
Q3. Why I chose biotechnology and now an MBA and how I see the biotech space growing in near future with some new findings in that area.
Add your answer

Started with interviewer telling me about him and his work area in A&M.

Tell me about yourself?
[Please note that I stands for Interviewer and C stands for Candidate]

C: Presented the prepared answer but modulated it more towards work experience and internships done in same area as the interviewer (Pharma).

I: Walk me through your CV and major projects done?

C: Started from work experience and explained all projects with an addition of projects done in internships at the end.

I: Your client is a big hospital looking to improve its operations. Come up with main 3 problems you would consider improving on by applying analytics-based methods.

C: Took a min to note down certain points. Followed the problems a normal person would face in the hospital after entering and effectively communicated my thinking for the problem with the interviewer.

Addressed problems relating to scheduling for a patient in attending a doctor consultation or lab, self-registration after entering hospital and report collection etc. and applied analytics-based solutions for the same.

You are conducting a cricket tournament in IIM Lucknow. How many cricket balls would be used in it if you want to order all at once?
[Please note that I stands for Interviewer and C stands for Candidate]

I: Tell me about your projects in dashboarding?

C: Walked him through all the projects done in that domain with all the technologies used. Some cross questioning on hygiene check of dashboards and things to consider while developing them.

I: As you mentioned you have a liking for sports, let's do a guesstimate. You are conducting a cricket tournament in IIM Lucknow. How many cricket balls would be used in it if you want to order all at once?

C: Asked preliminary questions about the tournament pattern and number of teams involved. Calculated the number of matches that would be played and then the number of balls that would be required. Added a buffer stock at the end as a random percentage but gave reasoning on the basis of loss and wear & tear of the balls.

The Interview was basically a last round just to know me more and about my background. Asked questions on why I chose biotechnology and now an MBA and how I see the biotech space growing in near future with some new findings in that area.

Some questions were about my work experience and internships and also about the life at IIM Lucknow so far.