AT&T India Technology Consultant Interview: Rounds, Questions and Preparation

What the job involves

Technology Consultants in GCCs and Big 4 firms help clients design, implement, and optimise technology solutions that solve business problems. Day to day, they gather requirements, map processes, support testing and deployment, and coordinate between client teams and technical developers. The role blends business analysis, project coordination, and hands-on exposure to tools like SQL, cloud platforms, and enterprise software.

Role and Technical Knowledge

1. 1

   What is the difference between a technology consultant and a software developer in a GCC?

   Highlight that consultants focus on client requirements, process improvement, and solution design, while developers build and maintain code. Show awareness that consultants bridge business and technical teams.

2. 2

   How would you explain cloud computing to a non-technical client?

   Use a simple analogy like renting electricity instead of building a power plant. Mention scalability, cost, and pay-as-you-go models without deep jargon.

3. 3

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

   Use a subquery with MAX or a window function like DENSE_RANK. Explain your logic step by step and mention edge cases like ties or nulls.

4. 4

   What are the key phases of an Agile project, and how does a consultant contribute?

   List phases like sprint planning, daily stand-ups, review, and retrospective. Explain that consultants help prioritise backlog, clarify requirements, and remove blockers.

Practical Scenarios

1. 5

   A client complains that their newly deployed CRM system is slow. How would you investigate?

   Start by gathering data on usage patterns, check server logs, and review recent changes. Suggest a structured approach: reproduce the issue, isolate variables, and propose short-term and long-term fixes.

2. 6

   You are asked to migrate a legacy application to the cloud. What steps would you take?

   Outline assessment, planning, migration strategy (rehost, replatform, refactor), testing, and cutover. Mention risk mitigation and stakeholder communication.

3. 7

   The client keeps changing requirements mid-sprint. How do you handle it?

   Acknowledge the need for flexibility but emphasise change control. Suggest a backlog grooming session, impact analysis, and re-prioritisation with the product owner.

4. 8

   You have to present a technical solution to a non-technical audience. How do you prepare?

   Focus on business benefits, use visuals, avoid acronyms, and prepare for questions. Mention storytelling and checking for understanding.

Behavioural and Situational

1. 9

   Describe a time you worked in a team to solve a complex problem.

   Use STAR format. Highlight your specific role, how you collaborated, and the measurable outcome. Show listening and adaptability.

2. 10

   Tell me about a time you had to learn a new technology quickly.

   Pick a real example from academics or internships. Explain your learning method, resources used, and how you applied it successfully.

3. 11

   How do you handle a situation where a teammate is not contributing?

   Show empathy and professionalism. Suggest a private conversation, understanding their challenges, and escalating only if necessary. Emphasise team goals.

4. 12

   Give an example of a time you received critical feedback.

   Choose a constructive example. Describe the feedback, how you acted on it, and the improvement you achieved. Avoid defensiveness.

HR and Motivation

1. 13

   Why do you want to work as a technology consultant in a GCC or Big 4 firm?

   Connect your interest in technology and business, exposure to diverse clients, and structured learning. Mention specific aspects like global projects or training programs.

2. 14

   Where do you see yourself in five years?

   Show ambition aligned with the firm. Mention growing into a subject matter expert or leading a small team, and a commitment to continuous learning.

3. 15

   How do you prioritise tasks when you have multiple deadlines?

   Explain a method like Eisenhower matrix or MoSCoW. Give a brief example of how you applied it in college or an internship.

4. 16

   Are you willing to relocate or work in different shifts?

   Be honest but flexible. Express willingness to adapt to client needs and mention any constraints upfront.