Analyst Trainee

You will handle technical assistance for clients by diagnosing and resolving IT-related issues, while ensuring their systems and services operate efficiently.

Perform activities based on defined guidelines in SOPs/Runbooks with an understanding of business impact. Adhere to customer security and compliance requirements. Follow customer communication etiquettes. Ensure stated productivity requirements for the engagement. Contribute to continuous service improvement plans (CSI). Participate proactively in knowledge-sharing sessions. Act as a buddy for new hires. Adhere to organizational policies and processes (including Cognizant’s security policies, LP, timelines, etc.).

2026 batch of any 3-year UG degree (For e.g. BCA, BSc, BA, BBA, BCom, Bvoc, BMS, etc) with minimum 50% in academics. (rounding off 49.9% is not allowed). Students withstanding arrears are NOT eligible. Flexibility to work from any Cognizant office location in a given shift timing and technology is mandatory. Open to Indian nationals / OCIs who are currently residing in India.

Step 1: Master SQL & Database Fundamentals Joins, subqueries, aggregate functions Table relationships (one-to-one, one-to-many, many-to-many) Indexing and query optimization Step 2: Practice CRUD Operations INSERT, UPDATE, DELETE, SELECT statements Writing and executing Stored Procedures Understanding Low-Level Design (LLD) concepts Step 3: Learn Testing Basics Writing test cases and test scripts Manual vs Automated testing concepts Preparing test data for different scenarios Step 4: Understand IT Service Management (ITSM) Learn ITIL basics (Incident, Problem, Change Management) Familiarize with tools like ServiceNow, Jira, or Freshdesk Understand Standard Operating Procedures (SOPs) Step 5: Explore Data Analytics Tools Learn basics of Excel, Power BI, or Tableau Understand data interpretation and reporting Practice analyzing datasets and drawing insights Step 6: Build Soft Skills Practice clear written and verbal communication Work on time management techniques (Pomodoro, task prioritization) Prepare examples of teamwork and problem-solving from past experience Step 7: Prepare for Root Cause Analysis Questions Learn the "5 Whys" technique Practice structured problem-solving frameworks Review common service ticket scenarios Step 8: Mock Interview Practice Practice SQL queries on HackerRank or LeetCode Do mock interviews focusing on analytical thinking Prepare answers using the STAR method (Situation, Task, Action, Result) Step 9: Show Innovation Mindset Research industry trends in ITSM and Data Analytics Prepare examples where you experimented or improved a process Stay updated on new tools and technologies