Novartis Interview Questions, Process, and Tips

Q1. Why you want to join, current profile, qualification amd
Add your answer

Q1. Role and responsibilities of MSL, sometimes about Novartis products depends on therapeutic area you are applying, your strength and skills match to JD, why ypu want to leave your current job etc
Add your answer

Q1. Presentation based on research article and then interview of article
Add your answer
Q2. Answers from Article
Add your answer

Q1. Final round and questions around package
Add your answer
Q2. Negotiations around your current salary
Add your answer

Investigation of a deviation faced during the past company responsibility

Q1. Project challenges faced and how it was overcome
Add your answer

Q1. Values and behaviour
Add your answer

Q1. When you can start?
Ans. 
I can start immediately and am excited to begin contributing to the team.
• I am available to start as soon as needed

• I am eager to begin working and contributing to the team

• I can start immediately upon acceptance of the offer
Answered by AI
Add your answer
Q2. What motivates you at work ?
Ans. 
I am motivated by the opportunity to learn and grow, the chance to make a positive impact, and the satisfaction of achieving goals.
• Opportunity to learn and grow in my field keeps me motivated

• Making a positive impact on projects or team members drives me

• Achieving goals and seeing results gives me satisfaction
Answered by AI
Add your answer

Q1. What is your salary expectation?
Ans. 
My salary expectation is based on my qualifications, experience, and the industry standard for this position.
• Consider my education level and relevant experience in the field

• Research the average salary range for Temp Scientific Associates in the industry

• Factor in the location and cost of living for the position

• Be open to negotiation based on benefits and opportunities for growth
Answered by AI
Add your answer

Q1. Previous technical stack used
Ans. 
Previous technical stack used includes Java, Spring Boot, Angular, and MySQL.
• Java

• Spring Boot

• Angular

• MySQL
Answered by AI
Add your answer
Q2. Reason for leaving old companies
Ans. 
Seeking new challenges and growth opportunities
• Desire for career advancement

• Company restructuring

• Relocation

• Seeking better work-life balance
Answered by AI
Add your answer

Excel assignment on data crunching

Q1. Previous project experience
Ans. 
Managed multiple projects in data analysis, market research, and financial modeling.
• Led a team to analyze customer data and identify trends for a marketing campaign

• Conducted market research to assess competitor strategies and market opportunities

• Developed financial models to forecast revenue and expenses for a new product launch
Answered by AI
Add your answer

Q1. Salary expectations from new role
Ans. 
I am looking for a competitive salary that reflects my experience and skills in the industry.
• Research industry standards for Senior Analyst salaries

• Consider my years of experience and level of expertise

• Factor in cost of living in the area where the job is located

• Negotiate based on benefits and perks offered by the company
Answered by AI
Add your answer
Q2. Joining date possible for new role
Add your answer

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...read more
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...read more
Answered by AI
Add your answer

Q1. Reason for change of company?
Add your answer
Q2. Depreciation based Questions Lease accounting case study
Add your answer