S&P Global Data Engineer Interview Questions and Answers

Q1. Basic Spark, Python, SQL Questions.
Add your answer
Q2. Some Data Modelling Questions.
Add your answer

Basic aptitude questions

Q1. SQL basics questions like joins
Add your answer
Q2. Pandas basics for data manipulation
Add your answer

Very Tough Test, high chances of giving up in the beginning. Test was 2 hrs, covered OOPS, Networks, ML, SQL and some other topics total of 8 questions.

Q1. Basic AI/ML and SQL/DBMS questions
Add your answer

Q1. Mostly about tech stack in projects that I've done, python and AI coding(just asked to write algos) & basic HR
Add your answer

Q1. I/p 1 o.p 1 1,2 1,2,3 Using ab initio
Add your answer
Q2. Inner Join , left distinct join , delete files grater than 30 days
Add your answer

Aws, scala and cloud concept

Q1. Python question
Add your answer

Q1. SQL and python medium level questions
Add your answer

Q1. What is pip in python
Ans. 
pip is a package manager for Python that allows you to install and manage libraries and dependencies.
• pip is used to install Python packages from the Python Package Index (PyPI)

• It can also be used to uninstall packages, upgrade packages, and list installed packages

• Example: 'pip install numpy' installs the numpy package
Answered by AI
Add your answer
Q2. Questions on join
Add your answer

Q1. Remove duplicates from given table
Ans. 
Use SELECT DISTINCT to remove duplicates from a table
• Use SELECT DISTINCT to retrieve unique rows from the table

• Identify the columns that should be used to determine uniqueness

• Consider using GROUP BY if you need to remove duplicates based on specific columns
Answered by AI
Add your answer