2 days ago
Pittsburgh, PA, USAStaff+
Responsibilities
- Design, code, document, and support software and ETL solutions for complex business needs.
- Develop and support production Informatica ETL solutions and complex SQL transformations.
- Analyze and troubleshoot data issues across multiple systems and large datasets.
- Translate business and technical requirements into reliable source-to-target data integrations.
- Provide technical guidance, lead complex problem solving, and support colleagues and solution development.
- Support production implementation processes, data reconciliation, batch processing, scheduling, and related data operations.
Requirements
- At least 5 years of hands-on Informatica development and production ETL support experience.
- At least 5 years of hands-on ANSI SQL experience, including complex queries, joins, subqueries, aggregations, stored procedures, and performance optimization.
- Strong experience with Oracle databases and Microsoft SQL Server.
- Strong understanding of ETL, data integration, data transformation, data quality, data engineering, relational databases, data modeling, and database design.
- Experience working with large datasets, complex source-to-target transformations, and data-related troubleshooting across multiple systems.
- Experience with structured software development life cycle and production implementation processes.
- Bachelor's degree or a comparable combination of education, job-specific certifications, and experience.
- Preferred qualifications include at least 1 year of Tableau or Power BI experience and exposure to mainframe environments or data sources.
Benefits
- Weekly in-office work is required in Pittsburgh, Pennsylvania.
- Benefits may include medical, prescription drug, dental, vision, life and disability insurance, 401(k) matching, pension, stock purchase plans, dependent care reimbursement, backup care, adoption and family-building reimbursements, educational assistance, and wellness programs.
- Paid time off may include parental leave, up to 11 paid holidays, 9 occasional absence days, and 15 to 25 vacation days depending on career level and service.
Tech Stack
Categories
Data Engineering
About PNC
PNC is a U.S. bank offering retail, business, and corporate banking, including checking, savings, credit cards, mortgages, auto loans, and wealth management. It earns revenue from interest income and fees across consumer, small-business, and institutional clients, and provides digital and branch services nationwide. Headquartered in Pittsburgh, it is a public company listed on the NYSE.