Data Engineer (Informatica/Teradata/Datawarehouse)

PNC

Pittsburgh, PA

Full Time

Mid Level

55k-152k

about 1 month ago

Job Description

About the Role

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 Data Engineer 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.

Key Responsibilities

Design, develop and maintain scalable and efficient data pipelines and ETL processes.
Collaborate with analysts and stakeholders to gather requirements and implement data solutions that meet business needs.
Propose and design data solutions to address complex business needs and prepare technical and procedural documentation.
Participate in code reviews and testing.
Apply modern principles, methodologies, and tools to advance business initiatives and capabilities.
Develop and manage data integrations between various systems, ensuring seamless data flow and consistency.
Optimize database and query performance to support analytical workloads.
Monitor and troubleshoot data workflows to ensure data quality and integrity at all times.
Stay current with industry trends, technologies and best practices to continuously improve our data ecosystem.

Requirements

Experience with data pipelines and ETL using Informatica.
Experience in SQL and database management systems.
Knowledge of data modeling, warehousing concepts, and ETL processes.
Experience with big data technologies and frameworks such as Hadoop, Hive, Spark, and programming in Python or Scala.
Demonstrated analytical and problem-solving skills.
Familiarity with cloud platforms (Azure, AWS) and their data-related services.
Proactive and detail-oriented professional with a strong sense of ownership.
Creative problem solver capable of tackling complex data challenges.
Ability to work in an agile environment and prioritize tasks effectively.

Nice to Have

Analytical Thinking
Data Analytics
Data Mining
Data Science
Machine Learning
Application Delivery Process
Big Data Management and Analytics
Business Intelligence
Data Analysis - Software
Data Architecture
Database Structures
Effective Communications
Problem Solving
Software Development Life Cycle

Qualifications

Typically requires a university/college degree with 3+ years of relevant industry experience.
In lieu of a degree, a comparable combination of education, certifications, and experience may be considered.
No required certifications or licenses.

Benefits & Perks

Medical/prescription drug coverage with Health Savings Account feature.
Dental and vision options.
Employee and spouse/child life insurance.
Short and long-term disability protection.
401(k) with PNC match, pension and stock purchase plans.
Dependent care reimbursement account.
Back-up child/elder care.
Adoption, surrogacy, and doula reimbursement.
Educational assistance, including fully paid programs.
Robust wellness program with financial incentives.
Paid time off including maternity/parental leave, holidays, vacation days, and occasional absence days.

Working at PNC

PNC fosters an inclusive and accessible workplace, emphasizing respect, diversity, and employee contribution. Employees are encouraged to take pride in the company's reputation and continuous improvement.

Apply Now