Data Engineer 2 Interview Questions and Answers

Design a datawarehouse for an e-commerce platform to store buy and sell transactions.

• Create separate tables for customers, products, transactions, and orders.

• Use a star schema with a central fact table for transactions and dimension tables for customers, products, and time.

• Include columns for transaction ID, customer ID, product ID, quantity, price, timestamp, etc.

• Implement data normalization to reduce redundancy and improve data integrity.

• Consider using ETL processes to extr...read more

Minimum number of swaps needed to reach the end index in an array

• Use a greedy approach to swap elements in the array

• Track the minimum number of swaps needed to reach the end index

• Consider edge cases like when the end index is already reached

Minimum number of swaps needed to make a string balanced by swapping adjacent characters

• Iterate through the string and count the number of unbalanced pairs of brackets

• Divide the count by 2 to get the minimum number of swaps needed

• Example: For the string '(()))', there are 2 unbalanced pairs, so 1 swap is needed