What are the responsibilities and job description for the SDET with Data background position at Visionary Innovative Technology Solutions LLC?
Position: SDET with Data background
Location: McLean, VA Hybrid (3 days onsite)
Duration: 6 Month
Responsibilities:
- Test Data Management: Design, generate, and maintain high-quality test data for different testing scenarios, including functional and regression testing.
- Database Management: Utilize SQL, PostgreSQL, and MongoDB to query, manipulate, and create test data sets. Ensure data is properly synced across various environments.
- Data Refresh & Synchronization: Develop and implement strategies for regular data refreshes and data synchronization across testing environments to ensure accuracy and consistency of data.
- Automation: Build and maintain automated test data generation processes and workflows to optimize efficiency in the testing process.
- Data Integrity & Quality Assurance: Ensure that test data meets the defined criteria for test case execution and that it remains accurate and consistent across systems.
- Collaboration: Work closely with QA teams, developers, and other stakeholders to understand testing requirements and provide appropriate test data solutions.
- Issue Resolution: Troubleshoot and resolve data-related issues that arise during testing, ensuring minimal impact on the testing cycle.
- Documentation & Reporting: Document test data generation processes, data flow, and changes to ensure a clear understanding for team members. Report on the status of data availability, refreshes, and sync processes.
Skills:
- Strong SQL skills: Ability to write complex queries and work with relational databases. Experience with optimizing queries.
- Experience with NoSQL databases: Familiarity with MongoDB and other NoSQL databases for handling unstructured or semi-structured data.
- Data Synchronization & Refresh: Knowledge of data refresh cycles and synchronization processes across different environments to ensure that testing systems reflect real-world data.
- Test Data Automation: Experience with automation tools or custom scripts to generate and manage test data efficiently (e.g., using Python, Java, or Bash scripting).
- Experience with CI/CD pipelines : Familiarity with integrating data generation processes into continuous integration/continuous deployment (CI/CD) pipelines to support agile testing workflows.
- Knowledge on UI Test automation tool like cypress, API automation is a big plus
