Job Profile

Position Overview

At PNC, our people are our greatest differentiator and competitive advantage in the markets we serve. We are all united in delivering the best experience for our customers. We work together each day to foster an inclusive workplace culture where all of our employees feel respected, valued and have an opportunity to contribute to the companys success. As a System Reliability & Support Specialist you will work within PNC's Retail Technology organization. This position can be remote and sit anywhere within the PNC footprint except Alaska, Hawaii and Colorado. In person activities may occur based on business need.

The ideal candidate will have the following preferred skills
Analysis, designing, development and support in Hadoop infrastructure using Hive , Sqoop, Oozie, Kafka, Spark Python and Scala.
Experience in working with Cloudera distribution with various nodes cluster running Spark on YARN.
Hands on experience in using Hive to extract, transform and load (ETL) data into a reportable format using Spark environment.
Experience in importing and exporting Gigabytes of data between HDFS and Relational Teradata Database using Sqoop.
HBase Database skills.
Experience in using Parquet file format in Hive and Spark.
Clear understanding of Hadoop architecture and various component like Resource manager, node manager, Name node, Data node HDFS etc.
Programing knowledge to get the data from Kafka using PySpark and load into Hadoop distributed file system and other downstream applications.
Hands on experience in designing ETL Informatica power center 9.1. Experience of Data warehousing concepts like Dimensional modeling like SCD-1, SCD-2 etc., different schemas (Star, Snowflakes etc.), Demoralization etc.
Proficient in Data analysis, Data modeling (Physical and logical), That Include ER diagrams, DFD (data flow diagrams) and Database designing.
Having Experience to work on Production support project consist of incident investigations, tracking the regular data loading jobs, resolve the tickets etc.
Proficient in performance tuning using through execution plan, Hints, Bulk Binding, Pipelined Functions, Partitions, index etc.
Having experience of UNIX Shell programing.
Pyspark and Scala programing experience.
Experience of Core Java, Angular J, JASON, Tableau, CA7, ServiceNow is preferred but not necessary.

Job Description

Monitor, maintain and support systems and software to ensure stability and compliance to technology standards.
Performs maintenance, including installation of patches and upgrades.
Incident detection, resolution and/or escalation. Participation in root cause analysis and correction resulting in prevention.
Monitors systems availability, performance, and capacity against baseline metrics and reports trends.
Develops in depth knowledge of supported systems and applications.
Performs application governance, such as required attestations, continuity testing, impact analysis, responding to audit/regulatory inquiries and complying with technology standards.

PNC Employees take pride in our reputation and to continue building upon that we expect our employees to be:

Customer Focused - Knowledgeable of the values and practices that align customer needs and satisfaction as primary considerations in all business decisions and able to leverage that information in creating customized customer solutions.
Managing Risk - Assessing and effectively managing all of the risks associated with their business objectives and activities to ensure they adhere to and support PNC's Enterprise Risk Management Framework.

Competencies

Analytical Thinking Knowledge of techniques and tools that promote effective analysis and the ability to determine the root cause of organizational problems and create alternative solutions that resolve the problems in the best interest of the business.

Application Maintenance Knowledge of and ability to define, implement changes to, and support a production application.

Application Programming Interfaces (API's) Knowledge and ability to write, test, and debug application programming interfaces (APIs).

Decision Making and Critical Thinking Understanding of the issues related to the decision-making process; ability to analyze situations fully and accurately, and reach productive decisions.

IT Environment Knowledge of an organization's IT purposes, activities and standards; ability to create an effective IT environment for business operations.

IT Incident Management Knowledge of and ability to investigate, troubleshoot, resolve and prevent the recurrence of incidents that interfere with the normal delivery of IT services.

IT Service Management (ITSM) Knowledge of and the ability to utilize a variety of management skill sets and technical tools to ensure quality and high standards in IT services.

IT Standards, Procedures & Policies Knowledge of and the ability to utilize a variety of administrative skill sets and technical knowledge to manage organizational IT policies, standards, and procedures.

Packaged Application Integration Knowledge of and the ability to implement packaged application software and integrate it with company applications, databases and technology platforms.

Software Reliability Management Knowledge of, and ability to develop and use, principles, methodologies and metrics that increase software product performance and reliability.

System Development Life Cycle Knowledge of project management techniques and the ability to plan, design, develop, test, implement and maintain system development life cycle segments and phases.

Technical Troubleshooting Knowledge of technical troubleshooting approaches, tools and techniques, and the ability to anticipate, recognize, and resolve technical (hardware, software, application or operational) problems.

Work Experience

Roles at this level typically require a university / college degree, with 2+ years of relevant professional experience. In lieu of a degree, a comparable combination of education and experience (including military service) may be considered.

Education

Bachelors

Additional Job Description

Base Salary: Commensurate with skills & experience

Benefits

PNC offers employees a comprehensive range of benefits to help meet your needs now and in the future. Depending on your eligibility, options for full-time employees include medical/prescription drug coverage (with a Health Savings Account feature); dental and vision options; employee and spouse/child life insurance; short- and long-term disability protection; maternity and parental leave; paid holidays, vacation days and occasional absence time; 401(k), pension and stock purchase plans; dependent care reimbursement account; back-up child/elder care; adoption assistance; educational assistance and a robust wellness program with financial incentives. To learn more about these and other programs, including benefits for part-time employees, visit pncbenefits.com > New to PNC.

Disability Accommodations Statement:

The PNC workplace is inclusive and supportive of individual needs. If you have a physical or other impairment that might require an accommodation, including technical assistance with the PNC Careers website or submission process, please call 877-968-7762 and select Option 4: Recruiting or contact us via email at pathfinder@pnc.com.

The Human Resources Service Center hours of operation are Monday - Friday 9:00 AM to 5:00 PM ET.

Equal Employment Opportunity (EEO):

PNC provides equal employment opportunity to qualified persons regardless of race, color, sex, religion, national origin, age, sexual orientation, gender identity, disability, veteran status, or other categories protected by law.

California Residents

Refer to the California Consumer Privacy Act Privacy Notice to gain understanding of how PNC may use or disclose your personal information in our hiring practices.