Prepare for and practice interview questions from Salt river project.

Salt river project Interview Questions

Salt river project Interview Guides

<p>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.</p>

<p>Write a query to randomly sample a row from this table.</p>

<p><strong>Input:</strong></p>

<p><code>big_table</code> table</p>

<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

<p>You are testing hundreds of hypotheses with many <em>t</em>-tests. What considerations should be made?</p>


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

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?

<p>Let’s say that your company is running a standard control and variant AB test on a feature to increase conversion rates on the landing page. The PM checks the results and finds a .04 p-value.</p>

<p>How would you assess the validity of the result?</p>


Experiment Validity

Salt river project Salaries by Position

<p>Requisition ID: 17988Join us in building a better future for Arizona! SRP is one of the largest public power and water utilities in the U.S. providing electricity to approximately one million customers in the greater metropolitan Phoenix area. Since its founding in 1903, SRP has fostered a culture of stewardship and customer service consistently ranking as an industry leader in customer service according to J.D. Power and named one of Arizona's best employers by Forbes. SRP continues to adapt to its changing business environment by seeking innovative ways to reimagine utility service and the provision of critical resources essential to the life and economy of Arizona.Why Work at SRPAt SRP, we foster an inclusive work environment and believe everyone should have a fair chance to work, regardless of who they are. That's why we value teams with diverse perspectives, experiences, and backgrounds to help SRP deliver on its mission of providing reliable, affordable and sustainable water and power.SRP's success is rooted in our employees' happiness, health, and safety. That's why we offer a comprehensive benefits package to meet the needs of our employees and enhance their well-being. In addition to competitive pay and performance incentives, eligible employees can take advantage of the following benefits: Pension Plan (at no cost to the employee) 401(k) plan with employer matching Available your first day: Medical, vision, dental, and life insurance Over 200+ hours of PTO (includes vacation days, holidays, floating holidays, and sick leave) Parental leave (up to 4 weeks) and adoption assistance Wellness programs (including access to a recreation and fitness facility) Short and long-term disability plans Tuition assistance for both undergraduate and graduate programs 10 Employee Resource Groups for career development, community service, and networkingSummaryProvides planning, analysis, and problem solving support for SRP utilizing numerous SRP computer applications. Conducts studies to quantify and enhance process and procedures for efficient operations of the department with special emphasis in the areas of budget control, competitive service value, and customer service.What You'll Do Provides analytical support to the department manager and the management staff. Assists department management to develop and implement strategic goals and objectives and to monitor results. Prepares, monitors, and reports on departmental O&M and Capital Budgets analyzing budget variance. Identifies and corrects any discrepancies that exist, and reports to Management any changes. Executes special tasks or project assignments by Management and performs independent analytical studies and evaluations of processes and supporting tools, methods, and technology. Maintains working knowledge of corporate and departmental policies and procedures. Has an ability to apply/use tools and technology for the purpose of accomplishing assigned tasks. Researches and prepares reports/presentations to management that effect business implementation decisions Assists management to identify internal/external items that may impact/improve effectiveness, costs, and customer service. Performs other functions and duties as assigned.ExperiencePromotion to Level 2 requires a minimum of two years experience at Level 1 and demonstrated capability to perform advanced and more difficult work as determiend by the supervisor. Promotion to Senior Level requires a minimum of 3 years experience at Level 2, is fully competent in all aspects of functional area of assignment and as such would be recognized as a specialist in area of assignment and may have periodic or occasional lead responsibilities.EducationCompletion of a Bachelor's Degree from an accredited institution that prepares the employee for the assignment.Hybrid WorkplaceSRP currently offers a hybrid workplace, which allows employees whose jobs can be performed remotely, and who have sufficient technical capability, to telework up to three days per week. Although teleworking is available, all employees must live and work in Arizona. We are taking steps to protect the health and well-being of all team members, and by following a number of health and safety protocols, to reduce the risk of the coronavirus (COVID-19).Drug/Alcohol Policy Statement To promote the safety and well-being of our employees, customers, and the communities we serve, SRP is committed to maintaining a drug/alcohol free work environment. Although marijuana may now be legal in Arizona, except as otherwise specified under Arizona law, SRP considers it to be an illegal drug for the purpose of our drug/alcohol policy because marijuana remains illegal at the federal level. Any candidate found to be impaired during the hiring process or who has the presence of an illegal drug or unauthorized substance in their system during the pre-employment drug/alcohol test may be disqualified from further consideration in the hiring process.Equal Opportunity Employer Statement Salt River Project (SRP) is committed to equal employment opportunity regardless of race, color, religion, sex (including pregnancy), gender identity, sexual orientation, national origin, age, disability, genetic information, military status, or any other protected status under applicable federal, state or local law.Work AuthorizationAll candidates must be legally authorized to work in the United States.Currently, SRP does not sponsor H1B visas, OPT, or other employment-related visa's.</p>

Salt river project Interview Questions

Salt river project Interview Guides

Salt river project Interview Questions

Salt river project Salaries by Position

Salt river project Opening Jobs