For 10+ years experience.
Q1: How do you design a reporting database?
- Star schema
- Fact tables
- Dimension tables
Q2: How do you handle 100M+ records?
- Partitioning
- Indexing
- Incremental loads
Q3: How do you ensure data quality?
- Validation checks
- Reconciliation
- Audit tables
Q4: How do you troubleshoot dashboard performance?
- Optimize SQL
- Reduce extracts
- Aggregate data
Q5: How do you mentor junior developers?
- Code reviews
- Standards
- Reusable SQL templates
