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

The hershey company Business Intelligence Interview Guide

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


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

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

Overview

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

The hershey company Business Intelligence Interview Process

<p>Suppose your company needs to cut costs due to an economic downturn. During a coffee break, you hear a rumor that a lot of money goes to employees who don’t do their work, and you decide to find out if the rumor is true.</p>

<p>Given two tables: <code>employees</code> and <code>projects</code>, find the sum of the salaries of all the employees who didn’t complete any of their projects.</p>

<p>Clarification:</p>

<p>We will consider a project unfinished if it has no end date (its <code>End_dt</code> is <code>NULL</code>).</p>

<p>Given this, we’ll say an employee didn’t finish any of their projects when:</p>

<ul>
<li>They were assigned at least one project.</li>
<li>None of their projects have an <code>End_dt</code>.</li>
</ul>

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

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

<p><code>employees</code> table</p>

<table>
<thead>
<tr>
<th>id</th>
<th>salary</th>
</tr>
</thead>

<tbody>
<tr>
<td>INTEGER</td>
<td>FLOAT</td>
</tr>
</tbody>
</table>
<p><code>projects</code> table</p>

<table>
<thead>
<tr>
<th>employee_id</th>
<th>project_id</th>
<th>Start_dt</th>
<th>End_dt</th>
</tr>
</thead>

<tbody>
<tr>
<td>INTEGER</td>
<td>INTEGER</td>
<td>DATETIME</td>
<td>DATETIME</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

<table>
<thead>
<tr>
<th>total_slack_salary</th>
</tr>
</thead>

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


Find the total salary of slacking employees.

Slacking Employees Salaries

<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

<p>You have been given a table <code>tbl_numbers</code> with only one column: <code>int_numbers</code>.  It can have one integer number value per row in a sequential manner.</p>

<p>Write a query to return the number repeated by one times its own value.</p>

<p>For example, the integer number 5 would appear five times in the output (1 times 5).</p>

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

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

<p><code>tbl_numbers</code> table</p>

<table>
<thead>
<tr>
<th>int_numbers</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>1</code></td>
</tr>

<tr>
<td><code>2</code></td>
</tr>

<tr>
<td><code>3</code></td>
</tr>

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

<table>
<thead>
<tr>
<th>seq_numbers</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>1</code></td>
</tr>

<tr>
<td><code>2</code></td>
</tr>

<tr>
<td><code>2</code></td>
</tr>

<tr>
<td><code>3</code></td>
</tr>

<tr>
<td><code>3</code></td>
</tr>

<tr>
<td><code>3</code></td>
</tr>

<tr>
<td><code>4</code></td>
</tr>

<tr>
<td><code>4</code></td>
</tr>

<tr>
<td><code>4</code></td>
</tr>

<tr>
<td><code>4</code></td>
</tr>
</tbody>
</table>


Sequentially Fill in Integers

The hershey company Business Intelligence Interview Questions

Job Location: Technical Center
Pay Level: 1A
This position will be posted internally until the close of business on 06/13/25.
Summary:
The Sr. Data Engineer, OT Digital Systems, works closely with cross functional teams in engineering and Information Technology. This resource helps implement digital and data manufacturing solutions in support of the Hershey Digital Factory initiative. The successful candidate works with project teams to implement systems and deliver measurable value for Hershey. Reporting to the Senior Manager, OT Digital Systems, this individual helps ensure solutions and their delivery align with Hershey’s Digital Factory Strategy.
Specific Role Focus Areas:
Executes digital and data solutions across Hershey’s manufacturing sites.
Uses high-level understanding of plant processes and procedures to develop and execute supporting digital systems.
Effectively communicates across all levels and disciplines of the organization.
Understands both industry and business standards in executing optimal solutions.
Interactions and Partnerships:
Information Technology
Operational Technology
Environment, Health, and Safety
Supply Chain Quality
Continuous Improvement
Other key stakeholders and leadership teams, including Quality and Regulatory Compliance, Procurement, Marketing, Operations Business Development, Manufacturing Alliances, Supply Planning and Production Planning
External vendors, contractors, and engineering firms
Travel Expectations:
Sr. Data Engineer travels as needed to fulfill job duties including international and domestic supply chain network sites.
Scope of Responsibility:
Capital Project Execution:
Leads the execution of digital and data systems and solutions (cost estimates, feasibility, interpretation of requirements specifications and recommendations).
Participates in the development of the business case, technical feasibility, and plan for customer (plant) acceptance.
Uses engineering knowledge, judgment, creativity, and experience to execute highly technical IT/OT digital data initiatives.
Establishes new procedures and technologies, identifying new industry trends with a continuous improvement mindset.
Provides leadership and expertise in support of projects utilizing the AVEVA PI and HiveMQ software suites.
Serves as a digital data subject matter expert for capital projects.
Innovation:
Identifies opportunities to drive the delivery, knowledge transfer and value generation of the digital manufacturing suite of applications.
Provides guidance to project teams and internal and external technical resources to assess opportunities for application of innovative designs, performance improvements, technical advantages, speed to market and capital efficiencies, while achieving optimum business value.
Exhibits sound judgment and effective analysis of emerging technologies
Business Knowledge:
Experienced and competent in process controls, digital technologies and automation systems, manufacturing execution system (MES), connected worker platforms (CW), Unified Namespace architecture, and integration techniques with other IT and OT Systems.
Uses knowledge to execute digital solutions and tactical plans for system implementation.
Applies technical and operational understanding to identify effective and economical digital solutions.
Able to implement projects in support of the strategic plan to establish digital data systems as a standard for continuous improvement within the manufacturing network.
Develops digital data systems strategies that deliver enhanced supply chain capabilities.
Demonstrates proficiency and knowledge of complex food industry manufacturing (or the equivalent), to include good manufacturing practices.
Serves as subject matter expert with suppliers to ensure alignment with Hershey strategies and standards.
Leadership and Development:
Practices personal and team accountability for the development and enforcement of our digital and automation solutions standards and best practices
Recognized as a subject matter expert with supplier companies, Hershey teammates and engineering disciplines.
Is a leader in guiding the convergence of information technology and operational technology systems in support of the Digitally Integrated Manufacturing Stack of applications.
Minimum Qualifications:
Knowledge of:  Programming languages/scripting (C#, Python, R, SQL, Java, etc.)
Data warehousing platforms such as Snowflake, Databricks, etc.
Experience with ETL/ELT toolsets
Big data technologies such as Apache Hadoop, Spark, Kafka, etc.
Proficiency with cloud platforms such as AWS, Azure, etc.
Data modeling and architecture
Databases, relational and time-series
Analytics and reporting tools such as MS Power BI, Tableau
Industrial control system integration using open integration protocols OPC/MQTT
Unified Namespace Architecture, event driven architectures
Inductive Automation Ignition Platform
AVEVA PI Systems architecture including connectivity, asset framework management, client visualization tools.
HiveMQ MQTT Broker system architecture and configuration
Control system components and architecture systems (e.g., PLCs, Ethernet, Kepware OPC, MQTT, Microsoft Networking [TCP/IP], HMI/SCADA)
Software development methodologies, version control systems, automated testing techniques, change management

Working knowledge of:  Data strategy, governance, integration, historization and management
State-of-the-art control components and systems
Continuous integration tools and processes (e.g., Lean, Six Sigma)
SAP Systems

Preferred design and development experience includes:  Inductive Automation Ignition: Plan and drive system specification, design, architecture, and development.
Database: Design of data strategy for manufacturing, quality, and business enterprise systems
AVEVA PI: Develop and define data structures / guide UI development.
Unified Namespace: HiveMQ broker configuration

Minimum Requirements and Education:
Bachelor of Science in Electrical Engineering, Electrical Engineering Technology, Information Technology, or other closely related field of study
5years’ experience leading and designing digital data systems

#J-18808-Ljbffr

Question	Topic	Difficulty	Ask Chance
Slacking Employees Salaries	SQL	Medium	Very High
Player Analysis	SQL	Easy	Very High
Sequentially Fill in Integers	SQL	Hard	Very High

The hershey company Business Intelligence Interview Guide

Overview

The hershey company Business Intelligence Interview Process

The hershey company Business Intelligence Interview Questions

The hershey company Business Intelligence Jobs