Bristol-Myers Squibb Data Engineer Interview Questions and Answers

Q1. Difference between all union all distinct
Ans. 
ALL returns all rows, UNION removes duplicates, DISTINCT returns unique rows.
• ALL: includes all rows, even duplicates

• UNION: combines two result sets and removes duplicates

• DISTINCT: returns only unique rows

• Example: SELECT name FROM table1 UNION SELECT name FROM table2;

• Example: SELECT name FROM table1 UNION ALL SELECT name FROM table2;

• Example: SELECT DISTINCT name FROM table1;
Answered by AI
Add your answer
Q2. Convert the given dictionary to list and sort dictionary in ascending order
Ans. 
Convert dictionary to list and sort in ascending order
• Use the items() method to convert dictionary to list of tuples

• Use the sorted() function to sort the list of tuples

• Use a lambda function to sort by dictionary values

• Convert the sorted list of tuples back to a dictionary using dict() method
Answered by AI
Add your answer

Piraamal finance jnlnm knkn

Q1. What is sql? and where to use
Ans. 
SQL is a programming language used for managing and manipulating relational databases.
• SQL stands for Structured Query Language

• Used to retrieve, update, and manage data in relational databases

• Commonly used in data analysis, data manipulation, and data reporting

• Examples: SELECT * FROM table_name, INSERT INTO table_name VALUES (value1, value2)
Answered by AI
Add your answer
Q2. Power bi description and its imp
Ans. 
Power BI is a business analytics tool by Microsoft that provides interactive visualizations and business intelligence capabilities.
• Power BI allows users to connect to a wide variety of data sources and create interactive reports and dashboards.

• Users can easily share their insights with others and collaborate in real-time.

• It offers features like data modeling, data preparation, and data visualization to help organizatio...read more
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. Basic of core java,oracle, html,css,Javascript
Add your answer
Q2. My self introduction
Add your answer

Good and not that much difficult

Q1. Good, interview was gone very smooth and you should know about what you mentioned in resume
Add your answer

Q1. They will ask about personal information and inform you about your role
Add your answer

Tableau Developer

I was given an assignment where I had to build dashboard with final story within 1 hour

Q1. Why Novo? Why this role?
Add your answer

Q1. Director Round with department head
Add your answer

Q1. Affiliate Round with either US folks or Denmark folks
Add your answer

Q1. What is your family background?
Add your answer
Q2. What are your strengths and weaknesses?
Add your answer
Q3. Tell me about yourself.
Add your answer
Q4. What are your salary expectations?
Add your answer

Aptitude test was quite good if we are good at basics

Group discussion happened to eliminate most of the candidates, just we have to put our point forward boldly, we can succeed

Coding test was but hard, they asked algorithms for searching and sorting techniques with code, OOPs concept was emphasised

Again there was a coding test, this time few coding related questions are given like the hacker rank and hacker earth problems

Q1. This round was with the manager and coding questions were asked in this round. Along with that few riddles were asked related to the logical thinking.
Add your answer

Q1. General HR questions are asked like tell about yourself
Add your answer
Q2. What are your strengths
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