Add office photos
Filter interviews by
Novartis Analyst Interview Questions, Process, and Tips
Top Novartis Analyst Interview Questions and Answers
- Q1. A person has 3000 bananas and a camel. The person wants to transport the maximum number of bananas to a destination which is 1000 KMs away, using only the camel as a mode ...read more
- Q2. Does Alteryx give an option for data validation? Can you apply a tool that will stop the workflow from running to the next step if the data is incorrect?
- Q3. 8 spheres and 1 weighing scale. 1 sphere weighs differently from other 7. What is the minimum number of steps needed to identify the different sphere.
Novartis Analyst Interview Experiences
14 interviews found
Harsh Vaidya
Data on territory×HCP level sales. Questions on top performing territory, volume growth, share change, etc.
Another graph on Earnings vs Accomplished and questions on Incentive Compensation
(2 Questions)
- Q1. A person has 3000 bananas and a camel. The person wants to transport the maximum number of bananas to a destination which is 1000 KMs away, using only the camel as a mode of transportation. The camel canno...
- Q2. 8 spheres and 1 weighing scale. 1 sphere weighs differently from other 7. What is the minimum number of steps needed to identify the different sphere.
(2 Questions)
- Q1. On a scale of 1-10 how much would you rate yourself in Alteryx?
- Q2. Does Alteryx give an option for data validation? Can you apply a tool that will stop the workflow from running to the next step if the data is incorrect?
(5 Questions)
- Q1. Tell me about yourself.
- Q2. Explain in brief the projects you have worked on.
- Q3. If I am a layman to pharma analytics, how would you explain what MMX Modelling is?
- Q4. What projects have you worked on using Patient Level Data?
- Q5. Why are you leaving your current organization?
Anonymous
(1 Question)
- Q1. Basic to advance sql related
(1 Question)
- Q1. Questions were asked from excel and sql .
What people are saying about Novartis
(2 Questions)
- 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
- 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
Novartis interview questions for designations
Selected
(3 Questions)
- Q1. Difference between Epi based forecasting and non-Epi based forecasting.
- Q2. How to estimate market share with precision of a pipeline product. Different methodologies, their flaws and merits.
- Ans.
Estimating market share of a pipeline product involves using various methodologies with their own flaws and merits.
One common method is using sales data from competitors and industry reports to estimate market size and then calculate the product's share.
Another approach is conducting surveys or focus groups to gather customer feedback and preferences, which can help in estimating market share.
Using predictive modeling ...
- Q3. Tell about different databases you have worked on ? Questions related to that specific database.
Market Estimation Case Study is given which tests a candidate understanding of the Pharma market, his technical skills, his aptitude and patience.
(2 Questions)
- Q1. How do your previous collegaues gauge you? Postive and negative both.
- Ans.
My previous colleagues would likely gauge me as hardworking, reliable, and detail-oriented, but may also see me as overly focused on perfection.
Colleagues would likely appreciate my strong work ethic and dedication to completing tasks efficiently.
They may see me as reliable and someone they can depend on to deliver high-quality work consistently.
Some colleagues may view me as overly focused on perfection, which could p...
- Q2. What value did you add to your previous team ?
Interview Preparation Tips
Get interview-ready with Top Novartis Interview Questions
Selected
I applied via Approached by Company and was interviewed before Mar 2023. There were 3 interview rounds.
(1 Question)
- Q1. Solve the data query.
Solve and present the case study
(1 Question)
- Q1. Salary discussion
Analyst Jobs at Novartis
I applied via Approached by Company and was interviewed in Apr 2022. There were 4 interview rounds.
(1 Question)
- Q1. Basic Sql questions and some questions related to the role
(1 Question)
- Q1. Logical questions general aptitude related questions
(1 Question)
- Q1. With group head. No technical questions
Interview Preparation Tips
Selected
I applied via Campus Placement and was interviewed before Apr 2023. There were 2 interview rounds.
(1 Question)
- Q1. Brief overview of SAP PP/ MM
- Ans.
SAP PP (Production Planning) and SAP MM (Materials Management) are modules in the SAP ERP system that help manage production processes and materials procurement.
SAP PP focuses on planning and controlling the manufacturing process
SAP MM deals with procurement and inventory management
Integration between SAP PP and SAP MM ensures smooth production processes
SAP PP includes functionalities like Bill of Materials (BOM) and W...
(1 Question)
- Q1. Why do you want to start your career with Novartis?
Skills evaluated in this interview
Selected
I applied via Referral and was interviewed before Mar 2023. There was 1 interview round.
(1 Question)
- Q1. What do you know about Global Supply Chain
- Ans.
Global Supply Chain refers to the interconnected network of organizations, resources, activities, and technologies involved in the production and distribution of goods and services on a worldwide scale.
Global Supply Chain involves sourcing raw materials, manufacturing products, and delivering them to customers across different countries.
It includes various stages such as procurement, production, inventory management, l...
Prakhar Gupta
Selected
I applied via campus placement at Institute of Technology, Banaras Hindu University and was interviewed before Jul 2022. There were 6 interview rounds.
The duration was one hour. Logical reasoning and mathematics
Topic - don't remember. time was around 15 minutes. Group of 10. Each one had to speak turn-wise first. Open discussion at the end.
Basic patient data-related case study.
(1 Question)
- Q1. Mostly resume-based questions on projects.
(1 Question)
- Q1. Case-based questions like - What would you do if a product may affect the health of patients in future but it is quite profitable so the company decides to launch it?
Selected
I applied via campus placement at National Institute of Technology (NIT), Tiruchirappalli and was interviewed before Mar 2022. There were 4 interview rounds.
Market Entry Case Study - Asking to decide which product to choose for market entry
(2 Questions)
- Q1. Be thorough with your resume and be attentive
- 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...
(1 Question)
- Q1. General HR Questions
Interview Preparation Tips
Novartis Interview FAQs
Some of the top questions asked at the Novartis Analyst interview -
The duration of Novartis Analyst interview process can vary, but typically it takes about less than 2 weeks to complete.
Tell us how to improve this page.
Novartis Interviews By Designations
- Novartis Analyst Interview Questions
- Novartis Senior Analyst Interview Questions
- Novartis Associate Analyst Interview Questions
- Novartis Manager Interview Questions
- Novartis Business Analyst Interview Questions
- Novartis Data Analyst Interview Questions
- Novartis Associate Director Interview Questions
- Novartis Financial Analyst Interview Questions
- Show more
Interview Questions for Popular Designations
Novartis Analyst Interview Process
based on 7 interviews in last 1 year
1 Interview rounds
- Technical Round
People are getting interviews through
Analyst Interview Questions from Similar Companies
Fast track your campus placements
Novartis Analyst Reviews and Ratings
based on 53 reviews
Rating in categories
|
Manager
412
salaries
|  ₹12 L/yr - ₹36 L/yr |
|
Senior Analyst
395
salaries
| ₹8.5 L/yr - ₹22.2 L/yr |
|
Analyst
324
salaries
| ₹5.3 L/yr - ₹17.5 L/yr |
|
Senior Financial Analyst
176
salaries
| ₹9.5 L/yr - ₹23 L/yr |
|
Specialist
166
salaries
| ₹5.9 L/yr - ₹20 L/yr |
GlaxoSmithKline Pharmaceuticals
Sun Pharmaceutical Industries
Cipla
Dr. Reddy's
Calculate your in-hand salary
- Home >
- Interviews >
- Novartis Interview Questions >
- Novartis Analyst Interview Questions
