**PNC will not provide sponsorship for employment visas or participate in STEM OPT for this position**Primary job responsibilities –
-Design, develop and maintain robust data solutions.
-Architect, implement and optimize informatica workflows, PL/SQL code & MSSQL, Teradata based data processing solutions.
-Collaborate with business analysts, stakeholders to translate business requirements into scalable data solutions.
-Acts as a lead by developing and documenting technical specifications for proposed solutions. This includes extensive hands-on coding and testing to support data solutions.
Develop and maintain comprehensive documentation of data architecture, ETL processes and performance metrics.
Provides mentorship and technical guidance to junior engineers and developers.
-Ensure data quality, integrity and governance standards are upheld across all data pipelines.Skills and expertise you bring
- Expert level Informatica PowerCenter skills
- Expert level database skills – MSSQL, Teradata, Oracle
- Expert level SQL, PL/SQL skills. Strong analytical and problem-solving skills.- Expertise in ETL design, data warehousing principles and performance tuning
- Proficient with code deployment tools such as Udeploy, Artifactory, GitHub
- Hands on Informatica, SQL, PL/SQL coding, testing, and overall documentation to ensure completeness and accuracy.
- Ability to work in agile environment.
- Good communication & leadership skills- Capable of moving seamlessly between iterative prototyping and enterprise application development and support.
Nice to have:
Experience in one of the cloud environments (Azure, AWS, GCP)
Experience with big data technologies such as Hadoop, Hive, Spark etc.
Programming experience in Python, Scala.
Job Description- 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.
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.
QualificationsSuccessful candidates must demonstrate appropriate knowledge, skills, and abilities for a role. Listed below are skills, competencies, work experience, education, and requiredneeded to be successful in this position.
Application Delivery Process, Application Design, Architecture, Application Development Tools, Application Testing, Packaged Application Integration, System Development Life Cycle, Technical TroubleshootingRoles at this level typically require a university / college degree, with 3+ years of relevant / direct industry experience. Certifications are often desired. In lieu of a degree, a comparable combination of education, job specific certification(s), and experience (including military service) may be considered.No Required Certification(s)No Required License(s)
This position is subject to the requirements of Section 19 of the Federal Deposit Insurance Act (FDIA) and, for any registered role, the Secure and Fair Enforcement for Mortgage Licensing Act of 2008 (SAFE Act) and/or the Financial Industry Regulatory Authority (FINRA), which prohibit the hiring of individuals with certain criminal history.
California ResidentsRefer to the