Convex Interview Question

HM Tech Screen - 30min behavioral - 30min SQL + Python. SQL was groupby + aggregation. Python was tree traversal using recursion to find the minimum distance to a given node Onsite - 2 Behaviorals: product alignment with a PM, and EQ focused workplace situations with HM - 2 Technicals: SQL screen, 2 easy problems using grouping, aggregations, joins, case when. 2 Leetcode Easy Python problems on arrays/hashmaps: is valid parentheses + intersection of two arrays. - 1 System Design: Design a basic batch processing analytics ETL/ELT architecture and discuss tradeoffs with streaming replicatoin options and various toolsets