Varite 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. Self Introduction
Add your answer
Q2. Salary Expectation
Add your answer

Q1. 14 questions in excel formulas
Add your answer

30 mins Aptitude Question

30 mins - 3 Coding Question

Q1. Describe Rest API
Ans. 
Rest API is a set of rules and conventions for building and interacting with web services using HTTP methods.
• Rest API stands for Representational State Transfer Application Programming Interface.

• It uses standard HTTP methods like GET, POST, PUT, DELETE to perform CRUD operations.

• RESTful APIs use URLs to access resources, and return data in JSON or XML format.

• Stateless communication allows for scalability and flexibilit...read more
Answered by AI
Add your answer
Q2. What is various Response code. Diffenrence b/w 200 & 201, 400 & 403
Ans. 
Response codes indicate the status of a HTTP request. 200 & 201 are success codes, while 400 & 403 are client error codes.
• 200 - OK: Request was successful

• 201 - Created: Request was successful and a new resource was created

• 400 - Bad Request: The server cannot process the request due to a client error

• 403 - Forbidden: The server understood the request, but refuses to authorize it
Answered by AI
Add your answer

60min of aptitude and coding test

2 questions on coding test

Basic aptitude questions and questions on React

Asked for printing patterns in a loop

Q1. Explain your code. Talked about projects, questions on array and a Water-jug problem puzzle question
Add your answer

Q1. Asked about family and residence.
Add your answer