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

Conviva Business Intelligence Interview Guide

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


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

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

Overview

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

Conviva 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>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.</p>

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

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

<p><em>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.</em></p>

<p><em>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.</em></p>

<p><em>The result should be rounded to two decimal places.</em></p>

<h3>Example:</h3>

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

<p><strong><code>friend_requests</code></strong></p>

<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>
<p><strong><code>requests_accepted</code></strong></p>

<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>
<p><strong><code>age_groups</code></strong></p>

<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>
<p><strong>Output:</strong></p>

<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

<p>What are the logistic and softmax functions? What is the difference between the two?</p>

<p>What makes them useful for use in logistic regression?</p>


<p>In logistic regression, how is the predicted class determined based on the logistic function?</p>


In logistic regression, how is the predicted class determined based on the logistic function?

Softmax vs Logistic II

<p>What is the key characteristic of the logistic function that makes it useful for mapping continuous values to a probability?</p>


What is the key characteristic of the logistic function that makes it useful for mapping continuous values to a probability?

Softmax vs Logistic I

What are the logistic and softmax functions? What is the difference between the two?

Softmax vs Logistic

Conviva Business Intelligence Interview Questions

<strong>Conviva is the first and best place to go to understand and optimize digital customer experiences. Our Operational Data Platform harnesses full-census, comprehensive client-side telemetry-capturing every aspect of customer experience and engagement across all devices and linking them to the performance of underlying services, in real time and at a fraction of the cost of alternative solutions. Trusted by industry leaders like Disney, NBC, and the NFL, Conviva revolutionizes how businesses understand customer experience and engagement, maximizing satisfaction, conversion, and revenue.</strong><br><br>As Conviva continues to grow, we are actively looking for highly motivated and talented distributed software engineers at all levels to join our dynamic backend development teams. You will work with some of the best engineers in building various portions of a large end to end, distributed real time streaming data processing platform in handling internet scale massive amount data in real time. At more senior levels, you will lead technology innovation, collaborating across teams, setting technical standards, and steering the overall architectural framework.<br><br><strong>What Success Will Look Like: </strong><br><ul><li>Design the next generation real-time big data processing, storage and analytics engine for stateful metrics, emphasizing scalable, reliable and cost-effective solutions for low latency queries across diverse domains. </li><li>Design, build, maintain and improve a range of algorithms and their underlying systems.</li><li>Lead critical technical decisions collaboratively, guiding and training team members to tackle engineering challenges.</li><li>Design and deploy ETL pipelines using various open-source frameworks, ensuring robustness and scalability.</li><li>Foster a positive team culture, promoting code quality, driving initiatives, and ensuring impeccable execution. </li><li>Stay current with industry trends and emerging technologies in distributed database systems and stream processing frameworks. </li></ul><br><br><strong>Who You Are & What You've Done:</strong> <br><ul><li>Solid foundation in computer science, computer engineering or related fields. </li><li>Strong programming skills in C++, Rust, Scala, Java or similar language. </li><li>5-6+ years of industry experience in software development using modern software development processes, tool chains and infrastructure. </li><li>Proficiency in major distributed stream processing frameworks, such as Akka Streams, Apache Spark, Apache Flink and others. </li><li>Hands-on development experience with query engines or distributed database systems, such as ClickHouse, Apache Druid, Presto, BigQuery and others. </li><li>Experience in performance tuning, analysis over distributed systems. </li><li>Experience building massively scalable data infrastructure using commercial and open-source tools. </li><li>Highly motivated, passionate about technology, eager to learn, and proving ability to learn and master fast pacing innovative technologies. </li><li>Demonstrate effective collaboration within teams while being open to receiving feedback, embracing a learning mindset, and actively supporting others. </li><li>Adaptable to ambiguity and comfortable in a fast-paced work environment. </li></ul><br><br><strong>Preferred:</strong><br><ul><li>Experience in a SaaS space</li><li>Track record of contributing to open-source projects</li></ul><br><br>The expected salary range for this full-time position is $160,000 - $200,000 + equity + benefits. Compensation is determined by numerous factors such as your qualifications, experience, relevant education or training, and work location.<br><br><strong>Privately held, Conviva is headquartered in Silicon Valley, California with offices and people around the globe. For more information, visit us at www.conviva.com. Join us to help extend our leadership position in big data streaming analytics to new audiences and markets! </strong>

Conviva is the first and best place to go to understand and optimize digital customer experiences. Our Operational Data Platform harnesses full-census, comprehensive client-side telemetry-capturing every aspect of customer experience and engagement across all devices and linking them to the performance of underlying services, in real time and at a fraction of the cost of alternative solutions. Trusted by industry leaders like Disney, NBC, and the NFL, Conviva revolutionizes how businesses understand customer experience and engagement, maximizing satisfaction, conversion, and revenue.<br/><br/>As Conviva continues to grow, we are actively looking for highly motivated and talented distributed software engineers at all levels to join our dynamic backend development teams. You will work with some of the best engineers in building various portions of a large end to end, distributed real time streaming data processing platform in handling internet scale massive amount data in real time. At more senior levels, you will lead technology innovation, collaborating across teams, setting technical standards, and steering the overall architectural framework.<br/><br/>What Success Will Look Like:
Design the next generation real-time big data processing, storage and analytics engine for stateful metrics, emphasizing scalable, reliable and cost-effective solutions for low latency queries across diverse domains.
Design, build, maintain and improve a range of algorithms and their underlying systems.
Lead critical technical decisions collaboratively, guiding and training team members to tackle engineering challenges.
Design and deploy ETL pipelines using various open-source frameworks, ensuring robustness and scalability.
Foster a positive team culture, promoting code quality, driving initiatives, and ensuring impeccable execution.
Stay current with industry trends and emerging technologies in distributed database systems and stream processing frameworks.
Who You Are & What You've Done:<br/><br/>Solid foundation in computer science, computer engineering or related fields.
Strong programming skills in C++, Rust, Scala, Java or similar language.
5-6+ years of industry experience in software development using modern software development processes, tool chains and infrastructure.
Proficiency in major distributed stream processing frameworks, such as Akka Streams, Apache Spark, Apache Flink and others.
Hands-on development experience with query engines or distributed database systems, such as ClickHouse, Apache Druid, Presto, BigQuery and others.
Experience in performance tuning, analysis over distributed systems.
Experience building massively scalable data infrastructure using commercial and open-source tools.
Highly motivated, passionate about technology, eager to learn, and proving ability to learn and master fast pacing innovative technologies.
Demonstrate effective collaboration within teams while being open to receiving feedback, embracing a learning mindset, and actively supporting others.
Adaptable to ambiguity and comfortable in a fast-paced work environment.
Preferred:<br/><br/>Experience in a SaaS space
Track record of contributing to open-source projects<br/><br/>The expected salary range for this full-time position is $160,000 - $200,000 + equity + benefits. Compensation is determined by numerous factors such as your qualifications, experience, relevant education or training, and work location.<br/><br/>Privately held, Conviva is headquartered in Silicon Valley, California with offices and people around the globe. For more information, visit us at www.conviva.com. Join us to help extend our leadership position in big data streaming analytics to new audiences and markets!

<strong>Conviva is the first and best place to go to understand and optimize digital customer experiences. Our Operational Data Platform harnesses full-census, comprehensive client-side telemetry-capturing every aspect of customer experience and engagement across all devices and linking them to the performance of underlying services, in real time and at a fraction of the cost of alternative solutions. Trusted by industry leaders like Disney, NBC, and the NFL, Conviva revolutionizes how businesses underst and customer experience and engagement, maximizing satisfaction, conversion, and revenue.ue.</strong><br><br>As Conviva continues to grow, we are actively looking for highly motivated and talented distributed systems engineers at all levels to join our dynamic backend development teams. You will work with some of the best engineers in building our distributed real-time streaming platform for processing, indexing and querying internet scale data. At more senior levels, you will lead technology innovations, collaborating across teams to set technical standards and steer the overall architectural framework.<br><br><strong>What Success Will Look Like: </strong><br><ul><li>Design the next generation real-time big data processing, storage and analytics engine for stateful metrics, emphasizing scalable, reliable and cost-effective solutions for low latency queries across diverse domains. </li><li>Design, build, maintain and improve a range of algorithms and their underlying systems.</li><li>Lead critical technical decisions collaboratively, guiding and training team members to tackle engineering challenges.</li><li>Design and deploy ETL pipelines using various open-source frameworks, ensuring robustness and scalability.</li><li>Foster a positive team culture, promoting code quality, driving initiatives, and ensuring impeccable execution. </li><li>Stay current with industry trends and emerging technologies in distributed database systems and stream processing frameworks. </li></ul><br><br><strong>Who You Are & What You've Done:</strong> <br><ul><li>Solid foundation in computer science, computer engineering or related fields. </li><li>Strong programming skills in C++, Rust, Scala, Java or similar language. </li><li>8+ years of industry experience in software development using modern software development processes, tool chains and infrastructure. </li><li>Proficiency in major distributed stream processing frameworks, such as Akka Streams, Apache Spark, Apache Flink and others. </li><li>Hands-on development experience with query engines or distributed database systems, such as ClickHouse, Apache Druid, Presto, BigQuery and others. </li><li>Experience in performance tuning, analysis over distributed systems. </li><li>Experience building massively scalable data infrastructure using commercial and open-source tools. </li><li>Highly motivated, passionate about technology, eager to learn, and proving ability to learn and master fast pacing innovative technologies. </li><li>Demonstrate effective collaboration within teams while being open to receiving feedback, embracing a learning mindset, and actively supporting others. </li><li>Adaptable to ambiguity and comfortable in a fast-paced work environment </li></ul><br><br><ul><li>Track record of contributing to open-source projects </li></ul><br><br>The expected salary range for this full-time position is $220,000 - $270,000 + equity + benefits. Compensation is determined by numerous factors such as your qualifications, experience, relevant education or training, and work location.<br><br><strong>Privately held, Conviva is headquartered in Silicon Valley, California with offices and people around the globe. For more information, visit us at www.conviva.com. Join us to help extend our leadership position in big data streaming analytics to new audiences and markets! </strong>

Conviva is the first and best place to go to understand and optimize digital customer experiences. Our Operational Data Platform harnesses full-census, comprehensive client-side telemetry-capturing every aspect of customer experience and engagement across all devices and linking them to the performance of underlying services, in real time and at a fraction of the cost of alternative solutions. Trusted by industry leaders like Disney, NBC, and the NFL, Conviva revolutionizes how businesses underst and customer experience and engagement, maximizing satisfaction, conversion, and revenue.ue. <br><br>As Conviva continues to grow, we are actively looking for highly motivated and talented distributed systems engineers at all levels to join our dynamic backend development teams. You will work with some of the best engineers in building our distributed real-time streaming platform for processing, indexing and querying internet scale data. At more senior levels, you will lead technology innovations, collaborating across teams to set technical standards and steer the overall architectural framework. <br><br><strong>What Success Will Look Like: </strong> <br><ul> <li>Design the next generation real-time big data processing, storage and analytics engine for stateful metrics, emphasizing scalable, reliable and cost-effective solutions for low latency queries across diverse domains. </li> <li>Design, build, maintain and improve a range of algorithms and their underlying systems. </li><li>Lead critical technical decisions collaboratively, guiding and training team members to tackle engineering challenges. </li><li>Design and deploy ETL pipelines using various open-source frameworks, ensuring robustness and scalability. </li><li>Foster a positive team culture, promoting code quality, driving initiatives, and ensuring impeccable execution. </li> <li>Stay current with industry trends and emerging technologies in distributed database systems and stream processing frameworks. </li> </ul><strong>Who You Are & What You've Done:</strong> <ul><li>Solid foundation in computer science, computer engineering or related fields. </li> <li>Strong programming skills in C++, Rust, Scala, Java or similar language. </li> <li>8+ years of industry experience in software development using modern software development processes, tool chains and infrastructure. </li> <li>Proficiency in major distributed stream processing frameworks, such as Akka Streams, Apache Spark, Apache Flink and others. </li> <li>Hands-on development experience with query engines or distributed database systems, such as ClickHouse, Apache Druid, Presto, BigQuery and others. </li> <li>Experience in performance tuning, analysis over distributed systems. </li> <li>Experience building massively scalable data infrastructure using commercial and open-source tools. </li> <li>Highly motivated, passionate about technology, eager to learn, and proving ability to learn and master fast pacing innovative technologies. </li> <li>Demonstrate effective collaboration within teams while being open to receiving feedback, embracing a learning mindset, and actively supporting others. </li> <li>Adaptable to ambiguity and comfortable in a fast-paced work environment </li> </ul><ul> <li>Track record of contributing to open-source projects </li> </ul><br> <br>The expected salary range for this full-time position is $220,000 - $270,000 + equity + benefits. Compensation is determined by numerous factors such as your qualifications, experience, relevant education or training, and work location. <br><br>Privately held, Conviva is headquartered in Silicon Valley, California with offices and people around the globe. For more information, visit us at www.conviva.com. Join us to help extend our leadership position in big data streaming analytics to new audiences and markets!

Conviva Business Intelligence Interview Guide

Overview

Conviva Business Intelligence Salary

Conviva Business Intelligence Interview Process

Conviva Business Intelligence Interview Questions

Conviva Business Intelligence Jobs