KASHII UPDATEZ Everyday Student Requirements & Python Coding Tutorials by Python Kashi
JD #2580
Applications open Internship

MIS Analyst

Capgemini

  • Gurugram, India
  • β‚Ή5 LPA – β‚Ή7 LPA
  • 2 Years
  • Posted Today
HR
Recruiter contact
Recruiter / hiring contact
No public email in this post. Use a source-linked contact instead.

About the role

Capgemini is a global leader in consulting, technology services and digital transformation. With a presence in over 50 countries and a workforce of more than 300,000 professionals, the company helps clients across industries re‑imagine their businesses for the digital age. In India, Capgemini has built a strong reputation for delivering end‑to‑end solutions, fostering a culture of continuous learning, and providing a platform for young talent to grow into future leaders.

The role of MIS Analyst at Capgemini’s Gurgaon office is positioned within the Manufacturing & Operations Engineering vertical. The analyst will work closely with senior engineers, project managers and client teams to design, monitor and improve industrial processes, supply‑chain flows and facility management systems. This is a permanent position aimed at experienced professionals who can translate data into actionable insights and support large‑scale transformation initiatives.

Key Responsibilities

  • Collect, validate and analyse operational data from production, procurement and logistics systems.
  • Develop and maintain Management Information System (MIS) dashboards using tools such as Power BI, Tableau or Excel.
  • Identify process bottlenecks and recommend data‑driven improvements.
  • Support project and change‑management activities for industrial transformation programmes.
  • Prepare regular performance reports for internal stakeholders and client leadership.
  • Collaborate with cross‑functional teams to ensure data integrity and alignment with business objectives.
  • Participate in root‑cause analysis and corrective‑action planning.
  • Automate repetitive reporting tasks using scripting languages (Python, VBA).
  • Ensure compliance with data governance and security standards.
  • Contribute to knowledge‑sharing sessions and mentor junior analysts.

Tech Stack: SQL, Power BI/Tableau, Excel, Python (pandas, matplotlib), SAP modules (MM, PP), basic understanding of ERP and IoT data sources.

Growth Path: Starting as an MIS Analyst, high performers can progress to Senior Analyst, Operations Engineer, Project Lead and eventually to Manager – Industrial Operations or Consulting roles, with opportunities to move across Capgemini’s Engineering, Invent and Sogeti brands.

Why Join Capgemini: The company offers exposure to global clients, a structured learning ecosystem (Capgemini Learning Hub), mentorship from industry veterans, and a clear career ladder. Employees enjoy a collaborative environment, flexible work arrangements, and a focus on work‑life balance, making it an ideal place for fresh graduates and early‑career professionals to launch a rewarding career in industrial analytics.

Eligibility & process

Who can apply

Graduates (B.Tech/B.E., B.Sc., B.Com, MBA) from any stream with a minimum of 60% aggregate; 0‑2 years of relevant experience; no active backlogs; strong analytical mindset and proficiency in MS Excel and data visualisation tools.

Skills & stack

Data Analysis SQL Power BI Tableau Advanced Excel Python SAP Stakeholder Management

Selection process

  1. Round 1: Online Aptitude Test
  2. Round 2: Technical Interview (MIS & analytics concepts)
  3. Round 3: HR Interview (fitment and behavioural assessment)

Prep kit

20 resources
Study material 4
Company-specific guides 4
Likely coding questions 4
Round-wise strategy 4
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 Analysis, SQL, Power BI, Tableau, Advanced Excel, Python, SAP, 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 Capgemini Core Values, Learning Agility & Offer Terms Demonstrate passion, strong communication, and readiness for full-time collaboration.
Technical questions 5
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.
Behavioural & HR questions 3
Why do you want to join Capgemini as a MIS Analyst?
Highlight Capgemini's market reputation, recent tech innovations, and how your skills in Data Analysis directly solve their team's objectives.
Describe a challenging bug or academic project roadblock and how you resolved it.
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?
Explain your prioritization strategy, proactive communication with mentors/peers, and agile mindset.
Capgemini β‚Ή5 LPA – β‚Ή7 LPA
Recruiter Resume Apply
Chat Chat with Kashii