Prepare for and practice interview questions from Louisiana State University.

Louisiana State University Interview Questions

lsu is the flagship institution of louisiana and is one of only 30 universities nationwide holding land-grant, sea-grant and space-grant status. since 1860, lsu has served its region, the nation, and the world through extensive, multipurpose programs encompassing instruction, research, and public service. the university brings in more than $150 million annually in outside research grants and contracts, a significant factor for the louisiana economy.

lsu is the flagship institution of louisiana and is one of only 30 universities nationwide holding land-grant, sea-grant and space-grant status. since 1860, lsu has served its region, the nation, and the world through extensive, multipurpose programs encompassing instruction, research, and public service. the university brings in more than $150 million annually in outside research grants and contracts, a significant factor for the louisiana economy.

Overview

Louisiana State University Interview Guides

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

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.

How would you assess the validity of the result?

Experiment Validity

Let’s say you work for a social media company that has just done a launch in a new city. Looking at weekly metrics, you see a slow decrease in the average number of comments per user from January to March in this city.

The company has been consistently growing new users in the city from January to March.

What are some reasons why the average number of comments per user would be decreasing and what metrics would you look into?

What metric could be used to measure if active users are still engaging on the platform despite an overall decrease in the average number of comments per user?

What metric could be used to measure if active users are still engaging on the platform despite an overall decrease in the average number of comments per user?

Decreasing Comments

How would you investigate a decline in the average number of comments per user?

Louisiana State University Salaries by Position

About Us: At the forefront of medical discovery as it relates to understanding the causes of obesity, diabetes, cardiovascular disease, cancer and dementia, Pennington Biomedical Research Center is a campus of Louisiana State University and conducts basic, clinical and population research. The Center includes Basic Science, Clinical Research, and Population and Public Health, enabling both focused research and translational science. Research at Pennington Biomedical is supported broadly by multiple NIH Research Centers, and includes approximately 65 faculty and 20 postdoctoral fellows who comprise a network of 44 laboratories and 13 highly specialized core service facilities. Pennington Biomedical is located within state-of-the-art research facilities on a 222-acre campus in Baton Rouge, Louisiana. All Job Postings will close at 12:01a.m. CST (1:01a.m. EST) on the specified Closing Date (if designated). If you close the browser or exit your application prior to submitting, the application progress will be saved as a draft. You will be able to access and complete the application through "My Draft Applications" located on your Candidate Home page. Job Posting Title: Research Scientist - Molecular Metabolism Position Type: Other Academic Department: LSUPBRC Basic - Molecular Metabolism (Tim Heden (00077869)) Work Location: LSU - Pennington Biomedical Pay Grade: Other Academic Job Description: Pennington Biomedical Research Center, a world-renowned academic research institute of Louisiana State University, is seeking a Research Scientist in the Molecular Metabolism Laboratory. The Research Scientist will assist the PI in examining the metabolic and behavioral phenotype of mice and rats. Projects for this position will include utilizing preclinical cell culture and animal models to study endoplasmic reticulum (ER) stress and the ER resident protein starch binding domain containing protein 1 (STBD1) in various contexts, such as cancer, obesity, and diabetes. Hands on training will be provided in the lab for genotyping and metabolic phenotyping of mice, fluorescent imaging, stable and radioactive isotope tracing, and numerous other basic biochemistry assays. Major Responsibilities <ul><li>Assist with ongoing NIH funded studies investigating various aspects of metabolism in the setting of cancer, obesity, and diabetes.</li><li>Mouse colony maintenance and genotyping, various experiments involving the handling of mice, animal tissue collection/processing/analyses, and data analysis/maintenance.</li><li>Design, oversee, and oversee multiple research projects.</li><li>Prepare abstracts and talks for scientific conferences.</li><li>Prepare manuscripts for submission to high-impact journals.</li></ul> Required Qualifications <ul><li>PhD in a science related field.</li><li>Minimum of two (2) years of experience working with rodent models, molecular biology and/or biological techniques.</li><li>Knowledge of statistical software (e.g. JMP, SPSS, R).</li><li>Knowledge or experience using equipment for metabolic and/or behavioral phenotyping of laboratory rodents.</li><li>Excellent written and verbal communication skills.</li></ul> Preferred Qualifications <ul><li>Five (5) or more years of experience working with rodent models, molecular biology and/or biological techniques.</li><li>Knowledge of metabolic and behavioral software programs (e.g. Promethion live, Macro Interpreter, Cal-R, Expedata, Ethovision, Anymaze).</li></ul> Pennington Biomedical Research Center (PBRC) is an equal employment opportunity employer and serves as a model employer for individuals with disabilities. Additional Job Description: Competencies: None Special Instructions: Interested candidates should include cover letter, curriculum vitae, and a statement of research interests (one or two pages). Official transcripts are required prior to hire and are not required at the time of application. Posting Date: October 4, 2024 Closing Date (Open Until Filled if No Date Specified): Additional Position Information: Pennington Biomedical is located within state-of-the-art research facilities on a 222-acre campus in Baton Rouge, Louisiana. For more information, visit PBRC. Questions regarding career opportunities at Pennington Biomedical should be sent to hrm@pbrc.edu. Background Check - An offer of employment is contingent on a satisfactory pre-employment background check. Benefits - Pennington Biomedical Research Center offers outstanding benefits to eligible employees and their dependents including health, life, dental, and vision insurance; flexible spending accounts; retirement options; various leave options; paid holidays; wellness benefits; tuition exemption for qualified positions; training and development opportunities; employee discounts; and more! Positions approved to work outside the State of Louisiana shall be employed through Louisiana State University's partner, nextSource Workforce Solutions, for Employer of Record Services including but not limited to employment, benefits, payroll, and tax compliance. Positions employed through Employer of Record Services will be offered benefits and retirement as applicable through their provider and will not be eligible for State of Louisiana benefits and retirement. Essential Position (Y/N): Pennington Biomedical Research Center/LSU is an Equal Opportunity Employer and SAME Agency: Pennington Biomedical Research Center and LSU believes diversity, equity, and inclusion enrich the educational experience of our students, faculty, and staff, and are necessary to prepare all people to thrive personally and professionally in a global society. We celebrate diversity and are committed to the principles of diversity and inclusion. We actively seek and encourage qualified applications from persons with diverse backgrounds, cultures, and experiences. PBRC and LSU are also designated as a State As a Model Employer (SAME) agency and provides assistance to persons needing accommodations or with the accessibility of materials. For those seeking such accommodations or assistance with the accessibility of materials related to this search are encouraged to contact the Office of Human Resource Management at hrm@pbrc.edu. Contact Information: Questions or concerns can be directed to PBRC Human Resources at 225-763-2776 or hrm@pbrc.edu.

Louisiana State University Interview Questions

Overview

Louisiana State University Interview Guides

Louisiana State University Interview Questions

Louisiana State University Salaries by Position

Louisiana State University Opening Jobs