To align business strategy with software solutions and address complex business needs at PNC
Requirements
- 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
- SQL
- ETL tools (Informatica / SSIS)
- Scripting in UNIX, Windows
Responsibilities
- Proposes, designs & codes software solutions to address complex business needs
- Oversees technical and procedural documentation required
- Leads complex problem solving
- Provides technical guidance and support to colleagues and solution development
- Displays an innovative approach to apply modern principles, methodologies and tools to advance business initiatives and capabilities
- Aligns business strategy with software solutions
Other
- Customer Focused - Knowledgeable of the values and practices that align customer needs and satisfaction as primary considerations in all business decisions
- Managing Risk - Assessing and effectively managing all of the risks associated with their business objectives and activities to ensure they adhere to and support PNC's Enterprise Risk Management Framework
- Bachelors degree
- 5+ years of industry-relevant experience