GeekCodersA DataEngineering Portal
For teamsStart practising free

TCS

Volume hiring on SQL and PySpark fundamentals: cleaning, type 2 history and reshaping, over tuning.

12 questions
PySpark · 9Python · 3
StatusTitleTechnologyTopicAcceptanceDifficulty
○77.Running balance per accountPySparkWindow functions100.0%Medium
○83.Pivot revenue into a column per categoryPySparkAggregation—Medium
○86.Quarantine the records that will not parsePySparkJSON Handling—Medium
○87.Split a tag list into rowsPySparkArray Handling100.0%Easy
○88.Standardise free-text citiesPySparkData quality100.0%Easy
○89.Unpivot quarterly targetsPySparkAggregation—Medium
○92.Carry the last sensor reading forwardPySparkWindow functions—Medium
○93.Days the feed never deliveredPySparkAnti-join—Medium
○94.Year-over-year revenue growthPySparkWindow functions—Medium
○96.Collapse a change feed to current statePythonData quality—Medium
○97.Detect schema drift between two batchesPythonData quality—Easy
○99.Reconcile two sourcesPythonJoins—Easy

Community-reported interview topics. Not official TCS questions and no affiliation is implied.