Polestar Solutions & Services India Senior Analyst Interview Questions and Answers

Q1. How do you go about SDLC process
Ans. 
I follow the Software Development Life Cycle (SDLC) process to ensure successful project delivery.
• I start with requirements gathering and analysis to understand the project scope and objectives.

• I then move on to design, where I create a detailed plan for how the system will be built.

• Next, I proceed to development, where the actual coding and implementation of the system takes place.

• After development, I conduct thorough...read more
Answered by AI
Add your answer
Q2. What are roles and responsibilities of a BA
Add your answer
Q3. How do you deduce a complex problem statement
Ans. 
By breaking down the problem into smaller components and analyzing each part individually
• Identify the key components of the problem statement

• Break down the problem into smaller, more manageable parts

• Analyze each part individually to understand its impact on the overall problem

• Consider different perspectives and potential solutions

• Collaborate with team members or stakeholders to gain additional insights
Answered by AI
Add your answer

Q1. Explain the difference between BRD and FRD
Ans. 
BRD is a document that outlines business requirements, while FRD is a document that details functional requirements.
• BRD focuses on what the business needs, while FRD focuses on how those needs will be met.

• BRD is high-level and non-technical, while FRD is detailed and technical.

• BRD is created before FRD in the project lifecycle.

• Example: BRD may state the need for a customer relationship management system, while FRD will...read more
Answered by AI
Add your answer
Q2. How do you go about creating user stories, how do you allocate the points
Ans. 
User stories are created by collaborating with stakeholders and allocating points based on complexity and effort required.
• Collaborate with stakeholders to gather requirements and understand user needs

• Break down features into smaller, manageable user stories

• Prioritize user stories based on business value and dependencies

• Allocate points based on complexity, effort, and risk involved

• Use techniques like Planning Poker to a
Answered by AI
Add your answer
Q3. What is the SOP while creating a requirement gathering doc
Ans. 
The SOP for creating a requirement gathering doc involves planning, interviewing stakeholders, documenting requirements, and obtaining approval.
• Plan the requirement gathering process by identifying stakeholders and their needs

• Conduct interviews with stakeholders to gather detailed requirements

• Document the requirements in a clear and organized manner

• Obtain approval from stakeholders to ensure alignment with business goa
Answered by AI
Add your answer

Q1. How proficient are you with using tools such as Jira, Cofluence, SQL
Ans. 
I am highly proficient in using Jira, Confluence, and SQL for various business analysis tasks.
• I have extensive experience using Jira for project management, issue tracking, and agile development.

• I am skilled in using Confluence for documentation, collaboration, and knowledge sharing within teams.

• I have strong SQL skills for data analysis, querying databases, and generating reports.

• I have used these tools in previous pr...read more
Answered by AI
Add your answer
Q2. How do you handle disagreements within internal stakeholders
Add your answer
Q3. What values do you look in a collegue
Ans. 
I look for values such as integrity, teamwork, communication, and adaptability in a colleague.
• Integrity - honesty, trustworthiness, and ethical behavior

• Teamwork - collaboration, support, and willingness to help others

• Communication - clear and effective communication skills

• Adaptability - ability to adjust to changing circumstances and problem-solve
Answered by AI
Add your answer

Q1. Coalesce, SQL Order of Execution
Add your answer
Q2. Given a table with fields(id, name, salary, managerId) find out the managers who have atleast 5 reportees under him/her.
Ans. 
Use SQL query to count number of reportees for each manager and filter out those with atleast 5 reportees.
• Write a SQL query to count number of reportees for each manager using GROUP BY clause

• Add HAVING clause to filter out managers with atleast 5 reportees

• Example: SELECT managerId, COUNT(id) AS num_reportees FROM table_name GROUP BY managerId HAVING num_reportees >= 5
Answered by AI
Add your answer
Q3. How to manage large datasets in python
Ans. 
Use libraries like pandas and dask to efficiently manage large datasets in Python.
• Use pandas library for data manipulation and analysis.

• Use dask library for parallel computing and out-of-core processing.

• Optimize memory usage by loading data in chunks or using data types efficiently.

• Consider using cloud services like AWS S3 or Google BigQuery for storing and processing large datasets.
Answered by AI
Add your answer
Q4. Name few of the commonly used python libraries used by DA
Ans. 
Some commonly used Python libraries for Data Analysts are Pandas, NumPy, Matplotlib, and Scikit-learn.
• Pandas - used for data manipulation and analysis

• NumPy - used for numerical computing and working with arrays

• Matplotlib - used for data visualization

• Scikit-learn - used for machine learning and data mining
Answered by AI
Add your answer

We have given 12 puzzles on hackerearth based on probability and statistics and have to solve in 45 minutes

Q1. There is a biased dice with the probability of 1 and 2 is 25% each. Find the probability of even number.
Ans. 
The probability of rolling an even number on a biased dice with 25% chance for 1 and 2 is 50%.
• The biased dice has a 25% chance for rolling a 1 and a 25% chance for rolling a 2, totaling 50% for odd numbers.

• Since there are only two odd numbers on a dice (1 and 2), the probability of rolling an even number is 50%.

• The probability of rolling an even number on a standard dice is 50% as well, since there are 3 even numbers o
Answered by AI
Add your answer
Q2. What is the pdf and pmf?
Ans. 
PDF stands for Probability Density Function and PMF stands for Probability Mass Function.
• PDF is used for continuous random variables while PMF is used for discrete random variables.

• PDF represents the probability distribution of a continuous random variable.

• PMF represents the probability distribution of a discrete random variable.

• Example: PDF can be used to calculate the probability of a random variable falling within a...read more
Answered by AI
Add your answer

Q1. SQL ,PLSQL, ETL
Add your answer

Q1. Related to Role and CV
Add your answer

Q1. With the client. Current roles and responsibility and technical.
Add your answer

Q1. Introduce yourself and ask the skills and technologies which i presented in the resume.
Add your answer
Q2. Basics of Java and other related concepts
Add your answer

Q1. Introduce yourself and salary discussions.
Add your answer