Stonex Senior Business Analyst Interview Questions and Answers

Q1. Questions on sql joins and window functions.
Add your answer
Q2. Window functions
Add your answer

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

Q1. Normal verification
Add your answer

Q1. Questions related to sql
Add your answer
Q2. Windows function in sql
Ans. 
The Windows function in SQL is used to perform calculations on a specific subset of rows in a result set.
• The Windows function is used with the OVER clause to define the subset of rows to perform calculations on.

• Common Windows functions include ROW_NUMBER, RANK, DENSE_RANK, and NTILE.

• Example: SELECT ROW_NUMBER() OVER (PARTITION BY department ORDER BY salary DESC) AS row_num FROM employees;
Answered by AI
Add your answer

Q1. Interview with stakeholders
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. Around advance sql, mostly windows function use case and some scenario based sql problem which will require windows function to solve.
Ans. Lead lag function and rank function
Answered Anonymously
Add your answer

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