SQL)

PNC

2d•$65,000 - $165,600•Onsite

About The Position

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 company’s success. As a Software Engineer Principal within PNC's C&IB Data Products organization, you will be based in Pittsburgh, PA, Strongsville, OH, Dallas, TX or Birmingham, AL. The position is primarily based in a PNC location. Responsibilities require time in the office or in the field on a regular basis. This role focuses on leading complex data warehouse applications and serving as a technical lead for a team of three offshore ETL developers. Responsibilities include managing all technical aspects of the applications, such as ETL development and design, orchestrating workflows using CA7, and implementing new data integrations and code deployments. The position requires strong collaboration with both business and technical stakeholders to ensure effective solutions. Additionally, the role involves working with large-scale databases like Teradata or Oracle to support enterprise-level data operations. The ideal candidate will have extensive experience leading complex data warehouse applications and advanced knowledge of Informatica ETL. Strong proficiency in SQL is essential, along with expertise in CA7 scheduling and Connect:Direct/NDM for data transfer. Familiarity with data warehousing concepts and hands-on experience with tools such as Informatica and Teradata are highly desirable. A solid understanding of ETL design, integration best practices, and the ability to guide offshore development teams will set candidates apart. 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.

Requirements

Extensive experience leading complex data warehouse applications
Advanced knowledge of Informatica ETL
Strong proficiency in SQL
Expertise in CA7 scheduling
Expertise in Connect:Direct/NDM for data transfer
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.

Nice To Haves

Familiarity with data warehousing concepts
Hands-on experience with tools such as Informatica and Teradata
Solid understanding of ETL design
Understanding of integration best practices
Ability to guide offshore development teams
Application Development
Business Management
Customer Solutions
Data Warehouse ETL
Design
ETL (Informatica)
ETL Design
Group Problem Solving
Process Improvements
Release Management
Software Solutions
Teradata ETL
User Experience (UX) Design
Application Design
Architecture
Packaged Application Integration
Product and Vendor Evaluation
Software Process Improvement (SPI)
System Development Life Cycle
Technical Troubleshooting

Responsibilities

Managing all technical aspects of the applications, such as ETL development and design
Orchestrating workflows using CA7
Implementing new data integrations and code deployments
Strong collaboration with both business and technical stakeholders to ensure effective solutions
Working with large-scale databases like Teradata or Oracle to support enterprise-level data operations
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.

Benefits

PNC offers 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; 401(k) with PNC match, pension and stock purchase plans; dependent care reimbursement account; back-up child/elder care; adoption, surrogacy, and doula reimbursement; educational assistance, including select programs fully paid; a robust wellness program with financial incentives.
In addition, PNC generally provides the following paid time off, depending on your eligibility: maternity and/or parental leave; up to 11 paid holidays each year; 9 occasional absence days each year, unless otherwise required by law; between 15 to 25 vacation days each year, depending on career level; and years of service.
To learn more about these and other programs, including benefits for full time and part-time employees, visit Your PNC Total Rewards.

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume