Job Title - ETL Lead
Hybrid Locations - Phoenix, Biltmore, Dallas, Pittsburgh, PA, Cleveland, OH, Birmingham, AL
Hybrid (3 days onsite, 2 remote)
Function of the Group
The Regulatory Risk and Compliance Reporting team within the Business Technology and Innovation Group at PNC develops innovative technology solutions to support regulatory submissions of the bank.
The ETL Lead role will focus on data-intensive applications supporting business and regulatory requirements. This role requires strong leadership, collaboration, design, and programming expertise across the ETL / data pipeline lifecycle-from consumption to reporting.
General Responsibilities
- Align business strategy with software solutions.
- Demonstrate strong written and verbal communication skills.
- Proactively broaden technology and business knowledge.
- Apply modern software development principles, methodologies, and tools to business initiatives.
- Participate in structured project methodologies (Agile, Waterfall).
- (Preferred) Experience in banking and regulatory reporting.
Experience Level : 5 7 years (Level 3)
Must-Have Technical Skills
Advanced design & programming in Informatica PowerCenter 9.6+ and Oracle SQL / PLSQLStrong in developing and debugging PL / SQL codeBuild SCD mappings with diverse source formats & transformationsPerformance tuning of targets, sources, mappings, sessions, and workflowsExperience designing HTTP transformationsKnowledge of ETL code deployments using DevOps toolsHands-on with UNIX shell scripting and CA7 job schedulerIntermediate skills in data analysis and data modelingFlex Skills / Nice-to-Have
Experience with AlteryxBI tools : Power BI, Tableau, Oracle BIHands-on with TeradataKnowledge of software design patterns and architectureLead complex problem-solving and provide technical guidancePropose, design, and code software solutions for complex needsMaintain technical and procedural documentation