Egen Associate Data Engineer Interview Questions and Answers

Q1. What is the difference between working from home and working from the office, and what are the benefits of each?
Ans. 
Working from home offers flexibility and comfort, while working from the office provides structure and social interaction.
• Working from home allows for flexibility in schedule and eliminates commute time.

• Working from the office provides a structured environment and opportunities for in-person collaboration.

• Benefits of working from home include increased productivity and work-life balance.

• Benefits of working from the off...read more
Answered by AI
Add your answer

Q1. All Programing ques
Add your answer

It was a written test where theoretical SQL questions were asked like primary key, foreign key, set operators and some queries

Q1. All SQL Concepts like Join, normalization, trigger, stored procedure, keys, drop truncate del difference, where having difference, Aggregate scaler window functions, fetch duplicate records query, acid pro...read more
Add your answer

Q1. Self Introduction
Add your answer
Q2. Salary Expectation
Add your answer

Q1. 14 questions in excel formulas
Add your answer

Object Detection on a subset of COCO dataset having Cars and Person classes

Q1. Technical discussion on Machine Learning, Deep Learning Concepts and coding round.
Add your answer

Q1. Technical discussion on Deep Learning and Computer Vision.
Add your answer

Q1. SQL related basic theory questions
Add your answer
Q2. SQL coding test
Add your answer

Q1. Explain process in adf
Ans. 
ADF stands for Azure Data Factory, a cloud-based data integration service that allows you to create, schedule, and manage data pipelines.
• ADF allows you to create data-driven workflows for orchestrating and automating data movement and data transformation.

• You can use ADF to ingest data from various sources, process and transform the data, and then publish the data to different destinations.

• ADF supports a wide range of d...read more
Answered by AI
Add your answer

Q1. Tell us about yourself?
Add your answer
Q2. What are joins in sql?
Ans. 
Joins in SQL are used to combine data from two or more tables based on a related column.
• Joins are used to retrieve data from multiple tables in a single query

• Common types of joins include inner join, left join, right join, and full outer join

• Join conditions are specified using the ON keyword and a related column in each table

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column
Answered by AI
Add your answer
Q3. Have you done any SQL projects?
Ans. 
Yes, I have worked on several SQL projects.
• Developed a database for a retail company to manage inventory and sales data using SQL Server

• Created complex queries to extract data from multiple tables for a financial services firm

• Optimized database performance by indexing and partitioning tables for a healthcare organization
Answered by AI
Add your answer
Q4. How will you remove duplicates in SQL?
Ans. 
Duplicates can be removed in SQL using DISTINCT keyword or GROUP BY clause.
• Use DISTINCT keyword to select unique values from a single column.

• Use GROUP BY clause to group rows with same values and select unique values from multiple columns.

• Use HAVING clause to filter out groups with count greater than 1.

• Use INNER JOIN to join tables and select unique values from multiple tables.

• Use ROW_NUMBER() function to assign a uniq...read more
Answered by AI
Add your answer
Q5. Are you a team player or an individual contributor?
Add your answer

Q1. Would you be comfortable working from Bangalore office?
Add your answer

Q1. Explain about dual axis in tableau
Ans. 
Dual axis in Tableau allows for combining two different measures on the same axis for better comparison.
• Dual axis allows for comparing two measures on the same chart

• Each measure can have its own scale, allowing for better visualization

• Different chart types can be used for each measure, such as bars and lines
Answered by AI
Add your answer
Q2. SQL coding questions
Add your answer