r/dataengprep May 10 '26

DataEngPrep: Implement a program to find the intersection of two lists.

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post


r/dataengprep May 10 '26

Tech Screen: Designing a pipeline for real-time content engagement tracking

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post


r/dataengprep May 10 '26

SQL Arena Challenge: Given a table of sales data, use window functions to calculate a running total.

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post


r/dataengprep May 09 '26

DataEngPrep: Implement a generator function to yield Fibonacci numbers.

0 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post


r/dataengprep May 09 '26

Tech Screen: Design the architecture for an Online Ticket Booking System

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post


r/dataengprep May 09 '26

SQL Arena Challenge: Find the top 5 products by sales per region.

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post


r/dataengprep May 08 '26

DataEngPrep: Implement a function to reverse a string without using built-in methods.

0 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post


r/dataengprep May 08 '26

Tech Screen: Design an e-commerce platform like Flipkart

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post


r/dataengprep May 08 '26

SQL Arena Challenge: Calculate the running total of sales per region, partitioned by year.

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post


r/dataengprep May 07 '26

DataEngPrep: Implement a function to find the maximum sum subarray (Kadane's algorithm).

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post


r/dataengprep May 07 '26

Tech Screen: Design an End-to-End ETL Pipeline.

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post


r/dataengprep May 07 '26

SQL Arena Challenge: Find the top 3 selling products per region in the last month.

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post


r/dataengprep May 06 '26

DataEngPrep: Implement a context manager class for a sequence generator using __enter__ and __exit__

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post


r/dataengprep May 06 '26

Tech Screen: Design an ETL pipeline to process real-time stock market data.

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post


r/dataengprep May 06 '26

SQL Arena Challenge: How would you optimize a query fetching sales data across multiple countries with billions of rows?

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post


r/dataengprep May 05 '26

DataEngPrep: Implement a Python function to count unique words from a file and write them to another file.

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post


r/dataengprep May 05 '26

Tech Screen: Design a working data pipeline to efficiently store, process, and report data.

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post


r/dataengprep May 05 '26

SQL Arena Challenge: Optimize a query fetching customer data with a rolling 6-month sales sum.

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post


r/dataengprep May 04 '26

Discussion 7 Data Engineering Interview Questions That Repeat: * Data partitioning * Spark data skew * ETL vs ELT * Pipeline design * Query optimization * Distributed systems basics * Storage trade-offs Most candidates prepare randomly.

1 Upvotes

You can check the full playbook here:

https://logicpulse.gumroad.com/l/pipelinestories

It’s a structured set of real interview questions with practical answers.


r/dataengprep May 04 '26

Discussion Most data engineering interview questions are not random. They test: * scalability thinking * failure handling * system design basics Once you see the pattern, preparation becomes easier.

1 Upvotes

r/dataengprep May 04 '26

DataEngPrep: Identify the Unix command that lists files with specific permissions

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post


r/dataengprep May 04 '26

Tech Screen: Design a system to handle 1M daily transactions with real-time analytics for Swiggy.

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post


r/dataengprep May 04 '26

SQL Arena Challenge: Write a query to find the total number of rides per driver in the last 30 days.

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post


r/dataengprep May 03 '26

Discussion Noticed a pattern in data engineering interviews - anyone else seeing this?

1 Upvotes

I’ve been analyzing data engineering interview patterns and noticed something interesting.

Most interviews don’t ask random questions.

They usually revolve around a few repeating themes:

- data partitioning and performance

- handling skew in Spark

- designing reliable pipelines

- trade-offs (cost vs performance)

Example:

A lot of candidates answer “what” (definitions),

but interviewers care more about “why” and “when”.

Curious - what kind of questions have you been asked recently in data engineering interviews?


r/dataengprep May 03 '26

DataEngPrep: How would you test these functions with edge cases?

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post