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

Ciena Business Intelligence Interview Guide

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


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

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

Overview

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

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

<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

Ciena Business Intelligence Interview Questions

<b>Ciena is committed to our people-first philosophy. Our teams enjoy a culture focused on prioritizing a personalized and flexible work environment that empowers an individual's passions, growth, wellbeing and belonging. We're a technology company that leads with our humanity-driving our business priorities alongside meaningful social, community, and societal impact.</b><br><br><b>Why Ciena?</b><br><ul><li>We're a company <b>rooted in people</b>-seeking to create a <b>vibrant and inclusive environment</b>, where everyone feels they can belong.</li><li>Accelerate your career path by gaining <b>hands-on experience</b> and exposure to the latest technology. Our interns and graduates work on <b>real projects</b> in real time in world class labs. Be a part of tomorrow's future - today.</li><li><b>Mentoring. Networking. Leadership Opportunities</b>. We recognize that the learning doesn't stop when you leave school - we champion a team environment for development and provide the tools to achieve success.</li><li>We recognize the importance of <b>well-being</b> and offer programs and benefits to support and sustain the mental & physical health, and financial security, of our employees and their families.</li></ul><ul><li>We are big proponents of <b>life-work integration. </b>Our people make a big difference at Ciena, but we want to shine light on their differences outside of working hours too. CienaCares supports non-profit causes important to employees by matching employee financial contributions and dedicating time for volunteering.</li></ul><br><br><b>How You Will Contribute:</b><br><br>As a Dataplane Software Engineer, you will enhance Ciena's Packet Networking Service Aware Operating System (SAOS) to support new Cloud and Routing services, develop Netconf/YANG interfaces, and develop High Availability capabilities for the Packet Network Platforms. You will also provide guidance instrumental to the definition and design of new architectures and technologies needed to drive adoption of Ciena's Cloud and IP Routing related software products.<br><ul><li>You will develop C/C++ software for packet processing using DPDK underneath. </li><li>You will develop real-time embedded software components that interact with the software based fast path. </li><li>You will participate in all stages of software development, including requirements analysis, design, implementation, test, maintenance, and documentation </li><li>You will be responsible for troubleshooting software issues and work with software and system engineers to identify root cause. </li></ul><br><br><b>What Does Ciena Expect of You?</b><br><ul><li><b>Initiative -</b> you're a self-starter who works with limited direction and is committed to delivering against aggressive deadlines.</li><li>The flexibility to <b>work independently</b> with little supervision and thrive as <b>part of a broader team</b>.</li><li>You are a <b>problem-solver - </b>you use your creativity, analytical mind and problem-solving skills to achieve key business objectives.</li><li>You are a <b>succinct communicator</b> - possessing the ability to tailor your communications/messages based on the type and level of audience.</li><li>You're <b>change agile</b>- thriving in a diverse environment of ever-changing priorities and sometimes stressful situations.</li><li>You are <b>self-motivated</b> - always seeking out and methodically solving sophisticated technical issues.</li><li>A dedication to<b> ongoing learning</b> - not only related specifically to your role, but also to new technologies/market developments.</li></ul><br><br><b>The Must Haves:</b><br><ul><li>Bachelor's degree in Computer Engineering or equivalent coupled with expertise in at least one programming language, preferably C/C++ in a Linux environment.</li><li>Strong fundamental knowledge related to data structures and operating system. </li><li>Proven experience developing and debugging in Linux environment. </li><li>Familiarity with TCP/IP networking and basic understanding of a Broadband Network. </li></ul><br><br><b>Not ready to apply? Join our </b>Talent Community<b> to get relevant job alerts straight to your inbox.</b><br><br><b>At Ciena, we are committed to building and fostering an environment in which our employees feel respected, valued, and heard. Ciena values the diversity of its workforce and respects its employees as individuals. We do not tolerate any form of discrimination.</b><br><br><b>Ciena is an</b> <b>Equal Opportunity Employer, including disability and protected veteran status.</b><br><br><b>If contacted in relation to a job opportunity, please advise Ciena of any accommodation measures you may require.</b>

Ciena Business Intelligence Interview Guide

Overview

Ciena Business Intelligence Salary

Ciena Business Intelligence Interview Process

Ciena Business Intelligence Interview Questions

Ciena Business Intelligence Jobs