i
Cornerstone OnDemand
Filter interviews by
I applied via Naukri.com and was interviewed in Apr 2023. There were 2 interview rounds.
Find second max salary of employee by department in SQL
Use GROUP BY clause to group employees by department
Use MAX() function to find the maximum salary
Use subquery to find the second maximum salary
Find second max salary of employee by department using pandas dataframe
Group the dataframe by department
Sort the salaries in descending order
Select the second highest salary for each department
Python code to download file from aws s3 to local using boto3
Install boto3 library using pip
Create an S3 client using boto3
Use the download_file method to download the file from S3 to local
A program to count the number of words in a text file using PySpark.
Read the text file using SparkContext
Split the lines into words using flatMap
Map each word to a tuple of (word, 1)
Reduce by key to count the occurrences of each word
Save the output to a file
Top trending discussions
I applied via Naukri.com and was interviewed in Apr 2021. There was 1 interview round.
I applied via Company Website and was interviewed before Jun 2020. There were 5 interview rounds.
I applied via Recruitment Consultant and was interviewed in May 2019. There were 4 interview rounds.
I was interviewed before Sep 2020.
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.
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...
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...
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.
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...
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
Tip 1 : Be clear about the concepts of Linux and shell scripting.
Tip 2 : Learn about the basics of Data structures and Algorithm.
Tip 3 : Be prepared to explain your projects mentioned in your CV.
Tip 1 : Use professional Keywords in your resume.
Tip 2 : Don't mention anything you are not confident in.
I applied via Naukri.com and was interviewed before Oct 2019. There was 1 interview round.
I applied via Campus Placement and was interviewed before Sep 2021. There were 4 interview rounds.
Math and verbal round .
General topics to speak
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
Success is achieving one's goals and feeling fulfilled in the process.
Success is subjective and varies from person to person.
It can be achieving a personal or professional goal.
Success can also be measured by the impact one has on others.
Feeling fulfilled and content is a key component of success.
Success is not always about material possessions or wealth.
Some of the top questions asked at the Cornerstone OnDemand Data Engineer interview -
based on 1 interview
Interview experience
Senior Software Engineer
111
salaries
| ₹0 L/yr - ₹0 L/yr |
Software Engineer
83
salaries
| ₹0 L/yr - ₹0 L/yr |
Lead Software Engineer
55
salaries
| ₹0 L/yr - ₹0 L/yr |
Associate Software Engineer
31
salaries
| ₹0 L/yr - ₹0 L/yr |
Principal Software Engineer
25
salaries
| ₹0 L/yr - ₹0 L/yr |
Saba Software
PeopleStrong
UKG
Sumtotal Systems