S&P Global Data Specialist Interview Questions and Answers for Experienced

Q1. Sum and sumif, date functions, text join, pivot tables
Add your answer

Q1. Sort array in python
Ans. 
Use the sorted() function to sort an array of strings in Python.
• Use the sorted() function with the array as input to get a new sorted array.

• You can use the reverse parameter to sort in descending order.

• You can use the key parameter to specify a custom sorting key.

• Example: sorted_array = sorted(array)
Answered by AI
Add your answer
Q2. Merge 2 arrays in python
Ans. 
Use the concatenate function from numpy to merge two arrays in Python.
• Import numpy library

• Use np.concatenate() function to merge the arrays

• Ensure both arrays have the same data type
Answered by AI
Add your answer
Q3. Sql to find 2nd highest salary
Ans. 
Use SQL query with ORDER BY and LIMIT to find 2nd highest salary
• Use ORDER BY clause to sort salaries in descending order

• Use LIMIT 1,1 to skip the highest salary and get the second highest

• Example: SELECT salary FROM employees ORDER BY salary DESC LIMIT 1,1
Answered by AI
Add your answer
Q4. Sql for running total
Ans. 
Running total in SQL is achieved by using window functions like SUM() with OVER() clause.
• Use SUM() function with OVER() clause to calculate running total.

• Specify the window frame with ORDER BY in the OVER() clause.

• Running total can be reset based on certain conditions using PARTITION BY in the OVER() clause.
Answered by AI
Add your answer

DSA and ML, AI, Coding question

Q1. Case study which was easy
Add your answer

Q1. In depth questions on ML
Add your answer

1 hr exam it is easy to crack

Q1. Self intro, how to do you know about the job.
Add your answer
Q2. Skills what i know, Said it is wfh. You have internet connection. Comfort to work. It's has Target.
Add your answer

Q1. Again self intro, previous experience
Add your answer
Q2. Ms office skills, ok with contract and salary
Add your answer

Q1. Related to work they send mail after getting selected.
Add your answer
Q2. Test complete and offer letter received training started.
Add your answer

Q1. Learn Hash and Heap Concepts SQL Basics Basics of C programming (not deep) HTML Concepts Data Structures What is Data Analysis? How can you clean the data? Excel basics ( If not no worries) Queue and E...read more
Add your answer

Q1. Will you reallocate to Bangalore or any base locations? Are you interested to join the company?
Ans. 
Yes, I am open to reallocate to Bangalore or any base locations.
• I am willing to relocate to Bangalore or any other base locations as required by the company.

• I understand the importance of being flexible and adaptable in order to pursue career opportunities.

• I am excited about the prospect of joining the company and contributing to its success.
Answered by AI
Add your answer

Q1. Data modeling on website data
Add your answer
Q2. Spark performance tuning
Add your answer

Excel and python sql power bi

Q1. Regarding job discussion
Add your answer
Q2. Regarding skill question
Add your answer