SDET with Data

Job Description:-

Required skills

• Must have 7+ years of exp 
• Strong proficiency in SQL
• Experience with MongoDB and MongoDB Compass
• Familiarity with data synchronization and refresh tools such as Delphix or similar
• Knowledge of PostgreSQL is a plus
• Automation experience, including scripting and process automation
• Programming skills in Java, JavaScript, or Python
• Excellent communication skills
• Experience with CI/CD pipelines is a plus
• 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