Software Engineer Principal-ETL/Informatica/Data Modeling/Oracle SQL/CA-7

R

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 our employees feel respected, valued and have an opportunity to contribute to the company's success. As a Software Engineer Principal within PNC's Technology organization, you will be based in Dalla, TX, Birmingham, AL, Cleveland, OH, or Pittsburgh, PA. The position is primarily based in a PNC location.

PNC will not provide sponsorship for employment visas or participate in STEM OPT for this position.

PNC Wealth Management seeks a Software Developer Principal. Core responsibilities include:

• Align business strategy with software solutions.
• Propose and design complex software solutions and processes addressing complex Investments business needs.
• Design, build, and maintain scalable data pipelines using ETL and big data technologies.
• Design, develop and maintain mainframe CA7 job schedules to support new and existing processes.
• Create complex SQL and PL/SQL queries using TOAD, SQL developer, Teradata Studio, Hive to perform Data Mining/Data Analysis.
• Oversee technical and procedural documentation.
• Lead complex problem solving.
• Collaborate with business analysts, data Analysts, and other stakeholders to understand requirements and deliver data solutions.
• Develop and optimize data warehousing solutions to ensure high availability and performance.
• Provide technical guidance and support to colleagues and solution development.
• Display an innovative approach to apply modern principles, methodologies, and tools to advance business initiatives and capabilities.
• Partner with business stakeholders and product owners to prioritize technology deliverables.
• Perform code reviews and suggest potential improvements and formulate best practices.
• Ensure quality of project deliverables while maintaining compliance with relevant standards and processes.
• Implement data modeling techniques to support analytics and reporting needs.
• Ensure data quality, governance, and compliance across all data processes.
• Create technical design and application architecture diagrams.
• Establish data and system integrations between internal and external partners.
• Establish and manage various OBIEE reports for business sales performance and key metrics.
• Design, document and test APIs using tools such as Swagger editor, PostMan and SOAPUI.
• Build integrations between internal and external applications using both REST & SOAP based APIs.
• Support Single-Sign On (SSO) technology for internal and external vendor applications using SAML.
• Integrate and automate business processes using CRM tools such as Salesforce and Oracle Siebel.
• Align to business and IT priorities by effectively leveraging waterfall, iterative and Agile methodologies, while coaching and mentoring team members.
• Coordinate Disaster Recovery events with enterprise support teams.

PNC will not provide sponsorship for employment visas or participate in STEM OPT for this position.

Job Description

• Aligns business strategy with software solutions.
• Proposes, designs & codes software solutions to address complex business needs. Oversees technical and procedural documentation required.
• Leads complex problem solving.
• Provides technical guidance and support to colleagues and solution development.
• Displays an innovative approach to apply modern principles, methodologies and tools to advance business initiatives and capabilities.

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.

Qualifications
Successful candidates must demonstrate appropriate knowledge, skills, and abilities for a role. Listed below are skills, competencies, work experience, education, and required certifications/licensures needed to be successful in this position.

Preferred Skills
Application Development, Business Management, Customer Solutions, Design, Group Problem Solving, Process Improvements, Release Management, Software Solutions, User Experience (UX) Design

Competencies
Application Design, Architecture, Packaged Application Integration, Product and Vendor Evaluation, Software Process Improvement (SPI), System Development Life Cycle, Technical Troubleshooting

Work Experience
Roles at this level typically require a university / college degree, with 5+ years of industry-relevant experience. Specific certifications are often required. In lieu of a degree, a comparable combination of education, job specific certification(s), and experience (including military service) may be considered.

Education
Bachelors

Certifications
No Required Certification(s)

Licenses
No Required License(s)

Pay Transparency
Base Salary: $65,000.00 – $165,600.00

Salaries may vary based on geographic location, market data and on individual skills, experience, and education. This role is incentive eligible with the