Thermo Fisher Scientific Scientist II Interview Questions and Answers

Aptitude is easy and if your basics are strong

Coding round has 2 parts realtime coding and coding

Q1. Asked about projects
Add your answer
Q2. Asked about oop concept
Add your answer

Q1. Sql related questions like temp tables, ctes, performance tuning. magic tables, how to read execution plan. error handling in stored procs.
Add your answer
Q2. SSIS questions related to multiple sources. transformations used, error logging, event handlers. conatiners.
Add your answer

Q1. Why do you want this role?
Add your answer
Q2. What experience do you have that makes you suited to the role?
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