I applied online. The process took 2 weeks. I interviewed at Novartis (Hyderābād) in Mar 2023
Interview
6 rounds-
1. online technical round
2. Technical round - puzzles, SQL, Excel
3. case study round 0 based on Excel - pivots, rank function, formulas
4. tech round based on case study
5. Higher management general round
6. HR Round for Behavioural questions and salary negotiation
There were 4 rounds
1) case study
2) Technical
3) Technical
4) HR
They took written test for case study round which is based on statistics and probability.
Case study round was non elimination round.
Interview questions [1]
Question 1
Types of join.
Explain cross join in detail..
Asked some queries.
Questions based on resume.