AstraZeneca Associate Analyst Interview Questions and Answers

Q1. Difference between List and Tuple?
Ans. 
List is mutable, Tuple is immutable in Python.
• List can be modified after creation, Tuple cannot be modified

• List is defined using square brackets [], Tuple is defined using parentheses ()

• Example: list_example = [1, 2, 3], tuple_example = (4, 5, 6)
Answered by AI
Add your answer
Q2. Define a sales forecasting approach?
Ans. 
Sales forecasting approach is a method used to predict future sales based on historical data and market trends.
• Sales forecasting can be done using quantitative methods like time series analysis or qualitative methods like expert opinion.

• It involves analyzing past sales data, market trends, and other relevant factors to predict future sales.

• Different approaches include moving average method, exponential smoothing, regre...read more
Answered by AI
Add your answer

SQL and 2 coding questions

The first round had aptitude,logical reasoning questions. There were three coding question of which I remember Jump Game IV.

Q1. They started off with a brief introduction of myself and then asked questions regarding my projects.And this went on - mainly based on projects.
Add your answer

Sql coding + project discussion

Q1. Share your excel experience
Ans. 
Proficient in Excel with experience in data analysis, pivot tables, and VLOOKUP functions.
• Experience in creating complex formulas and macros to automate tasks

• Skilled in data visualization using charts and graphs

• Familiar with advanced functions such as INDEX-MATCH and conditional formatting
Answered by AI
Add your answer
Q2. How will you resolve conflict
Ans. 
I will address conflicts by actively listening, understanding all perspectives, and facilitating open communication to find a mutually beneficial solution.
• Actively listen to all parties involved to understand their perspectives

• Encourage open communication and dialogue to address underlying issues

• Seek common ground and find a mutually beneficial solution

• Mediate discussions and facilitate conflict resolution

• Use problem-s
Answered by AI
Add your answer

Q1. Questions were asked from excel and sql .
Add your answer

Q1. Basic to advance sql related
Add your answer

Market Entry Case Study - Asking to decide which product to choose for market entry

Q1. Be thorough with your resume and be attentive
Add your answer
Q2. Do an SWOT analysis between Chennai and Banglore
Ans. 
SWOT analysis between Chennai and Bangalore
• Strengths of Chennai: Rich cultural heritage, affordable cost of living, well-connected transport system

• Weaknesses of Chennai: Poor infrastructure, water scarcity, high pollution levels

• Opportunities for Chennai: Growing IT sector, increasing tourism, potential for development in real estate

• Threats for Chennai: Competition from other cities, natural disasters like floods and cy...read more
Answered by AI
Add your answer

Q1. General HR Questions
Add your answer