What are the responsibilities and job description for the SDET with MongoDB position at Ekcel Technologies Inc?
SDET with Test data management strong sql and mongo or postgre sql exp
Location: Mclean, VA
Client: Hexaware Freddie Mac
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
