AT and T

Role: Data-related role (3+ years experience)

College: Not Specified

Interview Date: April 2, 2025

Interview Type: Off-Campus (LinkedIn application)

Result: Rejected

Difficulty: Easy

Rounds: 1 round (Online Coding Test)

Topics Asked: SQL, Excel, Snowflake, Database design patterns, Azure Databricks, Data Warehouse, Security compliances, Resilience in database designing, Delta tables, Autoloader in Databricks.

Experience:

This candidate applied for a role at AT&T Communication Services India Pvt Ltd via LinkedIn, despite not having the required 3+ years of experience. The process involved a single online coding assessment.

Round 1: Online Coding Test
The assessment link was received via email and could be attempted anytime, with a duration of 90 minutes.

Coding Questions:

• Data Warehouse & Database Designing: How to handle late arriving data in a customer data table with minimal downtime? How to utilize a common date dimension in three entity tables without data redundancy?
• Count Distinct Substrings.
• Azure Databricks: Best way to manage logs written to a single Azure notebook from various microservices? Importance of delta tables in Azure Databricks? How to use autoloader in Databricks when a library is not working well with streaming data?
• SQL query: How to check which employee has logged in for 6 or more consecutive days?

The candidate was rejected due to insufficient experience, but noted getting most of the assessment correct.

Tips: Gain hands-on practice for Azure tools, understand security compliances and resilience in database designing, and comprehend delta tables and their implementation in Azure Databricks. Resume tips included relevant projects and leadership experiences.