Comcast

SQL (joins, SCD, window), Spark/Python/Scala, and a Hadoop→Spark batch+streaming migration design with sub-3-minute freshness.

Cloud / platform

AWS (+ Azure/GCP); Presto, Hive, Spark

Reported difficulty

Not reported

SQLSparkPythonScalaAWSPrestoHive

Hiring process

Recruiter

Technical screen (1h)

Second recruiter call

Onsite loop

Offer

Round-by-round breakdown

3

01

Technical screen

· 1 hourMedium confidence

Comcast data systems, ETL pipelines, SQL

02

SQL

High confidence

Joins, SCD types, window functions
Top-N per group, dedup, running totals

03

Spark / Python / Scala

Medium confidence

Hands-on coding: SQL queries, ETL implementation
Tools: AWS, Presto, Hive

System & pipeline design prompts

1

Design a Spark-based batch AND streaming pipeline to replace legacy Hadoop jobs, delivering analytics with sub-3-minute freshness

Rejection patterns

3

Weak SCD/data-modeling
Cannot design batch+streaming migration
No data-quality/scalability reasoning

Reported experiences

1

Data Engineer (India)

No offer (positive)First-hand

JoinTaro (Jun 2023) confirming recruiter → technical screen → onsite loop shape.

Hiring process

Round-by-round breakdown

Technical screen

SQL

Spark / Python / Scala

System & pipeline design prompts

Prep — high priority

Prep — medium priority

Rejection patterns

Reported experiences

Data Engineer (India)

Rehearse for Comcast

Comcast

Hiring process

Round-by-round breakdown

Technical screen

SQL

Spark / Python / Scala

System & pipeline design prompts

Prep — high priority

Prep — medium priority

Rejection patterns

Reported experiences

Data Engineer (India)

Rehearse for Comcast