Company: Flipkart
Position - Data Engineer - II

Round 1:

• Machine coding / Spark coding
  Given 4 nested json files representing 4 tables. Write spark program to populate desired result by joining & sql like queries.
• Spark optimizations , Caching , OOM Error handling etc..,

Round 2:

• Design a comprehensive data model which captures cricket tournament information, with teams, players, matches, scores, (stadiums). It is also possible that a player is part of multiple Leagues and national teams. Derive the following information from the data model
  Cumulative score of a player for all matches in the tournament and lot of other sql questions on the same.

Round 3:

• Differnet scenarios of handling data pipelines
• Data processing from Kafka topics in-depth discussion
• Spark dynamic allocation , caching , joins etc,,,
• Project discussions

Round 4:

• General Behavioural questions

Verdict: Offered.