Egen Senior Data Engineer Interview Questions and Answers

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

There was a coding round and out of 75 students 28 got selected for next round

Q1. Total on resume and basic coding questions like write code for different sorting algorithms.
Add your answer
Q2. Explain your project in detail and asking cross questions regarding project.
Add your answer

Q1. I was rejected in round 2.
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

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