Analyst Trainee

You will be responsible for performing database queries, CRUD operations, and writing stored procedures. You will prepare and execute tests, analyze and resolve service tickets, and demonstrate proficiency in IT Service Management and Data Analytics tools, with a strong drive for innovation.

2026 batch BCA, BSc - Computer Science, Information Technology (allied streams), Mathematics, Physics, Chemistry, Statistics & Electronics with minimum 60% in academics. (rounding off 59.9% is not allowed). Students should possess consistent academic record with minimum 60% in X, XII, Diploma, UG (rounding off 59.9% is not allowed). At the time of joining, all recruits need to have a minimum 60% aggregate in the pursuing degree with no standing arrears Students applied for re-evaluation and waiting for the results would be validated with the initial results score declared Appropriate CGPA to % conversion to be considered as per university norms Students with standing arrears are NOT eligible to apply.. 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

2026 batch BCA, BSc - Computer Science, Information Technology (allied streams), Mathematics, Physics, Chemistry, Statistics & Electronics with minimum 60% in academics. (rounding off 59.9% is not allowed). Students should possess consistent academic record with minimum 60% in X, XII, Diploma, UG (rounding off 59.9% is not allowed). At the time of joining, all recruits need to have a minimum 60% aggregate in the pursuing degree with no standing arrears Students applied for re-evaluation and waiting for the results would be validated with the initial results score declared Appropriate CGPA to % conversion to be considered as per university norms Students with standing arrears are NOT eligible to apply.. 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