City of Philadelphia Data Engineer Interview Questions
The questions to prepare for a City of Philadelphia Data Engineer interview. Questions from real interview reports rank first. Updated weekly.
Approach for keeping records aligned and trustworthy when multiple source systems feed the same pipeline.
City of PhiladelphiaApproach for safely backfilling missing data while preserving correctness, idempotency, and data quality.
City of PhiladelphiaApproach for building fault tolerance into a distributed data pipeline, including retries, idempotency, and recovery controls.
City of PhiladelphiaPractical approach for maintaining data quality across ML ETL pipelines, orchestration, and repeatable data processing.
City of PhiladelphiaExplain the differences between WHERE and HAVING clauses in SQL and when to use each.
City of PhiladelphiaExplain how to choose between star and snowflake schemas for corporate operations reporting, balancing query simplicity, integrity, and performance.
City of PhiladelphiaTests SQL window function usage for analytical reporting over time.
City of PhiladelphiaAggregate monthly sales by product category and use LAG to calculate month-over-month changes.
Total Wine & More
Inc.
Benjamin MooreCompute daily agent call KPIs and SLA using joins, aggregations, and window ranking in a contact center model.
ADPUse ROW_NUMBER() to keep the earliest created_at 'Repl created' per entity and return out-of-order duplicates to delete.
Replit
QuantcastSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Assesses motivation and alignment with public sector data engineering work at City of Philadelphia.
City of Philadelphia