Porter 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 Answer
• Q2. 2 SQL questions. 1. based on logic 2nd highest salary. 2. Basic Question on window functions and self join
  Add Answer

• Q1. RCA on why the conversion is down on the app.
  Add 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...read more
  Add Answer

SQL and Tableau were asked. 4 questions each.

Case study was asked related to covid

• Q1. Around advance sql, mostly windows function use case and some scenario based sql problem which will require windows function to solve.
  View Answers (1)

It's a general case study round, motive is to know your thought process.

• Q1. Questions on SQL joins, window functions etc.
  Add Answer

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

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

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

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