Prepare for and practice interview questions from Pacific Gas And Electric Company.

Pacific Gas And Electric Company Interview Questions

Pacific Gas And Electric Company Interview Guides

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

What is a key disadvantage of the F-test when compared to multiple t-tests?

What is a key disadvantage of the F-test when compared to multiple t-tests?

Hundreds of Hypotheses

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

Let’s say we have a table with an <code>id</code> and <code>name</code> fields. The table holds over 100 million rows and we want to sample a random row in the table without throttling the database.

Write a query to randomly sample a row from this table.

Input:

<code>big_table</code> table

<table>
<thead>
<tr>
<th>Columns</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>name</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>

Write a query to randomly sample a row from a big table.

Random SQL Sample

In an A/B test, how can you check if assignment to the various buckets was truly random?

In an A/B test, which of the following is a common method to determine if the assignment to the test groups was truly random?

In an A/B test, which of the following is a common method to determine if the assignment to the test groups was truly random?

Random Bucketing

Pacific Gas And Electric Company Salaries by Position

Requisition ID# 160896 Job Category: Information Technology Job Level: Manager/Principal Business Unit: Information Technology Work Type: Hybrid Job Location: Oakland Department Overview Information Systems Technology Services is a unified organization comprised of various departments which collaborate effectively in order to deliver high quality technology solutions. Position Summary We are seeking a highly skilled and experienced Manager to lead PG&E's Enterprise Data Engineering team. This role will take charge in building our enterprise data & analytics capabilities, creating innovative data products and services to support business operations, analytic product teams, and internal stakeholders. The ideal candidate will have a strong background in project delivery, data architecture, data modeling, and ETL processes, combined with leadership experience and a passion for leading, developing and mentoring high performing teams This position is hybrid, working from your remote office and the Oakland General Office(OGO) at least once per week and or based on business needs. PG&E is providing the salary range that the company in good faith believes it might pay for this position at the time of thejob posting. This compensation range is specific to the locality of the job. The actual salary paid to an individual will bebased on multiple factors, including, but not limited to, specific skills, education, licenses or certifications, experience,market value, geographic location, and internal equity.Although we estimatethe successful candidate hiredinto this rolewill beplaced between the entry point and the middle of the range, the decisionwill be made on a case-by-casebasis related tothese factors.This job is also eligible to participate inPG&E's discretionary incentive compensation programs. A reasonable salary range is: Bay Area Minimum: $140,000 Bay Area Maximum: $238,000 Job Responsibilities <ul> <li>Leadership and Team Management: Lead, mentor, and develop a team of data engineers, ensuring high levels of engagement, performance, and professional growth. </li><li>Data Architecture: Direct the development and implementation of scalable, reliable, and efficient data architectures to enable analytic products. </li><li>Data Quality: Establish and enforce data quality standards and best practices to ensure data integrity and reliability. </li><li>Collaboration: Work closely with stakeholders: product managers, senior leadership, business stakeholders, data scientists, analysts, and others to understand their data needs and provide solutions that drive business value. </li><li>Planning and Project Management: Manage data engineering projects, including planning, resource allocation, and execution, ensuring timely delivery and alignment with business objectives. Partner with stakeholders to develop robust data product roadmaps. </li><li>Continuous Improvement: Foster a culture focused on continuous improvement to meet evolving business needs and technologies. </li><li>Compliance: Ensure all data engineering activities comply with relevant data protection and privacy regulations and company policies. </li><li>Cost Management: Responsible for managing team and project budget, ensuring that budget forecasts and actuals are closely monitored and providing variance analysis. </li></ul> Qualifications Minimum: <ul> <li>Bachelors Degree in Computer Science or job-related discipline or equivalent experience </li><li>Experience in IT-Information Technology, 8 years </li><li>Experience: At least 5 years of experience in a leadership or managerial role with a minimum of 2 years in data engineering, data solutions architect, data management, data product management. </li><li>Leadership: Proven track record of leading and developing high-performing teams. </li><li>Communication: Excellent verbal and written communication skills, with the ability to effectively communicate with both technical and non-technical stakeholders. </li><li>Project Management/Delivery: Experience managing multiple projects simultaneously, with a focus on delivering results in a fast-paced environment. Track record of successful delivering on large scale enterprise projects. </li><li>Technical Skills: Deep knowledge of data warehouse and business intelligence design and architecture, sql, python, and pyspark. </li></ul> Desired: <ul> <li>Masters Degree in Business Administration or job-related discipline or equivalent experience </li><li>Utility industry experience </li><li>Leadership experience, IT-Information Technology </li><li>Experience in operations </li><li>PMI-Project Management Institute PMP-Project Management Professional certification </li></ul> #featuredjob

Requisition ID# 160358 Job Category: Information Technology Job Level: Individual Contributor Business Unit: Information Technology Work Type: Hybrid Job Location: Oakland Department Overview Meter to Cash (MTC) Delivery is responsible for analyzing and designing work that impacts the Meter to Cash systems and their direct interfaces. This team works with business and technical stakeholders to obtain the best possible solutions for its clients. Its deliverables include providing estimates for MTC related work; developing an internal work plan with identified resources and target completion dates; and preparing requirements and functional designs. To ensure the MTC Delivery team provides the utmost service to its clients, it is organized into three functional areas that align with PG&E's business operations: Customer Information, Billing/Finance, and Measure & Field Services. Position Summary We are looking for an Expert level IT business analyst in MTC Delivery Billing/Finance team who can be a quick learner, thorough, organized, flexible to adapt in fast paced and dynamic environments. The analyst serves as a subject matter expert for assigned area of coverage with in-depth knowledge of the business practices and MTC functionality that supports it. The analyst is mainly responsible for analyzing business requirements, proposing system solution and developing function requirement and function design documents. In addition, the analyst is responsible for analyzing O&M and project defects to determine business/technical impact and providing recommendation on fixing the defects. PG&E is providing the salary range that the company in good faith believes it might pay for this position at the time of the job posting. This compensation range is specific to the locality of the job. The actual salary paid to an individual will be based on multiple factors, including, but not limited to, specific skills, education, licenses or certifications, experience, market value, geographic location, and internal equity. We would not anticipate that the individual hired into this role would land at or near the top half of the range described below, but the decision will be dependent on the facts and circumstances of each case. A reasonable salary range is: Bay Area Minimum: $122,000.00 Bay Area Maximum: $194,000.00 &/OR California Minimum: $116,000.00 California Maximum: $184,000.00 Qualifications Minimum: <ul> <li>Bachelor's degree in Computer Science, Information Systems or job-related discipline or equivalent work experience </li><li>Minimum 7 years of experience in analyzing, designing and developing functional requirements and application functional design in rate billing and financial domain </li><li>Minimum 5 years of working experience of Oracle CC&B/BCS/C2M application and data model </li><li>Participation in projects of high complexity. </li></ul> Desired: <ul> <li>Experience in CC&B billing financial and Energy Service Provide direct access, Community Choice Aggregation rate billing </li><li>Working knowledge of relational databases (SQL experience) </li><li>Excellent verbal and written communication </li><li>Collaborate with cross functional teams to maintain efficiency, consistency and achieve successful implementation of system enhancement </li><li>Working experience with the corresponding Line of Business </li><li>Leadership role in projects of high complexity </li><li>Working knowledge of MS Office suite of applications, including Word, Excel, PowerPoint, Visio </li><li>CCBA-certification of Competency in Business Analysis certification </li> </ul>Responsibilities Ideation: <ul> <li>Work with business organizations to provide input regarding enhancement feasibility </li><li>Using business process knowledge, proactively look for opportunities for system enhancements </li><li>Evaluate and provide input to "business concept requirements" </li><li>Prepare high level design approach and develop concept estimation </li><li>Anticipate client concerns and questions, and provide proactive, timely and professional client-focused communications. </li></ul> Project: <ul> <li>Analyze/assemble Functional/non-Functional requirements </li><li>Analyze and design solutions independently with minimal guidance as needed on the most complex projects. </li><li>Provide technical expertise and assistance in designing, testing and developing applications </li><li>Perform feasibility analysis, design and provide recommendations on the alternative solutions, project strategy and deliverable prioritization, as well as system alternatives or enhancements to current systems </li><li>Prepare functional requirement and functional design documentation </li><li>Conduct walkthrough of deliverables with business and obtain approval/signoff </li><li>Provide SME support to developers and testers </li><li>Work with business to document and analyze project change controls </li><li>Work with business to document and analyze project change controls </li><li>Work effectively with other groups to persuade, exchange ideas and foster cooperation </li><li>Analyze end-to-end business processes of moderate to high complexity and information needs of the clients in one or more business functional areas. </li><li>Support stabilization of deployed code </li><li>Comply with SOX and other standard process requirements. </li><li>Provide expert consulting in information technology to the client to identify and satisfy the business needs. </li><li>Provide timely responses to client inquiries or delegate as appropriate. </li><li>Provides mentorship and guidance to less experienced employees. </li><li>Review design and technical specification documents for alignment with business solution. </li><li>Serves as key technical resource within the area of specialization. </li><li>Mentors the Associate and Career-level team members. </li><li>Understand in detail the current and future business environment of the business clients; effectively anticipate, identify, and fully meet the business needs. </li></ul> Maintenance: <ul> <li>Troubleshoot potential MTC system issues to determine if there is a defect </li><li>Analyze production defects, identify business and system impacts and quantify problems </li><li>Contribute to defect troubleshooting and solution design </li><li>Assist business and technical teams with adhoc requests </li><li>Provide functional expertise to clients for resolving business issues </li></ul> #featuredjob

Pacific Gas And Electric Company Interview Questions

Pacific Gas And Electric Company Interview Guides

Pacific Gas And Electric Company Interview Questions

Pacific Gas And Electric Company Salaries by Position

Pacific Gas And Electric Company Opening Jobs