AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
PharmEasy Lead Analyst Interview Questions and Answers
PharmEasy Lead Analyst Interview Experiences
1 interview found
Anonymous
Selected
I applied via Referral and was interviewed before Aug 2023. There were 2 interview rounds.
(2 Questions)
- Q1. Running sum of numbers
- Ans.
Running sum of numbers is a cumulative sum of elements in an array.
Iterate through the array and keep adding the current element to the running sum.
Store the running sum at each index in a new array.
Example: Input array [1, 2, 3, 4], Running sum array [1, 3, 6, 10].
- Q2. Output of inner, left , outer joins
- Ans.
Inner join returns only matching rows, left join returns all rows from left table and matching rows from right table, outer join returns all rows from both tables
Inner join: Returns rows that have matching values in both tables
Left join: Returns all rows from the left table and the matched rows from the right table
Outer join: Returns all rows when there is a match in either left or right table
Questions about drop in conversion rate
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
I applied via campus placement at Nitte Meenakshi Institute of Technology, Bangalore and was interviewed in Nov 2024. There were 4 interview rounds.
Questions from arrays and strings and some aptitude questions
(2 Questions)
- Q1. How to merge 2 csv files
- Ans.
To merge two CSV files, you can use software like Microsoft Excel or programming languages like Python.
Open both CSV files in a software like Microsoft Excel.
Copy the data from one CSV file and paste it into the other CSV file.
Save the merged CSV file with a new name.
Alternatively, you can use programming languages like Python to merge CSV files by reading both files, combining the data, and writing to a new file.
- Q2. Basic questions on arrays
(1 Question)
- Q1. 3 reasons why u choose this company
- Ans.
I applied to this company because of its reputation in the industry, opportunities for growth, and company culture.
Reputation in the industry - I have heard great things about the company's innovative projects and successful track record.
Opportunities for growth - The company offers various training programs and career advancement opportunities for employees.
Company culture - I value a positive work environment and the...
(1 Question)
- Q1. Questions on python
Skills evaluated in this interview
I applied via Campus Placement and was interviewed in Oct 2024. There were 3 interview rounds.
It was based on 4 sql questions of medium to hard level and 24 mcqs based on sql,aptitude,excel.
(1 Question)
- Q1. They give you some questions and you have to write sql queries for them
(1 Question)
- Q1. You are given case study and come sql questions based on that
I applied via LinkedIn and was interviewed in Aug 2024. There were 2 interview rounds.
Technical + Analytics
I gave my coding test this august 2024, it was purely based on SQL coding
8 question, 3 easy, 3 intermediate and 3 hard.
(2 Questions)
- Q1. Introduction and explain any one of the projects plus what was the analytics you used
- Ans.
Implemented a project to optimize marketing campaigns using predictive analytics
Developed a predictive model to identify the most effective marketing channels
Utilized data from past campaigns to train the model
Used techniques such as regression analysis and decision trees to analyze the data
Generated insights on customer behavior and preferences to improve campaign targeting
- Q2. SQL coding, shared screen and was asked to find cumulative sum of cost for a table.
Interview Preparation Tips
I applied via Referral and was interviewed in Jun 2024. There were 2 interview rounds.
(2 Questions)
- Q1. Case study questions based on Logistics & Porter business.
- Q2. More Case study & porter business questions
(2 Questions)
- Q1. Some medium SQL Queries
- Q2. Some medium python codes
(1 Question)
- Q1. SQL based questions were asked on Group by, Window functions
The interview was good mostly on SQL, and Python
(1 Question)
- Q1. Sql questions on advanced concepts
(1 Question)
- Q1. Previous experience and business questions
varun garg
(2 Questions)
- Q1. SQL query writing
- Q2. Discussion on resume projects
shashwat sinha
Data structure and Algorithm problems.
Selected
I applied via LinkedIn and was interviewed in Apr 2024. There was 1 interview round.
(2 Questions)
- Q1. SQL base Question
- Q2. About your projects
PharmEasy Interview FAQs
Tell us how to improve this page.
PharmEasy Interviews By Designations
- PharmEasy Software Engineer Interview Questions
- PharmEasy Pharmacist Interview Questions
- PharmEasy Category Executive Interview Questions
- PharmEasy Customer Delight Officer Interview Questions
- PharmEasy Data Analyst Interview Questions
- PharmEasy Data Entry Operator Interview Questions
- PharmEasy Executive Engineer Interview Questions
- PharmEasy Executive Pharmacist Interview Questions
- Show more
Interview Questions for Popular Designations
PharmEasy Lead Analyst Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
|
Pharmacist
286
salaries
|  ₹1.2 L/yr - ₹4.5 L/yr |
|
Assistant Manager
178
salaries
| ₹3.5 L/yr - ₹13 L/yr |
|
Customer Delight Officer
150
salaries
| ₹2 L/yr - ₹4 L/yr |
|
Senior Executive
114
salaries
| ₹2.6 L/yr - ₹8.1 L/yr |
|
Senior Software Engineer
88
salaries
| ₹17 L/yr - ₹32 L/yr |
Medlife
Tata 1mg
Netmeds.com
Practo
- Home >
- Interviews >
- PharmEasy Interview Questions >
- PharmEasy Lead Analyst Interview Questions
