PNC Financial Services Group Interview Questions

PNC Financial Services Group Interview Guides

Click or hover over a slice to explore questions for that topic.
Data Structures & Algorithms
(81)
SQL
(47)
Machine Learning
(46)
Probability
(25)
Business Case
(17)

PNC Financial Services Group Interview Questions

Practice for the PNC Financial Services Group interview with these recently asked interview questions.

QuestionTopicDifficulty
SQL
Easy

We’re given two tables, a users table with demographic information and the neighborhood they live in and a neighborhoods table.

Write a query that returns all neighborhoods that have 0 users. 

Example:

Input:

users table

Columns Type
id INTEGER
name VARCHAR
neighborhood_id INTEGER
created_at DATETIME

neighborhoods table

Columns Type
id INTEGER
name VARCHAR
city_id INTEGER

Output:

Columns Type
name VARCHAR
Behavioral
Medium
Behavioral
Medium
Loading pricing options

View all Pnc questions

Challenge

Check your skills...
How prepared are you for working at Pnc?

PNC Financial Services Group Salaries by Position

$100K
$140K
Data Engineer
Median: $111K
Mean (Average): $112K
Data points: 19
$96K
$110K
Product Manager
Median: $110K
Mean (Average): $105K
Data points: 3
$82K
$112K
Data Scientist
Median: $95K
Mean (Average): $98K
Data points: 20
$60K
$130K
Software Engineer
Median: $93K
Mean (Average): $91K
Data points: 12
$56K
$82K
Data Analyst
Median: $66K
Mean (Average): $68K
Data points: 4

Most data science positions fall under different position titles depending on the actual role.

From the graph we can see that on average the Data Engineer role pays the most with a $111,562 base salary while the Data Analyst role on average pays the least with a $67,634 base salary.

Discussion & Interview Experiences

?
There are no comments yet. Start the conversation by leaving a comment.