Prepare for and practice interview questions from Improvix Technologies.

Improvix Technologies Interview Questions

Improvix Technologies 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?

Improvix Technologies Salaries by Position

Role: Senior Full Stack Software Engineer (.NET) Location: Washington, DC (Hybrid - 2 days on site) Type: Full Time Clearance: Secret Clearance (Top Secret Eligible) Overview We are looking for bright, enthusiastic, and motivated team players that are excited about Microsoft technology, and who want to help us solve problems and deliver value for high-profile, federal clients. We have openings for .NET and SharePoint Developers supporting our US Department of State program. As a .NET or SharePoint Developer at Improvix, you will be creating applications using Microsoft .NET, MVC, C#, React, PHP, SharePoint 2016, and Office 365 (SharePoint Online and Power Platform). If you're a can-do developer who wants to learn, grow, and work in a creative, fun, stimulating environment, then Improvix wants to hear from you! Skills & Requirements <ul> <li>At least 5 years of professional software development experience.</li> <li>Proficiency in SharePoint development, PowerApps Development, C#, and .NET Framework.</li> <li>Experience with N-Tier application development framework. </li> <li>Familiarity with SQL Server (or other major DBMS) using SQL and stored procedures.</li> <li>Client scripting skills (JavaScript, jQuery, JSON and AJAX).</li> <li>Experience with CSS, XML, XSLT, PHP.</li> <li>Work well as part of a team.</li> <li>Good communication skills.</li> <li>Solid Internet and Intranet application development experience.</li></ul> Desirable Skills <ul> <li>Experience developing web parts/features for SharePoint 2016 and O365 Suites of applications (SharePoint Online), including using the SP object model, SharePoint Designer, and Power Platform - PowerApps, Logic Apps and Flow (or willingness to learn).</li> <li>Experience with SDLC process using Agile Methodology. </li> <li>Experience with data modeling and object modeling.</li> <li>Experience being responsible for the overall project database design, application architecture and application design.</li> <li>Experience producing Design Documentation and Functional Specifications.</li></ul> About Us: Our Vision is to provide innovative, reliable, and cost-effective IT solutions for the public and private sector. We strive to improve our customers' technology usage by expanding their mobility, securing their infrastructure, modernizing their environment, and providing top tier customer service and response time. Our team is comprised of talented, energetic, and dedicated employees who similarly share our desire to provide impactful expertise and support to our customers. Improvix Technologies is an equal opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, or any other characteristic protected by law. Skills & Requirements Qualifications At we understand the importance of secure and reliable IT solutions. To this end, our stellar track record highlights our consistent delivery of cost-effective, strongly-secure, and highly-integrated IT solutions that exceed customers' expectations and enhance the Government's technology landscape. We invite you to join our dynamic organization serving federal and corporate clients. Improvix Technologies offers competitive salaries and a comprehensive benefits package to provide our employees with financial and health protection and advantages they deserve. Our benefits include 401K matching, life insurance, up to four weeks of paid annual leave, transit and training compensation, health, dental and vision benefits. Improvix Technologies, Inc.is committed to hiring and retaining a diverse workforce. We are proud to be an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, sexual orientation, religion, age, national origin, disability status or any other class protected by law. U.S. Citizenship is required for most positions.

Improvix Technologies Interview Questions

Improvix Technologies Interview Guides

Improvix Technologies Interview Questions

Improvix Technologies Salaries by Position

Improvix Technologies Opening Jobs