Tata Consultancy Services (North America) Data Engineer Interview Questions
The questions to prepare for a Tata Consultancy Services (North America) Data Engineer interview. Questions from real interview reports rank first. Updated daily.
Parse nested JSON and expand object arrays into flattened row dictionaries using recursive traversal.
Tata Consultancy Services (North America)Reverse a string and extract insertion-ordered unique values from a Python dictionary using slicing and a set.
Tata Consultancy Services (North America)Explain how map differs from flatMap by comparing output cardinality, nesting, and typical use cases.
Tata Consultancy Services (North America)Aggregate TCS BaNCS sales by month, then calculate a chronological running total with a window function.
Tata Consultancy Services (North America)Explain TRUNCATE vs DELETE vs DROP, focusing on logging, constraints, transactions, and safe usage in production.
Tata Consultancy Services (North America)Optimize a PostgreSQL reporting query by reducing scanned rows, preserving unmatched records, and selecting the latest related review efficiently.
Zillow
OneDemonstrate common SQL join types by comparing matched, unmatched, and Cartesian row counts.
Fast Enterprises
GoogleAA healthcare dataSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Design a Databricks-native lineage pipeline that captures table and column dependencies across batch and streaming jobs with <5 minute freshness.
Tata Consultancy Services (North America)A practical approach to tuning slow SQL queries and stored procedures used inside data pipelines.
Tata Consultancy Services (North America)Design and implement SCD Type 1 and Type 2 dimensions with history tracking, idempotent loads, and data quality controls.
Tata Consultancy Services (North America)