Prepare for and practice interview questions from Egen.

Egen Interview Questions

Egen 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?

Egen Salaries by Position

About Egen: Egen is a fast-growing and entrepreneurial company with a data-first mindset. We bring together the best engineering talent working with the most advanced technology platforms, including Google Cloud and Salesforce, to help clients drive action and impact through data and insights. We are committed to being a place where the best people choose to work so they can apply their engineering and technology expertise to envision what is next for how data and platforms can change the world for the better. We are dedicated to learning, thrive on solving tough problems, and continually innovate to achieve fast, effective results. If this describes you, we want you on our team. Want to learn more about life at Egen? Check out these resources in addition to the job description. -> Meet Egen -> Life at Egen -> Culture and Values at Egen -> Career Development at Egen About the job: <ul><ul><li>Work directly with client technical and business teams</li><li>Provide both consultative and hands-on technical guidance and support</li><li>Use GCP services to deploy highly available, scalable, and secure pipelines and applications</li><li>Implement workflows to automate the release and upgrade process for applications in Development, Test and production environments</li><li>Implement secure integrations using Google security and networking technologies (IAP, VPC, and PSC). Administration and engineering of IAM user Role-Based Access Controls and processes </li><li>Create and update support documentation and standards</li><li>Develop automated methodologies for deployment activities, configuration management, supporting systems and business processes</li><li>Investigate and contribute to solving various issues in production environments</li></ul></ul> About you: <ul><ul><li>4+ years GCP with focus on BQ and including networking and access control/security management</li><li>4+ years in software development, preferably with Python</li><li>4+ SQL and complex stored procedures</li><li>Experience with CI/CD Pipelines and Workflows</li><li>Azure Devops/GIT</li><li>Good understanding of ETL/ELT principals</li><li>LAMDA and Shell Scripting and Cloud Functions</li><li>Excellent debugging and testing skills</li><li>Qlik Change Data Capture</li><li>Windows operating system and scripting</li><li>VPN and Partner Interconnect</li></ul></ul> EEO and Accommodations: Egen is an equal opportunity employer and is committed to inclusion, diversity, and equity in the workplace. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veterans' status, or any other characteristic protected by federal, state, or local laws. Egen will also consider qualified applications with criminal histories, consistent with legal requirements. Egen welcomes and encourages applications from individuals with disabilities. Reasonable accommodations are available for candidates during all aspects of the selection process. Please advise the talent acquisition team if you require accommodations during the interview process.

About Egen: Egen is a fast-growing and entrepreneurial company with a data-first mindset. We bring together the best engineering talent working with the most advanced technology platforms, including Google Cloud and Salesforce, to help clients drive action and impact through data and insights. We are committed to being a place where the best people choose to work so they can apply their engineering and technology expertise to envision what is next for how data and platforms can change the world for the better. We are dedicated to learning, thrive on solving tough problems, and continually innovate to achieve fast, effective results. If this describes you, we want you on our team. Want to learn more about life at Egen? Check out these resources in addition to the job description. -> Meet Egen -> Life at Egen -> Culture and Values at Egen -> Career Development at Egen About the job: <ul><ul><li>Lead delivery teams and clearly delineate parallel work-streams</li><li>Lead discovery sessions with clients and carefully navigate requirement discussions to avoid designs requiring additional scope</li><li>Support pre-sales discussions and assist pre-sales engineers to identify scope issues and clearly define assumptions for LOEs</li><li>Drive reusable code and solution architecture practice</li><li>Apply cloud architecture and application design knowledge</li><li>Assist the sales team with potential clients</li><li>Document requirements and design decisions</li><li>Ensure coding practices result in clean, reusable code to consistently mature the delivery practice</li></ul></ul> About you: <ul><ul><li>5+ years of experience as a ML Engineer</li><li>Bachelor's Degree is preferred but will consider relevant experience as an equivalent</li><li>Strong foundation in NLP, vision, and generative AI</li><li>Vertex AI, Vertex Search and Conversations</li><li>Dialogflow CX</li><li>Vision AI and OCR</li><li>Cloud Text-to-Speech, Cloud Speech-to-Text</li><li>Cloud Translation, Glossaries</li><li>Python</li><li>Vector stores</li><li>Langchain</li><li>Data Loss Prevention</li><li>CICD best practices, especially with complexity of CCAI and/or PSO engagements</li></ul></ul> EEO and Accommodations: Egen is an equal opportunity employer and is committed to inclusion, diversity, and equity in the workplace. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veterans' status, or any other characteristic protected by federal, state, or local laws. Egen will also consider qualified applications with criminal histories, consistent with legal requirements. Egen welcomes and encourages applications from individuals with disabilities. Reasonable accommodations are available for candidates during all aspects of the selection process. Please advise the talent acquisition team if you require accommodations during the interview process.

Egen Interview Questions

Egen Interview Guides

Egen Interview Questions

Egen Salaries by Position

Egen Opening Jobs