onsite
Quality Assurance Architect - Test Data Management - PNC Financial Services Group
Software Engineer
Lead the design and implementation of test data management solutions, ensuring high‑quality data for automated and manual testing across complex financial systems using SQL, Python, and data‑warehouse technologies.
About the role
Key Responsibilities
- Architect, develop, and maintain a scalable test data management framework that supports functional, performance, and security testing.
- Design data masking, sub‑setting, and synthetic data generation processes to protect sensitive information while meeting test coverage needs.
- Collaborate with development, QA, and data engineering teams to integrate test data pipelines into CI/CD workflows.
- Automate data provisioning, refresh, and cleanup using Python scripts, SQL queries, and ETL tools.
- Establish governance, documentation, and best‑practice standards for test data creation, storage, and lifecycle management.
Requirements
- 5+ years of experience in quality assurance or test data management within large‑scale, data‑intensive environments.
- Strong proficiency in SQL and Python for data extraction, transformation, and automation.
- Hands‑on experience with data‑warehouse platforms (e.g., Snowflake, Redshift, Oracle) and ETL tools.
- Knowledge of data masking, synthetic data generation, and compliance requirements (e.g., PCI, GDPR).
- Experience working in Agile/Scrum teams and integrating test data solutions into CI/CD pipelines.