The City Of Providence Data Engineer Interview Questions
The questions to prepare for a The City Of Providence Data Engineer interview. Questions from real interview reports rank first. Updated daily.
Design and implement SCD Type 1 and Type 2 dimensions with history tracking, idempotent loads, and data quality controls.
The City Of ProvidenceCompare star and snowflake schemas in a warehouse pipeline, including structure and transformation trade-offs.
The City Of ProvidenceCompare ETL and ELT, and explain when ELT is the better pipeline pattern.
The City Of ProvidenceExplain how clustered and non-clustered indexes differ in storage, lookup behavior, and query performance.
The City Of ProvidenceUse window functions to identify duplicate municipal transaction records and show each duplicate's count and sequence.
The City Of ProvidenceTests data validation, cleansing, and safe ingestion practices for external files.
The City Of ProvidenceRank retailers by seasonally adjusted quarterly sales and return the top 10 percent using PostgreSQL CTEs and window functions.
The City Of ProvidenceFind the second highest salary in each department without using aggregate functions.
Credit Genie
Devoteam
Cisco Restaurant + BarSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Tests ownership of an end-to-end analytics project, including cross-functional collaboration, technical judgment, and measurable business impact.
The City Of ProvidenceAssesses breadth of core CS fundamentals relevant to building reliable data systems.
The City Of Providence