Tcg Digital Solutions Data Engineer Interview Questions and Answers

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

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. A Lot of OOPS and Virtual concept
Add your answer
Q2. Basic SQL till joins
Add your answer
Q3. Java script medium
Add your answer
Q4. C# oops output based
Add your answer

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

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

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

Q1. 14 questions in excel formulas
Add your answer