Tech Mahindra
Multinational IT services and consulting company.
4 Rounds
~21 Days
Medium
The Interview Loop
Recruiter Screen (30 min)
Standard fit check, behavioral questions, and resume overview.
Technical Loop (3-4 Rounds)
Deep dive into domain knowledge, coding, and system design.
Interview Question Bank
Data Engineer
•
System Design
•
medium
Design an ETL pipeline on AWS to ingest daily Call Detail Records (CDRs) from an SFTP server, transform them, and load them into Redshift for reporting.
#AWS
#ETL Architecture
#Data Warehousing
Data Engineer
•
System Design
•
hard
Design a real-time streaming pipeline to process IoT sensor data from manufacturing plants, detect anomalies, and store the results.
#Streaming
#Kafka
#Spark Streaming
#NoSQL
Data Engineer
•
System Design
•
hard
A healthcare client wants to move from a traditional data warehouse to a Data Lakehouse architecture. How would you design this using Databricks?
#Data Lakehouse
#Databricks
#Medallion Architecture
Data Engineer
•
System Design
•
hard
Design a batch processing pipeline to ingest 500GB of transactional data daily. How do you handle incremental loads?
#Batch Processing
#Incremental Load
#Architecture
Data Engineer
•
Technical
•
medium
What is 'Idempotency' in the context of data engineering? Why is it critical for data pipelines?
#Pipeline Design
#Reliability
Difficulty Radar
Based on recent AI-sourced data.
Meet Your Interviewers
The "Standard" Interviewer
Senior EngineerFocuses on core competencies, system constraints, and clear communication.
SimulateUnwritten Rules
Think Out Loud
Always explain your thought process before writing code or drawing architecture.