Euromonitor Research And Consultingindia Interview Questions and Answers

Q1. Basic Java, Python, SQL Technical Questions.
Add your answer

Q1. Questions from SQL, Python, Java.
Add your answer
Q2. Asked to print 2 max salary in emp table.
Add your answer

Q1. Basic Personal questions.
Add your answer

Total 10ques, 3 from python and java, 4 from SQL.

Q1. How will you find loyal customers for a store like DMart , SmartBazar
Ans. 
Utilize customer transaction data and behavior analysis to identify loyal customers for DMart and SmartBazar.
• Use customer transaction history to identify frequent shoppers

• Analyze customer behavior patterns such as repeat purchases and average spend

• Implement loyalty programs to incentivize repeat purchases

• Utilize customer feedback and reviews to gauge loyalty

• Segment customers based on their shopping habits and preferenc
Answered by AI
Add your answer
Q2. Who is more valuable a customer who is making small transactions everyday or the customer who makes big transactions in a month
Ans. 
It depends on the business model and goals of the company.
• Small transactions everyday can lead to consistent revenue streams and customer engagement.

• Big transactions in a month can indicate high purchasing power and potential for larger profits.

• Consider customer lifetime value, retention rates, and overall business strategy when determining value.
Answered by AI
Add your answer
Q3. What will you do as a data scientist if the sales of a store is declining
Ans. 
I would conduct a thorough analysis of the sales data to identify trends and potential causes of the decline.
• Review historical sales data to identify patterns or seasonality

• Conduct customer surveys or interviews to gather feedback

• Analyze competitor data to understand market dynamics

• Implement predictive modeling to forecast future sales

• Collaborate with marketing team to develop targeted strategies
Answered by AI
Add your answer
Q4. We have to bundle the items together in the units of 2-3 as a single units like chips of 3 packets together. how to identify which items to bundle and number of units. Create a machine learning model for i...read more
Add your answer
Q5. You are working in a project, where your approach towards problem is more innovative while the rest of the team is following conventional approach. how will you convince them to follow your approach.
Ans. 
I would showcase the potential benefits and results of my innovative approach to convince the team.
• Highlight the advantages of the innovative approach such as improved efficiency, accuracy, or cost-effectiveness.

• Provide real-world examples or case studies where similar innovative approaches have led to successful outcomes.

• Encourage open discussion and collaboration within the team to explore the potential of combining ...read more
Answered by AI
Add your answer

1. A store has promotional offers how will you analyse that offers are working in their favour.
2. What data will you require if you want to predict the sales of the chocolate in a store.
3. Why data is distributed normally in linear regression.
4. Difference between linear and logistic regression
5. A person who is senior to you and you are working on the same project. But that person has very bad reputation of misbehaving and being rude to people. And he is doing same with you. What will you do?

Market Research Questions

Q1. What is market research
Ans. 
Market research is the process of gathering, analyzing, and interpreting information about a market, including customers, competitors, and industry trends.
• Involves collecting data on customer preferences, buying habits, and market trends

• Helps businesses make informed decisions about product development, pricing, and marketing strategies

• Includes techniques such as surveys, focus groups, and data analysis

• Examples: conduc...read more
Answered by AI
Add your answer

Q1. Why do you want to join our company?
Add your answer

Aptitude test conducted with normal logical reasoning, verbal ability and quantitative type aptitude problems were asked.

Case study round scheduled with Practice Director:
Started with normal greetings and basic introduction followed by deep dive into the resume and some questions based on what was in my resume. Then started with the case study.
Case : Your client is a totally offline bank ( think of SBI) and wants to undergo a digital transformation (somewhat like HDFC wherein all services are online as well) . How would you create a framework to do so ?

Q1. Estimate the number of viewers who watched 2024 T20 World Cup.
Ans. 
Estimating the number of viewers for the 2024 T20 World Cup.
• Consider past viewership trends for T20 World Cup events.

• Analyze the popularity of cricket in the host country and globally.

• Take into account the impact of digital streaming platforms on viewership.

• Factor in potential growth in viewership due to increased interest in T20 cricket.

• Consult experts in sports broadcasting and market research for insights.
Answered by AI
Add your answer
Q2. Estimate the number of Gyms in Delhi
Ans. 
Estimating the number of Gyms in Delhi based on population density, urbanization, and market demand.
• Consider the population density of Delhi

• Analyze the urbanization level in different areas of Delhi

• Research on the market demand for fitness centers in Delhi

• Consult with local authorities or fitness industry experts for insights

• Use data from online directories or platforms listing Gyms in Delhi
Answered by AI
Add your answer

Q1. It was a cultural fit/HR round taken by the Partner/Managing Partner in the firm. Questions around personality likes/dislikes future goals, MBA aspirations etc were asked
Add your answer

Q1. What is coalesce
Ans. 
Coalesce is a function used to return the first non-null value in a list of expressions.
• Coalesce function is commonly used in SQL to handle null values.

• It takes multiple arguments and returns the first non-null value.

• Example: COALESCE(column1, column2, 'default') will return the value of column1 if not null, else column2, and if both are null, it will return 'default'.
Answered by AI
Add your answer
Q2. What is repartition
Ans. 
Repartition is the process of redistributing data across partitions in a distributed system.
• Repartitioning helps in balancing the workload and improving performance in distributed computing environments.

• It involves moving data between partitions based on certain criteria such as key values or hash functions.

• Repartitioning can be done in Spark using operations like repartition() or coalesce().
Answered by AI
Add your answer

Q1. Non repeatable character
Ans. 
A non repeatable character is a character that appears only once in a given string.
• Iterate through the string and count the frequency of each character

• Identify the characters that have a frequency of 1

• Return the first non repeatable character found
Answered by AI
Add your answer
Q2. Sort list without sort method
Ans. 
Sort list without using sort method
• Create a custom sorting function using loops

• Compare each element with every other element to determine the correct order

• Swap elements based on the comparison results
Answered by AI
Add your answer

Q1. What experience you and expectation with yougov
Add your answer

Q1. Technical question related to market research
Add your answer

Q1. Tell me about yourself
Add your answer
Q2. What are your strengths
Add your answer

Q1. Basic questions regarding to your last experience and skills oriented
Add your answer

Q1. Interview is very depths by manager. And it will brush up all the knowledge
Add your answer

Q1. Very behavioural questions asked, extremely nice people
Add your answer
Q2. What are your strengths
Add your answer
Q3. What are your weaknesses
Add your answer

Q1. Again very friendly people, asking different scenario questions to judge your capabilities
Add your answer