Software Engineer Lead - Finance Technology (ETL, Informatica, SQL)
PNC•Strongsville, OH
•Onsite
About The Position
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
- Strong hands-on experience in ETL development and data integration (Informatica).
- Strong SQL knowledge for creating complex queries, Stored procedures and managing relational databases (Oracle, SQL Server, PostgreSQL or MySQL)
- Experience building and maintaining batch and/or near‑real‑time ETL pipelines.
- Proven ability to optimize data pipelines, mappings and sql queries for large datasets
- Experience with error handling, logging, and monitoring.
- Ability to work independently and within Agile/Scrum teams
- University / college degree, with 3+ years of relevant / direct industry experience.
Nice To Haves
- Experience with CA7 and mainframe is a plus.
Responsibilities
- 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.
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.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
Upload and Match Resume
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Number of Employees
5,001-10,000 employees
