Top 17
Prep plan
Updated weekly · Last refresh Oct 17

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

17questions
~3htotal time
Track your progressSign up free to work through all 17 questions and resume where you left off.
Start practicing free →
1
PipelinesStart here. 4 questions · ~36 min
ETL vs ELT Trade-offsEasy

Compare ETL and ELT, and explain when ELT is the better pipeline pattern.

ETLELTData ModelingPG&E
Data Quality and Schema EvolutionMedium

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

schema evolutionData ModelingQualityPG&E
Migrate ETL to SnowflakeHard

Evaluates your strategy for modernization, data validation, and minimizing disruption during migration.

migrationETLPG&E
More Pipelines questions with a free account
2
Coding3 questions · ~27 min
Build a Data Pipeline ExampleMedium

Assesses your end-to-end data pipeline design, implementation, and operational considerations.

data pipelinepythonPG&E
Average Outage Duration FunctionMedium
Practice

Group valid PG&E outage events by region and average their durations while skipping missing or malformed timestamps.

aggregationnull handlingData WranglingPG&E
More Coding questions with a free account

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 + 3 drills · ~57 min
Optimize Slow Join QueryHard

Tests query optimization skills for large joins between asset and sensor datasets.

Performance TuningJoinsindexesPG&E
Snowflake Partitioning and ClusteringMedium

Tests your Snowflake performance tuning approach for analytics workloads at PG&E.

snowflake schemaperformancepartitioningPG&E
Top Energy Users by ZipMedium

Tests SQL windowing, aggregation, and ranking for smart meter analytics at PG&E.

Window FunctionsRankingsqlPG&E
SQL Join Query PracticeEasy
Practice
Practice drill

Join related customer and service request records to return request details with the matching customer name.

data relationshipsJoinssqlPG&E
Cleaning a Messy DatasetMedium
Practice
Practice drill

Filter invalid game events and normalize event names using PostgreSQL string and null handling.

missing valuesdata cleaningnull handlingQuantiumScopelyCarvana
Handling Missing ValuesMedium
Practice
Practice drill

Summarize missing and non-missing values in a new YipitData data set using SQL aggregation.

missing valuesnull handlingData WranglingYipitData
4
Behavioral & Leadership7 questions · ~63 min
More Behavioral & Leadership questions with a free account
The finish line: interview-readyComplete all 17 questions plus 3 hands-on drills to finish this plan.