Cornerstone OnDemand Interview Questions, Process, and Tips

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

I have experience with several CSPM tools.

• I have used AWS Config to monitor and assess the configuration of AWS resources.

• I am familiar with Azure Security Center, which provides continuous monitoring and threat detection for Azure resources.

• I have worked with Google Cloud Security Command Center to gain visibility into security risks and vulnerabilities in Google Cloud Platform.

• I have also used tools like CloudCheckr ...read more

I prioritize features in the roadmap based on strategic goals, customer feedback, market trends, and resource availability.

• Align features with strategic goals of the company

• Consider customer feedback and prioritize based on impact and urgency

• Take into account market trends and competitive analysis

• Evaluate resource availability and feasibility of implementation

• Use frameworks like MoSCoW method or Kano model for prioriti

I measure success by setting clear KPIs, tracking progress regularly, and analyzing data to make informed decisions.

• Set clear Key Performance Indicators (KPIs) to measure success

• Regularly track progress towards KPIs

• Analyze data to make informed decisions and adjustments

• Use tools like Google Analytics, Mixpanel, or internal dashboards for measurement

I communicate changes or goals through clear and concise messaging, utilizing various channels and ensuring alignment with stakeholders.

• Utilize multiple communication channels such as emails, meetings, presentations, and project management tools

• Tailor the message to the audience to ensure understanding and buy-in

• Provide regular updates on progress towards goals and address any concerns or questions

• Seek feedback from st...read more