PG&E Interview Questions
The questions to prepare for PG&E interviews, across all roles. Questions from real interview reports rank first. Updated weekly.
Approach for handling schema changes and data quality checks in a high-volume data lake pipeline.
PG&ESign up to see every question
Create a free account to unlock this list and practice real interview questions.
Explain how INNER JOIN, LEFT JOIN, and RIGHT JOIN change row retention and NULL handling in reporting queries.
PG&EAggregate monthly sales by product category and use LAG to calculate month-over-month changes.
Total Wine & More
Inc.
Benjamin MooreRank the top 3 completed rides per vehicle per day using joins, a CTE, and ROW_NUMBER.
WaymoUse joins, CTEs, and row ranking to resolve conflicting customer profile values across ACME House systems.
Ramsey Solutions
ACME HouseTests your ability to deliver a clear, relevant introduction tailored to the role at Aqr.
PG&ETests your ability to distinguish assessment types and their goals, scope, and outputs.
PG&ETests accuracy with numeric operations across common data types without calculator support.
PG&EExplain why correlated customer behaviors do not by themselves prove a causal effect, and how you would tell the difference.
PG&ETests ability to define and interpret metrics that improve operational performance.
PG&E