Me postulé a través de un reclutador. El proceso tomó 2 semanas. Acudí a una entrevista en Altimetrik en jul 2024
Entrevista
Recruiter cal and then coding interview with a "senior" tech person. As all interviewers appreciate the candidate talking through the thought process while solving the problem, this interviewer asked me to no talk and just write the code. And after that he will check the code. He was mighty rude and has no sense of team work. Very unfit to lead a team/project because he only discourages you.
Preguntas de entrevista [1]
Pregunta 1
Write SQL queries for:
1. From above data, pick latest transaction for each credit Card and total number of transactions done by each credit card
2. Given data: Team_A Team_B WON
find:
Team Total_Played Total_Won Total_Lost Total_Drawn
first L1 round asked pyspark, sql queries, python program
then scenario based questions about project work. concepts and questions on snowflake cloud, query optimization, monitoring, etl/elt difference, joins, using cte write the query
Me postulé a través de un reclutador. Acudí a una entrevista en Altimetrik (Hyderabad) en mar 2026
Entrevista
Initial Screening (HR / Recruiter Round)
This is a quick discussion to understand your background, experience, and expectations.
They typically ask about:
Your current role and projects
Tech stack (like PySpark, SQL, AWS, etc.)
Notice period and salary expectations
2. Technical Round 1 (SQL + Basics)
This round mainly checks your fundamentals.
You can expect:
SQL problems (joins, window functions, aggregations)
Data cleaning or transformation questions
Basic Python or PySpark questions
Example:
Find nth highest salary
Remove duplicates
Identify consecutive records
3. Technical Round 2 (Data Engineering Concepts)
This is more in-depth and practical.
Topics usually include:
Data pipeline design
ETL/ELT concepts
Batch vs streaming
Partitioning, bucketing
Data lakes vs data warehouses
They may ask:
How you designed a pipeline using Spark/Airflow
Handling late-arriving data
Performance optimization techniques
4. System Design Round (Important for 3+ yrs experience)
Here they test how you think and design systems.
Typical questions:
Design a data pipeline for a telecom or e-commerce system
Handle large-scale data ingestion (Kafka → S3 → Redshift)
Data quality and monitoring
Focus areas:
Scalability
Fault tolerance
Cost optimization
5. Managerial / Behavioral Round
This round checks how you work in a team.
Common questions:
Challenges you faced in a project
How you handled failures in pipelines
Working with stakeholders
The first round was technical and the interviewer started with asking me to write some python code on a compiler while sharing the screen, it was a leetcode question easy one.