AstraZeneca Patient Safety Specialist Interview Questions and Answers

Logical reasoning numerical English sum

Python power bi sql tablue

Q1. Coding questions on python
Add your answer
Q2. Version control system GitHub questions
Add your answer
Q3. Web scraping questions
Add your answer

Q1. Behavioral questions on senarioy
Add your answer

Q1. Do you know adobe analytics
Ans. 
Yes, I am familiar with Adobe Analytics and have experience using it for data analysis.
• I have used Adobe Analytics to track website traffic and user behavior

• I have created custom reports and dashboards using Adobe Analytics

• I am proficient in extracting insights from Adobe Analytics data to drive business decisions
Answered by AI
Add your answer
Q2. Explain example of window function
Ans. 
Window functions are used to perform calculations across a set of table rows related to the current row.
• Window functions are applied to a set of rows related to the current row in a query result.

• They can be used to calculate running totals, averages, ranks, and more.

• Examples include ROW_NUMBER(), RANK(), DENSE_RANK(), and NTILE().
Answered by AI
Add your answer

Q1. Explain example of window function
Ans. 
Window functions are used to perform calculations across a set of table rows related to the current row.
• Window functions are used in SQL to perform calculations within a specific window or subset of rows.

• They allow you to perform aggregate functions like SUM, AVG, COUNT, etc. over a specific range of rows.

• Examples include ROW_NUMBER(), RANK(), DENSE_RANK(), and NTILE().
Answered by AI
Add your answer
Q2. A question using aggregate function and case when in sql
Add your answer

Q1. Basic introduction with HR on call
Add your answer

Q1. Technical questions with respect to SQL and SAS, complexity was easy to medium.
Add your answer

Q1. Manager asked during the final round regarding the job, your motivation to join the company, and about my role in previous organization.
Add your answer

Q1. Questions related to Data analytics and SharePoint for my role.
Add your answer
Q2. Previous projects and their solutions.
Add your answer
Q3. Tool used in previous company. (SharePoint, Power BI, Nintex, InfoPath, Power Apps, Workflows)
Add your answer

Q1. Related to professional life and assurance to work.
Add your answer

Q1. Salary details and candidature check.
Add your answer

Q1. Tell me about your experiences
Ans. 
I have experience working as a data analyst in various industries, utilizing statistical analysis and data visualization tools.
• Worked as a data analyst at XYZ Company, analyzing sales data to identify trends and make recommendations for improvement

• Utilized SQL and Python to extract and manipulate data from databases

• Created interactive dashboards using Tableau to present findings to stakeholders

• Performed A/B testing to ...read more
Answered by AI
Add your answer
Q2. What is the one thing that eli lilly has as a pharmaceutical brand
Add your answer