Cornerstone OnDemand Data Engineer Interview Questions, Process, and Tips

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

Math and verbal round .

General topics to speak

Q1. Duplicates in array College Projects Hashmap implementation
Ans. 
Implement a function to find duplicates in an array of strings using Hashmap.
• Create a Hashmap to store the frequency of each string in the array

• Iterate through the array and check if the frequency of any string is greater than 1

• If yes, add it to the list of duplicates

• Return the list of duplicates
Answered by AI
Add your answer