SailPoint Technologies Data Analyst Interview Questions and Answers

It was more about soft skills based on your work experience

Q1. Team interview - job responsibilites and work exp
Add your answer

Q1. Find second max salary of employee by department in sql
Ans. 
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
Answered by AI
Add your answer
Q2. Find second max salary 9f employee by department using python pandas dataframe
Ans. 
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
Answered by AI
Add your answer
Q3. Python code to download file from aws s3 to local using boto3
Ans. 
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
Answered by AI
Add your answer
Q4. Write word count program in pyspark
Ans. 
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
Answered by AI
Add your answer