The Airgas Business Intelligence interview guide, interview questions, salary data, and interview experiences.

Airgas Business Intelligence Interview Guide

<p>Getting ready for an Business Intelligence interview at Airgas? The Airgas Business Intelligence interview span across 10 to 12 different question topics. In preparing for the interview:</p>
<ul>
<li>Know what skills are necessary for Airgas Business Intelligence roles.</li>
<li>Gain insights into the Business Intelligence interview process at Airgas.</li>
<li>Practice real Airgas Business Intelligence interview questions.</li>
</ul>
<p>Interview Query regularly analyzes interview experience data, and we've used that data to produce this guide, with sample interview questions and an overview of the Airgas Business Intelligence interview.</p>


Getting ready for an Business Intelligence interview at Airgas? The Airgas Business Intelligence interview span across 10 to 12 different question topics. In preparing for the interview:

- Know what skills are necessary for Airgas Business Intelligence roles.
- Gain insights into the Business Intelligence interview process at Airgas.
- Practice real Airgas Business Intelligence interview questions.

Interview Query regularly analyzes interview experience data, and we've used that data to produce this guide, with sample interview questions and an overview of the Airgas Business Intelligence interview.
        

Overview

Airgas Business Intelligence Salary

<p>We've gathered this data from parsing thousands of interview experiences sourced from members.</p>

We've gathered this data from parsing thousands of interview experiences sourced from members.

Airgas Business Intelligence Interview Process

<p>We’re given a table of bank transactions with three columns, <code>user_id</code>, a deposit or withdrawal value (determined if the value is positive or negative), and <code>created_at</code> time for each transaction.</p>

<p>Write a query to get the total three-day rolling average for deposits by day.</p>

<p><em>Note: Please use the format <code>&#39;%Y-%m-%d&#39;</code> for the date in the outout</em></p>

<p><strong>Example:</strong></p>

<p><strong>Input:</strong></p>

<p><code>bank_transactions</code> table</p>

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

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

<tr>
<td><code>created_at</code></td>
<td>DATETIME</td>
</tr>

<tr>
<td><code>transaction_value</code></td>
<td>FLOAT</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

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

<tbody>
<tr>
<td><code>dt</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>rolling_three_day</code></td>
<td>FLOAT</td>
</tr>
</tbody>
</table>


Rolling Bank Transactions

<p>Write a query to show the number of users, number of transactions placed, and total order amount per month in the year 2020. Assume that we are only interested in the monthly reports for a single year (January-December).</p>

<p><strong>Example:</strong></p>

<p><strong>Input:</strong></p>

<p><code>transactions</code> table</p>

<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>user_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>created_at</code></td>
<td>DATETIME</td>
</tr>

<tr>
<td><code>product_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>quantity</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<p><code>products</code> table</p>

<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>name</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>price</code></td>
<td>FLOAT</td>
</tr>
</tbody>
</table>
<p><code>users</code> table</p>

<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>name</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>sex</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

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

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

<tr>
<td><code>num_customers</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>num_orders</code></td>
<td>INTEGER</td>
</tr>

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


Monthly Customer Report

<p>Write a query to identify customers who placed more than three transactions each in both 2019 and 2020.</p>

<p><strong>Example:</strong></p>

<p><strong>Input:</strong></p>

<p><code>transactions</code> table</p>

<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>user_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>created_at</code></td>
<td>DATETIME</td>
</tr>

<tr>
<td><code>product_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>quantity</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<p><code>users</code> table</p>

<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>name</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>
<p> 
<strong>Output:</strong></p>

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

<tbody>
<tr>
<td><code>customer_name</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>


<p>Which of the following queries will return a list of customers and the total amount they have spent on orders?</p>


Which of the following queries will return a list of customers and the total amount they have spent on orders?

Customer Orders

Airgas Business Intelligence Interview Questions

<p>R10052897 Software Engineer Industrial Controls (Open) <br><br>Location: <br>Cheshire, CT (ASG) - Management <br><br><strong>How will you CONTRIBUTE and GROW?</strong> <br><br>Design and maintain control software used in chemical automation equipment. This will include programming, testing, and remote customer assistance in the deployment of solutions in the field. <br><br> </p><ul><li>Unwavering commitment to ensuring our systems are developed with safety as the 1st priority </li><li>Provide technical expertise for application development, system setup, and troubleshooting. </li><li>Planning/writing of programming code as necessary, to ensure the end product meets functional goals expected of the product on required schedules. </li><li>Provide on-site assistance during system start-up, commissioning and maintenance </li><li>Support the creation of technical product documentation and information </li><li>Report on project progress, update plans, and communicate changes to others </li><li>Collaborate with team members across various engineering disciplines to accomplish objectives </li><li>Resolve support issues with production systems promptly to maintain systems uptime </li><li>Travel up to 20% </li></ul><strong>Are you a MATCH?</strong><ul><li>1-3 years experience with C# and .NET programming is required </li><li>1-3 years experience with SQL databases such as PostgreSQL or MS SQL </li><li>1-3 years experience designing and developing user interfaces </li><li>WPF development experience desired </li><li>Experience consuming web APIs </li><li>Basic web development a plus </li><li>Git experience is a plus </li><li>Experience with LabVIEW and Modbus is a plus </li><li>Electrical experience is a plus </li><li>Basic thermodynamics knowledge a plus </li><li>Strong communications and organizational skills are required </li><li>Must be able to create and execute software validation plans </li></ul><b><b>EDUCATION and/or EXPERIENCE:</b></b> <ul> <li>BA/BS degree in computer science, computer engineering, or related field; equivalent experience will be considered </li><li>1-3 years programming experience required </li></ul> <br><br>We care about and support our Airgas Families. This is evident not only through our competitive compensation but also through a comprehensive benefits package that includes medical, dental, and vision plans, vacation, sick time, floating holidays, and paid holidays for full-time employees. <br> <br>We provide a progressive parental leave package for our eligible Airgas parents, offering generous paid time off for the birth or placement of children, including 14 weeks of paid child birth benefit for birth mothers on leave, as well as paid parental leave benefits for other associates. <br> <br>Additionally, we offer our employees a 401k plan with company matching funds, tuition reimbursement, discounted college tuition for employees' dependents, and an Airgas Scholarship Program for dependent children. <br><br><b>Your differences enhance our performance</b> <br><br>At Airgas, we are committed to building a diverse and inclusive workplace that embraces the diversity of our employees, our customers, patients, community stakeholders and cultures across the world. <br><br>We welcome and consider applications from all qualified applicants, regardless of their race, gender, sexual orientation, religion, disability or any other protected characteristic. We strongly believe a diverse organization opens up opportunities for people to express their talent, both individually and collectively and it helps foster our ability to innovate by living our fundamentals, acting for our success and creating an engaging environment in a changing world. <br><br><b>Equal Employment Opportunity Information</b> <br><br>We are an equal opportunity employer. We evaluate qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, or any other protected characteristic. <br> <br>Please click here to view the EEO Know Your Rights poster and here to view the Pay Transparency Nondiscrimination poster. Airgas, an Air Liquide Company invites any applicant and/or employee to review the Company's written Affirmative Action Plan or Policy Statement. This plan or policy statement is available for inspection upon request. <br><br>Airgas, an Air Liquide Company and its group of companies does not discriminate against qualified applicants with disabilities and is committed to providing reasonable accommodations to the known disabilities of such individuals so as to ensure equal access to benefits and privileges of employment. If you are an individual with a disability and would like to request a reasonable accommodation as part of the employment selection process, please contact us by email at us-accommodationrequest@airgas.com. <br><br>California Privacy Notice

Airgas Business Intelligence Interview Guide

Overview

Airgas Business Intelligence Salary

Airgas Business Intelligence Interview Process

Airgas Business Intelligence Interview Questions

Airgas Business Intelligence Jobs