Prepare for and practice interview questions from Agileengine.

Agileengine Interview Questions

Agileengine 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

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

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

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?

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?

Agileengine Salaries by Position

Job Description This is a remote position and we are hiring candidates from the whole country. AgileEngine is one of the Inc. 5000 fastest-growing companies in the US and a top-3 ranked dev shop according to Clutch. We create award-winning custom software solutions that help companies across 15+ industries change the lives of millions. If you like a challenging environment where you're working with the best and are encouraged to learn and experiment every day, there's no better place - guaranteed! :) What you will do <ul><li>Design data management strategies and processes for the organization; </li><li>Design and build systems and solutions leveraging various AWS cloud components & tools; </li><li>Design, build, and orchestrate data pipelines from multiple sources into the enterprise data warehouse, supporting data modeling for use in the enterprise semantic layer; </li><li>Design and build new functionalities and solutions for client use cases; </li><li>Design and build data platforms; </li><li>Act as the Subject Matter Expert for Testers, Developers, and Business Users in the area of Data solution functionality; </li><li>Build and maintain relationships with key stakeholders to understand their Data needs and business goals, transforming them into actionable data actions; </li><li>Define and estimate the scope of work needed for the implementation of business architecture; </li><li>Lead project and program development team; </li><li>Perform analysis of functional and business requirements, develop user stories and design solutions; </li><li>Support the growth of the Data competency; </li><li>Identify and optimize performance bottlenecks. </li></ul>Must haves <ul><li>A minimum of 7 years of design & implementation experience with distributed applications and systems; </li><li>3+ years of hands-on experience with architecting solutions on Cloud Platforms; </li><li>Ability to design and document data architecture, governance and management processes; </li><li>Ability to analyze and document data structures and transformations; </li><li>Strong experience with DBT, Redshift, MWAA (Airflow), Lambda functions; </li><li>Proficient in Python and SQL; </li><li>Strong skills and proven experience working with Data Warehouses; </li><li>Willingness to develop in Data & Analytics space; </li><li>Strong English language skills for both verbal and written communication; </li><li>Excellent communication skills to interact with a range of stakeholders; </li><li>Ability to plan, track, and report the status of the deliverables; </li><li>At least a Bachelor's degree, preferably in engineering, computer science or a related field; </li><li>Experience in data collection, modeling, validation and normalization; </li><li>Experience in working in Agile methodology; </li><li>Experience working in an environment leveraging remote communication and collaboration tools (e.g. Github, Slack, JIRA). </li></ul>Nice to haves <ul><li>Infrastructure experience as a DevOps Engineer is a high plus; </li><li>Experience working with Quicksight. </li></ul>Applicants must be authorized to work for ANY employer in the US (i.e. Green card holders, TN visa holders, GC EAD, H4 EAD, U4U with EAD). We are unable to sponsor or take over sponsorship of an employment Visa at this time. The benefits of joining us <ul> <li>Professional growth </li></ul>Accelerate your professional journey with mentorship, TechTalks, and personalized growth roadmaps <ul><li>Competitive compensation </li></ul>We match your ever-growing skills, talent, and contributions with competitive USD-based compensation and budgets for education, fitness, and team activities <ul><li>A selection of exciting projects </li></ul>Join projects with modern solutions development and top-tier clients that include Fortune 500 enterprises and leading product brands <ul><li>Flextime </li></ul> Tailor your schedule for an optimal work-life balance, by having the options of working from home and going to the office - whatever makes you the happiest and most productive.

Job Description This is a remote position and we are hiring candidates from the whole country. AgileEngine is one of the Inc. 5000 fastest-growing companies in the US and a top-3 ranked dev shop according to Clutch. We create award-winning custom software solutions that help companies across 15+ industries change the lives of millions. If you like a challenging environment where you're working with the best and are encouraged to learn and experiment every day, there's no better place - guaranteed! :) What you will do <ul><li>Design data management strategies and processes for the organization;</li><li>Design and build systems and solutions leveraging various AWS cloud components & tools;</li><li>Design, build, and orchestrate data pipelines from multiple sources into the enterprise data warehouse, supporting data modeling for use in the enterprise semantic layer;</li><li>Design and build new functionalities and solutions for client use cases;</li><li>Design and build data platforms;</li><li>Act as the Subject Matter Expert for Testers, Developers, and Business Users in the area of Data solution functionality;</li><li>Build and maintain relationships with key stakeholders to understand their Data needs and business goals, transforming them into actionable data actions;</li><li>Define and estimate the scope of work needed for the implementation of business architecture;</li><li>Lead project and program development team;</li><li>Perform analysis of functional and business requirements, develop user stories and design solutions;</li><li>Support the growth of the Data competency;</li><li>Identify and optimize performance bottlenecks.</li></ul> Must haves <ul><li>A minimum of 7 years of design & implementation experience with distributed applications and systems;</li><li>3+ years of hands-on experience with architecting solutions on Cloud Platforms;</li><li>Ability to design and document data architecture, governance and management processes;</li><li>Ability to analyze and document data structures and transformations;</li><li>Strong experience with DBT, Redshift, MWAA (Airflow), Lambda functions;</li><li>Proficient in Python and SQL;</li><li>Strong skills and proven experience working with Data Warehouses;</li><li>Willingness to develop in Data & Analytics space;</li><li>Strong English language skills for both verbal and written communication;</li><li>Excellent communication skills to interact with a range of stakeholders;</li><li>Ability to plan, track, and report the status of the deliverables;</li><li>At least a Bachelor's degree, preferably in engineering, computer science or a related field;</li><li>Experience in data collection, modeling, validation and normalization;</li><li>Experience in working in Agile methodology;</li><li>Experience working in an environment leveraging remote communication and collaboration tools (e.g. Github, Slack, JIRA).</li></ul> Nice to haves <ul><li>Infrastructure experience as a DevOps Engineer is a high plus;</li><li>Experience working with Quicksight.</li></ul> Applicants must be authorized to work for ANY employer in the US (i.e. Green card holders, TN visa holders, GC EAD, H4 EAD, U4U with EAD). We are unable to sponsor or take over sponsorship of an employment Visa at this time. The benefits of joining us <ul><li>Professional growth</li></ul> Accelerate your professional journey with mentorship, TechTalks, and personalized growth roadmaps <ul><li>Competitive compensation</li></ul> We match your ever-growing skills, talent, and contributions with competitive USD-based compensation and budgets for education, fitness, and team activities <ul><li>A selection of exciting projects</li></ul> Join projects with modern solutions development and top-tier clients that include Fortune 500 enterprises and leading product brands <ul><li>Flextime</li></ul> Tailor your schedule for an optimal work-life balance, by having the options of working from home and going to the office - whatever makes you the happiest and most productive.

Agileengine Interview Questions

Agileengine Interview Guides

Agileengine Interview Questions

Agileengine Salaries by Position

Agileengine Opening Jobs