KASHII UPDATEZ Everyday Student Requirements & Python Coding Tutorials by Python Kashi
KashiiUpdatez
REQUIREMENT_ID_139 β€’ 3-DAY_ACTIVE_POLICY

Data Operations

Company
Company Spglobal
Type
Opportunity Type Internship
Salary
Stipend / Salary β‚Ή6–10 LPA
Location
Location Ahmedabad
Posted Date
Posted Date Today
Data entry MS Excel SQL Attention to detail Analytical thinking Reporting tools Basic knowledge of data validation Communication skills
πŸ“–
Aptitude Practice Questions Open Resource β†—
Curated quantitative and logical aptitude problems to help you clear the online test at S&P Global.
πŸ“–
Company Interview Preparation Guide Open Resource β†—
Insights and sample questions for interviews at global finance and data firms like S&P Global.
πŸ“–
Comprehensive Interview Prep Resources Open Resource β†—
Step‑by‑step preparation material covering aptitude, technical, and HR topics relevant for S&P Global hiring.
πŸ“–
Algorithm and Data Structure Problems Open Resource β†—
Practice coding and problem‑solving questions to sharpen logical thinking for technical rounds.

Graduates (B.Tech/B.E, B.Sc, B.Com, MBA or equivalent) from any discipline with a minimum of 60% aggregate. Final year students of the 2025 or 2026 batch are eligible. No active backlogs at the time of joining. Candidates should possess strong analytical abilities, attention to detail, and basic computer proficiency.

1
Round 1: Online Aptitude Test
2
Round 2: Technical/Logical Round (data handling and Excel assessment)
3
Round 3: HR Interview
S&P Global is a leading provider of transparent and independent market intelligence, data, and analytics that help customers make informed decisions across the financial, corporate, and public sectors. With a presence in more than 30 countries, the company offers a wide range of solutions covering equities, commodities, credit, and indices. Its Metals & Mining division delivers deep, data‑driven insights into the global mining landscape, helping investors, corporations, and governments understand supply‑demand dynamics, pricing trends, and regulatory impacts. Working at S&P Global means being part of a culture that values curiosity, integrity, and continuous learning, while leveraging cutting‑edge technology to solve complex real‑world problems. The Data Operations role is positioned within the Metals & Mining Industry Content Department. As a fresher, you will be responsible for handling day‑to‑day data management tasks that ensure the accuracy and reliability of the content delivered to S&P Global’s clients. You will work closely with senior analysts, content managers, and technology teams to capture, validate, and report on data that powers market reports, dashboards, and research publications. This role offers a solid foundation in data handling, quality assurance, and reporting, making it an ideal launchpad for a career in data analytics or financial services. Key responsibilities include: 1. Perform straightforward, stand‑alone data entry and editing tasks following detailed guidelines and checklists. 2. Capture comprehensive information on metals and mining data points as defined by the content team. 3. Generate daily work‑performance reports using internal reporting tools, extracting and validating any data discrepancies. 4. Review feedback on content accuracy, help correct errors, and suggest procedural improvements. 5. Meet individual and team targets while maintaining high quality and excellence. 6. Collaborate with team members and related departments to understand and streamline processes. 7. Maintain documentation of data handling procedures and updates. 8. Participate in periodic data quality audits and assist in root‑cause analysis. 9. Support the creation of ad‑hoc data extracts for senior analysts when required. 10. Continuously learn and adopt new tools or technologies introduced by the department. The tech stack for this role primarily includes Microsoft Excel (advanced functions, pivot tables, macros), SQL for basic data extraction, and internal reporting platforms such as PowerBI or Tableau. Familiarity with data‑validation scripts and content‑management systems is a plus. Career growth at S&P Global is well‑structured. Starting as a Data Operations Analyst, high performers can progress to Senior Analyst, Data Quality Lead, or move into specialized analytics roles within the Metals & Mining division. The company also encourages cross‑functional moves into product development, client services, or broader data science tracks, supported by internal training programs and mentorship. Why join S&P Global? You will be part of a globally recognized brand that values data integrity and innovation. The role offers exposure to real‑world financial data, a collaborative environment, and ample opportunities for upskilling through workshops, certifications, and on‑the‑job learning. Fresh graduates will benefit from a clear career roadmap, competitive compensation, and the chance to contribute to insights that shape global markets.

Spglobal β€” Data Analytics & SQL Interview Guide

Previously asked questions, exam syllabus, coding benchmarks & round strategy.

APTITUDE & LOGIC πŸ“–
Aptitude Practice Questions & Online Mock Tests

Curated logical, quantitative, and verbal reasoning problems to sharpen reasoning skills required for the initial screening test.

Open Resource β†—
COMPANY GUIDE 🎯
Spglobal Interview Preparation Corner

Comprehensive guide covering typical interview formats, common questions, and preparation tips for Spglobal and off-campus tech roles.

Open Resource β†—
MOCK TESTS & PAPERS πŸ“
Comprehensive Interview Prep Resources & Syllabus

Collection of previous year questions, company-specific test patterns, and interview experiences for technical and HR rounds.

Open Resource β†—
CODING PRACTICE πŸ’»
Algorithm and Data Structure Problem Set

Practice problems to improve coding proficiency and algorithm problem-solving speed for technical rounds.

Open Resource β†—
Round 1: Online Assessment (OA)
Aptitude, Quantitative Logic & 2 Coding Problems
Focus on accuracy and speed. Practice arrays, strings, and standard arithmetic puzzles.
Round 2: Technical Interview 1
Core Tech Stack (Data entry, MS Excel, SQL, Attention to detail, Analytical thinking, Reporting tools, Basic knowledge of data validation, Communication skills) & Live Code Tracing
Explain your thought process aloud. Analyze time & space complexities before coding.
Round 3: System Design & Problem Solving
Database Schemas, APIs & Architecture Basics
Clarify edge cases, diagram schemas cleanly, and discuss scalability trade-offs.
Round 4: HR & Cultural Fit Discussion
Spglobal Core Values, Learning Agility & Offer Terms
Demonstrate passion, strong communication, and readiness for full-time collaboration.
What is the difference between WHERE and HAVING clauses in SQL? Answer β–Ό
Model Answer: WHERE filters rows before any groupings are applied, while HAVING filters aggregated groups after GROUP BY has executed.
Explain SQL Window functions: ROW_NUMBER(), RANK(), and DENSE_RANK(). Answer β–Ό
Model Answer: ROW_NUMBER() assigns unique sequential integers. RANK() assigns identical ranks to ties and skips ranks. DENSE_RANK() assigns identical ranks to ties without skipping rank numbers.
How do you handle NULL and missing values during data cleaning in Python/Pandas? Answer β–Ό
Model Answer: Use .isna().sum() to identify missing values. Impute with mean/median using .fillna() or remove with .dropna(subset=[...]) depending on variance impact.
What is the difference between Star Schema and Snowflake Schema in Data Warehousing? Answer β–Ό
Model Answer: Star Schema has denormalized dimension tables directly connected to the central Fact table. Snowflake Schema normalizes dimension tables into sub-dimensions to minimize redundancy.
How do you calculate MoM (Month-over-Month) growth in SQL? Answer β–Ό
Model Answer: Use LAG(revenue, 1) OVER (ORDER BY month) to fetch the previous month's revenue and compute (revenue - prev_revenue) / prev_revenue * 100.
Why do you want to join Spglobal as a Data Operations?
Preparation Tip: Highlight Spglobal's market reputation, recent tech innovations, and how your skills in Data entry directly solve their team's objectives.
Describe a challenging bug or academic project roadblock and how you resolved it.
Preparation Tip: Use the STAR method: Situation (project context), Task (what needed solving), Action (specific tools/logic applied), Result (quantifiable positive outcome).
How do you handle strict deadlines or sudden scope changes?
Preparation Tip: Explain your prioritization strategy, proactive communication with mentors/peers, and agile mindset.

More Fresh Requirements in Software & Tech

View Category Feed β†—
Spglobal
Data Operations
Apply Apply Now β†—
Chat Chat with Kashii