Pennant Technologies Senior Business Analyst Interview Questions and Answers

Q1. SQL and domain - Use case scenarios and real time examples
Ans. 
SQL is used in various domains for data analysis and reporting. Use cases include financial analysis, inventory management, and customer relationship management.
• Financial analysis - using SQL to analyze revenue, expenses, and profitability

• Inventory management - tracking stock levels, orders, and shipments

• Customer relationship management - analyzing customer data, preferences, and interactions
Answered by AI
Add your answer
Q2. SQL questions and domain related questions.
Add your answer

Normal Question, about yourself. About previous job

Q1. What are your roles and responsibilities as a business analyst
Add your answer
Q2. What projects have you worked on?
Add your answer
Q3. Scenario based questions
Add your answer
Q4. Analytical Questions
Add your answer
Q5. Write a user story
Ans. 
As a user, I want to be able to search for products by category so that I can easily find what I need.
• User can select a category from a dropdown menu

• User can see a list of products within the selected category

• User can filter the products by price or other attributes
Answered by AI
Add your answer

Q1. What are your goals and aspirations
Add your answer
Q2. What does your day look like at your company
Add your answer
Q3. What are your expectations from your next company
Add your answer

Sql, Python mcq test

Q1. Joins, Rank Dense Rank Rownumber, Window Function, Query to find 2nd highest salary
Add your answer

Q1. Why do you want to change job
Ans. 
Seeking new challenges and growth opportunities in a dynamic environment.
• Looking for new challenges and opportunities for growth

• Interested in working in a more dynamic environment

• Seeking a change to further develop my skills and knowledge
Answered by AI
Add your answer
Q2. See yourself in 5yrs
Ans. 
In 5 years, I see myself as a seasoned Business Analyst leading cross-functional teams to drive strategic initiatives and deliver impactful solutions.
• Leading cross-functional teams to drive strategic initiatives

• Delivering impactful solutions to meet business objectives

• Continuing professional development to stay current with industry trends
Answered by AI
Add your answer

1 hour test - Verbal, Quants, Logical Reasoning and Data analysis. Some aptitude questions.

Q1. What does a sales process look like in B2B?
Ans. 
A sales process in B2B involves identifying prospects, building relationships, presenting solutions, negotiating contracts, and closing deals.
• Identify and qualify potential leads

• Build relationships through networking and referrals

• Present solutions tailored to the prospect's needs

• Negotiate contract terms and pricing

• Close the deal and ensure customer satisfaction

• Follow up for repeat business and referrals
Answered by AI
Add your answer