One in Five
An easy AI Coding mock interview question on DataDriven, with an AI interviewer who asks follow-up questions and a hire or no-hire decision at the end.
- Domain
- AI Coding
- Difficulty
- easy
- Seniority
- L4
Interview Prompt
Analytics ships fct_payments through dbt nightly. The unique test on payment_id passes locally every time, fails in CI ~20% of runs. Same input fixtures, same model SQL. Run tests/test_uniqueness.py to reproduce, then fix the model so the test is deterministic. The fix is in the SQL, not the test.
Summary
Green, green, red, green.
How This Interview Works
- Read the task and the repository: the files, the failing check and the constraints
- Work the fix with the AI agent at your side, and run the checks until they pass
- Submit, then answer the interviewer's questions about the change you made
- Get a hire or no-hire decision with feedback on how you drove the agent