Ltimindtree Data Engineer Interview Questions

The questions to prepare for a Ltimindtree Data Engineer interview. Questions from real interview reports rank first. Updated daily.

40questions

~8htotal time

Track your progressSign up free to work through all 40 questions and resume where you left off.

SQL & Data ManipulationStart here. 10 questions · ~115 min

Translate a PySpark running-total requirement into PostgreSQL for each account, ordered chronologically with deterministic tie handling.

Convert SQL Rank to PySparkMedium

Practice

Return all records with the second distinct salary rank using PostgreSQL RANK semantics.

Data Manipulationdatabase queryingAggregations

Ltimindtree

More SQL & Data Manipulation questions with a free account

Coding9 questions · ~104 min

Implement a normalized word count using map-reduce style tokenization and aggregation.

PySpark JSON to ParquetHard

Practice

Define a deterministic PySpark transformation plan for reading ADLS JSON data and writing curated Parquet output.

deduplicationclean codedata persistence

Ltimindtree

More Coding questions with a free account

Create a free account to unlock this list and practice real interview questions.

Pipelines8 questions · ~92 min

Spark Optimization and Cost EfficiencyHard

Explain how you diagnosed and optimized a Spark job while preserving data correctness and reducing runtime and infrastructure cost.

distributed computingETL optimizationbottleneck optimization

Ltimindtree

More Pipelines questions with a free account

Technical Fundamentals3 questions · ~35 min

Snowflake Micro-PartitionsMedium

Tests your knowledge of Snowflake’s storage layout and how it supports efficient query pruning.

performancetechnical experienceData Modeling

Ltimindtree

More Technical Fundamentals questions with a free account

Behavioral & Leadership8 questions · ~92 min

More Behavioral & Leadership questions with a free account