Position Overview

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 Sr. within PNC's DevOps organization, you will be based in Pittsburgh, PA.

This position also offers the opportunity to work remotely from home.

The Test Data Management (TDM) role will be responsible for planning, discovery, design, development, and maintenance of test data using appropriate test data management tools and techniques. This role will develop test data management strategies and plans to provide right sized, production like, reusable and secured test data per test data requirements, as well as discover, generate, profile, transform, enrich, cleanse, extract, subset, mask, load, validate, refresh, reset, archive, purge test data and resolve defects of test data using Informatica Information Lifecycle Management (ILM), Test Data Management (TDM), automation tools and SQL scripts.

Implement the development of the test data management strategy and focus specifically on maximizing test data reuse, safety, initial state repeatability, profiling, catalog and versioning. In designing test data management strategy, they will have a thorough understanding of data governance which subsets data quality, information life cycle management (data modelling, data development and admin), metadata, master data management and data security. This role will implement the strategy via developing, coding and executing test data discovery, architecting, sub setting, masking, provisioning and maintenance solutions using automated test data architect, profiling, cleansing, validation, sub setting and privacy.

Extensive knowledge of databases, data warehouses, systems integrations, and data flows is preferred for this role. Additionally, candidates should be well-versed in data architecture, data development, test data management tools configuration and development, with a proven history of providing effective test data solutions. Extensive knowledge of business processes and related data flows and system integrations is also preferred for this position.

Technical Qualifications:
• At least 8 to 10 years hands experience in Informatica ETL tools
• Sound knowledge understanding the relational databases bases - Oracle ,Teradata, DB2 and SQL server
• Mainframe Data experience –VSAM and IMS file layouts
• Capability to develop complex SQL queries and ETL tool transformations logic
• Good understanding in writing regular expressions and database metadata definitions
• Writing automation shell scripts in add-on advantage
• Experience writing informatica workflows and guiding team members in project implementations
• Good understanding SDLC life cycle of Waterfall and Agile implementations
• Capable to prepare project estimations and release plans
• Good understanding HIPPA, PCI,PII and PHI compliance – sensitive data
• Hands on experience using Informatica power center and database client tools i.e. Toad and SQL developer
• Good understanding in relational database ,data warehouse architecture and Logical design and dataflow diagrams
• Solid experience in informatica workflow performance tuning and trouble shooting
• Ability to prepare project Design artifacts and code review check lists
• Coordinate and manage onsite ,offshore teams on project deliverable

Job Description

• Leads in developing, supporting and implementing data solutions for multiple applications in order to meet business objectives and user requirements. Leverages technical knowledge and industry experience to design, build and maintain technology solutions.
• Leads data requirement analysis and the data preparation process development for targeted data solutions.
• Leads in designing and building data service infrastructure on multiple data platforms, according the workflow.
• Oversees the development and implementation of data solutions for multiple applications to ensure its scalability, availability and maintainability.
• Consults on data migration and transformation to ensure the accuracy and security of data solutions.

PNC Employees take pride in our reputation and to continue building upon that we expect our employees to be:

• Customer Focused - Knowledgeable of the values and practices that align customer needs and satisfaction as primary considerations in all business decisions and able to leverage that information in creating customized customer solutions.
• Managing Risk - Assessing and effectively managing all of the risks associated with their business objectives and activities to ensure they adhere to and support PNC's Enterprise Risk Management Framework.

Competencies

Application Delivery Process – Knowledge of major tasks, deliverables, and formal application delivery methodologies; ability to utilize these in order to deliver new or enhanced applications.Big Data Management and Analytics – Knowledge and ability to plan and execute, big data management and analytics.Business Intelligence – Knowledge of and ability to utilize business processes and technologies for gathering, storing, analyzing, and providing access to data that helps the organization make better business decisions.Consulting – Knowledge of techniques, roles, and responsibilities in providing technical or business guidance to clients, both internal and external; ability to apply this knowledge appropriately to diverse situations.Data Analysis - Software – Knowledge of the investigation, evaluation, interpretation, and classification of data; the ability to identify, collect and analyze data to facilitate the development, implementation and application of software systems.Data Architecture – Knowledge and ability to create models and standards to govern which data is collected, and how it is stored, arranged, integrated, and put to use in data systems and in organizations.Database Structures – Knowledge of and the ability to utilize appropriate database structures to organize and store data in a particular manner.Problem Solving – Knowledge of approaches, tools, techniques for recognizing, anticipating, and resolving organizational, operational or process problems; ability to apply this knowledge appropriately to diverse situations.Software Development Life Cycle – Knowledge of and experience with using a structured methodology for delivering new or enhanced software products to the marketplace.

Work Experience

Roles at this level typically require a university / college degree, with 5+ years of industry-relevant experience. Specific certifications are often required. In lieu of a degree, a comparable combination of education and experience (including military service) may be considered.

Education

Bachelors (Required)

Additional Job Description

Benefits

PNC offers employees a comprehensive range of benefits to help meet your needs now and in the future. Depending on your eligibility, options for full-time employees include 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; maternity and parental leave; paid holidays, vacation days and occasional absence time; 401(k), pension and stock purchase plans; dependent care reimbursement account; back-up child/elder care; adoption assistance; educational assistance and a robust wellness program with financial incentives. To learn more about these and other programs, including benefits for part-time employees, visit pncbenefits.com > New to PNC.

Disability Accommodations Statement:

The PNC workplace is inclusive and supportive of individual needs. If you have a physical or other impairment that might require an accommodation, including technical assistance with the PNC Careers website or submission process, please call 877-968-7762 and select Option 4: Recruiting or contact us via email at pathfinder@pnc.com.

The Human Resources Service Center hours of operation are Monday - Friday 9:00 AM to 5:00 PM ET.

Equal Employment Opportunity (EEO):

PNC provides equal employment opportunity to qualified persons regardless of race, color, sex, religion, national origin, age, sexual orientation, gender identity, disability, veteran status, or other categories protected by law.

California Residents

Refer to the California Consumer Privacy Act Privacy Notice to gain understanding of how PNC may use or disclose your personal information in our hiring practices.