PerkinElmer Master Data Specialist Interview Questions and Answers

Q1. What is lamda function
Ans. 
Lambda function is an anonymous function in programming that can have multiple arguments but can only have one expression.
• Lambda functions are used for creating small, one-time use functions without the need to define a formal function.

• They are often used in functional programming languages like Python.

• Lambda functions can take any number of arguments, but can only have one expression.

• Example: lambda x: x*2 defines a l
Answered by AI
Add your answer
Q2. Difference between list and tuple
Ans. 
List is mutable, tuple is immutable in Python.
• List can be modified after creation, tuple cannot.

• List uses square brackets [], tuple uses parentheses ().

• List is used for collections of items that may change, tuple for fixed collections.

• Example: list_example = [1, 2, 3], tuple_example = (4, 5, 6)
Answered by AI
Add your answer

Q1. Explain your previous work experience
Add your answer
Q2. Explain with example how your work related to real life example
Add your answer

Q1. What are the basics of power bi
Ans. 
Power BI is a business analytics tool by Microsoft for visualizing and analyzing data.
• Power BI is a business analytics tool by Microsoft

• It allows users to visualize and analyze data from various sources

• Users can create interactive reports and dashboards

• Power BI offers a wide range of data connectors for seamless integration

• It provides features like data modeling, data preparation, and data visualization

• Power BI can be ...read more
Answered by AI
Add your answer

Q1. Do you know adobe analytics
Ans. 
Yes, I am familiar with Adobe Analytics and have experience using it for data analysis.
• I have used Adobe Analytics to track website traffic and user behavior

• I have created custom reports and dashboards using Adobe Analytics

• I am proficient in extracting insights from Adobe Analytics data to drive business decisions
Answered by AI
Add your answer
Q2. Explain example of window function
Ans. 
Window functions are used to perform calculations across a set of table rows related to the current row.
• Window functions are applied to a set of rows related to the current row in a query result.

• They can be used to calculate running totals, averages, ranks, and more.

• Examples include ROW_NUMBER(), RANK(), DENSE_RANK(), and NTILE().
Answered by AI
Add your answer

Q1. Explain example of window function
Ans. 
Window functions are used to perform calculations across a set of table rows related to the current row.
• Window functions are used in SQL to perform calculations within a specific window or subset of rows.

• They allow you to perform aggregate functions like SUM, AVG, COUNT, etc. over a specific range of rows.

• Examples include ROW_NUMBER(), RANK(), DENSE_RANK(), and NTILE().
Answered by AI
Add your answer
Q2. A question using aggregate function and case when in sql
Add your answer

Q1. BI and excel presentation on sales related data: all the questions were asked from the presentation only.
Add your answer
Q2. Why I am switching my job?
Add your answer

Q1. It was very cool and the recruiter was very energetic.
Add your answer

Business usecases technical discussion and written test

Q1. Professional experiences
Add your answer

Q1. Based on your CV
Add your answer

Q1. Based on you CV
Add your answer