At PNC, our people are our greatest differentiator and competitive advantage in the markets we serve, and we need a Software Engineer Principal to align business strategy with software solutions and address complex business needs.
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.
- 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)
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.
- Develop SCD mappings with difference source formats using necessary Transformations.
- Performance tuning of Targets, Source, Mappings, Sessions, and Workflows.
Other
- Customer Focused - Knowledgeable of the values and practices that align customer needs and satisfaction as primary considerations in all business decisions and able to leverage that information in creating customized customer solutions.
- 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.
- Roles at this level typically require a university / college degree, with 5+ years of industry-relevant experience.
- Bachelors degree
- PNC will not provide sponsorship for employment visas or participate in STEM OPT for this position.