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

Pgim Business Intelligence Interview Guide

Getting ready for an Business Intelligence interview at Pgim? The Pgim Business Intelligence interview span across 10 to 12 different question topics. In preparing for the interview:
<ul>
<li>Know what skills are necessary for Pgim Business Intelligence roles.</li>
<li>Gain insights into the Business Intelligence interview process at Pgim.</li>
<li>Practice real Pgim Business Intelligence interview questions.</li>
</ul>
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 Pgim Business Intelligence interview.


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

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

Overview

Pgim Business Intelligence Salary

We've gathered this data from parsing thousands of interview experiences sourced from members.

We've gathered this data from parsing thousands of interview experiences sourced from members.

Pgim Business Intelligence Interview Process

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.

Write a query to get the total three-day rolling average for deposits by day.

Note: Please use the format <code>&#39;%Y-%m-%d&#39;</code> for the date in the outout

Example:

Input:

<code>bank_transactions</code> table

<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>
Output:

<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

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

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.

Example:

Input:

<code>players</code> table

<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>
Output:

<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

Write a query to identify customers who placed more than three transactions each in both 2019 and 2020.

Example:

Input:

<code>transactions</code> table

<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>
<code>users</code> table

<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>
 
Output:

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

Which of the following queries will return a list of customers and the total amount they have spent on orders?

Which of the following queries will return a list of customers and the total amount they have spent on orders?

Customer Orders

Pgim Business Intelligence Interview Questions

Job Classification: Technology - Architecture PGIM Private Capital Specialist, Data Modeler As part of the Information Technology & Services team within PGIM Private Capital (PPC), we support PPC with both vendor and internally designed applications, processes, and reporting. We are looking for an astute, determined professional like you to fulfill a data modeler role on this team. You will showcase your success through collaboration, ownership, and innovation. Your knowledge in emerging trends and practices will evoke stimulating discussions around optimization and change to help keep our competitive edge. This rewarding opportunity will enable you to have an impact in our organization, so if this sounds exciting, then PGIM Private Capital might be the place. Your Impact: <ul><li>Owning and championing the design and operation of data models in Microsoft Fabric</li><li>Analyzing and translating business needs into long-term solution data models</li><li>Implementing data strategies and developing data models</li><li>Evaluating, maintaining, and documenting existing data systems for variances and efficiencies</li><li>Reviewing modifications of existing systems for cross-compatibility</li><li>Partnering with data engineering to implement, troubleshoot, and optimize data models</li><li>Following and suggesting standards and best practices for development</li></ul> Your Required Skills: <ul><li>Bachelor's degree in Computer Science, Engineering, or equivalent work experience</li><li>Relevant experience in the financial services industry</li><li>Minimum 3+ years of hands-on experience data modeling within Enterprise Data Warehouse (Data Vault 2.0 and data modeling tools like Erwin preferred)</li><li>Business Intelligence visualization tools such as Power BI/ Tableau is strongly preferred</li><li>Strong interpersonal and communication skills</li><li>Ability to stay current with rapidly changing technology and apply it to business needs</li></ul> The PGIM Private Capital Business: At PGIM Private Capital (PPC), expertise, analysis, and experience drive everything we do. We strategically target select global markets to offer unique deal flow to investors and prospective issuers. Our team is comprised of bright, focused professionals who collaborate at all levels to manage originations and a private debt portfolio across investment grade, high yield, and mezzanine investments. We invest in the potential of our employees by offering them large-scope, small-team emphasis on collaboration, and commitment to a healthy balance between a professional and personal life. We challenge you as an individual so you can make real contributions while you grow your capabilities. The PGIM Culture: PGIM is proud of its distinctive and inclusive culture, with a sound reputation for the pedigree and professionalism of its employees. PGIM has a feeling of quality and stability, but at the same time it is forward-thinking and evolutionary in its approach. Employees have a unique opportunity to build their career path by owning their development, their career and their future. As a result, staff turnover is particularly low, and leadership is dedicated to growing talent at all levels within the organization. Note: Prudential is required by state specific laws to include the salary range for this role when hiring a resident in applicable locations. The salary range for this role is from $100,000-$115,000 Specific pricing for the role may vary within the above range based on many factors including geographic location, candidate experience, and skills. Roles may also be eligible for additional compensation and/or benefits. Eligibility to participate in a discretionary annual incentive program is subject to the rules governing the program, whereby an award, if any, depends on various factors including, without limitation, individual and organizational performance. * To find out more about our Total Reward package, visit https://jobs.prudential.com/us-en/about/work-life #LI-MM1 What we offer you: <ul><li>Market competitive base salaries, with a yearly bonus potential at every level. </li></ul> <ul><li>Medical, dental, vision, life insurance, disability insurance, Paid Time Off (PTO), and leave of absences, such as parental and military leave. </li></ul> <ul><li>401(k) plan with company match (up to 4%).</li></ul> <ul><li>Company-funded pension plan.</li></ul> <ul><li>Wellness Programsincluding up to $1,600 a year for reimbursement of items purchased to support personal wellbeing needs.</li></ul> <ul><li>Work/Life Resources to help support topics such as parenting, housing, senior care, finances, pets, legal matters, education, emotional and mental health, and career development.</li></ul> <ul><li>Education Benefit to help finance traditional college enrollment toward obtaining an approved degree and many accredited certificate programs.</li></ul> <ul><li>Employee Stock Purchase Plan: Shares can be purchased at 85% of the lower of two prices (Beginning or End of the purchase period), after one year of service.</li></ul> Eligibility to participate in a discretionary annual incentive program is subject to the rules governing the program, whereby an award, if any, depends on various factors including, without limitation, individual and organizational performance. To find out more about our Total Rewards package, visit Work Life Balance | Prudential Careers. Some of the above benefits may not apply to part-time employees scheduled to work less than 20 hours per week. Prudential Financial, Inc. of the United States is not affiliated with Prudential plc. which is headquartered in the United Kingdom. Prudential is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, national origin, ancestry, sex, sexual orientation, gender identity, national origin, genetics, disability, marital status, age, veteran status, domestic partner status, medical condition or any other characteristic protected by law. If you need an accommodation to complete the application process, please email accommodations.hw@prudential.com. If you are experiencing a technical issue with your application or an assessment, please email careers.technicalsupport@prudential.com to request assistance.

<h3>The Prudential Insurance Company of America - Director - Software Engineer </h3>Location: Newark, New Jersey Director - Software Engineer (The Prudential Insurance Company of America, Newark, NJ): Code, test and debug new and existing applications as implement capabilities to solve sophisticated business problems, deploy innovative products, services and experiences to delight our customers. Build applications ensuring that the code follows the latest coding practices, industry standards, and Prudential standards, using modern design patterns and architectural principles; remove complex technical impediments. Collaborate with product owners in understanding needs and defining feature stories, tech leads in defining technical design and other team members to understand the system end-to-end and deliver robust solutions that bring about business impact. Write unit, integration tests and functional automation, researching problems discovered by quality assurance or product support, developing solutions to address the problems. Bring a deep understanding of relevant and emerging technologies, give technical direction to team members and embed learning and innovation in the day-to-day. Work on significant and unique issues where analysis of situations or data requires an evaluation of intangible variables and may impact future concepts, products or technologies. Full time employment, Monday - Friday, 40 hours per week. Telecommuting permitted up to 3 days a week. <h3>Minimum Requirements: </h3>Bachelor’s degree in Computer Science, Engineering, or a related field, and 5 years of progressive, post-baccalaureate related work experience. Of the required experience, must have 3 years of experience in each of the following: <ol><li>Utilizing programming languages: Python, Java, or Java Script; </li><li>Frameworks: React, Springboot, and Node.js; </li><li>Application Programming Interfaces (API): Consumption & Development; </li><li>Design and implementation of microservices/API architecture patterns using REST, JSON, HTTP, and TLS; </li><li>Unit, interface, performance and end user testing concepts and tooling (functional & non-functional); </li><li>Dev Ops Tools and Practices: Branching techniques and usage of GitHub, Bitbucket, Subversion, DevOps, Jenkins, and CI/CD; </li><li>AWS Core Services: Lambda, S3, or CloudWatch; </li><li>Deploying applications to AWS, ECS, EC2, and EKS. </li> </ol>Domestic travel required up to 10%. To Apply: Apply online at <a >this link </a>. Should you have any difficulty in applying for this position through our website, please contact for assistance in the application process. #J-18808-Ljbffr

Job Classification: Technology - Engineering & Cloud A GLOBAL FIRM WITH A DIVERSE & INCLUSIVE CULTURE As the Global Asset Management business of Prudential, we're always looking for ways to improve financial services. We're passionate about making a meaningful impact - touching the lives of millions and solving financial challenges in an ever-changing world. We also believe talent is key to achieving our vision and are intentional about building a culture on respect and collaboration. When you join PGIM, you'll unlock a motivating and impactful career - all while growing your skills and advancing your profession at one of the world's leading global asset managers! If you're not afraid to think differently and challenge the status quo, come and be a part of a dedicated team that's investing in your future by shaping tomorrow today. At PGIM, You Can! What you will do In PGIM Fixed Income, our Front Office technology team is a dynamic, fast-paced environment, with exciting changes on the horizon under new senior leadership. We are looking for a senior software engineer to help us build our next generation of portfolio management and trading systems. What you can expect <ul><li>Design and implement investment decision supporting services across all fixed income domains.</li><li>Maintain and enhance existing portfolio management applications in Java and Python</li><li>Work closely with our quantitative solutions and other front office investment teams.</li><li>Build and maintain application services that are critical to our front office systems.</li></ul> What you will bring <ul><li>6+ years of experience in developing front office and related applications.</li><li>Proficient in Python and SQL.</li><li>Solid fixed income knowledge</li><li>Proactive and ownership mentality</li><li>Strong analytical and problem-solving skills within a fast moving and dynamic environment</li><li>Extensive knowledge and experience with SDLC tools such as Git, Jira, Docker, Jenkins etc.</li></ul> What will set you apart? <ul><li>Azure or AWS experience.</li><li>Java or C++ development experience.</li><li>Financial market data such as datasets from Bloomberg, S&P, Moody's, ICE etc</li><li>Investment universe customization and back testing</li><li>Direct experience in supporting front office end-users (PM, Quant).</li></ul> Note: Prudential is required by state specific laws to include the salary range for this role when hiring a resident in applicable locations. The salary range for this role is from $ 130,000 to $170,000. Specific pricing for the role may vary within the above range based on many factors including geographic location, candidate experience, and skills. Roles may also be eligible for additional compensation and/or benefits. Eligibility to participate in a discretionary annual incentive program is subject to the rules governing the program, whereby an award, if any, depends on various factors including, without limitation, individual and organizational performance. About PGIM Fixed Income PGIM Fixed Income is a global asset manager offering active solutions across all fixed income markets. With approximately 1000 employees and $821Bn assets under management, the company has offices in Newark, London, Letterkenny, Amsterdam, Munich, Zurich, Tokyo, Hong Kong, and Singapore. Our business climate is a safe inclusive environment, centered around mutual respect, intellectual honesty, transparency, and teamwork. Our leaders are focused on talent & culture; dedicated to fostering growth & development at all levels to develop the industry leaders of tomorrow. What we offer you: <ul><li>Market competitive base salaries, with a yearly bonus potential at every level. </li></ul> <ul><li>Medical, dental, vision, life insurance, disability insurance, Paid Time Off (PTO), and leave of absences, such as parental and military leave. </li></ul> <ul><li>401(k) plan with company match (up to 4%).</li></ul> <ul><li>Company-funded pension plan.</li></ul> <ul><li>Wellness Programsincluding up to $1,600 a year for reimbursement of items purchased to support personal wellbeing needs.</li></ul> <ul><li>Work/Life Resources to help support topics such as parenting, housing, senior care, finances, pets, legal matters, education, emotional and mental health, and career development.</li></ul> <ul><li>Education Benefit to help finance traditional college enrollment toward obtaining an approved degree and many accredited certificate programs.</li></ul> <ul><li>Employee Stock Purchase Plan: Shares can be purchased at 85% of the lower of two prices (Beginning or End of the purchase period), after one year of service.</li></ul> Eligibility to participate in a discretionary annual incentive program is subject to the rules governing the program, whereby an award, if any, depends on various factors including, without limitation, individual and organizational performance. To find out more about our Total Rewards package, visit Work Life Balance | Prudential Careers. Some of the above benefits may not apply to part-time employees scheduled to work less than 20 hours per week. Prudential Financial, Inc. of the United States is not affiliated with Prudential plc. which is headquartered in the United Kingdom. Prudential is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, national origin, ancestry, sex, sexual orientation, gender identity, national origin, genetics, disability, marital status, age, veteran status, domestic partner status, medical condition or any other characteristic protected by law. If you need an accommodation to complete the application process, please email accommodations.hw@prudential.com. If you are experiencing a technical issue with your application or an assessment, please email careers.technicalsupport@prudential.com to request assistance.

<h3>The Prudential Insurance Company of America Lead Data Engineer Newark, New Jersey Apply Now</h3>Lead Data Engineer (The Prudential Insurance Company of America, Newark, NJ): Lead the design and development of highly scalable and efficient data architectures that meet business requirements and support analytical use-cases. Provide technical leadership to the data engineering team, guiding them in best practices, coding standards, and architectural designs. Design and implement robust ETL/ELT pipelines to ingest, transform and load data from diverse sources into the data ecosystem by leveraging AWS Cloud and Big Data technologies using Spark & Python. Demonstrate expertise in AWS data services including AWS S3, Glue, Redshift, EMR, Kinesis, and Lambda. Create automations and CI/CD pipelines using the tools available like BitBucket, Jenkins, and Cloud Formation. Optimize the data storage, query performance, costs on AWS resources for operation efficiency. Ensure data security best practices, encryption and access controls are in place to meet industry standards and regulations. Collaborate with data scientists, analysts and other stakeholders to understand the business requirements and deliver actionable insights. Maintain comprehensive documentation of data engineering processes, data models, and infrastructure configurations.Minimum Requirements:<ol><li>Bachelor’s degree in Computer Science or a related field and 5 years of progressive, post-baccalaureate related work experience; OR a Master’s degree in Computer Science or a related field, and 3 years of related work experience.</li><li>Of the required experience, must have 3 years of experience in each of the following:</li><ol><li>Extract-Transform-Load;</li><li>Python;</li><li>AWS Services, including S3, Glue, Lambda and IAM;</li><li>Spark, Hadoop, Hive, Impala, Sentry, and PySpark;</li><li>Job Orchestration: Step Function, Airflow, or Autosys;</li><li>Utilizing Version Control Tools: Bitbucket, GitHub, or GitLab;</li><li>CI/CD Pipelines: Jenkins, TeamCity, or GitLab pipelines;</li><li>Infrastructure as Code: CloudFormation, CDK, or Terraform;</li><li>Working with RDS and SQL Databases.</li></ol></ol>Telecommuting permitted up to 100%. To Apply: Apply online at <a href="#">this link</a>. Should you have any difficulty in applying for this position through our website, please contact Ramona.wallace@prudential.com for assistance in the application process.
#J-18808-Ljbffr

Job Classification: Technology - Engineering & Cloud A GLOBAL FIRM WITH A DIVERSE & INCLUSIVE CULTURE As the Global Asset Management business of Prudential, we're always looking for ways to improve financial services. We're passionate about making a meaningful impact - touching the lives of millions and solving financial challenges in an ever-changing world. We also believe talent is key to achieving our vision and are intentional about building a culture on respect and collaboration. When you join PGIM, you'll unlock a motivating and impactful career - all while growing your skills and advancing your profession at one of the world's leading global asset managers! If you're not afraid to think differently and challenge the status quo, come and be a part of a dedicated team that's investing in your future by shaping tomorrow today. At PGIM, You Can! What you will do In PGIM Fixed Income, our Front Office technology team is a dynamic, fast-paced environment, with exciting changes on the horizon under new senior leadership. We are looking for a senior software engineer to help us build our next generation of portfolio management and trading systems. What you can expect <ul><li>Design and implement investment decision supporting services across all fixed income domains.</li><li>Maintain and enhance existing portfolio management applications in Java and Python</li><li>Work closely with our quantitative solutions and other front office investment teams.</li><li>Build and maintain application services that are critical to our front office systems.</li></ul> What you will bring <ul><li>6+ years of experience in developing front office and related applications.</li><li>Proficient in Python and SQL.</li><li>Solid fixed income knowledge</li><li>Proactive and ownership mentality</li><li>Strong analytical and problem-solving skills within a fast moving and dynamic environment</li><li>Extensive knowledge and experience with SDLC tools such as Git, Jira, Docker, Jenkins etc.</li></ul> What will set you apart? <ul><li>Azure or AWS experience.</li><li>Java or C++ development experience.</li><li>Financial market data such as datasets from Bloomberg, S&P, Moody's, ICE etc</li><li>Investment universe customization and back testing</li><li>Direct experience in supporting front office end-users (PM, Quant).</li></ul> *PGIM welcomes all applicants, even if you don't meet every requirement. If your skills align with the role, we encourage you to apply. What we offer you <ul><li>Medical, dental, vision, life insurance and PTO (Paid Time Off)</li><li>Retirement plans:</li><li>401(k) plan with generous company match (up to 4%)</li><li>Company-funded pension plan</li><li>Wellness Programs to help you achieve your wellbeing goals, including up to $1,600 a year for reimbursement of items purchased to support personal wellbeing needs</li><li>Work/Life Resources to help support topics such as parenting, housing, senior care, finances, pets, legal matters, education, emotional health, and career development.</li><li>Tuition Assistance to help finance traditional college enrollment, approved degrees, many accredited certificate programs, and industry designations.</li></ul> To find out more about our Total Reward package, Total Rewards Brochure Note: Prudential is required by state specific laws to include the salary range for this role when hiring a resident in applicable locations. The salary range for this role is from $ 130,000 to $170,000. Specific pricing for the role may vary within the above range based on many factors including geographic location, candidate experience, and skills. Roles may also be eligible for additional compensation and/or benefits. Eligibility to participate in a discretionary annual incentive program is subject to the rules governing the program, whereby an award, if any, depends on various factors including, without limitation, individual and organizational performance. About PGIM Fixed Income PGIM Fixed Income is a global asset manager offering active solutions across all fixed income markets. With approximately 1000 employees and $821Bn assets under management, the company has offices in Newark, London, Letterkenny, Amsterdam, Munich, Zurich, Tokyo, Hong Kong, and Singapore. Our business climate is a safe inclusive environment, centered around mutual respect, intellectual honesty, transparency, and teamwork. Our leaders are focused on talent & culture; dedicated to fostering growth & development at all levels to develop the industry leaders of tomorrow. Prudential Financial, Inc. of the United States is not affiliated with Prudential plc. which is headquartered in the United Kingdom. Prudential is a multinational financial services leader with operations in the United States, Asia, Europe, and Latin America. Leveraging its heritage of life insurance and asset management expertise, Prudential is focused on helping individual and institutional customers grow and protect their wealth. The company's well-known Rock symbol is an icon of strength, stability, expertise and innovation that has stood the test of time. Prudential's businesses offer a variety of products and services, including life insurance, annuities, retirement-related services, mutual funds, asset management, and real estate services. We recognize that our strength and success are directly linked to the quality and skills of our diverse associates. We are proud to be a place where talented people who want to make a difference can grow as professionals, leaders, and as individuals. Visit www.prudential.com to learn more about our values, our history and our brand. Prudential is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, national origin, ancestry, sex, sexual orientation, gender identity, national origin, genetics, disability, marital status, age, veteran status, domestic partner status , medical condition or any other characteristic protected by law. The Prudential Insurance Company of America, Newark, NJ and its affiliates. Note that this posting is intended for individual applicants. Search firms or agencies should email Staffing at staffingagencies@prudential.com for more information about doing business with Prudential. PEOPLE WITH DISABILITIES: If you need an accommodation to complete the application process, which may include an assessment, please email accommodations.hw@prudential.com. Please note that the above email is solely for individuals with disabilities requesting an accommodation. If you are experiencing a technical issue with your application or an assessment, please email careers.technicalsupport@prudential.com to request assistance.

Pgim Business Intelligence Interview Guide

Overview

Pgim Business Intelligence Salary

Pgim Business Intelligence Interview Process

Pgim Business Intelligence Interview Questions

Pgim Business Intelligence Jobs