Top 50
Prep plan
Updated weekly · Last refresh Aug 30

The City Of Providence Software Engineer Interview Questions

The questions to prepare for a The City Of Providence Software Engineer interview. Questions from real interview reports rank first. Updated weekly.

50questions
~8htotal time
Track your progressSign up free to work through all 50 questions and resume where you left off.
Start practicing free →
1
CodingStart here. 18 questions · ~169 min
First Non-Repeating CharacterEasy
Practice
Recently asked

Find the first non-repeating character in a string using frequency counting and a second pass in O(n) time.

Hash TablesStringsSearchingThe City Of Providence
Array Sum by ValueMedium
Practice

Count target-sum contiguous subarrays and report their shortest and longest lengths using prefix sums and hash maps.

implementationThe City Of Providence
More Coding questions with a free account
2
SQL & Data Manipulation9 questions + 2 drills · ~104 min
Second Highest Without AggregatesHard
Practice
Recently asked

Find the second highest salary in each department without using aggregate functions.

SubqueriesRankingSelf-JoinsThe City Of Providence
Customer Orders: LEFT vs INNER JOINEasy
Recently asked

Explain how INNER JOIN and LEFT JOIN differ, and when to use each for matched-only versus all-left-row analysis.

JoinsData WranglingGroup ByThe City Of Providence
SQL Join and Group By PracticeHard
Practice
Practice drill

Join SAT data, aggregate monthly center performance, and compare average scores with LAG.

JoinsGroup BysqlThe College Board
Rank Top Service CategoriesEasy
Practice
Practice drill

Use RANK() and grouped revenue to find ServiceTitan's top three service categories in each region.

RankingperformancesqlServiceTitan
More SQL & Data Manipulation 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
3
System Design3 questions · ~28 min
E-Commerce OOP DesignHard

Evaluates your ability to model a domain and design classes for an e-commerce system.

The City Of Providence
More System Design questions with a free account
4
Security & Infrastructure5 questions · ~47 min
Network Fundamentals and WirelessMedium

Evaluates your breadth of networking knowledge and practical automation awareness.

The City Of Providence
Protecting an APIMedium

Assesses your knowledge of API security practices and threat mitigation.

api securityThe City Of Providence
More Security & Infrastructure questions with a free account
5
Behavioral & Leadership14 questions · ~131 min
More Behavioral & Leadership questions with a free account
6
More topics1 question · ~9 min
Fast Testing With Limited ResourcesHard

Evaluates your ability to design an efficient strategy under constraints.

TestingThe City Of Providence
The finish line: interview-readyComplete all 50 questions plus 2 hands-on drills to finish this plan.