Software Engineer Lead - Informatica/Database Tech/Data Solutions

ZipRecruiter; Pittsburgh (Allegheny County); On-site; USD 100,000 - 130,000; Full time

Job summary

A leading company in financial services seeks a Software Engineer Lead in Pittsburgh. The role involves designing data solutions, mentoring junior engineers, and ensuring data quality. Ideal candidates will have strong expertise in Informatica and SQL, along with leadership skills.

Benefits

Health Coverage

401(k)

Wellness Programs

Paid Time Off

Qualifications

• 3+ years relevant experience required.
• Certifications preferred but not required.

Responsibilities

• Design, develop, and maintain robust data solutions.
• Lead technical design and development of software solutions.
• Provide technical guidance to software development teams.

Skills

Informatica PowerCenter

MSSQL

Teradata

Oracle

SQL

PL/SQL

Analytical Skills

Problem Solving

Communication

Leadership

Education

Bachelor's degree

Tools

Udeploy

Artifactory

GitHub

Job description

Job DescriptionPosition 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 of our employees feel respected, valued and have an opportunity to contribute to the company’s success. As a Software Engineer Lead within PNC’s Technology organization, you will be based in Pittsburgh, PA; Cleveland, OH; Birmingham, AL or Dallas, TX. The position is primarily based in a PNC location. Responsibilities require time in the office or in the field on a regular basis. Some responsibilities may be performed remotely, at the manager’s discretion.

Primary 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 and stakeholders to translate business requirements into scalable data solutions.
- Lead by developing and documenting technical specifications, including extensive hands-on coding and testing.
- Troubleshoot issues, research solutions, and coordinate with cross-functional teams to resolve complex problems.
- Provide technical guidance to software development teams.
- Develop and maintain documentation of data architecture, ETL processes, and performance metrics.
- Mentor junior engineers and developers.
- Ensure data quality, integrity, and governance standards are upheld.

Required Skills and Expertise
- Expert in Informatica PowerCenter, MSSQL, Teradata, Oracle, SQL, PL/SQL.
- Strong analytical and problem-solving skills.
- Knowledge of ETL design, data warehousing, and performance tuning.
- Proficient with deployment tools like Udeploy, Artifactory, GitHub.
- Experience in agile environments.
- Good communication and leadership skills.
- Prior experience in financial services domain preferred.
- Ability to work 80% hands-on and 20% on innovation.
- Nice to have: Cloud experience (Azure, AWS, GCP), big data technologies (Hadoop, Hive, Spark), programming in Python or Scala.

Additional Responsibilities
- Lead the technical design and development of software solutions.
- Propose and design solutions to address complex business needs.
- Provide technical guidance and support to colleagues.
- Apply modern methodologies and tools to enhance business capabilities.

Qualifications
- Bachelor’s degree and 3+ years relevant experience; certifications preferred but not required.
- Excellent skills in application development, design, and troubleshooting.
- Strong understanding of business processes and IT solutions.

Benefits and Equal Opportunity
- Comprehensive benefits including health coverage, 401(k), wellness programs, paid time off.
- PNC is committed to diversity and inclusion, providing accommodations for applicants with disabilities.

Note: This position does not include sponsorship for employment visas or STEM OPT.

Contact for accommodations: [e-mail] or call 877-968-7762.