Cloudaeon 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

Q1. Questions were based QMS & ISMS and past experience
Add your answer

Q1. Discussed about past experience
Add your answer

Q1. Scenario based leadership questions
Add your answer
Q2. Revenue, margin, leadership skills
Add your answer
Q3. Conflict management, stakeholder management
Add your answer

Q1. Portfolio management
Add your answer
Q2. CI CD pipeline based questions, some other technical questions
Add your answer
Q3. Stakeholder management, project metrics, leadership, team upskilling, resource management, risk management
Add your answer

Q1. Solution architecture questions scenario based
Add your answer
Q2. DR activity scenario based questions
Add your answer

Q1. Cultural fit related
Add your answer
Q2. Leadership and team handling related questions
Add your answer

Q1. Behavior, worst personality, useless manager
Add your answer
Q2. Always keeping eyes on girls one of the worst manager
Add your answer

Q1. Questions about kubernetes and 5gc
Add your answer
Q2. Containers and implementation of pods for 5gc
Add your answer

Q1. Previous company and package negotiation
Add your answer

1 python question and 1 sql question for coding and rest were the mcqs based on sql and python.

Q1. Python code was asked for checking the anagrams
Add your answer
Q2. Sql code asked to solve on screen share using various use cases like group by, having, count
Add your answer

Q1. Python code was asked for swaping any number but without using python libraries
Add your answer
Q2. Sql code was asked using concepts of rank dense,rank, partition by
Add your answer