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 daily.
Explain how to choose between star and snowflake schemas for corporate operations reporting, balancing query simplicity, integrity, and performance.
City of PhiladelphiaExplain the differences between WHERE and HAVING clauses in SQL and when to use each.
City of PhiladelphiaRank Philadelphia departments by quarterly spending and return the top three for each fiscal quarter.
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.
ADPExplain how to build and operate an incremental daily batch load with safe reruns, backfills, and data quality checks.
City of PhiladelphiaDiscuss Python scripting experience for ETL, orchestration, and data quality tasks in data pipelines.
City of PhiladelphiaApproach for keeping records aligned and trustworthy when multiple source systems feed the same pipeline.
City of PhiladelphiaDescribe a real production pipeline failure, how you diagnosed and fixed it, and what changes you made around orchestration, quality, and reruns.
City of PhiladelphiaSign 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