Upload Button Icon Add office photos

Filter interviews by

Novartis Cloud Architect Interview Questions and Answers

Updated 7 Jun 2023

Novartis Cloud Architect Interview Experiences

1 interview found

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

Skills evaluated in this interview

Interview questions from similar companies

Interview Questionnaire 

1 Question

  • Q1. Questions on excel, six Sigma.

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
  • 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
  • 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
  • Q4. Family back ground and native information
  • Q5. Hobbies and passion

Interview Preparation Tips

Interview preparation tips for other job seekers - Do not hide any information.
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
1
Bad
Difficulty level
-
Process Duration
-
Result
-
Round 1 - departmental 

(3 Questions)

  • Q1. About hplc and its priciple?
  • 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
  • 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
Round 2 - HR 

(2 Questions)

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

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

(1 Question)

  • Q1. Tell me about all your Candidature Background.
Round 3 - HR 

(1 Question)

  • Q1. Salary Negotiation

Interview Preparation Tips

Interview preparation tips for other job seekers - My Interview was quite impressive. Your interview in AKUMS done by your Department HOD. The Interview process is simple you answers all the questions without any hesitation. So All The Best & Do Your Best.
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - HR 

(1 Question)

  • Q1. Introduction and your profile related questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare a your section knowledge when experience
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
-

I applied via Approached by Company and was interviewed in Mar 2024. There were 3 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. Domain based with the reporting manager
Round 2 - Technical 

(1 Question)

  • Q1. Interview round with the head of dept.
Round 3 - HR 

(1 Question)

  • Q1. HR based Q and A round
Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
Selected Selected

I appeared for an interview before Feb 2024.

Round 1 - HR 

(2 Questions)

  • Q1. Name and city personal details
  • Q2. Qualities and job experience

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 Cloud Architect Interview Process

based on 1 interview

Interview experience

4
  
Good
View more

Interview Questions from Similar Companies

Cipla Interview Questions
4.1
 • 483 Interviews
Dr. Reddy's Interview Questions
4.0
 • 401 Interviews
Lupin Interview Questions
4.2
 • 337 Interviews
Aurobindo Pharma Interview Questions
4.0
 • 238 Interviews
Hetero Interview Questions
3.8
 • 225 Interviews
Mankind Pharma Interview Questions
3.9
 • 191 Interviews
View all
Novartis Cloud Architect Salary
based on 4 salaries
₹26 L/yr - ₹35 L/yr
14% more than the average Cloud Architect Salary in India
View more details
Senior Analyst
395 salaries
unlock blur

₹8.5 L/yr - ₹24.5 L/yr

Manager
380 salaries
unlock blur

₹12 L/yr - ₹33.4 L/yr

Analyst
337 salaries
unlock blur

₹5.8 L/yr - ₹18 L/yr

Senior Financial Analyst
179 salaries
unlock blur

₹8.4 L/yr - ₹21.5 L/yr

Specialist
175 salaries
unlock blur

₹6.3 L/yr - ₹20 L/yr

Explore more salaries
Compare Novartis with

Cipla

4.1
Compare

Dr. Reddy's

4.0
Compare

Lupin

4.2
Compare

Zydus Lifesciences

4.1
Compare
Did you find this page helpful?
Yes No
write
Share an Interview