Creates and leads the technical design and development of software solutions
Proposes & designs software solutions to address complex business needs
Prepares technical and procedural documentation required
Facilitates complex problem resolution
Provides technical guidance and support to colleagues
Reviews coding, testing, and documentation of software
Applies modern principles, methodologies and tools to advance business initiatives and capabilities

Requirements

Hands on development and support experience with Informatica, Oracle database and Microsoft SQL Server
Perform 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
Lead and mentor a team of developers and interact closely with the lines of Business and project teams
Experience with CA7 and mainframe is a plus
Demonstrated experience performing highly complex software development activities
Strong analytical and problem solving skills
Production system problem resolution and support
Strong verbal and written communications skills
Must have the ability to interact with all levels of management and teams
Capable of handling multiple projects simultaneously and ability to work under pressure with strict timelines
Self-Starter, Highly Motivated, Passionate, enthusiastic and “CAN-DO” attitude
Skills- ETL – Informatica Oracle PL/SQL and Microsoft SQL Shell scripting
Experience with code deployment tools such as Udeploy, Artifactory, GitHub is a plus

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

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

InformaticaOracle databaseMicrosoft SQL ServerPL/SQLETL developmentSQL tuningInformatica Server administrationShell scriptingCA7mainframe

Soft Skills

analytical skillsproblem solvingverbal communicationwritten communicationteam leadershipproject managementability to work under pressureself-starterhighly motivatedenthusiastic