7 Novartis Data Analyst Interview Questions & Answers | Complete Prep Guide 2025

Novartis Data Analyst Interview Experiences

4 interviews found

Data Analyst Interview Questions & Answers

Anonymous

posted on 18 Oct 2024

Interview experience

Good

Difficulty level

Moderate

Process Duration

Less than 2 weeks

Result

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

Round 1 - One-on-one

(1 Question)

Q1. About Sql, project and work we did

Add your answer

Data Analyst Interview Questions & Answers

Anonymous

posted on 21 May 2024

Interview experience

Average

Difficulty level

Easy

Process Duration

Less than 2 weeks

Result

Selected

I applied via Approached by Company and was interviewed in Apr 2024. There was 1 interview round.

Round 1 - Technical

(2 Questions)

Q1. Data management

Add your answer

Q2. Excel pivot, Vlookup

Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - know more about the role in JD

Data Analyst Interview Questions & Answers

taufeek khan

posted on 5 Aug 2023

Interview experience

Excellent

Difficulty level

Moderate

Process Duration

Less than 2 weeks

Result

Selected

I applied via Company Website and was interviewed in Jul 2023. There were 6 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 Resume tips

Round 2 - Aptitude Test

Basic questions based on sql theories and excel

Round 3 - Assignment

Assignment to solve excel sheets using advanced excel functions

Round 4 - Technical

(1 Question)

Q1. Common interview questions, index match, self join, SQL theoretical questions ( types of join, union and union all , delete and truncate difference), data modelling using excel, count if, case study.

Add your answer

Round 5 - Technical

(1 Question)

Q1. Previous experience and personal questions and tools knowledge

Add your answer

Round 6 - HR

(1 Question)

Q1. Salary discussion round

Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared

Data Analyst Interview Questions & Answers

Anonymous

posted on 22 Jan 2021

I applied via Recruitment Consultant and was interviewed in Feb 2020. There were 4 interview rounds.

Interview Questionnaire

1 Question

Q1. Technical questions regarding Sas and aptitude questions and previous company project details

Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident on projects and technical knowledge in sas

Data Analyst Jobs at Novartis

View all

ES Data Analyst

Hyderabad / Secunderabad

10-12 Yrs

Not Disclosed

Top trending discussions

View All

Interview Tips & Stories

2d (edited)

timepasstiwari

A Digital Markter

Got Rejected In an Interview, Just Because I Didn’t Answer a Personal Question

So, I got invited for this interview, and they told me to be there at 9 AM. Of course, I get there early, like 8:30, because I don't want to be late. But then I end up waiting for 1.5 hours... read more

Got a question about Novartis?

Ask anonymously on communities.

Interview questions from similar companies

Data Analyst Interview Questions & Answers

Pfizer

Anonymous

posted on 4 Mar 2024

Interview experience

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?

Add your answer

Round 2 - One-on-one

(1 Question)

Q1. Tell me about your project

Add your answer

Round 3 - Group Discussion

Time management and organization skills

Data Analyst Interview Questions & Answers

Torrent Pharmaceuticals

Prateeksha Lankeppanavar

posted on 18 Oct 2024

Interview experience

Excellent

Difficulty level

Moderate

Process Duration

Less than 2 weeks

Result

I applied via Apna Jobs and was interviewed in Sep 2024. There was 1 interview round.

Round 1 - HR

(2 Questions)

Q1. Questions on Data analysis tools,process, data mining, machine learning.

Add your answer

Q2. Main tool IBM SPSS modular.

Add your answer

Interview Preparation Tips

Topics to prepare for Torrent Pharmaceuticals Data Analyst interview:

IBM SPSS modular
Data Analytics
Data analytics tools and process
Data mining

Interview preparation tips for other job seekers - Be thorough with your technical skills.

Data Analyst Interview Questions & Answers

Dr. Reddy's

Anonymous

posted on 11 Mar 2024

Interview experience

Excellent

Difficulty level

Moderate

Process Duration

2-4 weeks

Result

Selected

I applied via Campus Placement and was interviewed before Mar 2023. There was 1 interview round.

Round 1 - Case Study

Complete discuss about college project

Interview Preparation Tips

Topics to prepare for Dr. Reddy's Data Analyst interview:

SQL
Data Science

Interview preparation tips for other job seekers - Be calm and confident

Data Analyst Interview Questions & Answers

Aurobindo Pharma

Anonymous

posted on 7 Jan 2021

Interview Questionnaire

1 Question

Q1. Questions on excel, six Sigma.

Add your answer

Data Analyst Interview Questions & Answers

Sun Pharmaceutical Industries

Anonymous

posted on 4 Oct 2023

Interview experience

Excellent

Difficulty level

Moderate

Process Duration

Less than 2 weeks

Result

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 Resume tips

Round 2 - One-on-one

(3 Questions)

Q1. Excel shortcut keys?

Add your answer

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

Add your answer

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

Add your answer

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

Analyst Interview Questions & Answers

GlaxoSmithKline Pharmaceuticals

Anonymous

posted on 2 Sep 2024

Interview experience

Average

Difficulty level

Moderate

Process Duration

2-4 weeks

Result

No response

I applied via Approached by Company and was interviewed in Mar 2024. There was 1 interview round.

Round 1 - Coding Test

Sql coding + project discussion

Novartis Interview FAQs

How many rounds are there in Novartis Data Analyst interview?

Novartis interview process usually has 2-3 rounds. The most common rounds in the Novartis interview process are Technical, Resume Shortlist and Aptitude Test.

How to prepare for Novartis Data Analyst interview?

Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Novartis. The most common topics and skills that interviewers at Novartis expect are SQL, Python, Data Analytics, Data Extraction and Data Modeling.

What are the top questions asked in Novartis Data Analyst interview?

Some of the top questions asked at the Novartis Data Analyst interview -

Common interview questions, index match, self join, SQL theoretical questions (...read more
About Sql, project and work we ...read more
Data managem...read more

Tell us how to improve this page.

Novartis Interviews By Designations

Interview Questions for Popular Designations

Novartis Data Analyst Interview Process

based on 4 interviews

Interview experience

3.8

Good

Akums Drugs & Pharmaceuticals Limited Data Analyst Interview Questions

4.4

• 2 Interviews

Eli Lilly and Company Data Analyst Interview Questions

3.8

• 2 Interviews

Piramal Group Data Analyst Interview Questions

3.9

• 2 Interviews

Merck Data Analyst Interview Questions

4.3

• 2 Interviews

Sun Pharmaceutical Industries Data Analyst Interview Questions

4.0

• 1 Interview

Dr. Reddy's Data Analyst Interview Questions

4.0

• 1 Interview

Pfizer Data Analyst Interview Questions

4.0

• 1 Interview

Aurobindo Pharma Data Analyst Interview Questions

4.0

• 1 Interview

Torrent Pharmaceuticals Data Analyst Interview Questions

3.9

• 1 Interview

MSN Laboratories Data Analyst Interview Questions

3.7

• 1 Interview

View all

Birla Institute of Technology and Science (BITS), Pilani Placement Questions

2 Interviews

National Institute of Technology (NIT), Tiruchirappalli Placement Questions

2 Interviews

National Institute of Technology (NIT), Warangal Placement Questions

1 Interview

Institute of Technology, Banaras Hindu University Placement Questions

1 Interview

KIIT University, Bhuvaneshwar Placement Questions

1 Interview

View all

Novartis Data Analyst Salary

based on 120 salaries

₹4.8 L/yr - ₹20 L/yr

79% more than the average Data Analyst Salary in India

View more details

Data Analyst Jobs at Novartis

ES Data Analyst

Hyderabad / Secunderabad

10-12 Yrs

Not Disclosed

Explore more jobs

Novartis Salaries in India

Manager 408 salaries	₹0 L/yr - ₹0 L/yr
Senior Analyst 403 salaries	₹0 L/yr - ₹0 L/yr
Analyst 332 salaries	₹0 L/yr - ₹0 L/yr
Senior Financial Analyst 174 salaries	₹0 L/yr - ₹0 L/yr
Specialist 173 salaries	₹0 L/yr - ₹0 L/yr