S&P Global Interview Questions, Process, and Tips for Freshers

Q1. Tell Me About Your Selfie
Add your answer
Q2. Explain Internship Expericence
Ans. 
Completed a 6-month data analysis internship at XYZ Company
• Worked on various data analysis projects to extract insights and trends

• Utilized tools such as Excel, SQL, and Tableau to manipulate and visualize data

• Collaborated with team members to present findings and recommendations

• Gained hands-on experience in data cleaning, data visualization, and statistical analysis
Answered by AI
Add your answer

Q1. Financial statements
Add your answer
Q2. EPS, Cost of Capital
Add your answer

The questions were related to finance questions and some are from exel related . So read the question carefully and attempt your best.

Q1. The interview was basic fiance questions
Add your answer

Q1. 1) What Is IPO 2) Sides Of Balance Sheet 3) What Is Depreciation 4) Financial Statements
Ans. 
Questions related to finance and accounting
• IPO stands for Initial Public Offering, which is the first time a company's stock is offered to the public

• Balance sheet has two sides - assets and liabilities & equity

• Depreciation is the decrease in value of an asset over time due to wear and tear or obsolescence

• Financial statements include income statement, balance sheet, and cash flow statement
Answered by AI
View 1 more answer
Q2. Tell Me About Yourself About Your Family Background & Education
Add your answer

Sure, here are some example coding questions for a data analyst interview:

1. **Data Cleaning**: Given a dataset with missing values in the "age" column, write a Python function using Pandas to fill in the missing values with the mean age.

2. **Data Manipulation**: Write a SQL query to retrieve the top 10 customers who made the highest number of purchases from a transactions table.

3. **Data Visualization**: Using Matplotlib or Seaborn, create a histogram to visualize the distribution of sales prices from a dataset of real estate transactions.

4. **Statistical Analysis**: Calculate the correlation coefficient between two numerical variables in a dataset using Python and explain what the result indicates about their relationship.

5. **SQL Queries**: Write a SQL query to find the total revenue generated by each product category from a sales database.

6. **Algorithmic Questions**: Write a Python function to find the median of a list of numbers without using any built-in functions for sorting.

These questions cover a range of skills commonly required for data analyst positions, including data cleaning, manipulation, visualization, statistical analysis, SQL querying, and algorithmic problem-solving.

Duration -1 hr
AGM related question.
equity calculation, derivatives, shares allocation, Accounting Knowledge.

Q1. Salary negotiation and they ask whether you'll be able to come to office on anchor days.
Add your answer

Q1. Just the general HR questions
Add your answer
Q2. Something about yourself.
Add your answer

Q1. Kind of fun activity called as test. Just be alert and pay attention to details.
Add your answer

Q1. Same general HR questions.
Add your answer

Q1. All the MBA finance related questions mostly from stock market like IPO to a bit about SEC and BSE/NSE. A bit of HR questions too.
Add your answer