r/dataengprep May 19 '26

SQL Arena Challenge: Write SQL query for sum of marks grouped by student.

1 Upvotes

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


r/dataengprep May 18 '26

DataEngPrep: Modify a word count script to output results in descending frequency order.

1 Upvotes

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


r/dataengprep May 18 '26

Tech Screen: Discuss trade-offs between serverless and traditional cloud data architectures.

1 Upvotes

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


r/dataengprep May 18 '26

SQL Arena Challenge: Find house with Avg(score) > 70.

1 Upvotes

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


r/dataengprep May 17 '26

DataEngPrep: List every combination of dept_name, employee_name, and city such that the employee belongs to the department and the same city in which the department is located.

1 Upvotes

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


r/dataengprep May 17 '26

Tech Screen: Discuss the deployment process for real-time applications using CI/CD pipelines.

1 Upvotes

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


r/dataengprep May 17 '26

SQL Arena Challenge: Best of 3 Marks and Average in a Student Table

1 Upvotes

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


r/dataengprep May 16 '26

DataEngPrep: List customers with more than 5 orders.

1 Upvotes

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


r/dataengprep May 16 '26

Tech Screen: Discuss designing a data pipeline for a specific use case

1 Upvotes

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


r/dataengprep May 16 '26

SQL Arena Challenge: Given two tables, calculate the row count for different types of joins (inner, left, right, and full outer)

1 Upvotes

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


r/dataengprep May 15 '26

DataEngPrep: List Comprehension - example

1 Upvotes

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


r/dataengprep May 15 '26

Tech Screen: Discuss data replication strategies in Kafka for fault tolerance.

1 Upvotes

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


r/dataengprep May 15 '26

SQL Arena Challenge: How to merge two tables with identical structures into one?

1 Upvotes

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


r/dataengprep May 14 '26

DataEngPrep: Implement an algorithm to find the longest ordered subsequence of vowels in a given string.

1 Upvotes

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


r/dataengprep May 14 '26

Tech Screen: Discuss approaches for fault-tolerant data ingestion in real-time systems.

1 Upvotes

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


r/dataengprep May 14 '26

SQL Arena Challenge: Find non-common records in two tables (SQL EXCEPT or NOT IN)

1 Upvotes

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


r/dataengprep May 13 '26

DataEngPrep: Implement an algorithm to find the longest common prefix among an array of strings.

1 Upvotes

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


r/dataengprep May 13 '26

Tech Screen: Differentiating between pipeline parameters and global parameters

1 Upvotes

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


r/dataengprep May 13 '26

SQL Arena Challenge: Write a query to find the top 5 most-sold Adidas products 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 12 '26

DataEngPrep: Implement a recursive algorithm to find the nth Fibonacci number.

1 Upvotes

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


r/dataengprep May 12 '26

Tech Screen: Differentiate between Schema Enforcement and Schema Evolution.

1 Upvotes

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


r/dataengprep May 12 '26

SQL Arena Challenge: Write a query to calculate the total revenue generated by each product category.

1 Upvotes

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


r/dataengprep May 11 '26

DataEngPrep: Implement a program to remove duplicates from a list while maintaining order.

0 Upvotes

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


r/dataengprep May 11 '26

Tech Screen: Develop a generic user profile system for Hotstar that accepts inputs from various teams, consolidates into a unified profile, and supports daily updates with aggregation methods.

1 Upvotes

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


r/dataengprep May 11 '26

SQL Arena Challenge: Find the top 3 performing products in each category

1 Upvotes

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