Add office photos
Filter interviews by
Novartis Senior Data Analyst Interview Questions and Answers
Novartis Senior Data Analyst Interview Experiences
1 interview found
I applied via Referral and was interviewed in Jul 2024. There were 4 interview rounds.
(1 Question)
- Q1. Data science related questions
(1 Question)
- Q1. Data science related questions
(1 Question)
- Q1. Data science and project
(1 Question)
- Q1. Current Compensation and expectations
Interview Preparation Tips
Interview questions from similar companies
Senior Data Analyst Interview Questions & Answers
Eli Lilly and Company
Adithya pythireddi
posted on 27 Jun 2024
(2 Questions)
- Q1. Using sql extract substring of name
- Ans.
Using SQL to extract substring of name
Use the SUBSTRING function in SQL to extract a specific portion of a string
Specify the starting position and length of the substring to be extracted
Example: SELECT SUBSTRING('John Doe', 1, 4) AS First_Name will return 'John'
- Q2. Using sql print cummulative sum of sales
- Ans.
Use SQL to print cumulative sum of sales
Use the SUM() function to calculate the cumulative sum of sales
Utilize the OVER() clause with ORDER BY to specify the order of the cumulative sum
Example: SELECT date, sales, SUM(sales) OVER (ORDER BY date) AS cumulative_sales FROM table_name
Skills evaluated in this interview
Selected
I applied via Recruitment Consulltant and was interviewed in Oct 2024. There were 2 interview rounds.
Logical reasoning numerical English sum
Python power bi sql tablue
Interview Preparation Tips
- Python
- SQL
- Power Bi
- Tablu
Data Analyst Interview Questions & Answers
Akums Drugs & Pharmaceuticals Limited
Anonymous
posted on 20 Dec 2024
Selected
(1 Question)
- Q1. How to handle noise in data
Data Analyst Intern Interview Questions & Answers
MSD Pharmaceuticals
Pratim Ray
posted on 5 Nov 2024
(1 Question)
- Q1. Describe project done previously
- Ans.
Developed a predictive analytics model to forecast sales for a retail company
Collected and cleaned historical sales data
Used machine learning algorithms to analyze trends and patterns
Built a forecasting model to predict future sales based on various factors
Evaluated the model's performance and made adjustments for accuracy
I applied via Company Website and was interviewed in Feb 2024. There were 3 interview rounds.
(1 Question)
- Q1. Why did you choose to work at Pfizer?
(1 Question)
- Q1. Tell me about your project
Time management and organization skills
(1 Question)
- Q1. Nlp related stuff
Data Analyst Interview Questions & Answers
Sun Pharmaceutical Industries
Anonymous
posted on 4 Oct 2023
Selected
I applied via Job Fair and was interviewed in Apr 2023. There were 2 interview rounds.
(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...
- 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
Interview Preparation Tips
- CONCENTRATION
- BODY LANGUAGE
- BOLD TO ANSWER
Selected
I applied via LinkedIn and was interviewed in Oct 2023. There were 2 interview rounds.
(2 Questions)
- Q1. About remote work willingness
- Q2. Salary expectation
Tell me about your recent project
Tableau Developer
I was given an assignment where I had to build dashboard with final story within 1 hour
(1 Question)
- Q1. Why Novo? Why this role?
(1 Question)
- Q1. Director Round with department head
(1 Question)
- Q1. Affiliate Round with either US folks or Denmark folks
(4 Questions)
- Q1. What is your family background?
- Q2. What are your strengths and weaknesses?
- Q3. Tell me about yourself.
- Q4. What are your salary expectations?
Interview Preparation Tips
Novartis Interview FAQs
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
- Data Scientist Interview Questions
- Data Analyst Intern Interview Questions
- Senior Data Scientist Interview Questions
- Data Science Intern Interview Questions
- Associate Data Analyst Interview Questions
- Jr. Data Scientist Interview Questions
- Data Analyst Interview Questions
- Associate Data Scientist Interview Questions
- Show more
People are getting interviews through
Interview Questions from Similar Companies
Fast track your campus placements
Novartis Senior Data Analyst Reviews and Ratings
based on 4 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 Senior Data Analyst Interview Questions
