BETA CAE Systems Interview Questions and Answers

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. What are Agile Values? Scrum Values? Scrum Ceremonies? Story Points?
Ans. 
Agile values include individuals and interactions over processes and tools, while Scrum values include commitment, courage, focus, openness, and respect.
• Agile values prioritize individuals and interactions over processes and tools

• Scrum values include commitment, courage, focus, openness, and respect

• Scrum ceremonies include Sprint Planning, Daily Standup, Sprint Review, and Sprint Retrospective

• Story points are a unit of...read more
Answered by AI
Add your answer
Q2. As project manager what docs do you prepare? How do you contribute as a PM?
Ans. 
As a project manager, I prepare various documents such as project plans, schedules, budgets, risk assessments, and progress reports. I contribute by leading the team, managing resources, and ensuring project success.
• Prepare project plans outlining scope, objectives, deliverables, and timelines

• Create schedules to allocate tasks and track progress

• Develop budgets to manage project costs effectively

• Conduct risk assessments...read more
Answered by AI
Add your answer
Q3. Capacity? Velocity? etc Agile/Scrum-based questions (bookish) this round was taken by Rajni
Add your answer

Q1. Megha took my final round and asked me questions about Agile/Scrum, Stroy Points (estimation).
Add your answer
Q2. Ques on explaining Sprint Planning, Retro, Review, using Doc/Excel (screen sharing)
Add your answer
Q3. Ques on Conflict and Resource Management, some scenario-based question.
Add your answer
Q4. How will you make a low-performing resource a high-performing one?
Ans. 
Provide clear expectations, offer support and training, provide feedback and recognition, set goals and milestones.
• Clearly communicate expectations and goals to the resource.

• Offer support and training to help the resource improve their skills and knowledge.

• Provide regular feedback and recognition for progress made.

• Set specific goals and milestones to track improvement.

• Create a development plan with the resource to addr...read more
Answered by AI
Add your answer
Q5. Megha did not hire me because she felt I had adequate knowledge and practical experience. (insecurities) Anyway, good luck with your interview.
Add your answer
Q6. What is Scrum of Scrums? What is PI planning?
Ans. 
Scrum of Scrums is a scaled agile framework where multiple Scrum teams coordinate their work. PI planning is a key event in SAFe where teams plan their work for the upcoming Program Increment.
• Scrum of Scrums involves representatives from each Scrum team meeting regularly to discuss dependencies and progress.

• PI planning is a two-day event where teams align on their objectives, dependencies, and priorities for the upcomi...read more
Answered by AI
Add your answer

Pretty standard GD on topics around working remotely and country's macroeconomic

Q1. Derivative Knowledge Check
Add your answer
Q2. Alternate Investment Knowledge Check
Add your answer

Q1. Scenario Based and financial instrument level
Add your answer
Q2. Deep dive into derivative and alternative investment
Ans. 
Derivative and alternative investments involve complex financial instruments and strategies beyond traditional stocks and bonds.
• Derivatives are financial contracts whose value is derived from an underlying asset, index, or rate. Examples include options, futures, and swaps.

• Alternative investments are non-traditional assets such as private equity, hedge funds, real estate, and commodities.

• Both derivative and alternative...read more
Answered by AI
Add your answer

Q1. General HR Question
Add your answer
Q2. Strength and Weakness
Add your answer

Q1. Tell me about yourself
Add your answer
Q2. What are your reasons for wanting to join our organization?
Add your answer

Q1. Basic networking questions
Add your answer
Q2. Operating system level questions Linux and windows installation and troubleshooting
Add your answer
Q3. Motherboard related many questions
Add your answer

Q1. Project related question
Add your answer

Q1. Scenario based question
Add your answer

Q1. Salary discussion
Add your answer

Q1. WHAT IS PANDAS LIBRARY
Add your answer
Q2. HOW TO DO DATA WRANGLING IN PYTHON
Add your answer

Q1. What was your contribution towards lead time improvement?
Ans. 
I implemented process improvements and streamlined workflows to reduce lead times by 20%.
• Analyzed current processes to identify bottlenecks

• Implemented automation tools to speed up tasks

• Trained team members on efficient time management techniques

• Collaborated with suppliers to optimize supply chain logistics
Answered by AI
Add your answer

Q1. How have you been able to successfully handle difficult stakeholders? Pls provide an example / case study
Ans. 
I have successfully handled difficult stakeholders by actively listening, addressing concerns, and finding common ground.
• Active listening to understand their concerns and perspectives

• Addressing their concerns with empathy and professionalism

• Finding common ground and working towards a mutually beneficial solution
Answered by AI
Add your answer

Q1. How do we improve lead time in fulfillment
Ans. 
Improving lead time in fulfillment involves optimizing processes, reducing bottlenecks, and enhancing communication.
• Implementing lean manufacturing principles to streamline operations

• Utilizing technology such as automation and inventory management systems

• Improving forecasting accuracy to better anticipate demand

• Enhancing communication between departments to reduce delays

• Regularly reviewing and optimizing the supply cha
Answered by AI
Add your answer

Q1. How have you been able to effectively improve the ER campaigns?
Ans. 
I have improved ER campaigns by analyzing data, implementing targeted strategies, and collaborating with cross-functional teams.
• Analyzed data to identify trends and areas for improvement

• Implemented targeted strategies based on data analysis

• Collaborated with cross-functional teams to ensure campaign success
Answered by AI
Add your answer

Q1. Overall summary with challenges and solutions towards the hurdles in improvement of recruitment process
Add your answer

Q1. What is vlookup?
Ans. 
VLOOKUP is a function in Excel used to search for a value in a table and return a corresponding value from another column.
• VLOOKUP stands for 'vertical lookup'

• It is commonly used in Excel to search for a value in the leftmost column of a table and return a value in the same row from a specified column

• Syntax: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

• Example: =VLOOKUP(A2, B2:D10, 3, FALSE) - searc...read more
Answered by AI
Add your answer
Q2. What do you know about us health care?
Add your answer

Q1. What is the difference between vlookup and index match?
Ans. 
VLOOKUP searches for a value in the first column of a range and returns a value in the same row. INDEX MATCH is more flexible and can search in any column.
• VLOOKUP searches vertically in a table and returns a value from the same row.

• INDEX MATCH can search horizontally or vertically and is more versatile.

• VLOOKUP requires the lookup value to be in the first column of the table.

• INDEX MATCH can search for the lookup value i...read more
Answered by AI
Add your answer
Q2. Us health care domain specific questions?
Add your answer

Q1. Questions on commitment towards the company, general team behaviour and typical scenario based questions to test your emotional intelligence?
Add your answer
Q2. Sallery discussion
Add your answer

Q1. Spring framework related questions
Add your answer
Q2. Angular related question, questions were of easy to medium level.
Add your answer
Q3. A hands on coding questions on DSA
Add your answer