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

Brillio Business Intelligence Interview Guide

<p>Getting ready for an Business Intelligence interview at Brillio? The Brillio 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 Brillio Business Intelligence roles.</li>
<li>Gain insights into the Business Intelligence interview process at Brillio.</li>
<li>Practice real Brillio 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 Brillio Business Intelligence interview.</p>


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

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

Overview

Brillio 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.

Brillio 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 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

<p>You’ve been asked to analyze the player’s behaviors at a gaming company.</p>

<p>Write a query to get the number of players who played between 5 and 10 games (5 and 10 excluded), and the number of players who played 10 games or more.</p>

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

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

<p><strong><code>players</code></strong> table</p>

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

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

<tr>
<td>name</td>
<td>VARCHAR</td>
</tr>

<tr>
<td>games_played</td>
<td>INTEGER</td>
</tr>

<tr>
<td>registered_at</td>
<td>TIMESTAMP</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

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

<tbody>
<tr>
<td>players_more_than_5_to_10_games</td>
<td>INTEGER</td>
</tr>

<tr>
<td>players_10_plus_games</td>
<td>INTEGER</td>
</tr>
</tbody>
</table>


Obtain count of players based on games played.

Player Analysis

Brillio Business Intelligence Interview Questions

<div>
<h3><b>Product Manager - R01542853</b></h3>
<div>
<b>About Brillio:<br/> </b>
</div>
<br/>
<div>
  Brillio is one of the fastest growing digital technology service providers and a partner of choice for many Fortune 1000 companies seeking to turn disruption into a competitive advantage through innovative digital adoption. Brillio, renowned for its world-class professionals, referred to as "Brillians", distinguishes itself through their capacity to seamlessly integrate cutting-edge digital and design thinking skills with an unwavering dedication to client satisfaction.
 </div>
<div>
  Brillio takes pride in its status as an employer of choice, consistently attracting the most exceptional and talented individuals due to its unwavering emphasis on contemporary, groundbreaking technologies, and exclusive digital projects. Brillio's relentless commitment to providing an exceptional experience to its Brillians and nurturing their full potential consistently garners them the Great Place to Work certification year after year.
 </div>
<div>
<b>Product Manager</b>
</div>
<h6><b>Primary Skills</b></h6>
<ul>
<li>CSPO</li>
</ul>
<h6><b>Specialization</b></h6>
<ul>
<li>Product Management: Software Development Engineer</li>
</ul>
<h6><b>Job requirements</b></h6>
<ul>
<li><b> Role: Product Owner/manager</b></li>
<li><b> Years of Experience: 10+ years</b></li>
<li><b> Travel Required: No</b></li>
<li><b> Location: remote</b></li>
<li><b> Job Description</b></li>
<li>As a Product Owner role within the Credit Administration group, you will be responsible for driving and developing end-to-end product roadmap for the Credit Reporting platforms and products, while ensuring timely delivery of features and functionality. The ideal candidate will possess a strong product management background, be steeped in Design Thinking, Lean UX, and agile delivery methodologies, and have a data-driven approach to decision making. Ideal candidates will have a background in credit data. This role will partner with stakeholders to identify business requirements, gaps in existing capabilities and defines opportunities to build technology products based on current and future application platforms that improve the business processes and accelerate critical business strategies. This Product Owner will be responsible for synthesizing requirements from the stakeholder into prioritized user stories, approving features that are in alignment with agreed upon acceptance criteria, and providing feedback to the team with a strong decision-making mindset. You will drive product delivery from inception until the solution enters production while also participating in standard Scrum activities including daily stand-ups, sprint planning, backlog refinement, sprint reviews, and sprint retrospectives.</li>
<li>Primary responsibilities include:</li>
<ul>
<li>Demonstrate prior experience in developing credit data mart and the technology infrastructure related for reporting & analytics.</li>
<li>Be a liaison for credit administration as it relates to data infrastructure with our stakeholders including Technology, Data team IT, credit reporting and other teams.</li>
<li>Partner with Credit Internal analytics to help build next gen reporting infrastructure that would advance self-service analytics capabilities.</li>
<li>Demonstrate an ability to collaborate with developers and data engineers to define the technology infrastructure and data architecture.</li>
<li>Possess a strong product management background, be steeped in Design Thinking, Lean UX, and agile delivery methodologies, and have a data-driven approach to decision making.</li>
<li>Develop and translate our high-level strategic vision into product roadmaps.</li>
<li>Understand user needs, identify the problem, and market opportunity, ideate solutions, prototype, and validate hypotheses.</li>
<li>Harness the power of a cross-functional team to take a product from concept to launch. From creating your product backlog and grooming features, to hardening code and shipping product, you will be empowered to define the future of your product.</li>
<li>Leverage data to unlock new experiences and new features that deliver the full potential of SVB to our clients.</li>
<li>Explore new approaches, methodologies, and technologies in an ever evolving and changing world.</li>
<li>Evangelize your products to internal stakeholders and clients.</li>
</ul>
</ul>
<div>
<b>Qualifications</b>
</div>
<ul>
<li>5+ years of Product management experience in managing cross-functional business systems initiatives/projects with a broad knowledge of the financial services systems.</li>
<li>Broad experience desired, in multiple domain areas, such as data warehousing, business intelligence (BI), data architecture, data integration.</li>
<li>Familiarity with databases, SQL querying is mandatory.</li>
<li>Familiarity with programming languages such as Python and visualization tools such as Tableau is preferred.</li>
<li>Bachelor’s degree in computer science, information systems or quantitative discipline, such as economics, finance, mathematics, or statistics.</li>
<li>Excellent interpersonal, communication, writing, and presentation skills.</li>
<li>Strong initiative, intellectual curiosity, ownership, and attention to detail.</li>
<li>Strong technical skills with a business acumen and ability to work across the organization to develop solutions to complex problems.</li>
<li>Strong understanding and working experience with design-thinking best practices to deliver industry-defining digital products and experiences.</li>
<li>Agile experience is mandatory.</li>
</ul>
<div>
<b>Equal Employment Opportunity Declaration</b>
</div>
<ul>
<li>Brillio is an equal opportunity employer to all, regardless of age, ancestry, colour, disability (mental and physical), exercising the right to family care and medical leave, gender, gender expression, gender identity, genetic information, marital status, medical condition, military or veteran status, national origin, political affiliation, race, religious creed, sex (includes pregnancy, childbirth, breastfeeding, and related medical conditions), and sexual orientation.</li>
</ul>
</div>
#J-18808-Ljbffr

<b>About Brillio: </b> <br><br>Brillio is one of the fastest growing digital technology service providers and a partner of choice for many Fortune 1000 companies seeking to turn disruption into a competitive advantage through innovative digital adoption. Brillio, renowned for its world-class professionals, referred to as "Brillians", distinguishes itself through their capacity to seamlessly integrate cutting-edge digital and design thinking skills with an unwavering dedication to client satisfaction. <br> <br>Brillio takes pride in its status as an employer of choice, consistently attracting the most exceptional and talented individuals due to its unwavering emphasis on contemporary, groundbreaking technologies, and exclusive digital projects. Brillio's relentless commitment to providing an exceptional experience to its Brillians and nurturing their full potential consistently garners them the Great Place to Work® certification year after year. <br><br><b>Data Scientist</b> <br><b>Primary Skills</b> <br><li>Hypothesis Testing, T-Test, Z-Test, Regression (Linear, Logistic), Python/PySpark, SAS/SPSS, Statistical analysis and computing, Probabilistic Graph Models, Great Expectation, Evidently AI, Forecasting (Exponential Smoothing, ARIMA, ARIMAX), Tools(KubeFlow, BentoML), Classification (Decision Trees, SVM), ML Frameworks (TensorFlow, PyTorch, Sci-Kit Learn, CNTK, Keras, MXNet), Distance (Hamming Distance, Euclidean Distance, Manhattan Distance), R/ R Studio </li><b>Specialization</b> <br><li>Data Science Advanced: Senior Data Scientist </li><b>Job requirements</b> <br><li>What you'll be doing... This candidate will perform analytics, create predictive models, apply machine learning techniques, and/or develop GenAI methods for high-visibility projects, as a member of a collaborative and open team that prides themselves on innovative solutions. </li> <li>The data scientist will explore information from multiple sources in order to gain maximum insight and provide a competitive advantage. </li> <li>The "data science" tasks may include statistical analyses, knowledge discovery, data mining, machine learning, and predictive modeling. </li><li>Responsibilities will include: - </li> <li>Performing data studies of new and diverse data sources. - Conducting statistical modeling and experiment design. </li> <li>Discovering "stories" told by the data and present them to peers, software developers, business analysts and business managers. </li> <li>Creating and validating predictive models and advanced algorithms; train AI and machine learning algorithms. </li><li>What are we looking for: You'll need to have: </li> <li>Bachelor's degree or four or more years of work experience. - Six or more years of analytics and data science experience. </li><li>Strong knowledge of programming and pattern recognition. </li> <li>Mastery of statistics, machine learning, algorithms, predictive modeling, and advanced mathematics. </li> <li>Knowledge of deep learning and GenAI techniques. </li> <li>Experience working with security data. </li> <li>Experience working with networking data. </li> <li>Experience using SQL (Structured Query Language) and other programming languages (R, C, Python) for statistical computing, graphics, and data mining. </li> <li>Experience with RDBMS, columnar, and NoSQL database technologies. </li> <li>Experience with Big Data and related tools such as Hadoop or Spark . </li><li>Familiarity with tools such as R, Rstudio, Python scipy and numpy, Jupyter notebook is desired. </li><li>Even better if you have one or more of the following: </li> <li>Advanced Degree in one of: Computer Science, Data Science, Physics (or other science), Engineering, or Mathematics/Statistics </li> <li>Strong critical thinking skills and the ability to relate them to Verizon business processes and operations. </li> <li>Excellent verbal and written communication skills as well as the ability to bridge the gap between data science and business management. </li> <li>Ability to collaborate with business units, IT, and data scientists across the enterprise to support descriptive and predictive analytics processes. - </li><li>Strong exploratory analysis skills and ability to think and research creatively. </li><li>#LI-PA1 </li> <li>Equal Employment Opportunity Declaration Brillio is an equal opportunity employer to all, regardless of age, ancestry, colour, disability (mental and physical), exercising the right to family care and medical leave, gender, gender expression, gender identity, genetic information, marital status, medical condition, military or veteran status, national origin, political affiliation, race, religious creed, sex (includes pregnancy, childbirth, breastfeeding, and related medical conditions), and sexual orientation. </li> <br><br>Know what it's like to work and grow at Brillio: Click here <br><br><b>Salary: 70-80 USD per-hour-wage</b>

<ul><li>Minimum 2 - 5 years of experience in Salesforce Commerce Cloud domain.</li><li>Carryout the development and implementation of Progressive Web Applications (PWA) on the Salesforce Commerce Cloud platform.</li><li>Collaborate with designers and architects to translate business requirements and design concepts into functional and visually appealing user interfaces.</li><li>Optimization, performance tuning, and scalability to ensure a seamless user experience across devices.</li><li>Conduct code reviews and provide guidance to junior developers to maintain code quality and adhere to coding standards.</li><li>Stay up to date with the latest trends and advancements in SFCC and PWA development, and proactively recommend innovative solutions to enhance the platform.</li><li>Salesforce Commerce Cloud Developer certification is a plus.</li></ul><p></p>

Brillio Business Intelligence Interview Guide

Overview

Brillio Business Intelligence Salary

Brillio Business Intelligence Interview Process

Brillio Business Intelligence Interview Questions

Brillio Business Intelligence Jobs