Filter interviews by
I applied via Campus Placement and was interviewed in Mar 2023. There were 3 interview rounds.
Basic verbal and quants easy to medium level
Round 1
1.Quant
2.Verbal
3.Reasoning
Round 2
1.Java code implementation
2.Sql query
I applied via Naukri.com and was interviewed in Mar 2022. There were 2 interview rounds.
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 condition.
...
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 duplicat...
To select the last 10 lines from a file in Informatica mapping, use the Source Qualifier transformation with a SQL override.
Add a Source Qualifier transformation to the mapping.
In the Source Qualifier transformation, specify the file as the source and set the appropriate file properties.
Write a SQL override in the Source Qualifier transformation to select the last 10 lines from the file.
Use the ROWNUM pseudocolumn or t...
Lookups in Informatica are used to retrieve data from a reference table based on a matching condition.
Lookups are used to perform data transformations and enrich the data in a mapping.
There are three types of lookups in Informatica: Connected, Unconnected, and Static.
Connected lookup returns multiple rows and can be used in any transformation.
Unconnected lookup returns a single value and is used in expressions or trans...
I have extensive experience in performance optimization of Informatica workflows and mappings.
Identifying and resolving performance bottlenecks
Tuning SQL queries and optimizing database connections
Optimizing transformations and reducing data processing time
Using partitioning and parallel processing for improved performance
Monitoring and analyzing session logs and performance statistics
Implementing caching and lookup op...
Push down optimization is a technique used in Informatica to improve performance by pushing data transformation operations to the source or target database.
Push down optimization reduces the amount of data transferred between the source and target systems.
It allows the database engine to perform transformations, aggregations, and filtering, leveraging its processing power.
By pushing down operations, Informatica minimiz...
Display the 10th line from a file in Unix.
Use the 'head' command to display the first 10 lines of the file.
Then use the 'tail' command to display the last line from the first 10 lines.
Combine both commands using a pipe ('|') to display the 10th line directly.
Display duplicate lines from a file in Unix.
Use the 'sort' command to sort the lines in the file.
Use the 'uniq' command with the '-d' option to display only the duplicate lines.
Redirect the output to a new file or display it on the console.
The Python code to check if a string starts with 'a' and has 4-8 'd' after that.
Use the startswith() method to check if the string starts with 'a'.
Use the count() method to count the occurrences of 'd' in the string.
Check if the count of 'd' is between 4 and 8 (inclusive).
To find disk usage of a specific directory in Unix, use the 'du' command.
Open the terminal and navigate to the desired directory
Run the 'du' command followed by the directory path
The command will display the disk usage in bytes for each file and subdirectory within the specified directory
To get the disk usage in human-readable format, use the '-h' option with 'du'
To sort the output by disk usage, use the '-s' option wi
In a left join, all the rows from the left table are included in the result set, along with matching rows from the right table.
Left join returns all rows from the left table and the matching rows from the right table
If there is no match, NULL values are returned for the columns of the right table
Left join is used to retrieve data from multiple tables based on a related column
I would address the issue by identifying the root cause, communicating with the client, and implementing necessary changes.
Identify the reasons for not meeting client expectations
Communicate with the client to understand their concerns and expectations
Evaluate the development process and identify areas for improvement
Implement necessary changes to meet client expectations
Ensure effective communication and collaboration...
I would handle the scenario by following a structured approach and effectively communicating with the team.
Assess the impact of the change on team workings
Identify the key challenges and areas of concern
Develop a structured plan to address the issues
Communicate the plan to the team and seek their input
Implement the plan while providing necessary support and guidance
Monitor the progress and make adjustments as needed
Reg...
I would handle the scenario by following a structured approach and effective communication.
Identify all the teams and stakeholders involved
Establish clear communication channels
Schedule regular meetings to discuss progress and address any issues
Document and track all interactions and decisions
Ensure everyone is aligned on goals and expectations
Provide regular updates and status reports
Resolve conflicts or disagreements...
Cloud computing offers scalability, cost-effectiveness, flexibility, and improved security compared to on-premise datacenters.
Scalability: Cloud allows easy scaling up or down of resources based on demand.
Cost-effectiveness: Cloud eliminates the need for upfront hardware and infrastructure investments.
Flexibility: Cloud enables easy access to data and applications from anywhere, anytime.
Improved security: Cloud provide...
I have extensive experience in performance optimization in SQL.
Identifying and optimizing slow queries
Creating and maintaining appropriate indexes
Using query execution plans to identify bottlenecks
Optimizing database schema and table design
Using appropriate data types and constraints
Caching and data caching techniques
Partitioning large tables
Optimizing query parameters and joins
Using stored procedures and views for per
I applied via LinkedIn and was interviewed before Oct 2023. There was 1 interview round.
AT&T interview questions for popular designations
I applied via LinkedIn and was interviewed before Aug 2022. There were 2 interview rounds.
Cloud project implementation challenges include security concerns, integration issues, and lack of expertise.
Security concerns related to data privacy and compliance regulations
Integration issues with existing systems and applications
Lack of expertise in cloud technologies and best practices
Cost management and budget constraints
Data migration and transfer challenges
Vendor lock-in and interoperability issues
Get interview-ready with Top AT&T Interview Questions
I applied via Referral and was interviewed before May 2023. There was 1 interview round.
I applied via LinkedIn and was interviewed before Mar 2022. There were 3 interview rounds.
Security related questions. Questions related to cryptography, SSL.
Design an e-commerce app with type ahead search. Provide end to end diagram and scaling.
Design a user-friendly interface with search bar and type ahead feature
Create a database schema to store product information
Implement a search algorithm to retrieve relevant products based on user input
Use caching and indexing to improve search performance
Scale the system by adding load balancers, increasing server capacity, and opt
I applied via AT&T website and was interviewed before Oct 2022. There were 2 interview rounds.
I applied via Company Website and was interviewed before Aug 2022. There were 3 interview rounds.
I applied via Naukri.com and was interviewed in Mar 2022. There was 1 interview round.
My expected CTC is negotiable based on the job responsibilities, company size, and location.
My expected CTC is based on my experience, skills, and industry standards.
I am open to discussing the compensation package during the interview process.
I am looking for a competitive salary that aligns with my qualifications and the market rate.
Yes, I am able to do rotational shifts as required for the job.
I am flexible with my work schedule and can adapt to different shifts
I have previous experience working in rotational shifts
I understand the importance of maintaining network operations 24/7, which may require working different shifts
Top trending discussions
The duration of AT&T interview process can vary, but typically it takes about less than 2 weeks to complete.
based on 46 interviews
Interview experience
Technical Specialist
306
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Associate
276
salaries
| ₹0 L/yr - ₹0 L/yr |
Network Engineer
235
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Technical Specialist
137
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Network Engineer
110
salaries
| ₹0 L/yr - ₹0 L/yr |
Verizon
Vodafone Idea
Bharti Airtel
Reliance Communications