Zelis Data Engineer Interview Questions and Answers

Round duration - 90 minutes
Round difficulty - Medium

It was Technical + Aptitude MCQ round.The technical section consisted if MCQ related to DSA,OS,DBMS.The aptitude section consisted of questions related to basic mathematics.

Q1. 
Candies Distribution Problem Statement
Prateek is a kindergarten teacher with a mission to distribute candies to students based on their performance. Each student must get at least one candy, and if two s...read more
Ans. 
The task is to distribute candies to students based on their performance while minimizing the total candies distributed.
• Create an array to store the minimum candies required for each student.

• Iterate through the students' ratings array to determine the minimum candies needed based on the given criteria.

• Consider the ratings of adjacent students to decide the number of candies to distribute.

• Calculate the total candies req...read more
Answered by AI
Add your answer

Round duration - 30 minutes
Round difficulty - Medium

It was a technical interview testing the basic skills of OS and DBMS of candidates along with few project discussions from your CV.

Q1. Can you write 15 Linux commands along with their functions?
Ans. 
List of 15 Linux commands with their functions
• ls - list directory contents

• pwd - print working directory

• cd - change directory

• mkdir - make a new directory

• rm - remove files or directories

• cp - copy files and directories

• mv - move or rename files and directories

• grep - search for patterns in files

• chmod - change file permissions

• ps - display information about running processes

• top - display and update sorted information about pr...read more
Answered by AI
Add your answer
Q2. What are DDL (Data Definition Language) and DML (Data Manipulation Language)?
Ans. 
DDL is used to define the structure of database objects, while DML is used to manipulate data within those objects.
• DDL includes commands like CREATE, ALTER, DROP to define database objects like tables, indexes, etc.

• DML includes commands like INSERT, UPDATE, DELETE to manipulate data within tables.

• Example of DDL: CREATE TABLE employees (id INT, name VARCHAR(50));

• Example of DML: INSERT INTO employees VALUES (1, 'John Doe
Answered by AI
Add your answer

Questions on Integer Arrays and String printing in a zigzag manner.

Q1. Questions on Integer Array and String pattern printing
Add your answer
Q2. Given integer arrays including 0s. Push all 0s at the end of the array.
Ans. 
Use two pointers to swap non-zero elements with zero elements at the end of the array.
• Initialize two pointers, one for iterating through the array and one for pointing to the last non-zero element.

• Swap non-zero elements with the last non-zero element and increment the pointer for non-zero elements.
Answered by AI
Add your answer

.net framework, C#, OPPs, Assembly, Coding snippets

Q1. Basic OPPs, C# and SQL
Add your answer

Q1. Scenario based questions
Add your answer

Q1. Why you want to join Allscripts
Add your answer