MSD Pharmaceuticals Senior Business Analyst Interview Questions and Answers

Q1. What are the basics of power bi
Ans. 
Power BI is a business analytics tool by Microsoft for visualizing and analyzing data.
• Power BI is a business analytics tool by Microsoft

• It allows users to visualize and analyze data from various sources

• Users can create interactive reports and dashboards

• Power BI offers a wide range of data connectors for seamless integration

• It provides features like data modeling, data preparation, and data visualization

• Power BI can be ...read more
Answered by AI
Add your answer

Q1. What is lamda function
Ans. 
Lambda function is an anonymous function in programming that can have multiple arguments but can only have one expression.
• Lambda functions are used for creating small, one-time use functions without the need to define a formal function.

• They are often used in functional programming languages like Python.

• Lambda functions can take any number of arguments, but can only have one expression.

• Example: lambda x: x*2 defines a l
Answered by AI
Add your answer
Q2. Difference between list and tuple
Ans. 
List is mutable, tuple is immutable in Python.
• List can be modified after creation, tuple cannot.

• List uses square brackets [], tuple uses parentheses ().

• List is used for collections of items that may change, tuple for fixed collections.

• Example: list_example = [1, 2, 3], tuple_example = (4, 5, 6)
Answered by AI
Add your answer

Q1. Explain your previous work experience
Add your answer
Q2. Explain with example how your work related to real life example
Add your answer

Q1. What is autoclave temperature range ? can we keep different sterilization temperature ? What you handled in previous company and how ? What is sterilization process ? which Biological indicator used in St...read more
Add your answer

Q1. Discussed about my personal things and previous company experience and CTC
Add your answer

Forecast model

Q1. General discussion about career progression and work handled in last company
Add your answer

Q1. Discussion with hiring manager
Add your answer
Q2. What is your career goal ?
Ans. 
To become a technical leader in software engineering, contributing to innovative projects and mentoring junior engineers.
• To continuously enhance my technical skills and stay updated with the latest technologies.

• To lead and deliver complex software projects successfully.

• To mentor and guide junior engineers, fostering their growth and development.

• To contribute to the development of innovative and impactful software solut...read more
Answered by AI
View 1 more answer

Q1. Behaviour questions on cloud hosting
Add your answer
Q2. How will you implement secure cloud deployments
Ans. 
Secure cloud deployments can be implemented through various measures such as encryption, access control, and regular security audits.
• Implement encryption for data at rest and in transit

• Use access control mechanisms to restrict unauthorized access

• Regularly conduct security audits to identify and address vulnerabilities

• Implement multi-factor authentication for added security

• Ensure compliance with industry standards and r...read more
Answered by AI
View 1 more answer

Q1. How will you troubleshoot 500 internal server error
Ans. 
Check server logs, review code, test endpoints, and verify database connections.
• Check server logs for error messages

• Review code for syntax errors or logical mistakes

• Test endpoints using tools like Postman or cURL

• Verify database connections and credentials

• Check for any recent changes or updates

• Consider scaling issues or server overload

• Consult with team members or experts if necessary
Answered by AI
View 1 more answer

Q1. What is your next career goals ?
Ans. 
My next career goal is to become a technical lead and mentor junior engineers.
• I want to take on more leadership responsibilities and guide a team towards success.

• I plan to enhance my skills in project management and communication.

• I aim to contribute to the growth and development of the organization.

• I aspire to continuously learn and stay updated with the latest technologies and industry trends.
Answered by AI
Add your answer

Q1. Data management
Add your answer
Q2. Excel pivot, Vlookup
Add your answer

Q1. About Sql, project and work we did
Add your answer