Data Engineer Sr.

PNC Financial Services Group, Inc. Virtual , WV

Posted 2 months ago

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.

ArrayArrayThe 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. Capability to develop complex SQL queries and ETL tool transformations logic . Experience writing informatica workflows and guiding team members in project implementations. Capable to prepare project estimations and release plans. Hands on experience using Informatica power center and database client tools i.e. Toad and SQL developer. Ability to prepare project Design artifacts and code review check lists . Coordinate and manage onsite ,offshore teams on project deliverable. 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. 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. Big Data Management and Analytics

  • Knowledge and ability to plan and execute, big data management and analytics. 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. 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. versioning, software, software systems, analytics, data security, facilitate, managing risk, database structures, data preparation, support, database, sql queries, marketplace, planning, analyzing, informatica power center, implementation, data migration, mainframe data, databases, data warehouse architecture, applications, software development life cycle, process, business processes, data preparation process development, assessing, focused, integrations, strategy, customer needs, transformations, oracle, requirement analysis, writing, big data management, ability to plan, analytics., master data management, toad, waterfall, application, data quality, pii, big data, performance tuning, system integrations, consumer privacy, provisioning, data discovery, teradata, vsam, relational database, data analysis, trouble shooting, test data management strategies, problem solving, hippa, test data management strategy, service, operational, etl tools, business, structured, mainframe, enterprise risk management framework, agile, relational databases, test data management, sdlc life cycle, infrastructure, automation, data modelling, data architecture, project, data governance, it, organize, developer, sql server, building, organizational, information lifecycle management, etl tool, sql, informatica, business intelligence, automation tools, Data Engineer & Python Developer, Data Engineer & Analyst, Senior Software Engineer & Data Scientist, Data Engineer, Senior Software Engineer

  • Scala, Senior Data Engineer, Software Engineer & Data Scientist, Senior Data Engineer & Architect, Big Data Software Engineer, Stack Analytics Engineer

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Software Developer Sr (Net/Sql/Api)

PNC Financial Services Group, Inc.

Posted 2 months ago

VIEW JOBS 12/8/2021 12:00:00 AM 2022-03-08T00:00 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. As a Software Developer Sr. within PNC's Retail MIS organization, you will be based in either Pittsburgh, PA, Cleveland or Columbus, OH. Remote opportunities to work from home also exist for this position. Successful candidates will have senior level experience with the following technologies: * .Net * SQL Server * Windows Servers * IIS * API Additional experience preferred: * Deluxe (formally DSS) Trips application experience (Exceptions, Returns, Legal, Disputes) * Mainframe * ServiceNow * NDM * Agile ceremonies (Standup, Sprint Planning, Backlog refinement, etc) Job Description * Proposes & designs software solutions to address complex business needs. Prepares technical and procedural documentation required. * Facilitates complex problem resolution. * Provides technical guidance and support to colleagues. Reviews coding, testing, and documentation of software. * Applies modern principles, methodologies and tools to advance business initiatives and capabilities. 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. Application Design, Architecture - Knowledge of application design activities, tools and techniques; ability to utilize these to convert business requirements and logical models into a technical application design. Application Development Tools - Knowledge of and ability to utilize a variety of specific tools and toolkits for the development and support of applications. Application Testing - Knowledge of application testing and ability to design, plan and execute application testing strategies and tactics to ensure software quality throughout all stages of application development. Packaged Application Integration - Knowledge of and the ability to implement packaged application software and integrate it with company applications, databases and technology platforms. System Development Life Cycle - Knowledge of project management techniques and the ability to plan, design, develop, test, implement and maintain system development life cycle segments and phases. Technical Troubleshooting - Knowledge of technical troubleshooting approaches, tools and techniques, and the ability to anticipate, recognize, and resolve technical (hardware, software, application or operational) problems. Job Description * 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. 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. Application Design, Architecture - Knowledge of application design activities, tools and techniques; ability to utilize these to convert business requirements and logical models into a technical application design. Application Development Tools - Knowledge of and ability to utilize a variety of specific tools and toolkits for the development and support of applications. Application Testing - Knowledge of application testing and ability to design, plan and execute application testing strategies and tactics to ensure software quality throughout all stages of application development. Packaged Application Integration - Knowledge of and the ability to implement packaged application software and integrate it with company applications, databases and technology platforms. System Development Life Cycle - Knowledge of project management techniques and the ability to plan, design, develop, test, implement and maintain system development life cycle segments and phases. Technical Troubleshooting - Knowledge of technical troubleshooting approaches, tools and techniques, and the ability to anticipate, recognize, and resolve technical (hardware, software, application or operational) problems. Technical Writing/Documentation - Knowledge of the technical language and writing approach, and the ability to write paper-based and on-line technical reference documentation (guidelines, standards, procedures, processes, applications, etc.) Work Experience Roles at this level typically require a university / college degree, with 3+ years of relevant / direct industry experience. Certifications are often desired. In lieu of a degree, a comparable combination of education and experience (including military service) may be considered. Education Bachelors Additional Job Description 1. COMPENSATION Base Salary: $55,000 to $142,600 Where a person is paid in the compensation range is aligned to their experience and skills. Placement within the compensation range is based on the specific role and the following factors: - Lower in range -Building skills and experience in the job - Within the range-Experience and skills align with proficiency in the role - Higher in range -Experience and skills add value above typical requirements of the role - Compensation Range may vary based on Geographic Location 2. INCENTIVE Role is incentive eligible with the payment based upon company, business and individual performance. 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. ArrayArrayProposes & designs software solutions to address complex business needs. Prepares technical and procedural documentation required. Facilitates complex problem resolution. Provides technical guidance and support to colleagues. Reviews coding, testing, and documentation of software. Applies modern principles, methodologies and tools to advance business initiatives and capabilities. 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. Provides detailed technical design and development of software solutions using existing and emerging technology platforms. Writes code, tests and deploys software. Prepares technical and procedural documentation required for software. Maintains and debugs software. software solutions, operational, software quality, application, ability to plan, assessing, applications, writing, project management techniques, business initiatives, system development life cycle, application software, agile, tactics, business, application design, focused, problem resolution, building, segments, software, customer needs, technical writing, application testing, mainframe, technical design, application integration, detailed, sprint planning, api, windows servers, process, enterprise risk management framework, complex problem resolution, service, support, sql server, technical application, application development tools, managing risk, Senior .Net & Web Developer - C# & ASP.Net & MVC & TFS & Sql Server & SSRS & SSIS & HTML, Database Architect & SQL Database Administrator & SQL Developer & ETL Developer, Plsql Developer, MSSQL Developer, .Net & SQL Developer, Enterprise Application Programmer & SQL Enterprise Application Programmer, Oracle PL & SQL Developer, Microsoft Business Intelligence Developer & SQL Server, Oracle SQL Developer, Senior .Net & Web Developer - C# & OOPS & Angular.js & Javascript & Linq & WCF & ASP.Net PNC Financial Services Group, Inc. Virtual WV

Data Engineer Sr.

PNC Financial Services Group, Inc.