Filter interviews by
Join concepts in SQL are used to combine rows from two or more tables based on a related column between them.
Joins are used to retrieve data from multiple tables in a single query.
Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.
INNER JOIN returns rows when there is at least one match in both tables.
LEFT JOIN returns all rows from the left table and the matched rows from the right table.
RIGHT JOI...
I applied via Campus Placement
Basic Apti questions and verbal reasoning
Group discussion on a simple topic for 15 minutes
Case study based questions , pen paper round
I applied via Campus Placement and was interviewed in Jan 2024. There were 5 interview rounds.
Smooth process some mcqs and basic tech questions
Our topic was Work from office vs Work from home
What people are saying about Novartis
I applied via Company Website and was interviewed in May 2024. There were 2 interview rounds.
Presentation to be shared for the case study
Novartis interview questions for popular designations
I applied via Company Website and was interviewed in Sep 2024. There was 1 interview round.
Analyse paper or review a study
Get interview-ready with Top Novartis Interview Questions
I applied via Campus Placement and was interviewed in Jun 2024. There was 1 interview round.
Gd topics were
Aiml in drug discovery
Role of communication in corporate world
Breaching gaps in industry and academia
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
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
I applied via Company Website and was interviewed in Aug 2023. There were 9 interview rounds.
What is clinical data management
I don't know because don't go this round
I don't know because don't go this round
I don't know because don't go this round
I'm not go this round
Some of the top questions asked at the Novartis interview -
The duration of Novartis interview process can vary, but typically it takes about less than 2 weeks to complete.
based on 113 interviews
Interview experience
based on 1.6k reviews
Rating in categories
Senior Analyst
401
salaries
| ₹8.5 L/yr - ₹22 L/yr |
Manager
398
salaries
| ₹12 L/yr - ₹34 L/yr |
Analyst
352
salaries
| ₹6.5 L/yr - ₹17.5 L/yr |
Senior Financial Analyst
173
salaries
| ₹8.6 L/yr - ₹23 L/yr |
Specialist
172
salaries
| ₹5.1 L/yr - ₹20 L/yr |
GlaxoSmithKline Pharmaceuticals
Sun Pharmaceutical Industries
Cipla
Dr. Reddy's