Novartis Healthcare Medical Education Executive Interview Questions and Answers

Q1. Asked about previous experiences
Add your answer

Knowledge and work experience

Q1. Process of aggregate in brief for all sections
Ans. 
Aggregate is the process of combining data from different sections into a single result.
• Aggregate functions are used to perform calculations on groups of rows to give a single result.

• Common aggregate functions include SUM, AVG, COUNT, MAX, and MIN.

• Aggregate queries often involve grouping data by certain criteria before applying the aggregate function.

• For example, calculating the total sales revenue by region or finding
Answered by AI
Add your answer

Q1. Initial with the recruiter
Add your answer
Q2. Brief about yourself and experience
Add your answer

Q1. Training development manager
Add your answer

Formal round of interview with the Operations manager

Q1. All about data warehouse, data lakes, management etc
Add your answer

Q1. Salary negotiation, managerial questions
Add your answer

General aptitude questions, 15 in number.

Q1. Explain about yourself
Add your answer
Q2. How do you know, you'll better suit the current opening in our org?
Add your answer

SWOT ANALYSIS OF A NEW PRODUCT IN THE MARKET

RESEARCH ASSIGNMENT ON THE TB SPACE

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