KPIT Technologies Technical Analyst Interview: Rounds, Questions and Preparation

What the job involves

A Technical Analyst in Indian IT services supports the design, configuration, and troubleshooting of IT systems for clients, often working on application support, infrastructure monitoring, or data analysis tasks. Day to day, they resolve tickets, document issues, coordinate with senior engineers, and ensure service level agreements are met. The role is a common entry point for freshers into IT services and offers exposure to multiple technologies and client environments.

Role and Technical Knowledge

1. 1

   What is the difference between an incident and a problem in ITIL?

   Explain that an incident is an unplanned interruption or reduction in service quality, while a problem is the underlying cause of one or more incidents. Mention that incident management aims to restore service quickly, while problem management aims to prevent recurrence.

2. 2

   How would you troubleshoot a slow-running SQL query?

   Cover checking for missing indexes, analyzing the execution plan, looking for full table scans, and considering query rewriting or adding indexes. Also mention checking server resources and database statistics.

3. 3

   Explain the OSI model layers and give an example of a protocol at each layer.

   List the seven layers (Physical, Data Link, Network, Transport, Session, Presentation, Application) and provide examples like Ethernet, IP, TCP, HTTP. Relate to troubleshooting by explaining how to isolate issues at different layers.

4. 4

   What are the key differences between Windows and Linux operating systems from a support perspective?

   Discuss file system structures, command-line tools, user permissions, and common troubleshooting commands. Highlight that Linux often uses SSH and shell scripting, while Windows uses GUI tools and PowerShell.

Practical Scenarios

1. 5

   A user reports that they cannot access a critical application. Walk me through your steps to resolve this.

   Start by gathering information: check if it is a single user or multiple users, verify network connectivity, check application logs, and follow the incident management process. Mention communication with the user and escalation if needed.

2. 6

   You have multiple high-priority tickets. How do you prioritize and manage your time?

   Explain using criteria like impact and urgency, referring to SLAs, and communicating with stakeholders. Mention using a ticketing tool to track and update status, and delegating or escalating when appropriate.

3. 7

   How would you handle a situation where a client is angry about a recurring issue?

   Focus on active listening, acknowledging the issue, apologizing for the inconvenience, and explaining the steps being taken to resolve it permanently. Mention keeping the client informed and following up after resolution.

4. 8

   Describe a time when you had to learn a new technology quickly to solve a problem. How did you approach it?

   Use the STAR method: describe the situation, the technology, your learning approach (documentation, online courses, asking colleagues), and the successful outcome. Emphasize self-learning and resourcefulness.

Behavioural and HR

1. 9

   Why do you want to work as a Technical Analyst in IT services, and why our company?

   Show enthusiasm for solving technical problems and helping clients. Research the company's values, projects, and training programs. Align your career goals with the role's growth opportunities.

2. 10

   How do you handle working in rotational shifts, including night shifts?

   Express willingness and adaptability, mentioning that you understand the global nature of IT services. Highlight your ability to manage time and stay productive during different shifts.

3. 11

   Tell me about a time you worked in a team to achieve a goal.

   Use a specific example from college projects or internships. Describe your role, how you collaborated, and the outcome. Emphasize communication and teamwork.

4. 12

   Where do you see yourself in five years?

   Show ambition to grow into a senior technical or lead role, possibly specializing in a technology. Mention continuous learning and contributing to the organization's success.

Technical Fundamentals and Tools

1. 13

   What is a ticketing tool? Have you used any?

   Explain that ticketing tools like ServiceNow or Jira are used to log, track, and manage incidents and requests. If you have used one in a project or internship, describe your experience; otherwise, express eagerness to learn.

2. 14

   What is the difference between a hub, switch, and router?

   Describe hub as a broadcast device, switch as a device that forwards based on MAC addresses, and router as a device that connects networks and forwards based on IP addresses. Mention their roles in network troubleshooting.

3. 15

   Write a basic SQL query to find the second highest salary from an Employee table.

   Use a subquery with LIMIT/OFFSET or a correlated subquery. For example: SELECT MAX(Salary) FROM Employee WHERE Salary < (SELECT MAX(Salary) FROM Employee); Explain the logic.

4. 16

   What are some common causes of a server being down, and how would you check?

   Mention hardware failure, network issues, service crashes, or resource exhaustion. Explain checking server logs, ping, service status, and using monitoring tools. Emphasize following escalation procedures.