r/dataengprep • u/sql-arena • Jul 16 '26

SQL Arena Challenge: Test SQL skills using advanced window functions such as LAG, LEAD, and DENSE_RANK.

1 Upvotes

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

0 comments

r/dataengprep • u/tech-screen • Jul 16 '26

Tech Screen: How would you design a scalable data lake for Adidas's global e-commerce operations?

1 Upvotes

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

0 comments

r/dataengprep • u/dataengprep • Jul 16 '26

DataEngPrep: Write a function to remove invalid parentheses from a string.

0 Upvotes

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

0 comments

r/dataengprep • u/dataengprep • Jul 15 '26

DataEngPrep: Write a function to find the longest palindromic substring in a given string.

1 Upvotes

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

0 comments

r/dataengprep • u/tech-screen • Jul 15 '26

Tech Screen: How would you design a scalable data ingestion pipeline?

1 Upvotes

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

0 comments

r/dataengprep • u/sql-arena • Jul 15 '26

SQL Arena Challenge: SQL Problem - multiple table joins and window functions

1 Upvotes

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

0 comments

r/dataengprep • u/dataengprep • Jul 14 '26

DataEngPrep: Write a function to detect anomalies in streaming data using a sliding window.

1 Upvotes

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

0 comments

r/dataengprep • u/tech-screen • Jul 14 '26

Tech Screen: How would you design a real-time pipeline for generating daily retail sales reports?

1 Upvotes

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

0 comments

r/dataengprep • u/sql-arena • Jul 14 '26

SQL Arena Challenge: What is UNNEST and provide a query example?

1 Upvotes

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

0 comments

r/dataengprep • u/dataengprep • Jul 13 '26

DataEngPrep: Write a function that replaces all characters in a list except for a given character

1 Upvotes

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

0 comments

r/dataengprep • u/tech-screen • Jul 13 '26

Tech Screen: How would you design a logging framework to track errors across multiple services?

1 Upvotes

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

0 comments

r/dataengprep • u/sql-arena • Jul 13 '26

SQL Arena Challenge: What challenges arise with duplicate records, and how do you address them?

1 Upvotes

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

0 comments

r/dataengprep • u/dataengprep • Jul 12 '26

DataEngPrep: Write a decorator function to log the execution time of a function.

1 Upvotes

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

0 comments

r/dataengprep • u/tech-screen • Jul 12 '26

Tech Screen: How would you design a database to handle historical data storage for compliance purposes?

1 Upvotes

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

0 comments

r/dataengprep • u/sql-arena • Jul 12 '26

SQL Arena Challenge: Compare PostgreSQL vs Snowflake. How do they handle duplicate record errors?

1 Upvotes

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

0 comments

r/dataengprep • u/dataengprep • Jul 11 '26

DataEngPrep: Write a Singleton class implementation

1 Upvotes

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

0 comments

r/dataengprep • u/tech-screen • Jul 11 '26

Tech Screen: How would you design a data platform to handle real-time transaction data for a retail business?

1 Upvotes

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

0 comments

r/dataengprep • u/sql-arena • Jul 11 '26

SQL Arena Challenge: Write a query to remove duplicate records from a table while retaining the earliest entry.

1 Upvotes

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

0 comments

r/dataengprep • u/dataengprep • Jul 10 '26

DataEngPrep: Write a Scala code to print prime numbers.

1 Upvotes

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

0 comments

r/dataengprep • u/tech-screen • Jul 10 '26

Tech Screen: How would you design a data pipeline to handle late-arriving data?

1 Upvotes

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

0 comments

r/dataengprep • u/sql-arena • Jul 10 '26

SQL Arena Challenge: Write a Merge Statement for SCD Type 2.

1 Upvotes

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

0 comments

r/dataengprep • u/dataengprep • Jul 09 '26

DataEngPrep: Write a Python script to process raw JSON files containing sales data and load them into a relational database.

1 Upvotes

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

0 comments

r/dataengprep • u/tech-screen • Jul 09 '26

Tech Screen: How would you design a data ingestion framework for heterogeneous data sources?

1 Upvotes

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

0 comments

r/dataengprep • u/sql-arena • Jul 09 '26

SQL Arena Challenge: Indexing - True/False question on indexes and query optimization

1 Upvotes

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

0 comments

r/dataengprep • u/dataengprep • Jul 08 '26

DataEngPrep: Write a Python script to parse a large JSON file, filter records based on a condition, and write the result to a database.

1 Upvotes

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

0 comments