Use event-time watermarks without discarding late telemetry silently
The hourly aggregate closes by arrival time and quietly ignores a delayed batch from an offline device.
Estimated field mix
- Data engineering70%
- Real-time systems30%
Preparing the next view without exposing private workflow data.
Design a system. Diagnose tail latency. Ship a migration. Recover a failed rollout. Pick a focused ticket or follow a project through its delivery phases.
1380 tickets · 138 projects · 26 engineering fields · Four difficulty levels
Field counts and the engineering field filter use each project's primary field. Estimated ticket labels can span multiple fields.
1380 matching tickets · Page 24 of 115
The hourly aggregate closes by arrival time and quietly ignores a delayed batch from an offline device.
Estimated field mix
Object storage contains yesterday's batches, but dashboard totals are low and no worker currently owns the missing jobs.
Estimated field mix
A conversion fix requires rebuilding a week of energy totals without obscuring what the previous dashboard showed.
Estimated field mix
A site with no recent readings is displayed as consuming zero energy, misleading dashboard consumers.
Estimated field mix
A report doubles subscription movement when a contract has two invoice lines in the same month.
Estimated field mix
A late payment makes the recurring-revenue chart dip even though no subscription changed.
Estimated field mix
A partner renamed subscription_id and the daily transformation published an empty table successfully.
Estimated field mix
Historical enterprise revenue changes whenever sales updates a customer's current segment.
Estimated field mix
The incremental model filters only creation time, so a corrected subscription end date never reaches the mart.
Estimated field mix
Deleting a cancelled subscription from the source erases the churn event from the report.
Estimated field mix
A new feature joins account tags to movement rows and inflates revenue for accounts with multiple tags.
Estimated field mix
An analyst sends a CSV to finance and later cannot identify which transformation commit or source cutoff produced it.
Estimated field mix
138 matching projects · Page 6 of 12
Reconcile local order state with a simulated provider under duplicate and delayed delivery.
Keep customer records consistent across a local application and a simulated CRM.
Reconcile availability and event changes across a scheduling app and a local calendar provider.
Define customer-facing reliability indicators and actionable budget policies.
Diagnose and recover delayed background work without duplicating effects.
Verify that database and object-store backups can reconstruct a coherent service.
Protect essential reads when optional workloads saturate a service.
Prepare a small service for a predictable launch surge through capacity and dependency review.
Make storage growth and transfer costs inspectable without compromising retained records.
Validate infrastructure changes as bounded plans with drift and recovery context.
Replace static service credentials with bounded workload identity and tested rotation.
Promote immutable application artifacts through environments with inspectable provenance.
Practice scoped changes, keep a portable implementation and verification record, and learn to explain operational tradeoffs. Choose a ticket whose prerequisites you can provide.
Use realistic work to structure onboarding, internal practice, and conversations about engineering decisions. Each project names the delivery benefit. Agree scope and compensation before requesting company-specific work.
CSV contains one row per ticket. Map fields and issue types in your tracker; project grouping and dependency keys are descriptive. JSON preserves the complete project structure. These downloads do not synchronize with Jira.