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

Analyst Trainee

Cognizant

  • India (Remote / Multiple), India
  • 3.5 LPA
  • Internship
  • Posted Today
HR
Recruiter contact
Recruiter / hiring contact
No public email in this post. Use a source-linked contact instead.

About the role

Cognizant is a global leader in professional services, providing consulting, technology, and outsourcing solutions to Fortune 500 companies across diverse industries. With a strong presence in India, Cognizant has built a reputation for delivering innovative digital transformation projects, leveraging cutting‑edge technologies such as cloud, AI, and analytics. The company’s culture emphasizes continuous learning, collaboration, and a commitment to client success, making it an attractive destination for fresh talent seeking a fast‑paced, technology‑driven career.

The Generation Cognizant (Gen‑C) hiring program is designed specifically for fresh graduates from three‑year degree streams. As an Analyst Trainee, you will embark on a structured learning journey that blends classroom‑style training with real‑world project exposure. The role serves as a launchpad into Cognizant’s technology ecosystem, allowing you to develop core consulting and technical skills while contributing to client engagements from day one.

Key responsibilities include

  • Assisting senior analysts in gathering and documenting business requirements.
  • Conducting data analysis and preparing insightful reports using Excel, SQL, or basic scripting.
  • Participating in solution design workshops and contributing ideas for process improvement.
  • Supporting the development and testing of prototypes or small‑scale applications.
  • Preparing presentation decks and client deliverables with a focus on clarity and professionalism.
  • Learning and applying industry‑standard tools such as Power BI, Tableau, or basic cloud services.
  • Collaborating with cross‑functional teams to ensure timely delivery of project milestones.
  • Maintaining documentation and knowledge‑base articles for future reference.
  • Engaging in continuous upskilling through Cognizant’s internal learning platforms.
  • Providing post‑implementation support and gathering feedback for iterative enhancements.

The technical stack for an Analyst Trainee typically includes Excel, SQL, basic Python or R for data manipulation, and exposure to visualization tools like Power BI or Tableau. Over time, trainees can progress to roles such as Business Analyst, Data Analyst, or Technology Consultant, with clear promotion pathways based on performance and skill acquisition.

Why join Cognizant? The company offers a robust onboarding program, mentorship from experienced professionals, and a vibrant community that encourages innovation. Freshers benefit from a stable salary, comprehensive benefits, and the opportunity to work on high‑impact projects for global clients, setting a solid foundation for a long‑term career in technology and consulting.

Eligibility & process

Who can apply

Eligibility: 3‑Year Full‑Time Degree (BCA, B.Sc, BA, B.Com, BBA, B.Voc, BMS or other equivalent). Minimum aggregate 60% (or CGPA 6.0/10). No active backlogs at the time of application. Eligible graduating batches: 2024, 2025, 2026. Candidates must be Indian citizens and have a valid email and phone number for communication.

Skills & stack

Basic Programming (Java Python) SQL Advanced Excel Data Visualization Adaptability Power BI Tableau

Selection process

  1. Round 1: Online Aptitude Test (logical reasoning, quantitative, verbal)
  2. Round 2: Technical Interview (basic programming, SQL, data analysis concepts)
  3. Round 3: HR Interview (behavioral fit, motivation, communication skills)

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 (Basic Programming (Java, Python), SQL, Advanced Excel, Data Visualization, Adaptability, Power BI, Tableau) & 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 Cognizant 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 Cognizant as a Analyst Trainee?
Highlight Cognizant's market reputation, recent tech innovations, and how your skills in Basic Programming (Java 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.
Cognizant 3.5 LPA
Recruiter Resume Apply
Chat Chat with Kashii