Data Engineer Interview - Grade Sheet
Questions
Questions the candidate should ask
- About Mayfair
- How big are they (employees/agents,etc.)
- How many properties per year?
- Are they growing?
- About Campaigns
- How do the campaigns work, exactly?
- What data is generated?
- Where is the generated?
- About Systems
- What IT systems do they use?
- How do they interact with the campaigns?
- About RealSoft
- On-prem or cloud?
- What database?
- API
- Entities?
- About Facebook
- How is a campaign mapped to a property?
- About Website
- What system (WordPress)?
- How do we measure the website visits?
Evaluation
| Area | Achievements | Maximum Points |
|---|---|---|
| Problem | Did the candidate ask relevant questions before starting a design? | 1 |
| Data Sources | Did the candidate correctly identify the data sources? | 1 |
| Data Access | Did the candidate ask relevant questions about the data sources? E.g. how we can access the data. | 1 |
| Frequency | Did the candidate correctly identify the right frequency? | 1 |
| Pipeline | Did the candidate come up with a feasible architecture to load the data? | 1 |
| Entities | Did the candidate identify the core entities? | 1 |
| Mapping | Did the candidate find ways to map the entities (especially Property) among systems? | 1 |
| ADM | Did the candidate design an ADM (Star Schema) that will solve the problem? | 1 |
| Thought Process | Could the candidate explain what he is doing, and why? | 1 |
| Estimate | Did the candidate come up with a reasonable estimate? | 1 |
| Total | 10 |