PayPal Data Analyst 2 Interview Questions and Answers

Q1. Basic questions about resume
Add your answer

Q1. Workplace adjustment questions
Add your answer
Q2. Are you willing to work extra hours
Add your answer

Q1. Implement lag() and lead() without using lag() or lead()
Ans. 
Implement lag() and lead() functions without using lag() or lead()
• To implement lag(), shift the values in the array by one position to the right

• To implement lead(), shift the values in the array by one position to the left

• For example, to implement lag() on [1, 2, 3, 4], you can shift the values to get [null, 1, 2, 3]

• For lead(), you can shift the values to get [2, 3, 4, null]
Answered by AI
Add your answer
Q2. How will you go about optimising a query?
Ans. 
Optimising a query involves identifying bottlenecks and improving efficiency.
• Identify slow-performing queries using tools like query execution plans.

• Optimize database indexes to speed up query performance.

• Limit the number of columns and rows returned in the query.

• Avoid using SELECT * and instead specify only the necessary columns.

• Use appropriate data types and avoid unnecessary data conversions.

• Consider denormalizing d...read more
Answered by AI
Add your answer
Q3. If the 3rd position in a string contains 'b' replace it with 'v'
Ans. 
Replace 'b' with 'v' in the 3rd position of each string in an array
• Iterate through each string in the array

• Check if the 3rd position contains 'b'

• If yes, replace 'b' with 'v'
Answered by AI
Add your answer

Q1. What is the order of execution in sql
Add your answer

Q1. How to do conditional formatting in excel
Ans. 
Conditional formatting in Excel allows users to format cells based on specified conditions.
• Select the range of cells you want to apply conditional formatting to

• Go to the 'Home' tab and click on 'Conditional Formatting'

• Choose the desired formatting option, such as color scales, data bars, or icon sets

• Set the conditions for when the formatting should be applied, such as greater than, less than, or equal to a certain valu...read more
Answered by AI
Add your answer

Q1. Tell me about yourself and the current projects you are working on.
Add your answer

Q1. Sql Questions on regex, json , window functions were there.
Add your answer

Q1. Questions on current project, Tableau related question were there.
Add your answer

Q1. Detailed discussion on past experience and projects.
Add your answer

Q1. 2 Hackerrank SQL Questions
Add your answer
Q2. 1 Hackerrank Python Question
Add your answer

It was a basic Aptitude test, Needed to learn Probability, Permutation , Cobination and SQL.
Total Duration 1 Hour.

Q1. Sql,power bi,aptitude,technical
Add your answer
Q2. How you take criticism
Ans. 
I view criticism as an opportunity for growth and improvement, embracing feedback to enhance my skills and performance.
• I actively listen to feedback without becoming defensive, ensuring I understand the critique fully.

• For example, when a colleague pointed out an error in my data analysis, I took the time to review their comments and corrected my approach.

• I ask clarifying questions to gain deeper insights into the criti...read more
Answered by AI
Add your answer

Q1. SQL case study for data
Add your answer
Q2. Find nth salary
Ans. 
To find the nth salary in a dataset
• Sort the dataset in descending order based on salary

• Remove duplicates if necessary

• Return the salary at index n-1
Answered by AI
Add your answer