Prepare for and practice interview questions from Florida International University.

Florida International University Interview Questions

Florida International University Interview Guides

<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

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

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

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


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

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?

Florida International University Salaries by Position

<p>Job Opening ID: 522882
Location: Modesto A. Maidique Campus
Full/Part Time: Full-Time
Review Date: 02/18/2021
Regular/Temporary: Regular
About FIU:
Florida International University is Miami's public research university, focused on student success. According to U.S. News and World Report, FIU has 42 top-50 rankings in the nation among public universities. FIU is a top U.S. research university (R1), with more than $200 million in annual expenditures. FIU ranks 15th in the nation among public universities for patent production, which drives innovation, and is one of the institutions that helps make Florida the top state for higher education. The Next Horizon fundraising campaign is furthering FIU's commitment to providing students Worlds Ahead opportunities. Today, FIU has two campuses and multiple centers, and supports artistic and cultural engagement through its three museums: Patricia & Phillip Frost Art Museum, the Wolfsonian-FIU, and the Jewish Museum of Florida-FIU. FIU is a member of Conference USA, with more than 400 student-athletes participating in 18 sports. The university has awarded more than 330,000 degrees to many leaders in South Florida and beyond. For more information about FIU, visit www.fiu.edu.
Job Summary:
Provides technical leadership and direction to the Computer Science team in integrating various modeling components, programming and software development for the Florida Public Hurricane Loss Model (FPHLM) project. Works closely with the team in the development of an efficient model to simulate and predict how, where and when hurricanes form, their wind speed, the damage caused to typical building structures, and how much of the loss will be paid by the insurers. Formulates and defines system scope, objectives and coding based on team needs and a thorough understanding of business systems and modeling requirements. Devises or modifies procedures to solve complex problems including coding and efficient modeling runs. Performs analysis of business and user needs, documents requirements, and translates them into proper system requirement specifications. Possesses full technical knowledge of various modeling components and coding, as well as considers the business implications of the application of technology to insurance business environment.
Works closely with the Principal Investigator (PI) and Co-PI in the day-to-day operational activities of the FPHLM. Advises the PI on technical changes/modifications and improvements. Develops and implements short and long-term operational plan for the FPHLM.
Provides technical leadership and guidance to the team in integrating modeling components, programming, and software development for the Florida Public Hurricane Loss Model (FPHLM).
Develops, implements, and recommends operating procedures and design approaches to solve complex problems for the project.
Responsible for the development/coding of FPHLM software and efficient communications with the other disciplines to seamlessly integrate the various modeling components.
Develops and maintains big data distributed computing infrastructure and software to efficiently process large amounts of data used in the FPHLM.
Develops, maintains and further automates the web-based data processing pipeline to generate required outputs and documents for the FPHLM.
Provides leadership to the technical team performing programming, database management, software engineering and analytic work.
Leads the large-scale software system development and integration. Troubleshoots the nuances of large-scale enterprise projects with a continuous development cycle.
Maintains knowledge and overviews expertise on current industry software and system development to support research requirements. Makes recommendation on improving the efficiency and performance of the risk model.
Serves as the project technical lead and ensures deadlines and project milestones are met while maintaining product quality while managing and overseeing support to resolve application issues.
Writes technical reports and co-authors peer-reviewed journals to present programming methodology, results and recommendations.
Leads a team of graduate assistants, temporary employees and other researchers to solve both functional and system issues.
Interprets and implements policies and procedures as necessary.
Performs other duties as assigned.
Minimum Qualifications:
Bachelor's degree and eight (8) years of experience in related field.
Desired Qualifications:
Experienced in large-scale system development and integration.
Highly proficient in Java, C, C++, and Linux shell programming, e.g., bash, cshell, and awk.
Competent in web technologies, e.g., JSP, Servlets, PHP, Ajax, JavaScript, and JQuery.
Proficient in Database concepts in PostgreSQL, e.g., server installation, maintenance, complex data types, indexes, schema modeling, stored procedures, and user administration.
Preferred experience in distributed computing, e.g., Spark, and Hadoop.
Experienced in Software Testing practices and documentation.
Proficient in Unix, Linux, and Windows Operating Systems.
Proficient in Microsoft Word and Excel, e.g., style and references management and track changes in Word; graphs, and formulas.
Job Category: Administrative
Advertised Salary: $80,000.00 - $90,000.00
Work Schedule: Begin time: 8:30 AM; End time: 5:00 PM
Pre-Employment Requirements:
Criminal Background Check
Fingerprinting Check
How To Apply:
Prospective Employee: If you have not created a registered account, you will be asked to create a username and password for use of the system. It is recommended that you provide an active/valid e-mail account as that will be the main source of communication regarding your status within the process. In this account, you are able to track your applicant status in My Applications .
*This posting will close at 12:00 am of the close date.
Current Employee: As a current employee, you must log into Employee Self Service (ESS) to apply for this and any other internal career opportunity of interest. In this account, you are able to track your applicant status in My Applications .
*This posting will close at 12:00 am of the close date.
Disclosures:
Florida Statute 1010.35 - Screening Foreign Researchers: Pursuant to Florida law, any citizen of a foreign county who is not a permanent resident of the U.S., or who is a citizen or permanent resident but is affiliated with or has had at least 1 year of employment or training in China, Russia, Iran, North Korea, Cuba, Venezuela, or Syria is subject to additional screening. Applicants meeting those criteria will be required to provide the following information in the application: every institution of higher education attended; all previous employment since the applicant's 18th birthday; list of all published material, current and pending research funding from any source, including details about the research, your role, funding source, and amount; list and description of any non-university professional activities; any affiliation with an institution or program in a foreign country; a complete copy of your passport; the most recently submitted DS-160 (Online Nonimmigrant Visa Application).
Clery Notice: In compliance with the Jeanne Clery Disclosure of Campus Security Policy and Crime Statistics Act, the University Police department at Florida International University provides information on crimes statistics, crime prevention, law enforcement, crime reporting, and other related issues for the past three (3) calendar years. The FIU Annual Security report is available online at: https://police.fiu.edu/download/annual-security-fire-safety-report/.
Pay Transparency: Florida International University will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information.
FIU is a member of the State University System of Florida and an Equal Opportunity, Equal Access Affirmative Action Employer all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status.

#J-18808-Ljbffr</p>

Florida International University Interview Questions

Florida International University Interview Guides

Florida International University Interview Questions

Florida International University Salaries by Position

Florida International University Opening Jobs