AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
AT&T Interview Questions and Answers
30 Interview questions
Denormalization in OLAP systems improves query performance by reducing the complexity of data retrieval.
Denormalization reduces the number of joins needed in queries, speeding up data retrieval.
In OLAP, data is often read-heavy; denormalized structures like star schemas optimize read performance.
For example, a star schema combines fact tables with dimension tables, simplifying queries.
Denormalization can lead to d...
Compensation and benefits include salary, bonuses, health insurance, retirement plans, and other perks.
Base Salary: The fixed annual amount paid to an employee, e.g., $100,000.
Bonuses: Performance-based incentives, e.g., annual bonuses up to 20% of salary.
Health Insurance: Coverage for medical expenses, e.g., employer pays 80% of premiums.
Retirement Plans: Contributions to 401(k) or pension plans, e.g., employer m...
CLR stands for Common Language Runtime, a virtual machine component of the .NET framework responsible for managing code execution.
CLR provides services such as memory management, exception handling, and security.
It compiles code into Intermediate Language (IL) and then translates it into machine code at runtime.
CLR allows for language interoperability within the .NET framework, enabling different languages to work...
Adding a tree child and subchild resembles creating directories and subdirectories in a file system.
A tree structure consists of nodes, where each node can have multiple children.
To add a child, create a new node and link it to the parent node.
For example, if 'Folder A' is a parent, 'Folder B' can be a child of 'Folder A'.
To add a subchild, link a new node to the child node, e.g., 'File 1' as a subchild of 'Folder...
Using Unix command 'grep' to find a word in a set of files
Use 'grep' command followed by the word you want to search for and the file(s) you want to search in
Add the '-r' flag to search recursively in all files in a directory
Use '-i' flag for case-insensitive search
Example: grep 'hello' file.txt
Example: grep -r 'error' /path/to/directory
Example: grep -i 'apple' file1.txt file2.txt
Azure hosted AKS is a managed Kubernetes service that simplifies deployment and management of containerized applications.
AKS stands for Azure Kubernetes Service
AKS is a fully managed Kubernetes container orchestration service
AKS automates the deployment, scaling, and management of containerized applications
AKS integrates with other Azure services such as Azure Active Directory, Azure Monitor, and Azure Container R...
AT&T HR Interview Questions
Kubernetes is a container orchestration platform that manages and automates the deployment, scaling, and management of containerized applications.
Kubernetes uses a master-slave architecture with a control plane and worker nodes.
The control plane manages the overall state of the cluster and schedules workloads to the worker nodes.
Worker nodes run the containers and communicate with the control plane to receive inst...
I would listen to their concerns, empathize with their situation, apologize for any inconvenience caused, and offer a solution to their problem.
Remain calm and professional
Listen actively to the customer's complaint
Empathize with their situation and apologize for any inconvenience caused
Offer a solution to their problem, and if necessary, escalate the issue to a supervisor
Follow up with the customer to ensure thei...
Router and filter transformations are used in Informatica for data filtering, but they have different functionalities.
Router transformation is used to route data based on specified conditions to multiple output groups.
Filter transformation is used to filter rows based on specified conditions and pass only the matching rows to the output.
Router transformation can have multiple output groups, each with its own condi...
Duplicates in mappings can be handled using various techniques in Informatica.
Use the Sorter transformation to sort the data and then use the Aggregator transformation to eliminate duplicates.
Use the Expression transformation with the DISTINCT keyword to remove duplicates.
Use the Rank transformation to rank the data and then filter out the duplicates based on the rank.
Use the Lookup transformation to check for dup...
AT&T Interview Experiences
60 interviews found
Anonymous
(2 Questions)
- Q1. How to pull the large amount of data in spring data jpa
- Q2. Write singleton class
Interview Preparation Tips
Skills evaluated in this interview
I appeared for an interview in Dec 2024.
(3 Questions)
- Q1. What is Object-Oriented Programming (OOP), and can you explain its fundamental concepts?
- Ans.
OOP is a programming paradigm based on the concept of objects, which can contain data in the form of fields and code in the form of procedures.
OOP focuses on creating objects that interact with each other to solve complex problems.
Fundamental concepts include classes, objects, inheritance, encapsulation, and polymorphism.
Classes are blueprints for creating objects, while objects are instances of classes.
Inheritance all...
- Q2. What is the definition of an array, and what are the different types of arrays?
- Ans.
An array is a data structure that stores a collection of elements of the same type. There are different types of arrays such as one-dimensional, multi-dimensional, and associative arrays.
One-dimensional array: Stores elements in a single row or column.
Multi-dimensional array: Stores elements in multiple rows and columns.
Associative array: Uses key-value pairs to store elements.
Example: ['apple', 'banana', 'orange']
- Q3. What is the clr
- Ans.
CLR stands for Common Language Runtime, a virtual machine component of the .NET framework responsible for managing code execution.
CLR provides services such as memory management, exception handling, and security.
It compiles code into Intermediate Language (IL) and then translates it into machine code at runtime.
CLR allows for language interoperability within the .NET framework, enabling different languages to work toge...
The content is based on HTML, Windows, and ADO.NET.
(2 Questions)
- Q1. What motivates you to pursue this job?
- Ans.
I am motivated to pursue a career as a Customer Care Executive because I enjoy helping others and providing excellent service.
I have a passion for assisting customers and resolving their issues
I thrive in a fast-paced environment where I can use my communication skills effectively
I find satisfaction in ensuring customer satisfaction and building positive relationships
I believe in the importance of delivering exceptiona...
- Q2. What is your expected salary?
- Ans.
My expected salary is based on my experience, skills, and the market rate for web developers.
I have researched the average salary for web developers in this location.
I am open to negotiation based on the overall compensation package offered.
I am looking for a salary that reflects my expertise and contributions to the team.
I applied via Approached by Company and was interviewed in Dec 2024. There were 3 interview rounds.
Request to write procedures for React, Node, and MySQL.
Discussed the terminologies related to the job position, such as securing data and handling large datasets.
(2 Questions)
- Q1. What is your reason for seeking a change in your current position?
- Ans.
Seeking new challenges and opportunities for growth in a more specialized role.
Desire to work on more complex projects
Opportunity to specialize in a specific technology or domain
Seeking career advancement and professional development
Looking for a more challenging and rewarding role
- Q2. What is the reason for your job changes approximately every 2.5 years?
- Ans.
Seeking new challenges and opportunities for growth led to job changes every 2.5 years.
Desire for new challenges and opportunities for growth
Seeking higher compensation or better benefits
Company restructuring or layoffs
Relocation or family reasons
Exploring different industries or technologies
Interview Preparation Tips
I applied via Referral and was interviewed in Oct 2024. There was 1 interview round.
(2 Questions)
- Q1. It was a online coding round with one question related to a medium hard binary search question..
- Q2. The second question was bit ambiguous question involving a tree, where we were asked to add a tree child and subchild in the form a a directory and subdirectory
- Ans.
Adding a tree child and subchild resembles creating directories and subdirectories in a file system.
A tree structure consists of nodes, where each node can have multiple children.
To add a child, create a new node and link it to the parent node.
For example, if 'Folder A' is a parent, 'Folder B' can be a child of 'Folder A'.
To add a subchild, link a new node to the child node, e.g., 'File 1' as a subchild of 'Folder B'.
T...
Interview Preparation Tips
I appeared for an interview in May 2025, where I was asked the following questions.
- Q1. SQL - easy/ medium aggregation based queries Python - list comprehension Databases - deep dive into OLAP dbs and data formats like AVRO, PARQUET Deep dive on points mentioned in resume. Overall 4 rounds - ...
- Q2. There might be offsite rounds
Selected
I appeared for an interview in Jun 2025, where I was asked the following questions.
- Q1. Spring boot , elastic query and docker based questions
- Q2. Find first non repeating letter of a string
Selected
I applied via Referral and was interviewed in Aug 2024. There were 3 interview rounds.
(2 Questions)
- Q1. Ospf protocol and routing
- Q2. Osi layers and bgp
(2 Questions)
- Q1. Bgp protocol and switching
- Q2. Incident management
(2 Questions)
- Q1. Tell me about yourself
- Ans.
I am a highly experienced Senior Network Engineer with a strong background in designing, implementing, and managing complex network infrastructures.
Over 10 years of experience in network engineering
Proficient in Cisco, Juniper, and Palo Alto technologies
Skilled in network design, implementation, and troubleshooting
Certified in CCNP and JNCIP
Led successful network upgrade projects at previous companies
- Q2. Experience and expertice , certification
Chandra Sekhar Mahanta
Selected
Automation scripting and test management.
How will you manage escalations with a third-party vendor?
(3 Questions)
- Q1. What is the breakdown of compensation and benefits?
- Ans.
Compensation and benefits include salary, bonuses, health insurance, retirement plans, and other perks.
Base Salary: The fixed annual amount paid to an employee, e.g., $100,000.
Bonuses: Performance-based incentives, e.g., annual bonuses up to 20% of salary.
Health Insurance: Coverage for medical expenses, e.g., employer pays 80% of premiums.
Retirement Plans: Contributions to 401(k) or pension plans, e.g., employer matche...
- Q2. Location preferences
- Ans.
I prefer locations that foster collaboration, innovation, and work-life balance, enhancing team productivity and morale.
I thrive in urban settings with access to diverse talent pools, like New York or San Francisco.
Remote work options are appealing, as they allow flexibility and can lead to increased job satisfaction.
I value locations with a strong professional network, such as Boston for healthcare or tech hubs like A...
- Q3. Reduce notice period in previous company
Interview Preparation Tips
I applied via LinkedIn and was interviewed in Jun 2024. There was 1 interview round.
(3 Questions)
- Q1. Sql question related to windows function
- Q2. Unix basics - find a word in a set of files
- Ans.
Using Unix command 'grep' to find a word in a set of files
Use 'grep' command followed by the word you want to search for and the file(s) you want to search in
Add the '-r' flag to search recursively in all files in a directory
Use '-i' flag for case-insensitive search
Example: grep 'hello' file.txt
Example: grep -r 'error' /path/to/directory
Example: grep -i 'apple' file1.txt file2.txt
- Q3. Python question related to file system, regex
Interview Preparation Tips
Skills evaluated in this interview
Selected
I appeared for an interview in Mar 2025, where I was asked the following questions.
- Q1. Tell me about your self.
- Q2. Why do you join this company.
- Q3. What is Oops concepts in java.
- Q4. What are the main features of java.
- Q5. What is the difference between JDK, JRE, AND JVM.
Skills evaluated in this interview
(2 Questions)
- Q1. Difference between streams and parallel streams
- Q2. What is Static keyword in Java do?
Interview Preparation Tips
Skills evaluated in this interview
Top trending discussions
AT&T Interview FAQs
The duration of AT&T interview process can vary, but typically it takes about less than 2 weeks to complete.
Tell us how to improve this page.
AT&T Interviews By Designations
- AT&T Network Engineer Interview Questions
- AT&T Senior Manager Interview Questions
- AT&T Senior Associate Interview Questions
- AT&T Technical Specialist Interview Questions
- AT&T Java Developer Interview Questions
- AT&T Intern Interview Questions
- AT&T Technical Intern Interview Questions
- AT&T Senior Technical Specialist Interview Questions
- Show more
Interview Questions for Popular Designations
- Network Engineer Interview Questions
- Executive Interview Questions
- Intern Interview Questions
- Business Analyst Interview Questions
- Senior Engineer Interview Questions
- Associate Software Engineer Interview Questions
- Senior Software Engineer Interview Questions
- Data Analyst Interview Questions
- Show more
Overall Interview Experience Rating
based on 52 interview experiences
Difficulty level
Duration
Interview Questions from Similar Companies
|
Technical Specialist
329
salaries
|  ₹22.3 L/yr - ₹38 L/yr |
|
Senior Associate
275
salaries
| ₹11.7 L/yr - ₹20 L/yr |
|
Network Engineer
218
salaries
| ₹4.2 L/yr - ₹14 L/yr |
|
Senior Technical Specialist
148
salaries
| ₹30.2 L/yr - ₹55 L/yr |
|
Senior Network Engineer
110
salaries
| ₹10.7 L/yr - ₹18.2 L/yr |
Jio
Vodafone Idea
Bharti Airtel
Ericsson
- Home >
- Interviews >
- AT&T Interview Questions
