Software Engineer Senior - Informatica Cloud Services/PowerCenter
About The Position
Design, develop, and maintain scalable ETL solutions using Informatica PowerCenter and/or Informatica Intelligent Cloud Services (IICS/IDMC – CDI, CAI), including reusable mappings, workflows, and frameworks. Apply advanced techniques such as performance tuning, partitioning, and error handling to ensure efficient, reliable processing of high-volume data. Build and support end-to-end data pipelines across system-of-record platforms using industry-standard ETL design patterns, including delta processing and reconciliation. Leverage strong SQL and database expertise (e.g., Oracle, SQL Server, Teradata, MongoDB) to analyze, optimize, and manage complex queries and large datasets across ODS and data warehouse environments. Implement and enforce data quality, validation, and cleansing frameworks, ensuring consistency, accuracy, and alignment with governance standards, including lineage and metadata management. Support DevOps and release management processes, including environment migrations and deployment coordination (e.g., uDeploy), while demonstrating strong ownership, problem-solving ability, and effective stakeholder communication. PNC is an in-office company that fosters a supportive culture where employees can thrive and achieve balance. We encourage candidates to connect with their recruiter and hiring manager to understand workplace expectations and ensure the role aligns with their goals. PNC will not provide sponsorship for employment visas or participate in STEM OPT for this position.
Requirements
- 3+ years of relevant / direct industry experience.
Nice To Haves
- Application Development
- Business Management
- Customer Solutions
- Design
- Group Problem Solving
- Process Improvements
- Release Management
- Software Solutions
- User Experience (UX) Design
- Application Delivery Process
- Application Design
- Architecture
- Application Development Tools
- Application Testing
- Packaged Application Integration
- System Development Life Cycle
- Technical Troubleshooting
- Technical Writing/Documentation
Responsibilities
- Design, develop, and maintain scalable ETL solutions using Informatica PowerCenter and/or Informatica Intelligent Cloud Services (IICS/IDMC – CDI, CAI), including reusable mappings, workflows, and frameworks.
- Apply advanced techniques such as performance tuning, partitioning, and error handling to ensure efficient, reliable processing of high-volume data.
- Build and support end-to-end data pipelines across system-of-record platforms using industry-standard ETL design patterns, including delta processing and reconciliation.
- Leverage strong SQL and database expertise (e.g., Oracle, SQL Server, Teradata, MongoDB) to analyze, optimize, and manage complex queries and large datasets across ODS and data warehouse environments.
- Implement and enforce data quality, validation, and cleansing frameworks, ensuring consistency, accuracy, and alignment with governance standards, including lineage and metadata management.
- Support DevOps and release management processes, including environment migrations and deployment coordination (e.g., uDeploy), while demonstrating strong ownership, problem-solving ability, and effective stakeholder communication.
- 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.
Benefits
- medical/prescription drug coverage (with a 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 select programs fully paid
- a robust wellness program with financial incentives
- maternity and/or parental leave
- up to 11 paid holidays each year
- 9 occasional absence days each year, unless otherwise required by law
- between 15 to 25 vacation days each year, depending on career level; and years of service
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
