PG&E Data Engineer Interview Questions
The questions to prepare for a PG&E Data Engineer interview. Questions from real interview reports rank first. Updated weekly.
Compare ETL and ELT, and explain when ELT is the better pipeline pattern.
PG&EApproach for handling schema changes and data quality checks in a high-volume data lake pipeline.
PG&ETests end-to-end pipeline design for streaming ingestion and historical joins in a utility context.
PG&ETests your Snowflake performance tuning approach for analytics workloads at PG&E.
PG&ETests SQL windowing, aggregation, and ranking for smart meter analytics at PG&E.
PG&ETests query optimization skills for large joins between asset and sensor datasets.
PG&ECompute daily agent call KPIs and SLA using joins, aggregations, and window ranking in a contact center model.
ADPAggregate monthly sales by product category and use LAG to calculate month-over-month changes.
Total Wine & More
Inc.
Benjamin MooreUse joins, CTEs, and CASE logic to flag and fill missing financial fields for Qlik planning records.
QlikSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Tests your ability to transform semi-structured logs into structured tables for downstream use.
PG&EAssesses your end-to-end data pipeline design, implementation, and operational considerations.
PG&E