North American Tech Company Business Analyst Interview Experience Share

Behavorial Questions

1. Introduce yourself
2. Why company?
3. What strength can you bring to this role?
4. Tell me about a time when you didn’t have enough data to make the right decision.
5. Tell me about a time when you took on something outside your area of responsibility.
6. Tell me about a time when you went above and beyond for a customer.
7. Tell me about a situation that required you to dig deep to get to the root cause.
8. Tell me about a time when you’ve had to push back to a customer request.
9. Tell me about a time when you were not able to meet a commitment.
10. Tell me about a time when you thought differently to improve a process that was working.
11. Describe a time when you influenced and drove new thinking and innovation out of your team.
12. Describe a time when you needed to influence a peer who had different opinion about a shared goal
13. Tell me about a time when you uncovered a significant problem in your team.

SQL Conceptual Questions

1. What are JOIN function, what are the differences between JOINS, make examples.
2. What are WHERE, GROUP BY, HAVING, how will you use them.
3. What are window functions, differences between RANK, DENSE_RANK, and ROW_NUMBER

SQL Coding Questions (EASY/MEDIUM)

1. Find how many employees joined in this company during year.
2. Find the second highest salary.
3. Find the employees who were in company but do not have a building number. (Use JOIN)
4. Use IFNULL to handle missing values
5. Questions related to experience and concepts of Tableau, Excel, and Python, such as VLOOKUP, pivot tables, and macros.