Position Overview

At PNC, our people are our greatest differentiator and competitive advantage in the markets we serve. We are all united in delivering the best experience for our customers. We work together each day to foster an inclusive workplace culture where all our employees feel respected, valued and have an opportunity to contribute to the company’s success as a Software Engineer Sr within PNC's C&IB organization, you will be based in GA Location, This is a remote position. Work may be performed from a quiet, confidential space in a home location, approved by PNC. This position may not be available in all geographic locations.

*****PNC will not provide sponsorship for employment visas or participate in STEM OPT for this position.*****

• Advanced proficiency in SQL - complex queries with joins using Teradata/Oracle/SQL Server.
• Working knowledge of Python preferred along with Exposure to Automating Data Validations is a PLUS
• Multiple years of Experience in working with large scale Enterprise Data Warehouse, Data Integration, Data Migration and upgrade projects.
• Skills and interest in participating in reviews of the data models, data mapping documents, ETL design, and ETL coding—as well as the ability to provide feedback to Dev/Tech teams.
• Data scripting language experience or equivalent (Python or Informatica/ETL preferred)
• Experience in the development of data warehouse test strategies, test plans, and test cases—what they are and how to develop them, specifically for data warehouses and decision-support systems. Experience in test Management tool/s is a PLUS.
• Demonstrated skills with creating effective data warehouse test cases and scenarios based on business and user requirements for the data warehouse. Data development experience is a PLUS.
• An overwhelming desire to find bugs
• Strong Working Knowledge on Data Visualizations concepts and reporting Platforms (Tableau/OBIEE/ R Shiny etc. )
• Strong Understanding of REST API types (GET, PUT, POST, DELETE) and how it works.
• Experience performing automated web-service validation for SOAP/REST services, using SOAP UI or Karate Framework for services automation. Strong working knowledge of any API testing tools like POSTMAN, Rest Client, SOAPUI etc.
• Strong experience with Cucumber, BDD methodology, Gherkin syntax Hands on experience in any Java IDE (e.g. Eclipse)
• Strong experience on GIT, JIRA, Jenkins Good understanding of HTTP, JSON protocol and syntax.

Job Description

• Provides detailed technical design and development of software solutions using existing and emerging technology platforms.
• Proposes & designs software solutions to address complex business needs.
• Writes code, tests and deploys software.
• Prepares technical and procedural documentation required for software.
• Maintains and debugs software.

PNC Employees take pride in our reputation and to continue building upon that we expect our employees to be:

• 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.

Qualifications

Successful candidates must demonstrate appropriate knowledge, skills, and abilities for a role. Listed below are skills, competencies, work experience, education, and required