Lead Software Engineer – ETL, Regulatory Risk & Compliance
PNC
full-time
Posted on:
Location Type: Office
Location: Farmers Branch • Pennsylvania • Texas • United States
Visit company websiteExplore more
Job Level
About the role
- 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
- 5+ years of development experience
- Aligns business strategy with software solutions.
- Must possess strong communication skills, both written and verbal.
- Candidate must actively and independently strive to broaden technology and business knowledge.
- Displays an innovative approach to apply modern software development principles, methodologies, and tools to advance business initiatives and capabilities.
- Formal experience in working in projects with a methodology (waterfall, agile)
- Banking and Regulatory Reporting experience a plus
- Advanced design and programming skills in Informatica power center 9.6 & above and Oracle SQL/PLSQL
- Proficiency in developing and debugging the PL/SQL Code.
- Develop SCD mappings with difference source formats using necessary Transformations.
- Performance tuning of Targets, Source, Mappings, Sessions, and Workflows.
- Design HTTP Transformations.
- Experienced in handling the ETL Code deployments using DevOps Tools
- Hands on knowledge with UNIX shell scripting and CA7 job scheduler
- Intermediate level skills in data analysis and data modeling
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
Informatica PowerCenter 9.6Oracle SQLPL/SQLETLData AnalysisData ModelingPerformance TuningHTTP TransformationsUNIX Shell ScriptingDevOps Tools
Soft Skills
CommunicationProblem ResolutionTechnical GuidanceInnovative ApproachIndependenceCollaborationLeadership