PharmEasy Senior Business Analyst Interview Questions and Answers

Duration was 45 min, Questions about business decisions, marketing campaigns

Hacker rank test with SQL questions

Design the database and write a query to find the most re-ordered product

Case study and technical round - database design questions and analytical thinking check

HR Related questions and market entry level case study

Q1. Going through your resume, past projects and metrics around that project.
Add your answer
Q2. 2 SQL questions. 1. based on logic 2nd highest salary. 2. Basic Question on window functions and self join
Add your answer

Q1. RCA on why the conversion is down on the app.
Add your answer
Q2. SQL question of high difficulty (don't remember the question as that was his self made question) Logic used: self join with date
Add your answer

Q1. 1.pivot function sql question 2.write a code in python to print out a triangle
Add your answer

SQL and Tableau were asked. 4 questions each.

Case study was asked related to covid

Q1. Questions on SQL joins, window functions etc.
Add your answer

Q1. Intermediate and Advanced SQL
Add your answer
Q2. Horse bridge Puzzle solving
Add your answer
Q3. Basic SQL involving joins
Add your answer

Q1. SQL questions based on specific scenarios. The scenarios were changed and the questions were modified at each level.
Add your answer

Q1. Asked basic SQL knowledge and optimization techniques.
Add your answer
Q2. Questions about current field of work
Add your answer

Q1. General questions to understand if i am fit for the company. More like having a talk with VP.
Add your answer