Search

Interview Questions

  • Reviews
  • Salaries
  • Interview Questions
  • About Company
  • Benefits
  • Jobs
  • Office Photos
  • Community
+ Contribute
notification
notification
Login
Upload Button Icon Add office photos
Employer? Claim Account for FREE

Novartis

Compare button icon Compare button icon Compare
4.1

based on 1.6k Reviews

Filter interviews by

Novartis Cloud Architect Interview Questions and Answers

Updated 7 Jun 2023

Novartis Cloud Architect Interview Experiences

1 interview found

Cloud Architect Interview Questions & Answers

user image Anonymous

posted on 7 Jun 2023

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

I applied via LinkedIn and was interviewed before Jun 2022. 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 - Technical 

(3 Questions)

  • Q1. Design a data processing system for 1 pb data per day, describe spark cluster configuration
  • Ans. 

    Design a data processing system for 1 pb data per day with Spark cluster configuration

    • Use a distributed storage system like HDFS or S3 to store the massive amount of data

    • Deploy a large Spark cluster with high memory and CPU resources to handle the processing

    • Utilize Spark's parallel processing capabilities to efficiently process the data in parallel

    • Consider using Spark's caching and persistence mechanisms to optimize pe...

    • Answered by AI
    Add your answer
  • Q2. Talk about caching in tools like redshift and snowflake
  • Ans. 

    Caching in tools like Redshift and Snowflake improves query performance by storing frequently accessed data in memory.

    • Caching in Redshift involves using WLM (Workload Management) to allocate memory for caching frequently accessed data.

    • Snowflake uses a feature called Result Caching to store query results in memory for faster access.

    • Caching helps reduce the need to access disk storage, improving query performance and red

    • Answered by AI
    Add your answer
  • Q3. How do you manage access control for data platform with multiple vendors like AWS, Snowflake and Databricks.
  • Ans. 

    Access control for data platform with multiple vendors is managed through IAM policies, role-based access control, and centralized identity management.

    • Implement IAM policies to control access to resources within each vendor platform

    • Utilize role-based access control to assign permissions based on job function or responsibility

    • Implement centralized identity management to ensure consistent access control across all platfo...

    • Answered by AI
    Add your answer

Skills evaluated in this interview

Top trending discussions

View All
Interview Tips & Stories
4d (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. Seriously, they didn't even acknowledge me until 10. Then this HR lady calls me in, and she's totally unprofessional. She's like, on her phone, making personal calls while I'm sitting right there. And then she starts asking me these really weird questions, like what my nickname is, and what my dad does for a living. It got really uncomfortable when she started pressing for details about where my dad works. I mean, what does that have to do with anything? So I politely told her I didn't want to answer, and she actually said, "Then we can't continue this interview." I was honestly shocked. But instead of arguing, I just stood up and said, “Alright then.” And walked out. I left feeling pissed. Not only did they waste an hour of my time, but the HR rep was also rude and unprofessional..
Got a question about Novartis?
Ask anonymously on communities.

Interview questions from similar companies

Data Analyst Interview Questions & Answers

Pfizer user image Anonymous

posted on 4 Mar 2024

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?
    • 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

Analyst Interview Questions & Answers

GlaxoSmithKline Pharmaceuticals user image Anonymous

posted on 2 Sep 2024

Interview experience
3
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

Data Analyst Interview Questions & Answers

Torrent Pharmaceuticals user image Prateeksha Lankeppanavar

posted on 18 Oct 2024

Interview experience
5
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.

Analyst Interview Questions & Answers

Lupin user image Anonymous

posted on 18 Jul 2024

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

(5 Questions)

  • Q1. ICH guidline of pharma
    • Add your answer
  • Q2. Self goal with company goal
  • Ans. 

    Aligning personal goals with company goals to drive mutual success

    • Setting personal goals that contribute to achieving company objectives

    • Regularly reviewing progress towards both personal and company goals

    • Seeking opportunities to align individual strengths with organizational needs

    • Collaborating with team members to ensure collective efforts support company mission

    • Celebrating achievements that benefit both personal growt

    • Answered by AI
    Add your answer
  • Q3. Industrial visit experience
  • Ans. 

    Visited a manufacturing plant to observe production processes and learn about industry practices.

    • Learned about the different stages of production

    • Observed how raw materials are transformed into finished products

    • Interacted with industry professionals to gain insights into the manufacturing sector

    • Answered by AI
    Add your answer
  • Q4. Family back ground and native information
    • Add your answer
  • Q5. Hobbies and passion
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Do not hide any information.

Analyst Interview Questions & Answers

Dr. Reddy's user image Anonymous

posted on 18 Feb 2024

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - HR 

(2 Questions)

  • Q1. Why do you want to join this company? and this role?
    • Add your answer
  • Q2. Why do you want this role?
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - There will be 2 interviews. ! Hr round and 1 technical round.

Data Analyst Interview Questions & Answers

Dr. Reddy's user image Anonymous

posted on 11 Mar 2024

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected 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 user image Anonymous

posted on 7 Jan 2021

Interview Questionnaire 

1 Question

  • Q1. Questions on excel, six Sigma.
    • Add your answer

Analyst Interview Questions & Answers

Zydus Lifesciences user image Anonymous

posted on 30 Apr 2024

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - HR 

(1 Question)

  • Q1. Self introduction
    • Add your answer

Analyst Interview Questions & Answers

Zydus Lifesciences user image Anonymous

posted on 13 Oct 2023

Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
-
Round 1 - departmental 

(3 Questions)

  • Q1. About hplc and its priciple?
    • Add your answer
  • Q2. UV and its principle?
  • Ans. 

    UV stands for ultraviolet and its principle involves electromagnetic radiation with a wavelength shorter than that of visible light.

    • UV radiation is divided into UVA, UVB, and UVC based on their wavelengths.

    • UV radiation is commonly known for its effects on skin, such as sunburn and skin cancer.

    • UV radiation is also used for disinfection purposes, such as in water treatment and sterilization.

    • Answered by AI
    Add your answer
  • Q3. What is pH of water?
  • Ans. 

    The pH of water is typically around 7, which is considered neutral.

    • The pH scale ranges from 0 to 14, with 7 being neutral, below 7 acidic, and above 7 basic.

    • Pure water has a pH of 7, but this can vary due to dissolved minerals or gases.

    • Acidic water has a pH below 7, while basic water has a pH above 7.

    • Answered by AI
    Add your answer
Round 2 - HR 

(2 Questions)

  • Q1. Nothing, only insulting the employee
    • Add your answer
  • Q2. They treat you like you know nothing
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - only politics in the department for appresel , they want to eat other jobs to get best appraisel
More about working at Novartis

Novartis Interview FAQs

How many rounds are there in Novartis Cloud Architect interview?
Novartis interview process usually has 2 rounds. The most common rounds in the Novartis interview process are Resume Shortlist and Technical.
How to prepare for Novartis Cloud Architect 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 Google Analytics, HTML, SQL, Solution Design and Cloud.
What are the top questions asked in Novartis Cloud Architect interview?

Some of the top questions asked at the Novartis Cloud Architect interview -

  1. How do you manage access control for data platform with multiple vendors like A...read more
  2. Design a data processing system for 1 pb data per day, describe spark cluster c...read more
  3. Talk about caching in tools like redshift and snowfl...read more

Tell us how to improve this page.

Novartis Interviews By Designations

Interview Questions for Popular Designations

Novartis Cloud Architect Interview Process

based on 1 interview

Interview experience

4
  
Good
View more

Interview Questions from Similar Companies

Cipla Interview Questions
4.1
 • 482 Interviews
Dr. Reddy's Interview Questions
4.0
 • 400 Interviews
Sun Pharmaceutical Industries Interview Questions
4.0
 • 393 Interviews
Lupin Interview Questions
4.2
 • 335 Interviews
Zydus Lifesciences Interview Questions
4.1
 • 310 Interviews
Akums Drugs & Pharmaceuticals Limited Interview Questions
4.4
 • 295 Interviews
Aurobindo Pharma Interview Questions
4.0
 • 238 Interviews
Hetero Interview Questions
3.9
 • 221 Interviews
Intas Pharmaceuticals Interview Questions
4.1
 • 208 Interviews
Ipca Laboratories Interview Questions
3.9
 • 156 Interviews
View all

Fast track your campus placements

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 Cloud Architect Salary
based on 4 salaries
₹26 L/yr - ₹35 L/yr
18% more than the average Cloud Architect Salary in India
View more details
Novartis Salaries in India
Senior Analyst
402 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Manager
379 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Analyst
333 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Financial Analyst
174 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Specialist
173 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Novartis with

GlaxoSmithKline Pharmaceuticals

4.1
Compare

Sun Pharmaceutical Industries

4.0
Compare

Cipla

4.1
Compare

Dr. Reddy's

4.0
Compare
Popular Calculators
Are you paid fairly?
Monthly In-hand Salary Calculator
Gratuity Calculator
HRA Calculator
Salary Hike Calculator
Did you find this page helpful?
Yes No
write
Share an Interview