Quality Analyst Lead -Sql Data Testing

PNC Financial Services Group, Inc. Virtual , NJ

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. As a Quality Analyst Lead within PNC's TCOE

  • ACFR organization, you will be based in Pittsburgh, PA or Cleveland, OH.

Remote opportunities to work from home may also be available for this position.

We are seeking talented individuals with advanced SQL and Java or Python

experience.

Job Responsibilities:

  • Assists in the development, testing, and implementation of software solutions.

  • Creates automation scripts for Smoke/System Integration Testing and Regression testing.

  • Assists with designing software solutions as one Team.

  • Writes code, tests and deploys software. Creates advanced level SQL queries to validate ETL transmissions and validate functional requirements.

  • Participates in the quality assurance process; follows procedures to ensure that all software products and components meet company standards and client requirements.

  • Performs automation code inspections, walk-throughs, design, and test-readiness reviews.

  • Reviews software and project documentation for completeness and adherence to standards.

  • Works on problem resolutions and reports progress to management. Plans, executes, and summarizes reliability and validation test cases, interfaces with developers on test results.

  • Assists in audits and reviews. Writes and executes test plans and cases for testing of software.

  • Perform installations and run quality assurance programs to test, identify, reproduce, debug, and report defects in software.

  • Conduct a wide range of quality control and systematic tests and analyses to develop software and ensure that it meets or exceeds specified standards for company products.

  • Design, develop, maintain and execute the automated test scripts using automation tools, and enhance the quality of the application under test.

  • Execute the regression scripts to identify both functional and nonfunctional defects for each release, report and track the defects to its closure with project teams.

  • Draft, modify and execute test plans and automated scripts to ensure alignment with standards and IT strategy. Analyze and write test standards and procedures by creating records to thoroughly test program logic and verify system flow.

  • Analyze the web-based front-end and Identity and Access Management applications to implement the automation.

  • Create Selenium scripts using JAVA for functional testing of web-based applications and add, modify, execute and maintain the automated scripts for each release. Coordinate with users to plan user acceptance, alpha and beta testing. Provides feedback in preparation of technical appraisals of programming languages, systems, and computation software.

  • Share automated and manual test results, Coordinate with Line of Business for the User Acceptance Testing, Assist LOB teams in functional validation and reporting in ALM.

  • Conduct Alpha testing before release in QA environment, Prepare the test summary report at the testing completion that consists of requirement traceability matrix, test execution status, number of test cycles and defects summary.

  • Ensures quality computer integration into the overall functions of scientific computation, data acquisition, and processing.

  • Achieve the maximum quality of the software product by testing complex logical algorithms, extensive mathematical calculations, processing of the data at multiple stages, upstream - downstream integrations etc.

  • Ensure the quality is achieved at every stage of Software Test Life Cycle and Defect Life Cycle.

The preferred candidate will have the following experience and skills:

  • Analytical and problem-solving skills.

  • Advance SQL, ETL testing experience.

  • Python or Java skills essential.

  • Strong communication, presentation, facilitation skills.

  • Strong leadership and mentoring experience.

  • Data Analytics and ETL transmission understanding required.

  • Experience with Agile and DEVOPS is required.

  • Understand Business requirements and guidelines for the products.

  • Able to work independently and collaboratively with limited supervision

  • Excellent written and verbal communication skills

Job Description

  • Coordinates and administers quality control program within a defined department of the organization.

  • Coordinates control plans, inspection systems, and action plans to achieve expected results.

  • Leads, mentors and develops team members to promote quality awareness and implement quality programs and initiatives.

  • Executes corrective actions and addresses non-conformances.

  • Facilitates or leads training on quality tools and skills.

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

Accuracy and Attention to Detail

  • Understanding of the necessity and value of accuracy and attention to detail; ability to process information with high levels of accuracy.

Analytical Thinking

  • Knowledge of techniques and tools that promote effective analysis and the ability to determine the root cause of organizational problems and create alternative solutions that resolve the problems in the best interest of the business.

Coaching Others

  • Knowledge of coaching concepts and methods; ability to encourage, motivate, and guide individuals or teams in learning and improving effectiveness.

Customer Support Policies, Standards and Procedures

  • Knowledge of the organization's customer support policies, standards and procedures and ability to guide customers on all company interactions.

Data Gathering and Reporting

  • Knowledge of and ability to utilize tools, techniques and processes for gathering and reporting data in a particular department or division of a company.

Internal Controls

  • Knowledge of and ability to create, implement, evaluate and enhance processes in internal controls.

Quality Management

  • Knowledge of quality management methods, tools, and techniques used to create and support an environment that meets the needs of the organization.

Regulatory Environment

  • Financial Services

  • Knowledge of and ability to help an organization adapt to applicable federal, state, local, and company-specific regulations, policies, and guidelines affecting business practices.

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 (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.

ArrayArrayAs a Quality Analyst Lead within PNC's TCOE

  • ACFR organization, you will be based in Pittsburgh, PA or Cleveland, OH. Assists in the development, testing, and implementation of software solutions. Creates automation scripts for Smoke/System Integration Testing and Regression testing. Assists with designing software solutions as one Team. Writes code, tests and deploys software. Creates advanced level SQL queries to validate ETL transmissions and validate functional requirements. Participates in the quality assurance process; follows procedures to ensure that all software products and components meet company standards and client requirements. Performs automation code inspections, walk-throughs, design, and test-readiness reviews. Reviews software and project documentation for completeness and adherence to standards. Works on problem resolutions and reports progress to management. Plans, executes, and summarizes reliability and validation test cases, interfaces with developers on test results. Assists in audits and reviews. Writes and executes test plans and cases for testing of software. Perform installations and run quality assurance programs to test, identify, reproduce, debug, and report defects in software. Conduct a wide range of quality control and systematic tests and analyses to develop software and ensure that it meets or exceeds specified standards for company products. Design, develop, maintain and execute the automated test scripts using automation tools, and enhance the quality of the application under test. Execute the regression scripts to identify both functional and nonfunctional defects for each release, report and track the defects to its closure with project teams. Draft, modify and execute test plans and automated scripts to ensure alignment with standards and IT strategy. Analyze and write test standards and procedures by creating records to thoroughly test program logic and verify system flow. Analyze the web-based front-end and Identity and Access Management applications to implement the automation. Create Selenium scripts using JAVA for functional testing of web-based applications and add, modify, execute and maintain the automated scripts for each release. Coordinate with users to plan user acceptance, alpha and beta testing. Provides feedback in preparation of technical appraisals of programming languages, systems, and computation software. Share automated and manual test results, Coordinate with Line of Business for the User Acceptance Testing, Assist LOB teams in functional validation and reporting in ALM. Conduct Alpha testing before release in QA environment, Prepare the test summary report at the testing completion that consists of requirement traceability matrix, test execution status, number of test cycles and defects summary. Ensures quality computer integration into the overall functions of scientific computation, data acquisition, and processing. Achieve the maximum quality of the software product by testing complex logical algorithms, extensive mathematical calculations, processing of the data at multiple stages, upstream - downstream integrations etc. Ensure the quality is achieved at every stage of Software Test Life Cycle and Defect Life Cycle. Understand Business requirements and guidelines for the products. Coordinates and administers quality control program within a defined department of the organization. Coordinates control plans, inspection systems, and action plans to achieve expected results. Leads, mentors and develops team members to promote quality awareness and implement quality programs and initiatives. Executes corrective actions and addresses non-conformances. Facilitates or leads training on quality tools and skills. 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. Quality Management

  • Knowledge of quality management methods, tools, and techniques used to create and support an environment that meets the needs of the organization. applications, problem resolutions, etl testing, functional testing, facilitation skills, project, automation, sql queries, advanced sql, web-based applications, quality assurance process, sql, regression testing, implementation, user acceptance testing, automated test scripts, application, support, supervision, quality management methods, customer needs, traceability matrix, front-end, coaching, systematic, automation tools, functional requirements, learning, presentation, java, test execution, attention to detail, analytical thinking, alm, data gathering, software solutions, work independently, assessing, etl, programming languages, design, quality management, managing risk, quality tools, regression, focused, system integration testing, software, organizational, business requirements, algorithms, access management applications, service, validation, problem-solving skills, verbal communication skills, business, analytical, beta testing, software test, integrations, mentoring, debug, leadership, enterprise risk management framework, selenium scripts, process, communication, agile, defect life cycle, it strategy, devops, training, strong communication, python, software test life cycle, action, strong leadership, data acquisition, data analytics, Implementation & Database Testing Quality Analyst Lead, Business System Analyst

  • EPC Data Governance, XML Data Quality Analyst, Business System Analyst Business Intelligence, Business Analyst

  • Sql Server, Java Developer & Jasper Report Developer, Business & System Analyst EDP, Business Analyst

  • Web Services, Test Automation

  • System Analyst, Lead Data Architect

  • Big Data & Statistical Analysis System & Hadoop

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
Project Management Analyst (Remote)

Pgim Global Short Duration High Yield Fund, Inc.

Posted 4 days ago

VIEW JOBS 1/23/2022 12:00:00 AM 2022-04-23T00:00 Job Classification: Project Mgmt, Transformation & Strategy - Project Mgmt, Transformation & Strategy Job Description The incumbent is responsible to support the disability claim management team, account management team and sales team by handling client/claim related matters with a focus on customer satisfaction as an expert in a product line. May review claims to assure claim management is reflective of our disability claim management decision making process. Leads initiatives to conduct research and analysis to identify business opportunities and to ensure that the business is prepared for change. Incumbent will interface with internal and external clients. . Qualifications 3-5 years of disability claim management expertise preferred Vendor oversight experience a plus Experience interfacing with Disability Claim Operation, Sales, Account Management and Clients Excellent communication skills, both verbal and written Excellent relationship building and partnership skills Ability to create, document and execute plans Ability to multitask and meet deadlines with quick turnaround time Excellent organization skills and high level of work discipline Ability to manage issues/problems from identification through resolution Presentation and/or training experience Experience with Visio, Excel and other Microsoft software Job responsibilities Biweekly customer calls Monthly Regular calls with Vendor Monthly customer audits Day to day liaison for Vendor STD team Quarterly Audits for remainder of Absence One Program Coverage for Vendor Relationship Manager Supportive role in strategic initiatives related to strategic partnership with Vendor * Note: Prudential is required by Colorado law to include the salary range for this role when hiring a Colorado resident. Salary range specific to Colorado: $69,600 - $94,200 + discretionary incentive bonus + benefits. Eligibility to participate in a discretionary annual incentive program is subject to the rules governing the program, whereby an award, if any, depends on various factors including, without limitation, individual and organizational performance. In addition, employees are eligible for standard benefits package including paid time off, medical, dental and retirement. RSRPRUD * Prudential Financial, Inc. of the United States is not affiliated with Prudential plc. which is headquartered in the United Kingdom. Prudential is a multinational financial services leader with operations in the United States, Asia, Europe, and Latin America. Leveraging its heritage of life insurance and asset management expertise, Prudential is focused on helping individual and institutional customers grow and protect their wealth. The company's well-known Rock symbol is an icon of strength, stability, expertise and innovation that has stood the test of time. Prudential's businesses offer a variety of products and services, including life insurance, annuities, retirement-related services, mutual funds, asset management, and real estate services. We recognize that our strength and success are directly linked to the quality and skills of our diverse associates. We are proud to be a place where talented people who want to make a difference can grow as professionals, leaders, and as individuals. Visit www.prudential.com to learn more about our values, our history and our brand. Prudential is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, national origin, ancestry, sex, sexual orientation, gender identity, national origin, genetics, disability, marital status, age, veteran status, domestic partner status , medical condition or any other characteristic protected by law. The Prudential Insurance Company of America, Newark, NJ and its affiliates. Note that this posting is intended for individual applicants. Search firms or agencies should email Staffing at staffingagencies@prudential.com for more information about doing business with Prudential. PEOPLE WITH DISABILITIES: If you need an accommodation to complete the application process, which may include an assessment, please call (800) 433-8960, prompt 4 or email accommodations.hw@prudential.com. Please note that the above number and email are solely for individuals with disabilities requesting an accommodation. If you are experiencing a technical issue with your application or an assessment, please email careers.technicalsupport@prudential.com to request assistance. Pgim Global Short Duration High Yield Fund, Inc. Virtual Office NJ

Quality Analyst Lead -Sql Data Testing

PNC Financial Services Group, Inc.