Photon Interactive Technical Analyst Interview: Rounds, Questions and Preparation

What the job involves

A Technical Analyst at an Indian IT services company supports the design, development, and maintenance of software applications for client projects. The role involves writing and debugging code, analysing requirements, and coordinating with senior developers and clients to deliver technical solutions. Freshers typically start in a trainee or junior analyst capacity, working on live projects under supervision.

Role and Technical Knowledge

1. 1

   What do you understand about the day-to-day responsibilities of a Technical Analyst in an IT services company?

   Mention tasks like coding, debugging, attending client calls, preparing documentation, and supporting senior team members. Show awareness that the role involves both technical and coordination work.

2. 2

   Explain the difference between a bug and a defect, and how you would handle each in a live project.

   Define bug as a coding error and defect as a deviation from requirements. Describe logging them in a tracking tool, prioritising based on impact, and coordinating with testers and developers.

3. 3

   What are the key phases of the Software Development Life Cycle (SDLC)?

   List requirements gathering, design, development, testing, deployment, and maintenance. Briefly explain your familiarity with at least two phases from academic projects.

4. 4

   How would you explain a technical concept to a non-technical client or stakeholder?

   Emphasise using simple language, avoiding jargon, and using analogies or visuals. Highlight the importance of confirming understanding and being patient.

Practical Scenarios

1. 5

   You are assigned a coding task with unclear requirements. What steps would you take?

   Show initiative by asking clarifying questions to your lead, checking existing documentation, and confirming assumptions before starting. Mention documenting the clarifications for future reference.

2. 6

   A client reports a critical issue in production. How would you respond?

   Focus on immediate triage: reproduce the issue, check logs, inform your supervisor, and apply a quick fix or workaround. Stress clear communication with the client and a post-mortem to prevent recurrence.

3. 7

   You are working on a legacy codebase with no documentation. How do you proceed?

   Suggest reading the code, running it locally, adding comments as you understand, and seeking help from senior colleagues. Mention using version control history to understand changes.

4. 8

   You have two urgent tasks from different team members. How do you prioritise?

   Assess impact and deadlines, communicate with both parties to negotiate priority, and inform your manager if needed. Show that you avoid silent delays and keep everyone updated.

Behavioural and HR

1. 9

   Why do you want to join the IT services sector, and what interests you about a role like Technical Analyst?

   Connect your interest to exposure to multiple clients, learning opportunities, and the chance to work on diverse technologies. Avoid saying it is just a backup option.

2. 10

   Tell me about a time you worked in a team to complete a project. What was your role?

   Use the STAR method: describe the situation, task, action, and result. Highlight collaboration, your specific contribution, and what you learned.

3. 11

   How do you handle feedback or criticism from a senior or mentor?

   Show openness to learning, ask for specific examples, and describe how you implemented the feedback. Avoid being defensive or dismissive.

4. 12

   Are you willing to relocate or work in different shifts as per project requirements?

   Be honest but flexible. If you have constraints, mention them politely. Most IT services roles expect some flexibility, so show willingness to adapt.

Coding and Database Fundamentals

1. 13

   Write a program to reverse a string without using built-in functions.

   Explain your logic step by step, handle edge cases like empty strings, and write clean code. Mention time and space complexity if asked.

2. 14

   What is the difference between SQL and NoSQL databases? When would you use each?

   Compare structured vs unstructured data, scalability, and use cases. Give examples like MySQL for transactions and MongoDB for flexible schemas.

3. 15

   Explain primary key, foreign key, and unique key with examples.

   Define each constraint clearly and show how they enforce data integrity. Use a simple two-table example like Customers and Orders.

4. 16

   How would you find the second highest salary from an Employee table?

   Write a SQL query using subquery or LIMIT/OFFSET. Explain the logic and mention alternative approaches like using DENSE_RANK.