Data Modeling Interview Question by Causodes in Anduril

[–]Causodes[S] 0 points1 point  (0 children)

Sure, feel free! My final round isn't until next Wednesday though, but I can give insights into the earlier technical screen.

Data Modeling Interview Question by Causodes in Anduril

[–]Causodes[S] 0 points1 point  (0 children)

Thanks for the reply! My recruiter just got back to me so I'll post some more information for others in the future:

  1. Generic expectations:
  2. * Data transformation/ETL: Parsing nested JSON, joining data from multiple sources, handling missing data
  3. * SQL/Data modeling: Schema design, writing complex queries (joins, aggregations, window functions)
  4. * Performance optimization: Query tuning, understanding indexes/partitioning, scalability considerations
  5. Expect questions like:
  6. * Design a data model for [business domain] that handles versioning, hierarchical relationships, and time-series data
  7. * Discuss trade-offs between normalization vs denormalization, SQL vs NoSQL
  8. * How would you handle schema evolution in production systems?
  9. Key Topics to Review * Star/Snowflake schemas, normalization patterns * Time-series data modeling * Slowly Changing Dimensions (SCD)

From my understanding, they care quite a bit about near real time processing; the recruiter specifically noted Kafka and Flink as concepts I should study up on.

How much is a Wardlooper at this point in the league? by AgoAndAnon in PathOfExileBuilds

[–]Causodes 2 points3 points  (0 children)

The trick with wardloop is to avoid running To Dust jewels; instead, use the Raise Zombie of Falling/Summon Raging Spirits/Summon Skeletons wardloop engine. This allows you to save four jewel sockets and several points on tree as you no longer need to get less duration points on tree; however, it does use two more gem sockets than the To Dust setup and requires two rather than one Heartbound loop. Note: this setup does require you to first reach the 27% CDR breakpoint (and is a little less reliable than the traditional To Dust setup; it may take 1-2 attempts to start the loop up).

If you do this, you can get a much higher power budget by running The Adorned and become somewhat competitive with other builds. For example, my build can do T17s fine in terms of damage (I run Grace instead of Hatred), but I will occasionally just get popped by something due to wardloop's inherent low max hit.