Avantor Production & Planning Engineer Interview Questions and Answers

It was a 90 mins round, and we have to do 85 questions. Coding was also a part of it.

Logical reasoning numerical English sum

Python power bi sql tablue

Q1. Aksjfhasf asjhfgkaskf sdkhgf
Add your answer
Q2. Sdkjghsdgd sdkgjsdg skdghsdtsd
Add your answer

Q1. Self , previous year company work
Add your answer

Q1. How do you find the code performance issue in the code deployed in production?
Ans. 
To find code performance issues in production, use monitoring tools and profiling techniques.
• Use monitoring tools like New Relic, AppDynamics, or Datadog to track performance metrics and identify bottlenecks.

• Use profiling techniques like CPU profiling, memory profiling, and network profiling to pinpoint specific areas of the code that are causing performance issues.

• Analyze logs and error messages to identify patterns a...read more
Answered by AI
View 1 more answer
Q2. What is asynchronous programming
Ans. 
Asynchronous programming is a programming paradigm that allows multiple tasks to run concurrently without blocking each other.
• Asynchronous programming is used to improve the performance of applications that require a lot of I/O operations.

• It involves the use of callbacks, promises, and async/await keywords in JavaScript.

• Asynchronous programming can be used in both front-end and back-end development.

• Examples of asynchro...read more
Answered by AI
Add your answer
Q3. Write a program to change background after every 0.5 sec interval to orange,white,green on button click in Angular?
Ans. 
Program to change background color on button click in Angular
• Create a button in Angular template

• Add click event listener to the button

• Use setInterval() function to change background color after every 0.5 sec

• Use ngStyle directive to change background color dynamically
Answered by AI
Add your answer
Q4. How to load a component only after 3 of my services are loaded?
Ans. 
Use Angular's 'resolve' property to load component after services are loaded.
• Create a resolver service that waits for all three services to complete before resolving.

• Add the resolver service to the 'resolve' property of the component's route.

• Access the resolved data in the component using the ActivatedRoute service.

• Example: { path: 'my-component', component: MyComponent, resolve: { data: MyResolverService } }
Answered by AI
Add your answer
Q5. What is difference between iquerable and ienumrable
Ans. 
IQueryable is for querying data from a source that implements IQueryable interface while IEnumerable is for iterating over a collection of data.
• IQueryable is used for deferred execution while IEnumerable is used for immediate execution.

• IQueryable is used for querying data from a remote data source while IEnumerable is used for querying data from an in-memory collection.

• IQueryable is more efficient for large datasets as...read more
Answered by AI
Add your answer
Q6. When you go with entity framework and ado.net
Ans. 
Entity Framework is an ORM while ADO.NET is a data access technology.
• Entity Framework is easier to use and provides more abstraction than ADO.NET.

• ADO.NET is faster and more flexible than Entity Framework.

• Use Entity Framework for simple CRUD operations and ADO.NET for complex queries and performance-critical applications.
Answered by AI
Add your answer

Q1. Use of Analytics
Ans. 
Analytics is crucial for making data-driven decisions and improving business performance.
• Analytics helps in identifying trends and patterns in data.

• It enables businesses to make informed decisions based on data insights.

• Analytics can be used to optimize processes and improve efficiency.

• Examples: Using sales analytics to identify top-performing products, using customer analytics to personalize marketing strategies.
Answered by AI
Add your answer
Q2. What do you want to bring to the table
Ans. 
I want to bring strong leadership skills, problem-solving abilities, and a passion for customer service to the table.
• Strong leadership skills: I have experience leading teams and making strategic decisions.

• Problem-solving abilities: I excel at finding creative solutions to challenges that arise.

• Passion for customer service: I prioritize providing excellent service and building strong relationships with customers.
Answered by AI
Add your answer

Easy but time limit was the main issue to address

Hard coding test on hacker earth platform no cameras and plagiarism tester will be on