Prepare for and practice interview questions from Indium Software.

Indium Software Interview Questions

Indium Software Interview Guides

Given tables <code>employees</code>,
<code>employee_projects</code>, and <code>projects</code>, find the 3 lowest-paid employees that have completed at least 2 projects.

Note: incomplete projects will have an end date of <code>NULL</code> in the projects table.

Example:

Input:

<code>employees</code> table

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>first_name</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>last_name</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>salary</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>department_id</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<code>employee_projects</code> table

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>employee_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>project_id</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<code>projects</code> table

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>title</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>start_date</code></td>
<td>DATE</td>
</tr>

<tr>
<td><code>end_date</code></td>
<td>DATE</td>
</tr>

<tr>
<td><code>budget</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
Output:

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>employee_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>salary</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>completed_projects</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>

Lowest Paid

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

Indium Software Salaries by Position

Job Description Title: Senior Data Engineer Education Qualification: Bachelor's degree in Computer Science, Information Technology, or a related field. Experience: 5-10 years Location: Pittsburgh Work Mode: Work from Office Required Skills: Snowflake engineers with strong SQL skills <ul><li>Snowflake Architecture and Design. </li><li>SQL and Data Modeling. </li><li>ETL and Data Integration. </li><li>Performance Tuning and Optimization. </li><li>Cloud Computing (AWS, GCP)Data Warehousing Concepts. </li><li>Data Security and Compliance. </li><li>Data Migration and Replication. </li><li>Azure </li><li>Snowflake engineers with strong SQL skills </li> </ul>

Job Description Title: Senior Data Engineer Education Qualification: Bachelor's degree in Computer Science, Information Technology, or a related field. Experience: 5-10 years Location: Pittsburgh Work Mode: Work from Office Required Skills: Snowflake engineers with strong SQL skills <ul><li>Snowflake Architecture and Design.</li><li>SQL and Data Modeling.</li><li>ETL and Data Integration.</li><li>Performance Tuning and Optimization.</li><li>Cloud Computing (AWS, GCP)Data Warehousing Concepts.</li><li>Data Security and Compliance.</li><li>Data Migration and Replication.</li><li>Azure</li><li>Snowflake engineers with strong SQL skills</li></ul>

Job Description Job Title: Data Architect Job Experience: 8 - 15 Years Educational Qualifications: Bachelor's degree in computer science, Information Technology, or a related field Work Location: Princeton Work Mode: Hybrid Key Responsibilities: Conceptual, logical and physical database design using SQL Server and other relevant technologies. Analyze existing databases, provide feedback, and recommend improvements. Develop and maintain controls for data quality. Work with the team to migrate historical data to a new environment. Set up standards for database development, maintenance, and operations. Develop data models that focus on maintainability, scalability, and performance. Collaborate with software developers, business analysts, and other stakeholders to ensure that database design meets project requirements. Test and automate database scripts and procedures to ensure data integrity and performance. Requirements: Experience in Insurance Domains is preferred. Experience in managing risk data (internal audit, Compliance, ER, ORM etc.) is preferred. Strong experience in SQL Server DBA, including database design, development, maintenance, and optimization. Expertise in Microsoft Full Stack technologies, including C#, .NET,ASP.NET, MVC, and Web API. Experience with data migration, ETL, and integration services, such as SSIS and Azure Data Factory. Experience with reporting services, such as SSRS, Power BI for creating visualizations and reports. Strong skills in data analysis, data quality, and data modeling, using tools such as Excel, Power BI, and ER/Studio. Knowledge of test automation tools and techniques for SQL DB. Excellent communication skills and ability to work collaboratively with a diverse team.

Job Description Title: Senior Data Scientist Experience: 10-15 years Location: NYC, NY Work Mode: Hybrid Must Have skills: ML, AI, LLM, NLP (Preferably from HealthCare Background) Required Skills: <ul><li>Proficiency in Python and ML/AI Libraries.</li><li>Good experience in LLM, NLP and Computer Vision specialization.</li><li>Familiar and hands-on with industry-leading AI/ML tools and architecture.</li><li>Should have experience integrating or working with Snowflake hosted in AWS.</li><li>Hands-on MLOps setups and executing.</li></ul> Responsibilities: <ul><li>Data Analysis: Collect, clean, and pre-process data from various sources to build datasets for analysis.</li><li>Machine Learning: Develop and implement machine learning algorithms and models for predictive and prescriptive analytics.</li><li>Statistical Analysis: Apply statistical techniques to interpret data, test hypotheses, and identify trends.</li><li>Data Visualization: Create compelling data visualizations and reports to communicate findings to non-technical stakeholders.</li><li>Feature Engineering: Identify and engineer relevant features for machine learning models.</li><li>Model Evaluation: Evaluate model performance, make improvements, and iterate on model development.</li><li>Data Insights: Provide actionable insights and recommendations based on data analysis.</li><li>Collaboration: Collaborate with cross-functional teams to integrate data-driven solutions into business processes.</li></ul>

Indium Software Interview Questions

Indium Software Interview Guides

Indium Software Interview Questions

Indium Software Salaries by Position

Indium Software Opening Jobs