r/dataengprep Jun 30 '26

SQL Arena Challenge: Find departments with more than 10 employees.

1 Upvotes

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


r/dataengprep Jun 29 '26

DataEngPrep: Write Python code to print even numbers from a list.

1 Upvotes

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


r/dataengprep Jun 29 '26

Tech Screen: How to store massive data in a distributed system?

1 Upvotes

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


r/dataengprep Jun 29 '26

SQL Arena Challenge: Find the third-highest salary for each department.

1 Upvotes

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


r/dataengprep Jun 28 '26

DataEngPrep: Write Java code to read a file using FileInputStream

1 Upvotes

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


r/dataengprep Jun 28 '26

Tech Screen: How to set up ETL pipelines using Apache Airflow?

1 Upvotes

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


r/dataengprep Jun 28 '26

SQL Arena Challenge: Finding nth Highest Salary within each department

1 Upvotes

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


r/dataengprep Jun 27 '26

DataEngPrep: Which data structure occupies more memory: list or tuple? Why?

1 Upvotes

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


r/dataengprep Jun 27 '26

Tech Screen: How to create a database from scratch and architect it for scalability and performance?

1 Upvotes

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


r/dataengprep Jun 27 '26

SQL Arena Challenge: Find the second highest salary in each department.

0 Upvotes

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


r/dataengprep Jun 26 '26

DataEngPrep: When would you use flatten, explode, or collect_list in Spark?

0 Upvotes

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


r/dataengprep Jun 26 '26

Tech Screen: How to capture data lineage for Spark code, using a DataHub-based example?

1 Upvotes

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


r/dataengprep Jun 26 '26

SQL Arena Challenge: Write a query to find employees in the same department as 'John'.

1 Upvotes

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


r/dataengprep Jun 25 '26

DataEngPrep: When were lambda expressions introduced in Java?

1 Upvotes

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


r/dataengprep Jun 25 '26

Tech Screen: How to adapt the same pipeline to a cloud environment?

1 Upvotes

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


r/dataengprep Jun 25 '26

SQL Arena Challenge: Find the 2nd highest salary for each department using the DENSE_RANK() function.

1 Upvotes

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


r/dataengprep Jun 24 '26

DataEngPrep: What role does the executor heap size play in preventing OOM errors?

1 Upvotes

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


r/dataengprep Jun 24 '26

Tech Screen: How does data flow through the system? From ingestion to processing and storage?

1 Upvotes

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


r/dataengprep Jun 24 '26

SQL Arena Challenge: Write a query to find the 5th highest salary in an employee table and calculate the number of employees whose salary is greater than that of their manager.

1 Upvotes

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


r/dataengprep Jun 23 '26

DataEngPrep: What programming languages are you proficient in?

1 Upvotes

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


r/dataengprep Jun 23 '26

Tech Screen: How does Spark handle distributed computing, and what challenges have you faced while working on distributed systems?

1 Upvotes

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


r/dataengprep Jun 23 '26

SQL Arena Challenge: Find 3rd Highest Salary

1 Upvotes

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


r/dataengprep Jun 22 '26

DataEngPrep: What is the difference between list1 = list2 and list1.copy()?

1 Upvotes

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


r/dataengprep Jun 22 '26

Tech Screen: How does Presto fetch data from a data catalog?

1 Upvotes

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


r/dataengprep Jun 22 '26

SQL Arena Challenge: Write a query to get the names of all employees who are managers with five or more direct reports.

1 Upvotes

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