AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Merilytics
Compare
Filter interviews by
Merilytics Interview Questions and Answers
26 Interview questions
The Frog Jump problem involves calculating the minimum cost to reach the last stone using dynamic programming.
Define the problem: A frog can jump 1 or 2 stones at a time, and each stone has a cost.
Use dynamic programming to store the minimum cost to reach each stone.
Base cases: Cost to reach the first stone is 0, and the cost to reach the second stone is the cost of the second stone.
Recurrence relation: Cost[i] = ...
Remove zeroes from a numbers only string and insert at last while maintaining relative order.
Iterate through the string and separate numbers and zeroes
Store numbers in an array and zeroes in a separate array
Concatenate the numbers array with the zeroes array at the end
Understanding SQL joins is crucial for combining data from multiple tables effectively.
INNER JOIN: Returns records with matching values in both tables. Example: SELECT * FROM A INNER JOIN B ON A.id = B.id;
LEFT JOIN: Returns all records from the left table and matched records from the right table. Example: SELECT * FROM A LEFT JOIN B ON A.id = B.id;
RIGHT JOIN: Returns all records from the right table and matched re...
Analyze monthly order changes to determine the most efficient campaign among three options.
Compare the percentage increase in orders for each campaign. For example, if Campaign A had a 30% increase, Campaign B had 20%, and Campaign C had 50%, Campaign C is the most efficient.
Evaluate the cost per order for each campaign. If Campaign A spent $1000 for 100 orders ($10/order), while Campaign B spent $800 for 50 order...
Key performance indicators (KPIs) are essential for evaluating marketing campaign success and guiding future strategies.
Conversion Rate: Measures the percentage of users who take a desired action, e.g., signing up for a newsletter.
Customer Acquisition Cost (CAC): Total cost of acquiring a new customer, e.g., total marketing spend divided by new customers gained.
Return on Investment (ROI): Evaluates the profitabili...
Analyze customer spending data to identify the most effective campaign for onboarding high-spending customers.
Collect data on customer spending before and after each campaign.
Calculate the cost per acquisition (CPA) for each campaign to assess efficiency.
Identify the average spending of customers acquired through each campaign.
Compare the average spending of customers from different campaigns to find the best perf...
Merilytics HR Interview Questions
Snowpipe is a continuous data ingestion service provided by Snowflake for loading streaming data into tables.
Snowpipe allows for real-time data loading without the need for manual intervention.
It can load data from various sources such as Amazon S3, Azure Blob Storage, and Google Cloud Storage.
Snowpipe uses a queue-based architecture to process data as soon as it arrives.
SQL commands are instructions used to interact with databases to perform tasks such as querying, updating, and managing data.
SQL commands are used to perform various operations on databases, such as SELECT, INSERT, UPDATE, DELETE.
Examples of SQL commands include SELECT * FROM table_name, INSERT INTO table_name (column1, column2) VALUES (value1, value2), UPDATE table_name SET column1 = value1 WHERE condition, DELET...
Left join returns all records from the left table and the matched records from the right table, while right join returns all records from the right table and the matched records from the left table.
Left join keeps all records from the left table, even if there are no matches in the right table.
Right join keeps all records from the right table, even if there are no matches in the left table.
Example: If we have a ta...
My favorite programming language is Python because of its readability, versatility, and extensive libraries.
Python is known for its readability, making it easier to write and maintain code.
Python is versatile and can be used for web development, data analysis, machine learning, and more.
Python has a vast collection of libraries like NumPy, Pandas, and Matplotlib that make data manipulation and visualization easier...
Merilytics Interview Experiences
51 interviews found
Anonymous
Selected
I applied via Campus Placement
First round Aptitude + Technical questions on CS fundamentals
(3 Questions)
- Q1. Frog jump Dynamic programming question
- Ans.
The Frog Jump problem involves calculating the minimum cost to reach the last stone using dynamic programming.
Define the problem: A frog can jump 1 or 2 stones at a time, and each stone has a cost.
Use dynamic programming to store the minimum cost to reach each stone.
Base cases: Cost to reach the first stone is 0, and the cost to reach the second stone is the cost of the second stone.
Recurrence relation: Cost[i] = min(C...
- Q2. Remove zeroes from a numbers only string and insert at last also maintain the relative order
- Ans.
Remove zeroes from a numbers only string and insert at last while maintaining relative order.
Iterate through the string and separate numbers and zeroes
Store numbers in an array and zeroes in a separate array
Concatenate the numbers array with the zeroes array at the end
- Q3. One sql question on joins
Skills evaluated in this interview
I applied via Campus Placement and was interviewed in Aug 2024. There were 3 interview rounds.
15 mcqs aptitude for 15 min, then section closes, then 15 coding mcqs based on oops, java, python,dsa and very few about sql.
(1 Question)
- Q1. Asked about what projects i did , and asked me to explain briefly about them , Asked if i would be given an offer , would it be final, or even then would you be applying for jobs for other companies. Aske...
(1 Question)
- Q1. Few questions about python , gave me a string "abc-def-ghi" and asked me to split it into substrings and return the substrings, asked about lists, tuples, dictionaries, differences and comparison between t...
Interview Preparation Tips
for writing complex queries, SQL 50 on leetcode would suffice, also learn window functions properly and their implementation in queries.
Prashast Jaipurkar
I applied via Approached by Company and was interviewed in May 2024. There were 2 interview rounds.
(3 Questions)
- Q1. Case study on marketing campaigns. What should be the KPIs/metrics to track the performance of these campaigns?
- Ans.
Key performance indicators (KPIs) are essential for evaluating marketing campaign success and guiding future strategies.
Conversion Rate: Measures the percentage of users who take a desired action, e.g., signing up for a newsletter.
Customer Acquisition Cost (CAC): Total cost of acquiring a new customer, e.g., total marketing spend divided by new customers gained.
Return on Investment (ROI): Evaluates the profitability of...
- Q2. Given data around the change in monthly orders from 3 different campaigns, find out which campaign was most efficient.
- Ans.
Analyze monthly order changes to determine the most efficient campaign among three options.
Compare the percentage increase in orders for each campaign. For example, if Campaign A had a 30% increase, Campaign B had 20%, and Campaign C had 50%, Campaign C is the most efficient.
Evaluate the cost per order for each campaign. If Campaign A spent $1000 for 100 orders ($10/order), while Campaign B spent $800 for 50 orders ($1...
- Q3. Given data around change in customer spending and cost of each campaign, find out which campaign ended up onboarding best spending customers.
- Ans.
Analyze customer spending data to identify the most effective campaign for onboarding high-spending customers.
Collect data on customer spending before and after each campaign.
Calculate the cost per acquisition (CPA) for each campaign to assess efficiency.
Identify the average spending of customers acquired through each campaign.
Compare the average spending of customers from different campaigns to find the best performer...
Case study about a Electronic Rental company in entertainment industry. Profits are declining, what could be the reasons? Company is trying to liquidate older equipments. Given data around depreciation, what would be the total cost incurred?
Interview Preparation Tips
- Case Studies
- Resume
- Calculation
My advice would be to practice mathematical calculations and do ain of 5-6 case studies which involves number crunching.
CAT type questions - more questions, less time
(2 Questions)
- Q1. One guesstimate, one consulting case
- Q2. One analytical case
I applied via Campus Placement and was interviewed in Jul 2024. There were 3 interview rounds.
20 MINUTES 15 QUESTIONS OF DATA INTERPETRATION
(3 Questions)
- Q1. INTRODUCE YOURSELF
- Q2. WHY THIS ROLE ?
- Q3. SIMPLE CASE STUDY
(2 Questions)
- Q1. CASE STUDY HARD ONE
- Q2. DIFFERENT SITUATIONS IN THE SAME PROLEM
- Ans.
Analyzing different situations within the same problem allows for a comprehensive understanding and effective solutions.
Identify the various factors contributing to the problem
Consider how each factor interacts with the others
Evaluate potential solutions based on the different scenarios
Adjust strategies as needed based on the changing circumstances
Aptitude test contains of programming language and aptitude questions
(2 Questions)
- Q1. Tell us about yourself
- Q2. Which is your favourite programming language
(2 Questions)
- Q1. What are SQL commands
- Q2. Difference between left and right join
Skills evaluated in this interview
Selected
I appeared for an interview in Jan 2025, where I was asked the following questions.
- Q1. Case study regarding revenue growth
- Q2. Case study regarding upscaling of brand gross margins
Selected
I applied via Referral and was interviewed in May 2024. There were 2 interview rounds.
(2 Questions)
- Q1. What is your family
- Q2. Why did u leave
(2 Questions)
- Q1. Special about u
- Q2. Why to hire u
Selected
Pure aptitude questions, time will be definitely less comparatively but just do as many correct question you can.
Business Case Study question check calculations also.
Case study checking calculations and business understanding
I applied via Campus Placement
The test was around 20 minutes and asked DILR questions along with some quant
(1 Question)
- Q1. Best time to buy and sell stock- leetcode quesiton
Interview Preparation Tips
- DSA
Top trending discussions
Merilytics Interview FAQs
Some of the top questions asked at the Merilytics interview -
The duration of Merilytics interview process can vary, but typically it takes about less than 2 weeks to complete.
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
Interview Questions for Popular Designations
Overall Interview Experience Rating
based on 43 interview experiences
Difficulty level
Duration
Interview Questions from Similar Companies
Merilytics Reviews and Ratings
based on 161 reviews
Rating in categories
|
Senior Business Analyst
165
salaries
|  ₹7 L/yr - ₹11.5 L/yr |
|
Business Associate
134
salaries
| ₹9 L/yr - ₹14.6 L/yr |
|
Business Analyst
84
salaries
| ₹5 L/yr - ₹10 L/yr |
|
Senior Technical Associate
73
salaries
| ₹6.1 L/yr - ₹10.4 L/yr |
|
Manager
58
salaries
| ₹14.3 L/yr - ₹26 L/yr |
FinThrive
Markets and Markets
Ascent Business Solutions
LogixHealth
- Home >
- Interviews >
- Merilytics Interview Questions
