Create and lead the technical design and development of software solutions
Propose & design software solutions to address complex business needs
Prepare technical and procedural documentation required
Facilitate complex problem resolution
Provide technical guidance and support to colleagues
Review coding, testing, and documentation of software
Apply modern principles, methodologies and tools to advance business initiatives

3+ years of relevant / direct industry experience
Hands on development and support experience with Informatica, Oracle database and Microsoft SQL Server
Advanced ETL development activities using Informatica, PL/SQL
Oracle Database tuning, SQL tuning, Informatica Server administration
Design, implement, test and maintain ETL components for multiple applications
Strong analytical and problems solving skills
Production system problem resolution and support
Strong verbal and written communications skills
Knowledge of CA7 and mainframe is a plus

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

Lead Software Engineer – Informatica Support, Development

Key skills