AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Merilytics
Compare
Filter interviews by
Merilytics Supervisor Interview Questions and Answers
Merilytics Supervisor Interview Experiences
1 interview found
I applied via Campus Placement and was interviewed in Aug 2023. There were 3 interview rounds.
Good to attend the test
(3 Questions)
- Q1. What is sql language
- Ans.
SQL is a programming language used for managing and manipulating relational databases.
SQL stands for Structured Query Language
It is used to communicate with databases to perform tasks such as querying data, updating data, and creating tables
Common SQL commands include SELECT, INSERT, UPDATE, DELETE
Example: SELECT * FROM customers WHERE city = 'New York';
- Q2. What is duplicates finding in sql
- Ans.
Duplicates finding in SQL is the process of identifying and removing duplicate records from a database table.
Use the DISTINCT keyword in a SELECT statement to retrieve unique records
Use the GROUP BY clause with COUNT() function to identify duplicate records
Use the ROW_NUMBER() function to assign a unique row number to each record and filter out duplicates
- Q3. What is java oops concept
- Ans.
Java OOPs concept refers to Object-Oriented Programming principles like inheritance, encapsulation, polymorphism, and abstraction.
Java OOPs concept includes inheritance, where a class can inherit properties and behaviors from another class.
Encapsulation involves bundling data and methods that operate on the data into a single unit.
Polymorphism allows objects to be treated as instances of their parent class, enabling fl...
Interview Preparation Tips
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
Selected
I applied via Approached by Company and was interviewed before Aug 2023. There were 3 interview rounds.
1 coding test having a DP question and some spark based questions.
(2 Questions)
- Q1. Fibonacci using DP
- Ans.
Fibonacci using Dynamic Programming
Use an array to store calculated Fibonacci numbers to avoid redundant calculations
Start with base cases of 0 and 1, then iterate to calculate subsequent Fibonacci numbers
Time complexity can be reduced from exponential to linear using DP
- Q2. SQL questions ( ranks and partition)
(1 Question)
- Q1. Design based questions
Skills evaluated in this interview
Shweta Saini
1. The online test includes questions related to spark and a coding questions.
(2 Questions)
- Q1. Questions related to sql , spark, data structures were asked
- Q2. 1. Questions based on window functions (rank, dense_rank)
(1 Question)
- Q1. Overall discussion of the projects that you have worked on.
Analyst Interview Questions & Answers
Institutional Shareholder Services
Anonymous
posted on 9 Jul 2020
I applied via Recruitment Consultant and was interviewed in Jan 2020. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. Problem solving,Core Java,SQL queries,Design patterns,project based questions
Interview Questionnaire
5 Questions
- Q1. A Big Bazaar store had low profits for the last two months. Whats going on?
- Ans.
Low profits in Big Bazaar store for last two months.
Check if there is a decrease in footfall or sales.
Analyze the competition in the area.
Check if there are any supply chain issues.
Evaluate the marketing strategies and promotions.
Assess the economic conditions of the area.
Consider the impact of COVID-19 on consumer behavior.
Review the store's inventory management and pricing strategies.
- Q2. Heres some data about the quantity of a particular item sold in a store for the last few weeks. Any thoughts?
- Q3. You have two brands of milk that you can sell in your store,. Which one would you pick?
- Ans.
I would pick the brand that has a higher quality and better taste.
Check the quality and taste of both brands
Consider the price of each brand
Look at the expiration date of both brands
Consider the popularity of each brand among customers
- Q4. Why do you want to work at Dunnhumby?
- Ans.
I am passionate about data-driven insights and Dunnhumby's reputation as a leader in customer data science.
I am impressed by Dunnhumby's innovative approach to customer data science
I am excited about the opportunity to work with a talented team of data analysts
I am drawn to Dunnhumby's reputation for delivering actionable insights to clients
I believe that Dunnhumby's focus on customer-centricity aligns with my own valu...
- Q5. Tell me about this particular internship that you did
- Ans.
I interned at a marketing firm where I worked on social media campaigns and market research.
Assisted in creating social media content for clients
Conducted market research on target demographics
Analyzed data to improve campaign performance
Attended client meetings and presented findings
Learned about marketing strategies and industry trends
Interview Preparation Tips
Experience: 70 people shortlisted probably by cv and pre-assessment test results.
Round: Group Discussion
Experience: 70 shortlisted candidates were divided into 10 groups of 10. GD started, we sat in a circle around a table. All of us were handed a booklet and rough sheets. The interviewers told us that the booklet had three sections. Each section contained some data about a company followed by a question. We, as a group had to answer the three questions within one hour. He, himself suggested that we take twenty minutes per section - 5 mins to go through the data, fifteen to discuss and come to a conclusion. The first section gave us an idea about the company and asked some general questions about decreasing costs. Generic case study stuff. The next two sections were quant heavy. Required us to do a lot of calculations albeit simple. We divided the task among the group members. Ran out of time before solving the third question. Interviewer stepped in and helped us reach a conclusion. We were asked to leave the rough sheet behind. One of the longest and most civil Gds that I have attended. A wonderful experience.
Tips: Try to help move the discussion forward. Draw out your calculations and tables in the rough sheet. Let others speak, one hour is enough time for everyone to shine :).
Round: Case Study Interview
Experience: One interviewer. Small talks about the GD. A moderately long case followed by two short cases. The cases involved some quants. Nothing fancy. I did not follow any framework but he did not seem to mind. He helped me out any place that i got stuck. Asked me about why Dunnhumby. Nailed this answer. Did not ask a lot a questions from my cv, just about an internship i had done at a startup. Asked me whether i was comfortable with coding, told him i had not coded since my first year at college. That was it. Shaked hands and asked me to wait outside. HR came and told me i got the job.
Tips: Think out loud. Whatever you are thinking when looking at the tables or numbers, just speak them out loud for the interviewer so that he knows your thought process. Learn about the company a little bit before showing up for the interview. I was asked only cases, I heard others were asked guesstimates as well.
General Tips: Case in Point is more than enough as far as preparation is concerned. A good CV and CGPA helps. Don't worry, I myself lacked both :P
Skills: Ability To Work In A Team, Case Solving Ability, Quant+Math
College Name: IIT Kharagpur
Motivation: Wanted a job as an analyst with a good work-life balance and a moderately good pay.
Interview Preparation Tips
Experience: Pre-Assesment Test conducted in my college.
Consists of Quant, Verbal and logical reasoning.
Students who scored good in this test and had CG above 7 are shortlisted
Tips: Cat preparation would help
Practice aptitude for two months prior to placement season
Round: Group Discussion
Experience: A case was given and should be solved by the group of 8 people in an hour.
They will closely monitor the group and select the students who provide right insights, direct the group in right direction.
Tips: Avoid talking just for sake of talking.
Understand the case and then summarize what you understood.
Speak you idea and also discuss other ideas.
Make sure that the invigilator understands that you are good with cases.
Read Case in point or other case books to get in touch with different cases.
Duration: 60 minutes
Round: Case Study Interview
Experience: Asked few questions like Why Dunnhumy? Type of profiles you applied for? Tell me about your childhood? and few basic HR questions.
Asked a profitability case problem.Even though I did not solve the entire problem, my approach was right.
Gave some data and asked my inference.
Asked to calculate a problem without using pen and paper.
Tips: You need to be good with numbers.
You need to show them that you have the enthusiasm to learn things.
Skill Tips: Go through any good case book.
Show them you enjoy numbers.
Show them you like this work.
Skills: Case Solving Ability, Number Crunching, Ability To Make Quick Calculations
College Name: IIT Kharagpur
Analyst Interview Questions & Answers
Institutional Shareholder Services
Anonymous
posted on 11 Jun 2024
Simple assignment testing research abilities
(1 Question)
- Q1. Explain past experiences, understanding of ESG
- Ans.
I have extensive experience analyzing companies' ESG practices and their impact on financial performance.
Researched and analyzed ESG data for investment decisions
Evaluated companies' sustainability initiatives and their alignment with ESG criteria
Participated in ESG ratings assessments and benchmarking
Engaged with company management on ESG issues during due diligence processes
Analyst Interview Questions & Answers
Institutional Shareholder Services
Sonal Nimkar
posted on 17 Apr 2024
(1 Question)
- Q1. ESG in detail.. Why people consider ESG now
- Ans.
ESG stands for Environmental, Social, and Governance criteria. People consider ESG now due to increasing awareness of sustainability and ethical practices in business.
ESG criteria are used by investors to evaluate the sustainability and ethical impact of a company.
Companies are increasingly focusing on ESG factors to attract investors and customers who prioritize sustainability.
Regulatory bodies are also emphasizing th...
Analyst Interview Questions & Answers
Institutional Shareholder Services
Anonymous
posted on 8 Aug 2024
Selected
I applied via Naukri.com and was interviewed before Aug 2023. There were 2 interview rounds.
Assignments based on Esg analysis of case
(1 Question)
- Q1. How do you weight ESG factors of a FMCG vs Banks
- Ans.
ESG factors are weighted differently for FMCG and banks based on industry-specific risks and opportunities.
Consider industry-specific risks and opportunities for FMCG and banks
For FMCG, focus on environmental impact of production, social responsibility in supply chain, and governance practices
For banks, prioritize governance practices, risk management, and social impact of lending practices
Use industry benchmarks and E...
Interview Preparation Tips
Selected
I applied via AmbitionBox and was interviewed before Apr 2022. There were 3 interview rounds.
(2 Questions)
- Q1. What is non covered services
- Q2. Denial code for non covered services
(2 Questions)
- Q1. What is pre authorization
- Q2. What is coverage terminated
- Ans.
Coverage terminated refers to the end of an insurance policy's coverage period.
Coverage terminated means that the insurance policy has ended and the insured is no longer covered.
This can happen due to non-payment of premiums, expiration of the policy term, or cancellation by the insurer.
Once coverage is terminated, the insured will no longer be able to make claims under the policy.
Merilytics Interview FAQs
Tell us how to improve this page.
Merilytics Interviews By Designations
- Merilytics Business Associate Interview Questions
- Merilytics Business Analyst Interview Questions
- Merilytics Senior Business Analyst Interview Questions
- Merilytics Data Engineer Interview Questions
- Merilytics Analyst Interview Questions
- Merilytics Senior Technical Associate Interview Questions
- Merilytics IT Analyst Interview Questions
- Merilytics Senior Analyst Interview Questions
- Show more
Overall Interview Experience Rating
based on 1 interview experience
Difficulty level
Duration
Interview Questions from Similar Companies
|
Senior Business Analyst
153
salaries
|  ₹6.6 L/yr - ₹11 L/yr |
|
Business Associate
133
salaries
| ₹9 L/yr - ₹14.8 L/yr |
|
Business Analyst
85
salaries
| ₹5 L/yr - ₹10 L/yr |
|
Senior Technical Associate
73
salaries
| ₹5 L/yr - ₹10.4 L/yr |
|
Senior Analyst
68
salaries
| ₹4 L/yr - ₹14 L/yr |
Markets and Markets
Ascent Business Solutions
LogixHealth
Coronis Health
- Home >
- Interviews >
- Merilytics Interview Questions
