Upload Button Icon Add office photos

Filter interviews by

Novartis Data Specialist Interview Questions and Answers

Updated 4 Mar 2024

Novartis Data Specialist Interview Experiences

1 interview found

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Technical 

(1 Question)

  • Q1. What is SDTM,? Uses of SDTM? What is to be done when you add new field on eCRF per clinical team request? Process followed to add any new field on eCRF?

Interview Preparation Tips

Interview preparation tips for other job seekers - I thought it is fresher position but it was for experienced position

Interview questions from similar companies

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed in Oct 2024. There were 2 interview rounds.

Round 1 - Aptitude Test 

Logical reasoning numerical English sum

Round 2 - Coding Test 

Python power bi sql tablue

Interview Preparation Tips

Topics to prepare for Merck Data Analyst interview:
  • Python
  • SQL
  • Power Bi
  • Tablu
Interview preparation tips for other job seekers - No
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
-
Result
Selected Selected
Round 1 - One-on-one 

(1 Question)

  • Q1. How to handle noise in data
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via campus placement at CMR Institute of Technology, Bangalore and was interviewed in May 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Explain about project in detail
  • Q2. How did you manage so much cgpa?
  • Ans. 

    I managed a high CGPA through consistent hard work, effective time management, seeking help when needed, and staying organized.

    • Consistent hard work by studying regularly and staying focused on academics

    • Effective time management to balance studies, assignments, and extracurricular activities

    • Seeking help from professors, tutors, or classmates when facing challenges

    • Staying organized with study schedules, notes, and deadli

  • Answered by AI
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in Feb 2024. There was 1 interview round.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Difference rank dense rank and rownumber
  • Ans. 

    Rank, Dense Rank, and Row Number are window functions used in SQL to assign a rank to each row based on a specific criteria.

    • Rank assigns a unique rank to each row based on the specified order.

    • Dense Rank assigns a unique rank to each row without any gaps, even if there are ties.

    • Row Number assigns a unique sequential integer to each row, without any regard to the order of the rows.

  • Answered by AI
  • Q2. Questions from join condition

Interview Preparation Tips

Topics to prepare for Viatris Data Engineer interview:
  • Tsql
  • Adf
  • Data bricks
Interview preparation tips for other job seekers - Advanced t sql questions

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
Not Selected

I applied via Company Website and was interviewed in Feb 2024. There were 3 interview rounds.

Round 1 - HR 

(1 Question)

  • Q1. Why did you choose to work at Pfizer?
Round 2 - One-on-one 

(1 Question)

  • Q1. Tell me about your project
Round 3 - Group Discussion 

Time management and organization skills

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Nlp related stuff
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - HR 

(2 Questions)

  • Q1. Fresher or experienced person?
  • Q2. Why you choose this company

Interview Preparation Tips

Interview preparation tips for other job seekers - Self motivated & hard working
Able to work in a team to achieve target's
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Asked about previous projects, mainly focusing around spark, redshift, glue
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Job Fair and was interviewed in Apr 2023. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - One-on-one 

(3 Questions)

  • Q1. Excel shortcut keys?
  • Q2. WHAT IS THE ROLE OF DATA ANALYST?
  • Ans. 

    Data Analysts are responsible for collecting, processing, and analyzing data to help organizations make informed decisions.

    • Collecting and organizing data from various sources

    • Cleaning and processing data to ensure accuracy and reliability

    • Analyzing data to identify trends, patterns, and insights

    • Creating visualizations and reports to communicate findings

    • Providing recommendations based on data analysis

    • Collaborating with st...

  • Answered by AI
  • Q3. What are the skills need for data analyst?
  • Ans. 

    Skills needed for data analyst include strong analytical skills, proficiency in data analysis tools, programming knowledge, and communication skills.

    • Strong analytical skills to interpret complex data sets

    • Proficiency in data analysis tools such as Excel, SQL, Python, R, etc.

    • Programming knowledge to manipulate and analyze data effectively

    • Communication skills to present findings and insights to stakeholders

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Sun Pharmaceutical Industries Data Analyst interview:
  • CONCENTRATION
  • BODY LANGUAGE
  • BOLD TO ANSWER
Interview preparation tips for other job seekers - As a fresher...my suggestion is...before going to interview please note that...they may have prepared to ans for your question...they concentrate more on subject related...bcz in this universe skills may offered by the company as well..so their is no need for asking more ques related to academic...along with this you should tell about what is current situation...which skills they should adopt like that..this is very much helpful for them to be confident while attending another interviews ....Thank you

Novartis Interview FAQs

How many rounds are there in Novartis Data Specialist interview?
Novartis interview process usually has 2 rounds. The most common rounds in the Novartis interview process are Resume Shortlist and Technical.

Tell us how to improve this page.

Interview Questions from Similar Companies

Cipla Interview Questions
4.1
 • 465 Interviews
Dr. Reddy's Interview Questions
4.1
 • 382 Interviews
Lupin Interview Questions
4.2
 • 328 Interviews
Aurobindo Pharma Interview Questions
4.0
 • 230 Interviews
Ipca Laboratories Interview Questions
4.0
 • 149 Interviews
Biocon Limited Interview Questions
3.9
 • 146 Interviews
Abbott Interview Questions
4.2
 • 142 Interviews
View all
Novartis Data Specialist Salary
based on 12 salaries
₹3.1 L/yr - ₹7.6 L/yr
54% less than the average Data Specialist Salary in India
View more details
Manager
410 salaries
unlock blur

₹12.3 L/yr - ₹34.5 L/yr

Senior Analyst
396 salaries
unlock blur

₹8.5 L/yr - ₹23 L/yr

Analyst
353 salaries
unlock blur

₹5.3 L/yr - ₹17.5 L/yr

Senior Financial Analyst
180 salaries
unlock blur

₹9.5 L/yr - ₹23 L/yr

Specialist
167 salaries
unlock blur

₹5.9 L/yr - ₹20 L/yr

Explore more salaries
Compare Novartis with

GlaxoSmithKline Pharmaceuticals

4.1
Compare

Sun Pharmaceutical Industries

4.1
Compare

Cipla

4.1
Compare

Dr. Reddy's

4.1
Compare

Calculate your in-hand salary

Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary
Did you find this page helpful?
Yes No
write
Share an Interview