Hybrid Principal Software Engineer – Data Management, Informatica ETL, Teradata, Oracle, SQL

at PNC

• Job title: Principal Software Engineer – Data Management, Informatica ETL, Teradata, Oracle, SQL
• Job type: Full Time
• Experience level: Lead
• Salary: $65,000 - $165,600 per year
• Degree requirement: Bachelor's Degree
• Tech skills: ETL, Informatica, Oracle, SQL
• Location requirements: Hybrid, Strongsville, United States

About the role

• Software Engineer Principal in PNC's C&IB Data Products organization leading data warehouse applications and guiding offshore ETL developers.

Responsibilities

• Leading complex data warehouse applications
• Serving as a technical lead for a team of three offshore ETL developers
• Managing all technical aspects of the applications, such as ETL development and design
• Orchestrating workflows using CA7
• Implementing new data integrations and code deployments
• Collaborating 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

Requirements

• Extensive experience leading complex data warehouse applications
• Advanced knowledge of Informatica ETL
• Strong proficiency in SQL
• Expertise in CA7 scheduling and Connect:Direct/NDM for data transfer
• Familiarity with data warehousing concepts
• Hands-on experience with tools such as Informatica and Teradata
• Solid understanding of ETL design and integration best practices
• Ability to guide offshore development teams
• University / college degree with 5+ years of industry-relevant experience, or a comparable combination of education, job specific certification(s), and experience (including military service) may be considered.

Benefits

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