Interview question
Optimize a slow SQL query on a large fact table
Asked in General Motors Software Engineer interviews
Asked by
34% candidates
Difficulty
Hard
Round
Technical Round 1
AI synthesized from candidate reports
Related practice
Candidates also saw
- Compare thread pools vs reactive programming for I/O workloads34%
- Explain core stack fundamentals with a production example59%
- Design a scalable REST API with caching and consistency trade-offs60%
- Debug concurrency issues in a high-throughput Java service20%
- Describe transaction isolation levels and when each applies21%
General Motors Software Engineer — People Also Ask
Common interview prep questions from recent candidates
- Recent candidates report role-specific technical questions, system design prompts, and behavioral STAR questions tied to ownership and impact.
- Competitive — panels test depth in role fundamentals, system thinking, and communication under follow-up pressure.
- Typical loops: Resume screening → Technical → Behavioral → Offer. Timelines often run 3–6 weeks.
- When the role involves Java or backend services, Spring Boot and API design often appear in technical rounds.
- Mid-senior Software Engineer loops frequently include system design or architecture discussions — especially for distributed systems and scale.