Dataford
Dataford
Top 28
Prep plan
Updated weekly · Last refresh Oct 17

Suntrust Investment Services Software Engineer Interview Questions

The questions to prepare for a Suntrust Investment Services Software Engineer interview. Questions from real interview reports rank first. Updated daily.

28questions
~4htotal time
Track your progressSign up free to work through all 28 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 3 questions + 3 drills · ~54 min
Type 2 Dimensions in Data WarehousingMedium

Assesses understanding of slowly changing dimensions and data modeling for historical reporting.

Suntrust Investment Services
SQL for Weekly PerformanceMedium
Practice
Practice drill

Use joins, weekly aggregation, and LAG to measure Clear location performance and week-over-week transaction changes.

Window FunctionsDate FunctionsAggregationsClearApex SystemsCisco Restaurant + Bar
Optimizing Poorly Performing SQLHard
Practice
Practice drill

Optimize a PostgreSQL reporting query by reducing scanned rows, preserving unmatched records, and selecting the latest related review efficiently.

database optimizationlarge datasetsperformancePPriority Technology Holdings, LLCZillowOne
Optimize SQL QueriesMedium
Practice
Practice drill

Optimize a PostgreSQL aggregation query by filtering early, reducing rows before joins, and returning qualifying active customers.

database optimizationperformanceindexesSofteamSSoftware Medical InformaticsGlassdoor
More SQL & Data Manipulation questions with a free account
2
Technical Fundamentals10 questions · ~80 min
JavaScript Event Loop BasicsMedium

Tests understanding of JavaScript concurrency and how async work is scheduled and executed.

asynchronous workjavascriptSuntrust Investment Services
Spring Transaction Management and PropagationMedium

Tests transactional design and propagation semantics for correct data consistency.

technical experienceSuntrust Investment Services
More Technical Fundamentals questions with a free account
3
Behavioral & Leadership8 questions · ~64 min
More Behavioral & Leadership questions with a free account
4
More topics7 questions · ~56 min
Troubleshooting Spanning Tree ProtocolMedium

Evaluates troubleshooting approach for network loop prevention and STP-related failures.

NetworkingTroubleshootingSuntrust Investment Services
Unit Test for Simple FunctionEasy

Tests basic unit testing ability and correctness for simple deterministic logic.

Suntrust Investment Services
Secure REST API for Vendor IntegrationHard

Tests secure API design practices for sensitive integrations with external vendors in financial services.

rest apissolution designSecuritySuntrust Investment Services
CI/CD Pipeline ExperienceMedium

Assesses ability to build and operate CI/CD pipelines that support reliable delivery.

experienceSuntrust Investment Services
Core Java and Spring BootMedium

Evaluates Java fundamentals and practical Spring Boot knowledge relevant to production services.

javaspring bootSuntrust Investment Services
More questions with a free account

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
The finish line: interview-readyComplete all 28 questions plus 3 hands-on drills to finish this plan.