Senior Tricentis DI Consultant; Tosca, DeX and qTest - Data integrity testing

Senior Tricentis DI Consultant (Tosca, DeX and qTest) - Data Integrity Testing

Location:

Hybrid in Miramar, FL and Dallas, TX preferred; open to remote candidates as well

Duration: 6+ months

Position

Description:

We're seeking a Senior Tosca Automation DI Consultant with expertise in test automation, CI/CD, and Center of Excellence practices. You'll be responsible for Data Integrity testing activities, tool configuration, and guiding best practices. You will be responsible for activities related to all five areas of DI test activities such as Reconciliation, Total Row Count, Change Event, Nullness & Metadata.

Future duties and responsibilities:

• 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
• 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

Required qualifications to be successful in this role:

• Minimum of 3+ years of experience using Tricentis testing automation tools:
  Tosca (required) in version 15.0 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…