Anywho, Basic Intro + 4 SQL Questions on Gsheets + Small Case Study. q1> output of left join q2> table n1 - 1 2 3 4 5 , generater output 1 2 2 3 3 3 4 4 4 4 5 5 5 5 5 and so on q3> dates which had the max no of employees on a payroll q4> cheapest cost between 2 travel destination if we are willing to take 1 stop Case Study - RCA for sudden 15% drop in cart to proceed to payment CTR (conversion), comparing today vs same time last week, with rest of the funnel behaving normally
Standard product sense and testing questions, though none of them related to Postman's product.
Tell me a time you demonstrated analysis on a population.
Standard Questions
What do you know about Lyst and why do you want to work here?
Most questions were behavirial like tell me of a time when you handled a difficult project? What tools have you used as a BA/Project Manager? Have you supervised people and how would you feel working in an enviroment that you don't supervise anyone. How do you work in a team environment? Difficult task that you have been able to accomplish? And what are your goals in the next five years? What project management methodology have you used in the past?
Would you accept to work on small projects before the main project comes in the pipeline
Write a query to fetch the top 3 customers having the maximum spends with the AMEX card in the month of February for a given year.
How to measure the effectiveness of a content asset?
UX/ Product experience and Agile SDLC experience. Product mindset
Viewing 111 - 120 interview questions