Prepare for and practice interview questions from Glotech, Inc..

Glotech, Inc. Interview Questions

Glotech, Inc. 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>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 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?

Glotech, Inc. Salaries by Position

<p>Data Engineer II Job Locations US-FL-Orlando Job ID 2024-1867  of Openings 2 Category Database Administration Overview GLOTECH, Inc., founded in 1995, is a privately and minority-owned company serving military, federal and commercial clients. We are a successful Information Technology firm with a large staff currently providing superior information technology and advanced engineering services around the world. Our success is built on attracting and retaining quality staff through a highly competitive benefits package with a special focus on continuing career development and corporate financial support. We also maintain a collegial working environment and offer our staff opportunities to improve and enhance their skills. GLOTECH is committed to a comprehensive employee benefits program that helps our employees stay healthy, feel secure and maintain a work/life balance. We provide medical dental and vision care, disability insurance (short and long term), Life & AD&D Insurance, Flexible Spending Accounts (Healthcare, Dependent Care and Commuter Transportation and Parking Reimbursement), and Employee Assistance Programs. Additionally, we provide Annual Leave, Sick Leave, Holiday Pay, Educational Assistance, Certification /Training Reimbursement, and a 401(k)-retirement savings contribution plan (with employer match). Responsibilities GLOTECH, Inc. is seeking an experienced Data Engineer to support the corporate office of United Parks & Resorts located in Orlando, FL. The Data Engineer will analyze, assemble and make available a high volume, variety, and velocity of data sets to help with data driven decision making. Design, develop, test, and deploy the required and optimal data services, structures, and overall solutions that meet the needs of the organization, including extraction, transformation, and loading of data from various data sources into the appropriate data environments Ensure best practices for data architecture and data management are implemented including metadata management, data cataloging, observability/monitoring Work closely with data product owners, data analysts, and BI developers to ensure your data solutions meet their needs and preferences Work with business stakeholders and technology partners including application teams, infrastructure and security, as well as technology leadership Qualifications BSc in Computer Science or relevant field Expert skill with Google Cloud, Big Query, Cloud Data Fusion, and other GCP related data technologies Experience gathering and analyzing system requirements Expertise building and deploying data pipelines using CI/CD Expertise in SQL, familiarity with noSQL databases Expertise in GCP Big Query, Cloud Data Fusion, other GCP data technologies and On-prem SQL Server technologies Familiarity with data visualization tools (e.g. Looker Pro, PowerBI, Tableau, D3.js and R) Problem-solving attitude Must be available to work onsite in Orlando, FL GLOTECH, Inc. is an Equal Opportunity/Affirmative Action Employer - Minorities/Females/Protected Veterans/Individuals with Disabilities.</p>

Glotech, Inc. Interview Questions

Glotech, Inc. Interview Guides

Glotech, Inc. Interview Questions

Glotech, Inc. Salaries by Position

Glotech, Inc. Opening Jobs