Line of Service
Advisory
Industry/Sector
Not Applicable
Specialism
Managed Services
Management Level
Senior Associate
Job Description & Summary
At PwC, our people in software and product innovation focus on developing cutting-edge software solutions and driving product innovation to meet the evolving needs of clients. These individuals combine technical experience with creative thinking to deliver innovative software products and solutions.
In testing and quality assurance at PwC, you will focus on the process of evaluating a system or software application to identify any defects, errors, or gaps in its functionality. Working in this area, you will execute various test cases and scenarios to validate that the system meets the specified requirements and performs as expected.
Focused on relationships, you are building meaningful client connections, and learning how to manage and inspire others. Navigating increasingly complex situations, you are growing your personal brand, deepening technical expertise and awareness of your strengths. You are expected to anticipate the needs of your teams and clients, and to deliver quality. Embracing increased ambiguity, you are comfortable when the path forward isn’t clear, you ask questions, and you use these moments as opportunities to grow.
Examples of the skills, knowledge, and experiences you need to lead and deliver value at this level include but are not limited to:
- Respond effectively to the diverse perspectives, needs, and feelings of others.
- Use a broad range of tools, methodologies and techniques to generate new ideas and solve problems.
- Use critical thinking to break down complex concepts.
- Understand the broader objectives of your project or role and how your work fits into the overall strategy.
- Develop a deeper understanding of the business context and how it is changing.
- Use reflection to develop self awareness, enhance strengths and address development areas.
- Interpret data to inform insights and recommendations.
- Uphold and reinforce professional and technical standards (e.g. refer to specific PwC tax and audit guidance), the Firm's code of conduct, and independence requirements.
Job Summary:
QCOE Test Automation DI (Data Integrity) Architect
PwC Enterprise Testing Managed Service team is looking for a Senior Tosca Automation DI Consultant in the areas of testing tools, CI/CD integration, and Center of Excellence Experience. The candidate will primarily be responsible for activities related to all five areas of DI test activities such as Reconciliation, Total Row Count, Change Event, Nullness & Metadata. He/she may be asked to perform additional architectural activities including but not limited to configuring the testing systems/tools, integrating with the other systems, developing standards and best practices, developing test case automation, and providing oversight, guidance, and enforcement to other areas in their test management DI automation journey.
Primary Duties of the Position:
- Configure, support, and maintain the Tosca DI integrated with Tosca, DeX and qTest
- Configure and develop to test database queries and file tests of the Data ETL systems such as Data Bricks, Teradata & DB2
- Build and carry out pre-screening file tests, field tests and more to ensure a high level of data integrity in the NS data ecosystem.
- Develop the Reconciliation tests for the Dataset comparisons
- Develop the Tests to identify the delta changes between the source and target after the Data migration.
- Develop the parallel execution methodology for reconciliation testing in the active data migration stage between source and target database systems.
- Design and develop the automation framework using DI for the day-to-day data ETL testing life
- Develop the Integration between the Databases on-prem and Cloud for testing/verification purposes
- Develop the Test cases in DI and automate them in Tosca to run in DeX to support the post migration efforts for the Row counts test when there is a change event occurred in the source data.
- Design and develop key reports to reflect the key metrics of the Data testing for the Management purposes.
- Design and Develop the DI Monitoring procedures
- Coordinate with vendors for Core Systems and Integrated Systems for support activities and triage of issues.
- Represent the Quality COE team for the projects assigned by team management
- Provide product training and guidance for Core Systems and Integrated systems
- Research/architect/design/implement new testing technologies and integrations related to Tosca DI
- Additional Test Engineer duties:
- Adopt and utilize the best practices and standard processes established by the QCOE for test management and test execution
- Lead discussions and actively communicate with test lead, scrum master, project manager, business partners, and application developers for test management and test development activities
- Decompose user stories to develop and design robust test cases and complete test scenarios
- Report bugs in Jira linked to qTest project
- Execute automated test cases in Tosca leveraging existing integrated technologies such as DEX, qTest/Launch, Sauce Labs, Jenkins CI/CD pipelines, and others as defined
- Coordinate with the QCOE for peer review of test design strategy, automated test cases, and adoption/adherence of standards and best practices
- Perform/support unit testing, integration testing, regression testing, and user acceptance testing activities
- Performance testing and/or support of performance testing may be required
- Adopt/adhere to execution of RTM (Requirements Traceability Matrix) in qTest to ensure proper requirements to test case coverage
- Identify the gaps in the test cases and create the missing requirements / test cases for the gaps
- Provide product, skill training and best practices knowledge to other team members for test management and automation
Education:
Bachelor's degree or job-related experience as outlined above
Job Related Experience:
Minimum of 5 years in test management areas and test automation with Tosca DI experience.
The following certificates are a must:
- Tricentis
- Tosca DI Architect Specialist
- Automation Specialist Level 1
- Automation Specialist Level 2
- Test Design Specialist Level 1
- Test Design Specialist Level 2
- Automation Engineer Level 1
- Automation Specialist for API
- Automation Engineer Level 2
- Tosca Integration Developer
- Test Architect Level 1
- Tosca Query Language
Exposure to Java, C#, Selenium, Appium, Webservices/API are preferrable
Experience in using Jira system for all integration requirements of qTest / Tosca
Required:
- Minimum of 3+ years of experience using Tricentis testing automation tools: Tosca (required) in version 2023.1 and above, including such skills as SQL, CI/CD integration, Git, Agile in Android and IOS applications (on Ionic Framework)
- Minimum of 2+years of experience using Tricentis DI tool with broad knowledge in both cloud and on-prem data ETL processes
- Minimum of 3+ years of experience leveraging DEX environment from Tosca; create the queues, analyzing the issues within DEX environment and developing best practices using DEX in sharable environment
- 3+ years of experience and proficiency developing, implementing, and executing data-driven or keyword driven testing frameworks using testing tools like Selenium, Coded UI Test (CUIT), Unified Functional Test (UFT), etc. to facilitate test automation
- 5+ years of experience and proficiency in implementing and executing testing strategies, plans, methodologies, and frameworks in support of Agile / SAFe / DevOps / DevSecOps development methodologies
- Define / Develop test strategies, test plans, KPI’s, metrics, defect management and reporting
- Must be able to lead meetings with other application tester teams for QCOE oversight
- Ability to translate requirements / user stories into in-depth test cases
- Ability to define / develop data management strategy and plans
- Ability to define / develop individual as well as end-to-end test scenarios
- Strong cross functional collaboration
- Must be a self-starter with an ability to work with limited oversight
- Must be able to work with remote / global team successfully
Desired:
- Experience with SAP ECC and S4 Hana database Tosca DI testing/validation
- Experience with Databases like Data Bricks, Teradata for Data migration
- Experience with HTML, CSS
- Working experience with Agile methodologies (SCRUM)
- Working experience with Jira
- Exposure to Java, C#, Selenium, Appium, Webservices/API are preferrable
- Excellent communication (written and oral) and interpersonal skills
- Strong analytical skills, detail oriented, and ability to troubleshoot issues and provide solutions
- Shows initiative and goes above and beyond to assist others as needed
- In-depth understanding of industry standards
Soft Skills:
- Good verbal and written communication in English
- Team player spirit is a must
- Flexibility to work with multiple assignments as directed by the team management
- Committed, positive and creative mindset
- Good presentation skills and ability to engage/drive/lead meetings with the audience on the meetings in positive way even when conflict arises
Required Skills
Optional Skills
Acceptance Testing, Acceptance Testing, Accepting Feedback, Active Listening, Analytical Thinking, Automated Testing, Automation Testing, Communication, Creativity, Data Model Testing, Debugging, Defect Management, Documentation Testing, Embracing Change, Emotional Regulation, Empathy, Fault Analysis, Functional Testing, Inclusion, Intellectual Curiosity, Learning Agility, Optimism, Performance Testing, Problem Diagnosis, Programming Languages {+ 19 more}
Desired Languages (If blank, desired languages not specified)
Travel Requirements
Not Specified
Available for Work Visa Sponsorship?
No
Government Clearance Required?
Yes
Job Posting End Date