DISYS Data Engineer Interview Questions and Answers

Q1. 3rd largest salary from each department(window function)
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

Basic self quotation

Song analysis and depiction

Q1. Tell about your self
Add your answer

Q1. Tell about yourself
Add your answer
Q2. What is your collage story
Add your answer
Q3. Family backgrond
Add your answer
Q4. Tell your love story
Add your answer

Q1. Questions about C# language features
Add your answer
Q2. Azure functions and other services
Add your answer

Q1. DevOps concepts
Add your answer
Q2. Angular basics
Add your answer

Leetcode easy level questions

Q1. Eliminate subsequent repetitions in a string
Ans. 
Remove subsequent repetitions in a string
• Iterate through the string and compare each character with the next one

• If they are the same, remove the repetition by shifting the characters to the left

• Repeat this process until all repetitions are eliminated
Answered by AI
Add your answer

Q1. Behavioral questions asked by Delivery Manager
Add your answer

Q1. Behavioral round and past experience
Add your answer

Q1. Design a URL shortener
Ans. 
A URL shortener is a tool that takes a long URL and generates a shorter, more manageable link.
• Generate a unique short code for each long URL

• Store the mapping between short code and long URL in a database

• Redirect users from short URL to original long URL when accessed
Answered by AI
Add your answer
Q2. Write unit test for a sevice class
Ans. 
Unit test for a service class
• Create a test class for the service class

• Mock any dependencies of the service class

• Write test methods to cover different scenarios

• Use assertions to verify the expected outcomes
Answered by AI
Add your answer

Q1. Basic to medium questions related to DotNet Core MVC, SQL Server, etc
Add your answer

Q1. Completely unprofessional behavior of the interviewer. - No Introduction Direct start asking questions. - Asking too many misleading questions (First ask what you worked on, then ask did you heard about th...read more
Add your answer

Q1. Go Lang related questions
Add your answer
Q2. System architecture
Add your answer

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

Q1. 14 questions in excel formulas
Add your answer