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

Analyst – GURUGRAM

Company
Company KPMG
Type
Opportunity Type Internship
Salary
Stipend / Salary Not disclosed
Location
Location Gurugram, Haryana, India
Posted Date
Posted Date Today
Microsoft Excel Microsoft Outlook MS Office Suite English communication attention to detail problem solving analytical thinking multi‑system handling time management organization stakeholder management
πŸ“–
Placement Papers for Analyst Roles Open Resource β†—
Curated set of past placement papers to help you practice typical questions asked for analyst positions.
πŸ“–
Interview Experiences and Tips Open Resource β†—
Real candidate experiences and preparation tips that are useful for cracking the analyst interview process.
πŸ“–
Comprehensive Interview Guide Open Resource β†—
Step‑by‑step guide covering interview stages, common questions, and preparation strategies for analyst roles.
πŸ“–
Problem‑Solving Practice Set Open Resource β†—
A collection of coding and logical problems to sharpen analytical thinking required for the technical rounds.

Graduates with a BA, B.Com, B.Ed, BE or BCA degree; 0 to less than 2 years of relevant experience; no minimum percentage specified; eligible for any graduation batch; must have cleared all backlogs; strong English communication skills; willingness to work in Gurugram office.

1
Round 1: Online aptitude/technical test
2
Round 2: Technical interview (focus on CPE processes, Excel, stakeholder handling)
3
Round 3: Managerial interview (scenario based, communication)
4
Round 4: HR interview (fitment, culture, salary discussion)
KPMG Global Services (KGS) is the technology and operations arm of KPMG, one of the world’s leading professional services firms. With a presence in over 150 countries, KGS delivers end‑to‑end solutions for audit, tax, advisory and consulting clients, leveraging cutting‑edge technology platforms and a deep pool of domain expertise. The organization is known for its strong emphasis on continuous learning, ethical standards, and a collaborative culture that encourages innovation and career growth. Working at KGS gives fresh graduates exposure to global best practices, cross‑border projects, and the opportunity to build a career in a highly respected brand. The Analyst role in Gurugram is an entry‑level position designed for recent graduates from BA, B.Com, B.Ed, BE or BCA streams. As an Analyst, you will be part of the Learning & Development support team that handles the end‑to‑end course review and approval workflow for KPMG’s Continuing Professional Education (CPE) program. You will interact with internal stakeholders, external training providers, and learners to ensure that all courses meet NASBA and KPMG guidelines, while maintaining high service‑level agreements. **Key Responsibilities** 1. Manage the complete course review and approval lifecycle from submission to certification. 2. Respond to learner queries and complaints via email, ensuring timely resolution. 3. Validate course content against NASBA and KPMG CPE standards. 4. Assign, track, and monitor daily learning requests across multiple systems. 5. Administer CPE credits in the Learning Management System and generate attendance certificates when required. 6. Communicate updates and status to internal and external stakeholders. 7. Maintain data accuracy, generate reports, and meet SLA targets. 8. Follow company policies, compliance procedures, and quality standards. 9. Identify process bottlenecks, propose improvements, and escalate critical issues. 10. Support busy season activities and ensure uninterrupted service delivery. **Tech Stack & Tools**: Microsoft Excel, Outlook, PowerPoint, Word, Learning Management System (LMS), email platforms, and basic data‑analysis tools. **Growth Path**: Analysts typically progress to Senior Analyst, then to Associate, Manager, and eventually to senior leadership roles within the Learning & Development or broader consulting streams. KPMG invests heavily in up‑skilling through internal training, certifications, and mentorship programs. **Why Join KPMG**: The role offers a gateway to a global professional services network, exposure to international compliance standards, and a structured career roadmap. Freshers benefit from a supportive team‑driven environment, regular feedback, and opportunities to work on high‑impact projects that shape the professional development of KPMG’s workforce worldwide.

KPMG β€” 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 🎯
KPMG Interview Preparation Corner

Comprehensive guide covering typical interview formats, common questions, and preparation tips for KPMG 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 (Microsoft Excel, Microsoft Outlook, MS Office Suite, English communication, attention to detail, problem solving, analytical thinking, multi‑system handling, time management, organization, stakeholder management) & 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
KPMG 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 KPMG as a Analyst – GURUGRAM?
Preparation Tip: Highlight KPMG's market reputation, recent tech innovations, and how your skills in Microsoft Excel 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 Non IT

View Category Feed β†—
KPMG
Analyst – GURUGRAM
Apply Apply Now β†—
Chat Chat with Kashii