3 months ago
Strongsville, OH, USASenior
Base Salary
$40k - $158k/yr
Responsibilities
- Design, develop, and maintain scalable ETL solutions using Informatica PowerCenter and Informatica Intelligent Cloud Services.
- Build reusable mappings, workflows, frameworks, and end-to-end data pipelines across system-of-record platforms.
- Apply performance tuning, partitioning, error handling, delta processing, reconciliation, and other ETL design patterns.
- Analyze, optimize, and manage complex queries and large datasets across ODS and data warehouse environments.
- Implement data quality, validation, cleansing, lineage, metadata management, and governance frameworks.
- Write, test, deploy, maintain, and debug software while preparing technical and procedural documentation.
- Support DevOps and release management processes, including environment migrations and deployment coordination using uDeploy.
- Propose technical solutions for complex business needs and collaborate with stakeholders on troubleshooting and delivery.
Requirements
- Bachelor’s degree.
- At least 3 years of relevant or direct industry experience.
- Strong experience with Informatica PowerCenter and/or Informatica Intelligent Cloud Services, including IICS/IDMC CDI and CAI.
- Strong SQL and database expertise with complex queries and large datasets.
- Knowledge of ETL design, data quality, validation, cleansing, lineage, metadata management, and data governance.
- Comparable combinations of education, job-specific certifications, and experience, including military service, may substitute for a degree.
- Strong technical design, application development, testing, troubleshooting, documentation, release management, and problem-solving skills.
- Certifications are often desired, but no certification or license is required.
Benefits
- In-office position based in Pittsburgh, PA; Strongsville, OH; or Dallas, TX.
- Medical and prescription drug coverage with a Health Savings Account feature, dental and vision options, life insurance, and short- and long-term disability protection.
- 401(k) with PNC match, pension, stock purchase plans, dependent care reimbursement, and back-up child and elder care.
- Adoption, surrogacy, doula reimbursement, educational assistance, and a wellness program with financial incentives.
- Eligible employees may receive parental leave, up to 11 paid holidays, 9 occasional absence days, and 15 to 25 vacation days depending on career level and years of service.
Tech Stack
Categories
Data Engineering
About PNC
We’ll help keep your money boring so your life doesn’t have to be. pnc.co/guidelines