Integral Ad Science Data Engineer Interview Questions and Answers

Q1. What is the importance of Microsoft Word, Microsoft Office, and Microsoft PowerPoint in your work?
Add your answer
Q2. You know about the computer knowledge and typing also very important okay and also good environment and good positive and responsible and from more more and more etc and make them very important knowledg...read more
Add your answer

Q1. Pivot columns in sql
Ans. 
Pivoting columns in SQL involves transforming rows into columns to display data in a different format.
• Use the PIVOT keyword in SQL to pivot columns

• Specify the columns to pivot on and the values to display in the new columns

• Aggregate functions like SUM, AVG, COUNT can be used with PIVOT

• Example: SELECT * FROM table_name PIVOT (SUM(value_column) FOR pivot_column IN ('value1', 'value2', 'value3'))
Answered by AI
Add your answer
Q2. Slow changing dimensions
Add your answer
Q3. Dynamic rankx top 3
Add your answer
Q4. Field parameters
Add your answer
Q5. Stored procedures
Add your answer

Q1. Dot net related stuffs
Add your answer
Q2. Dependency injection
Add your answer

Built an app using dot net and angular

Q1. Difference between union and union all in SQL?
Ans. 
Union combines and removes duplicates, Union All combines without removing duplicates.
• Union combines result sets and removes duplicates

• Union All combines result sets without removing duplicates

• Union is slower than Union All as it involves removing duplicates

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

• Example: SELECT column1 FROM table1 UNION ALL SELECT column1 FROM table2;
Answered by AI
Add your answer
Q2. How to show top 5 in pandas?
Ans. 
To show top 5 in pandas, use the nlargest() function.
• Use the nlargest() function with the 'n' parameter set to 5 to get the top 5 values in a pandas DataFrame.

• For example: df['column_name'].nlargest(5) will return the top 5 values in the specified column.
Answered by AI
Add your answer

Q1. If we have 3 numerical columns, which chart is a better representation these column?
Ans. 
A scatter plot is a better representation for 3 numerical columns.
• Use a scatter plot to show the relationship between the numerical columns.

• Scatter plots are effective for visualizing correlations and patterns in data.

• Each point on the plot represents a data point with values from all 3 columns.
Answered by AI
Add your answer

Q1. It was good and easy
Add your answer

Q1. Its all about package discussion
Add your answer

In this round, there is aptitude & 2 coding questions.

Q1. Java oops concept
Add your answer
Q2. Again Live coding test
Add your answer

Q1. Discussion about salary and company
Add your answer

Mathematics, English and Reasoning..

Q1. What is python? What is uses of python?
Ans. 
Python is a high-level, interpreted programming language used for web development, data analysis, artificial intelligence, and more.
• Python is easy to learn and has a simple syntax.

• It is used for web development with frameworks like Django and Flask.

• Python is popular for data analysis and visualization with libraries like Pandas and Matplotlib.

• It is used for artificial intelligence and machine learning with libraries li...read more
Answered by AI
Add your answer
Q2. Some coding based questions of python.
Add your answer

Q1. Salary and work discussionion
Add your answer
Q2. Short and long term goals.
Add your answer
Q3. Work Role, post and company work.
Add your answer