Skip to content

Instantly share code, notes, and snippets.

View mmanske3D's full-sized avatar

Matt Manske mmanske3D

  • Divergent3D
  • New York, NY
  • 11:01 (UTC -05:00)
View GitHub Profile
@mmanske3D
mmanske3D / Data_Engineer_Code_Exersize.md
Last active March 18, 2022 16:41
Divergent 3D Data Engineer Coding Exercise

Instructions

For this exercise, any code samples should be written in SQL. The candidate can assume that there is already a database setup with the appropriate connections, etc. We’re simply asking for the schema definitions and some SQL queries.

If you have any questions or clarification about the prompt, please make your best educated guess about what the business case might be asking for and make note of those assumptions. The exercise is intended to be open to interpritation, so there is no one correct solution to strive for. Follow-up conversations around your decisions & assumptions will be more valuable than the code itself, so feel free to be describe your thoughts as you're going along.

Prompt

Company X runs a factory producing customizable widgets. There are four variations of widgets that can be ordered. Each widget, regardless of variation, must go through the same three processing steps. Each processing step is done by hand by a variety of operators on the factory floor. For the purp

@mmanske3D
mmanske3D / Full_Stack_Developer_Code_Exercise.md
Last active June 15, 2024 22:30
Divergent 3D Full-Stack Developer Coding Exercise

Instructions

For this exercise, you can use any JS/TS libraries, frameworks or build systems that you’d like. The end result should be a functional web page that we can either run or build locally that will demonstrate a working example of the prompt. Code should be shared as a GitHub repository.

If you have any questions or clarification about the prompt, please make your best educated guess about what the user might be asking for and make note of those assumptions. Conversation about your interpretations & possible edge-cases is as important as the quality of the code. Also, the usability of your interface is much more important than the aesthetics.

For the exercise, stand-up a web application and the requested functionality for the component described below. Concentrate on the functionality of the component itself, and unit testing. This exercise is intended to be the start of a larger conversation, so be prepared to discuss any decisions or functionality.

Prompt