Top 15
Prep plan
Updated weekly · Last refresh Aug 13

Pacific Gas and Electric Data Engineer Interview Questions

The questions to prepare for a Pacific Gas and Electric Data Engineer interview. Questions from real interview reports rank first. Updated weekly.

15questions
~2htotal time
Track your progressSign up free to work through all 15 questions and resume where you left off.
Start practicing free →
1
PipelinesStart here. 5 questions · ~40 min
Data Quality and Schema EvolutionMedium

Approach for handling schema changes and data quality checks in a high-volume data lake pipeline.

schema evolutionData ModelingQualityPacific Gas and Electric
Batch vs Stream Processing Trade-offsMedium

Compare batch and stream processing across latency, complexity, cost, and data quality in a modern analytics pipeline.

InfrastructureStream ProcessingETLPacific Gas and Electric
Design AWS Snowflake Realtime AnalyticsHard

Design an AWS and Snowflake real-time analytics pipeline processing 250K events/sec with CDC, data quality checks, and sub-2-minute freshness.

InfrastructureStream ProcessingData ModelingPacific Gas and Electric
More Pipelines questions with a free account
2
SQL & Data Manipulation3 questions + 3 drills · ~54 min
Optimize a Slow Join QueryHard

Tests performance tuning skills for joining large historical and real-time datasets in SQL.

fact tablesJoinsperformancePacific Gas and Electric
Second-Highest Consumption QueryMedium

Tests SQL ranking and edge-case handling for energy consumption analytics queries.

SubqueriesRankingAggregationsPacific Gas and Electric
Running Total with Window FunctionsMedium

Tests SQL window function skills for time-series aggregation and substation-level analytics.

Window FunctionsGroup ByRunning TotalsPacific Gas and Electric
Monthly Sales Trends by CategoryMedium
Practice
Practice drill

Aggregate monthly sales by product category and use LAG to calculate month-over-month changes.

InfrastructureToolsData WranglingTotal Wine & MoreHD SupplyBenjamin Moore
Contact Center Agent Performance MetricsMedium
Practice
Practice drill

Compute daily agent call KPIs and SLA using joins, aggregations, and window ranking in a contact center model.

ETLAggregationsData ModelingADP
Unify CRM and Google Analytics ViewHard
Practice
Practice drill

Merge CRM orders with GA events via an identity map to build a customer-level view using joins, window functions, and monthly rollups.

SubqueriesJoinsData WranglingArtefact
3
Behavioral & Leadership5 questions · ~40 min
More Behavioral & Leadership questions with a free account
4
More topics2 questions · ~16 min
Clean Smart Meter TimestampsMedium

Tests data cleaning and preprocessing skills for time-series sensor and meter data.

deduplicationnull handlingData WranglingPacific Gas and Electric
Parse IoT JSON for StorageMedium

Tests ability to transform semi-structured IoT data into database-ready structures using Python.

json parsingData WranglingfunctionsPacific Gas and Electric

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
The finish line: interview-readyComplete all 15 questions plus 3 hands-on drills to finish this plan.