KASHII UPDATEZ Everyday Student Requirements & Python Coding Tutorials by Python Kashi
KashiiUpdatez
πŸ”₯ Today
JD #2579
Applications open Internship

MIS Analyst

Capgemini

  • Gurugram, India
  • β‚Ή5 LPA – β‚Ή7 LPA
  • 2 Years
  • Posted Today
Apply on official portal Prep kit
Build resume Find recruiter WhatsApp
HR
Recruiter contact
Recruiter / hiring contact
No public email in this post. Use a source-linked contact instead.
Connect LinkedIn

About the role

Capgemini is a global leader in consulting, technology services and digital transformation. With a presence in over 50 countries, the firm helps Fortune 500 companies re‑imagine their businesses through innovative solutions, cloud migration, AI, and data‑driven insights. In India, Capgemini has built a strong ecosystem of delivery centres, research labs and innovation hubs, offering employees exposure to cutting‑edge projects across sectors such as banking, retail, manufacturing, and telecom.

The company’s culture emphasizes continuous learning, collaboration, and a commitment to sustainability, making it a preferred destination for ambitious professionals.

The role of MIS Analyst at Capgemini’s Gurgaon office is designed for experienced candidates who can translate raw data into actionable business intelligence. As an MIS Analyst, you will be responsible for gathering, validating, and presenting data that drives strategic decisions for internal stakeholders and clients. You will work closely with functional teams, project managers, and senior leadership to ensure that key performance indicators (KPIs) are accurately tracked and reported.

Key Responsibilities

  • Collect, cleanse, and consolidate data from multiple sources including SAP, ERP, and legacy systems.
  • Design and maintain MIS dashboards using Power BI, Tableau, or similar visualization tools.
  • Generate periodic management reports, trend analyses, and ad‑hoc insights.
  • Monitor KPI health, flag anomalies, and recommend corrective actions.
  • Collaborate with business units to understand reporting requirements and translate them into technical specifications.
  • Automate repetitive reporting tasks through scripting (SQL, Python) or RPA tools.
  • Ensure data integrity, security, and compliance with company policies.
  • Participate in cross‑functional meetings to present findings and support decision‑making.
  • Mentor junior analysts and contribute to knowledge‑sharing sessions.
  • Continuously evaluate and improve reporting processes for efficiency.

Tech Stack: SQL, Advanced Excel, Power BI/Tableau, SAP BTP, Python (pandas), RPA (UiPath), data warehousing concepts.

Growth Path: Starting as an MIS Analyst, high performers can progress to Senior Analyst, MIS Lead, and eventually to roles such as Business Intelligence Manager or Data Strategy Consultant. Capgemini’s internal mobility program and extensive training catalog enable analysts to upskill into data science, cloud, or consulting tracks.

Why Join Capgemini? The firm offers a vibrant, inclusive environment where learning is embedded in daily work. Employees benefit from global exposure, mentorship from industry veterans, and a clear career ladder.

Competitive compensation, performance‑linked bonuses, and a robust benefits package further enhance the employee experience. If you are passionate about turning data into strategic advantage, Capgemini provides the platform, resources, and brand credibility to accelerate your career.

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
πŸ“– Aptitude Practice Questions & Mock Tests Curated logical, quantitative, and verbal reasoning problems for the initial online screening round. 🎯 Company-Specific Interview Preparation Corner Detailed interview experiences, exam formats, and previous test questions for Capgemini and tech roles. πŸ“ Technical Placement Question Bank High-yield coding cheat sheets, core CS fundamentals (OOP, DBMS, OS, Networks), and rapid revision guides. πŸ’» Algorithm, DSA & Live Code Debugger Practice Hands-on problem sets to improve coding speed and step-by-step memory debugging.
Company-specific guides 4
πŸ“– 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. 🎯 COMPANY GUIDE Capgemini Interview Preparation Corner Comprehensive guide covering typical interview formats, common questions, and preparation tips for Capgemini and off-campus tech roles. πŸ“ 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. πŸ’» CODING PRACTICE Algorithm and Data Structure Problem Set Practice problems to improve coding proficiency and algorithm problem-solving speed for technical rounds.
Likely coding questions 4
πŸ’» Two Sum & Two Pointers Array Optimization Easy / Medium Asked in 85% tech rounds ⚑ Live debugger πŸ’» Reverse Linked List & Detect Cycle (Floyd's Algorithm) Medium Frequently asked in core rounds ⚑ Live debugger πŸ’» SQL Nth Highest Salary with DENSE_RANK() & Subqueries Medium Top standard database question ⚑ Live debugger πŸ’» Valid Parentheses & Stack Implementation Easy / Medium Standard online assessment problem ⚑ Live debugger
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.

More fresh requirements in MBA & Management

View category feed β†—
Qualcomm Today

Senior AI Platform / Agentic Systems Engineer

Hyderabad, India Competitive Package

Linkton Today

Full Stack Engineer

India (Remote / Multiple), India Competitive Package

DoorDash Today

Senior Software Engineering, Backend

Hyderabad, India Competitive Package

The Alter Office Today

SDE 1

Bengaluru, India Competitive Package

Capgemini β‚Ή5 LPA – β‚Ή7 LPA
Recruiter Resume Apply
Chat Chat with Kashii