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

Impetus Business Intelligence Interview Guide

Getting ready for an Business Intelligence interview at Impetus? The Impetus Business Intelligence interview span across 10 to 12 different question topics. In preparing for the interview:
<ul>
<li>Know what skills are necessary for Impetus Business Intelligence roles.</li>
<li>Gain insights into the Business Intelligence interview process at Impetus.</li>
<li>Practice real Impetus Business Intelligence interview questions.</li>
</ul>
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 Impetus Business Intelligence interview.


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

- Know what skills are necessary for Impetus Business Intelligence roles.
- Gain insights into the Business Intelligence interview process at Impetus.
- Practice real Impetus 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 Impetus Business Intelligence interview.
        

Overview

Impetus Business Intelligence Salary

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

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

Impetus Business Intelligence Interview Process

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.

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

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

Example:

Input:

<code>bank_transactions</code> table

<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>
Output:

<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

Write a query to identify the manager with the biggest team size.

You may assume there is only one manager with the largest team size.

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

<tr>
<td><code>manager_id</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<code>managers</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>name</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>team</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>
Output:

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

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

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

Manager Team Sizes

Let’s say you’re working for a social media company trying to grow your user base. You know that people tend to use the same social network as their peers, so you want to target all your growth and marketing efforts on specific age groups so as to take advantage of network effects.

You wish to begin with the age group that is currently generating the most connections (fastest growing).

Write a SQL query to find the average number of accepted friend requests for each age group and order the results in descending order.

Note: The average number of accepted friend requests is calculated as the total number of friend requests sent by an age group that was accepted divided by the number of members in said age group.

We can assume the tables hold valid data in that there are no duplicate friend requests, friend requests are only accepted once, and user A can only accept a friend request from User B after B sends A a friend request.

The result should be rounded to two decimal places.

<h3>Example:</h3>

Input:

<code>friend_requests</code>

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

<tbody>
<tr>
<td>requester_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>receiver_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>sent_at</td>
<td>DATETIME</td>
</tr>
</tbody>
</table>
<code>requests_accepted</code>

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

<tbody>
<tr>
<td>accepter_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>requester_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>accepted_at</td>
<td>DATETIME</td>
</tr>
</tbody>
</table>
<code>age_groups</code>

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

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

<tr>
<td>age_group</td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>
Output:

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

<tbody>
<tr>
<td>age_group</td>
<td>VARCHAR</td>
</tr>

<tr>
<td>average_acceptance</td>
<td>FLOAT</td>
</tr>
</tbody>
</table>

Find the average number of accepted friend requests for each age group that sent the requests.

Avg Friend Requests By Age Group

Impetus Business Intelligence Interview Questions

The ideal candidate is a self-motivated, multi-tasker, and demonstrated team-player. You will be a lead developer responsible for the development of new software products and enhancements to existing products. You should excel in working with large-scale applications and frameworks and have outstanding communication and leadership skills. Responsibilities<ul><li>Should have strong experience in Java, Core Java, spring core, Spring boot, Rest API , Microservices, SQL.</li><li>Should know executor services and completable futures, parallel stream API</li><li>Should be good in , Design pattern, SQL Queries, Collections & in singleton, Junit & etc. </li><li>Should know HashMap synchronized</li><li>Should know component & swagger</li><li>Should know Solid principals </li><li>Should be Well versed with CICD, Agile processes . good attitude, good communication skills.</li><li>Should be good in Kafka or in AWS</li><li>Should be able to do client communication independently</li><li>Should be ready and flexible to work from Impetus office and customer office as per the requirement of project.</li><li>Should be able to handle team also if needed. </li></ul> If you are Interested, please share your resume along with below details - Experience -CTC-Expected-NP-Location Preference - Gurgaon/Bangalore

About Impetus Impetus Technologies is a digital engineering company focused on delivering expert services and products to help enterprises achieve their transformation goals. We solve the analytics, AI, and cloud puzzle, enabling businesses to drive unmatched innovation and growth.Founded in 1991, we are cloud and data engineering leaders providing solutions to fortune 100 enterprises, headquartered in Los Gatos, California, with development centers in NOIDA, Indore, Gurugram, Bengaluru, Pune, and Hyderabad with over 3000 global team members. We also have office in Canada and collaborate with a number of established companies, including American Express, Bank of America, Capital One, Toyota, United Airlines, and Verizon. Location- Noida, Gurgaon, Bangalore, Indore Job Description <ul><li>4-10 years of good hands on exposure with Big Data technologies – pySpark (Data frame and SparkSQL), Hadoop, and Hive</li><li>Good hands on experience of python and Bash Scripts</li><li>Good understanding of SQL and data warehouse concepts</li><li>Strong analytical, problem-solving, data analysis and research skills</li><li>Demonstrable ability to think outside of the box and not be dependent on readily available tools</li><li>Excellent communication, presentation and interpersonal skills are a must</li></ul>Good to have:<ul><li>Hands-on experience with using Cloud Platform provided Big Data technologies (i.e. IAM, Glue, EMR, RedShift, S3, Kinesis)</li><li>Orchestration with Airflow and Any job scheduler experience</li><li>Experience in migrating workload from on-premise to cloud and cloud to cloud migrations</li></ul> Roles & Responsibilities <ul><li>Develop efficient ETL pipelines as per business requirements, following the development standards and best practices.</li><li>Perform integration testing of different created pipeline in AWS env.</li><li>Provide estimates for development, testing & deployments on different env.</li><li>Participate in code peer reviews to ensure our applications comply with best practices.</li><li>Create cost effective AWS pipeline with required AWS services i.e S3,IAM, Glue, EMR, Redshift etc.</li></ul>

About Impetus Impetus Technologies is a digital engineering company focused on delivering expert services and products to help enterprises achieve their transformation goals. We solve the analytics, AI, and cloud puzzle, enabling businesses to drive unmatched innovation and growth.Founded in 1991, we are cloud and data engineering leaders providing solutions to fortune 100 enterprises, headquartered in Los Gatos, California, with development centers in NOIDA, Indore, Gurugram, Bengaluru, Pune, and Hyderabad with over 3000 global team members. We also have offices in Canada and Australia and collaborate with a number of established companies, including American Express, Bank of America, Capital One, Toyota, United Airlines, and Verizon. Job Description: Years of Experience: 3.5-6yrsLocation: Bangalore/Gurgaon Skills: Java; J2EE; Spring; Spring Boot,Hibernate; API Key Responsibilities:3.5 - 6 years of experience in a Java 8 or later, Spring boot, Hibernate, SOAP WebservicesExperience in application design, software development, and testing, in an Agileenvironment.Experience with relational and NoSQL databasesExperience designing and developing REST APIs for high volume clients.Experience with continuous integration tools & container orchestration technologies(e.g. Docker and Kubernetes)Experience with version control systems like GitExperience working with asynchronous messaging systems like KafkaExperience with Atlassian software development and collaboration tools (JIRA,Confluence, etc.), a plus.Position requires a Bachelors degree in Computer Science, Engineering, or a relatedfield Preferred Additional:Experience working on JavaKnowledge of financial industryExperience with open-source frameworks is a plus -especially maintaining orcontributing to open-source projects!Ability to effectively communicate with internal and external business partners. Mandatory SkillsJava, Spring boot, Microservices

About Impetus Impetus Technologies is a digital engineering company focused on delivering expert services and products to help enterprises achieve their transformation goals. We solve the analytics, AI, and cloud puzzle, enabling businesses to drive unmatched innovation and growth.Founded in 1991, we are cloud and data engineering leaders providing solutions to fortune 100 enterprises, headquartered in Los Gatos, California, with development centers in NOIDA, Indore, Gurugram, Bengaluru, Pune, and Hyderabad with over 3000 global team members. We also have offices in Canada and Australia and collaborate with a number of established companies, including American Express, Bank of America, Capital One, Toyota, United Airlines, and Verizon. Job Role- Data Scientist Experience- 3.5+ years Locations- Indore, Bangalore, Pune, Gurgaon, Noida Job Description<ul><li>Hands on experience of working with LLM (Large Language Models) or LangChain and OpenAI in particular.</li><li>Implementing and fine tuning the AI- generated text prompts using LLMs (eg:-GPT4)</li><li>Skilled in AI-specific utilities like ChatGPT, Hugging Face Transformers, etc.</li><li>Ability to understand business requirements.</li><li>Usecase derivation and solution creation from structured/unstructured data</li><li>Story telling, Business communication and Documentation</li><li>Programming Skills – Python, Scikit-Learn, TensorFlow, PyTorch, Keras</li><li>Exploratory Data Analysis</li><li>Machine Learning and Deep Learning Algorithms</li><li>Model building, Hyperparameter tuning and Model performance metrics</li><li>MLOps, Data Pipeline, Data engineering</li><li>Statistics Knowledge (Probability Distributions, Hypothesis Testing)</li><li>Time series modeling, Forecasting, Image/Video Analytics, Natural Language Processing (NLP).</li><li>ML services from Clouds such as AWS, GCP, Azure and Databricks</li><li>Optional - Big Data -Basic knowledge on Spark, Hive</li></ul> Roles & ResponsibilitiesAcquire skills required for building Machine learning models and deploy them for production.Feature Engineering, EDA, Pipeline creation, Model training and hyperparameter tuning with structured and unstructured data sets.Develop Cloud based applications including LLM/GenAI and deploy them into production. QualificationDegree – Graduates/Postgraduate in CSE/IT or related field

Impetus Business Intelligence Interview Guide

Overview

Impetus Business Intelligence Salary

Impetus Business Intelligence Interview Process

Impetus Business Intelligence Interview Questions

Impetus Business Intelligence Jobs