Dataford
Dataford
Top 19
Prep plan
Updated weekly · Last refresh Oct 17

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 daily.

19questions
~3htotal time
Track your progressSign up free to work through all 19 questions and resume where you left off.
Start practicing free →
1
PipelinesStart here. 6 questions · ~53 min
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
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
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
More Pipelines questions with a free account
2
Coding3 questions · ~27 min
Python Dictionary SortingMedium

Assesses your ability to write correct Python for common data manipulation tasks.

data pipelinepythonPacific 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
Clean Smart Meter TimestampsMedium

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

deduplicationnull handlingData WranglingPacific 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
3
SQL & Data Manipulation3 questions + 2 drills · ~47 min
Second-Highest Consumption QueryMedium
Practice

Find all records tied at the second-highest energy consumption level for a specified utility grid sector.

SubqueriesJoinsRankingPacific 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
Window Functions for Top CustomersMedium
Practice
Practice drill

Use a CTE, LEFT JOIN, aggregation, and ROW_NUMBER to find the top three PG&E customers by 2025 usage in each region.

Window Functionssql queryPacific Gas and ElectricHsbc
Rolling Average Outage DurationMedium
Practice
Practice drill

Calculate a 30-day rolling outage-duration average for each PG&E service area using a CTE, join, and window function.

Window FunctionssqlTime SeriesPacific Gas and Electric
More SQL & Data Manipulation questions with a free account
4
Behavioral & Leadership7 questions · ~62 min
More Behavioral & Leadership questions with a free account
The finish line: interview-readyComplete all 19 questions plus 2 hands-on drills to finish this plan.