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

Catalent pharma Business Intelligence Interview Guide

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


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

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

Overview

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

Catalent pharma 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 show the number of users, number of transactions placed, and total order amount per month in the year 2020. Assume that we are only interested in the monthly reports for a single year (January-December).</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>products</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>

<tr>
<td><code>price</code></td>
<td>FLOAT</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>

<tr>
<td><code>sex</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>month</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>num_customers</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>num_orders</code></td>
<td>INTEGER</td>
</tr>

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


Monthly Customer Report

<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

Catalent pharma Business Intelligence Interview Questions

<p>**QA Product Manager**</p><p>**Position Summary**</p><p>St. Petersburg is our primary soft gel development and manufacturing facility in North America with capacity of 18 billion capsules per year.  Within the Catalent network, we offer a broad range of integrated formulation and analytical services to solve difficult development and manufacturing challenges. Catalent is committed to a Patient First culture through excellence in quality and compliance, and to the safety of every patient, consumer and Catalent employee.</p><p>The QA Product Manager provides customer service, with the highest integrity, focused on quality and compliance with partnership with Catalent St. Petersburg's customers and internal organizations. This position serves as a representative for their clients within the Catalent St. Petersburg site. The QA Product Manager is responsible for the overall Quality Assurance review and approval of all technical documents including but not limited to: a) change controls and associated Master documents, including but not limited to MERs and material Specifications; Product specifications; Test methods; Master Batch Records; Master Shipper Labels; all equipment IQ/OQ/PQ documents regarding equipment, utilities, and computer systems; b) process improvement projects and Product Development Projects; c) all product process validation and cleaning validation documents; d) all Preventive Maintenance and Calibration work order requirements for critical systems.</p><p>**The Role**</p><p>+ Primary quality liaison for clients and internal customers. Is expected to become the Subject Matter Expert for the client products, processes and requirements.</p><p>+ Responsible for maintaining, developing, and nurturing the client partnership to ensure alignment and consensus.</p><p>+ Effective coordination of functions across the site and with clients to drive timely review, approval, and closure of investigations, change controls, audit tasks, corrections, and effectiveness checks.</p><p>+ Generate quality metrics, trackers, and reports for management and clients to characterize the health of the client relationship and state of quality systems</p><p>+ Provide QA Technical recommendations based on trend analysis to eliminate future problems.</p><p>+ Participates in Product Development/Validation/Engineering project meetings to provide Quality Assurance input with respect to compliance to cGMP requirements.</p><p>+ Provides feedback to the appropriate department (i.e. regarding the compliance and adequacy of the documents reviewed as it pertains to cGMPs, site SOPs, and FDA/MCA regulatory guidelines).</p><p>+ Provide support to internal, client, and regulatory audits.</p><p>+ Engage in monitoring quality systems to maintain awareness and audit/inspection readiness at all times.</p><p>+ All other duties as assigned.</p><p>**The Candidate**</p><p>+ Bachelor's Degree in Science (Chemistry, Microbiology or Biology preferred) required with a minimum of five years of related experience and/or training and/or equivalent combination of education and experience in the QA pharmaceutical industries.</p><p>+ Prior experience working with validation, manufacturing or product development preferred.</p><p>+ Proven ability to multi-task and demonstrate diplomatic skills.</p><p>+ Must possess excellent English verbal and written communication skills.</p><p>+ Intermediate to proficient skills in Microsoft Office applications.</p><p>+ Prior quality assurance experience is required.</p><p>+ Working knowledge of cGMPs and/or OSHA regulations required.</p><p>+ Certified Quality Engineer is a plus.</p><p>+ Excellent oral and written communication skills a must.</p><p>+ Proficient in Microsoft Word, Excel, Access and Power Point.</p><p>+ Ability to speak effectively and present before groups within the organization.</p><p>+ Ability to review and evaluate technical documents and determine impact to processes and systems in place.</p><p>+ Ability to work effectively under pressure to meet deadlines. Individual may be required to sit, stand, walk regularly and occasionally lift to 15 pounds; no lifting greater than 44.09 pounds without assistance. Be accessible to manufacturing floor and office staff and to use required office equipment. Specific vision requirements include reading of written documents and use of computer monitor screen frequently.</p><p>**Why You Should Join Catalent**</p><p>+ Competitive medical benefits and 401K</p><p>+ 152 hours of PTO + 8 Paid Holidays</p><p>+ Dynamic, fast-paced work environment</p><p>+ Opportunity to work on Continuous Improvement Processes</p><p>**Catalent offers rewarding opportunities to further your career!**   Join the global drug development and delivery leader and help us bring over 7,000 life-saving and life-enhancing products to patients around the world. Catalent is an exciting and growing international company where employees work directly with pharma, biopharma and consumer health companies of all sizes to advance new medicines from early development to clinical trials and to the market. Catalent produces more than 70 billion doses per year, and each one will be used by someone who is counting on us. Join us in making a difference.</p><p>personal initiative. dynamic pace. meaningful work.</p><p>Visit Catalent Careers (https://careers.catalent.com/us/en)  to explore career opportunities.</p><p>Catalent is an Equal Opportunity Employer, including disability and veterans.</p><p>If you require reasonable accommodation for any part of the application or hiring process due to a disability, you may submit your request by sending an email, and confirming your request for an accommodation and include the job number, title and location to  DisabilityAccommodations@catalent.com . This option is reserved for individuals who require accommodation due to a disability. Information received will be processed by a U.S. Catalent employee and then routed to a local recruiter who will provide assistance to ensure appropriate consideration in the application or hiring process.</p><p>Notice to Agency and Search Firm Representatives: Catalent Pharma Solutions (Catalent) is not accepting unsolicited resumes from agencies and/or search firms for this job posting. Resumes submitted to any Catalent employee by a third party agency and/or search firm without a valid written & signed search agreement, will become the sole property of Catalent. No fee will be paid if a candidate is hired for this position as a result of an unsolicited agency or search firm referral. Thank you.</p><p>Important Security Notice to U.S. Job Seekers:</p><p>Catalent NEVER asks candidates to provide any type of payment, bank details, photocopies of identification, social security number or other highly sensitive personal information during the offer process, and we NEVER do so via email or social media. If you receive any such request, DO NOT respond- it is a fraudulent request. Please forward such requests to spam@catalent.com for us to investigate with local authorities.</p><p>California Job Seekers can find our California Job Applicant Notice HERE (https://cdn.catalent.com/files/legal/CCPA-Privacy-Notice-at-Collection-for-California-Employees-and-Applicants-English.pdf) .</p>

Catalent pharma Business Intelligence Interview Guide

Overview

Catalent pharma Business Intelligence Salary

Catalent pharma Business Intelligence Interview Process

Catalent pharma Business Intelligence Interview Questions

Catalent pharma Business Intelligence Jobs