Data Validation Tester

Title: Data Validation Tester
Hybrid

Responsibilities:

• Develop and execute test plans, test cases, and test scripts to test AWS Data Lake project like data pipeline, data validation between source and destination.
• Develop test plans, test cases, and test scripts for comparing CSV files for multiple datasets.
• Very transformation logic and mapping of ETL pipelines.
• Write complex SQL queries to compare source and target data.
• Develop test plans, test cases, and test scripts for system integration testing.
• Develop test plans, test cases, and test scripts for APIs based on functional and non-functional requirements.
• Perform functional, regression, and performance testing to identify software defects and verify fixes.
• Isolate issues and create succinct & precise reproduction steps when reporting defects.
• Develop and maintain test documentation including test plans, procedures, reports, etc.
• Collaborate with cross-functional teams to facilitate knowledge sharing and future testing efforts.
• Participate in Agile ceremonies for requirement reviews, sprint planning, retrospectives etc. to provide input on testability and quality considerations.
• Provide support for troubleshooting and debugging issues in test and production environments.
• Maintain and communicate testing timelines, schedules, and status reports.
• Identify opportunities for process improvement and contribute to the enhancement of testing methodologies and best practices.

Skills & Experience:

• 8+ years of experience as QA Analyst or Test Engineer.
• 5+ years of experience with Test Case Development and Execution for software testing.
• 5+ years of strong SQL skill for writing complex queries to compare source and target data.
• 3+ years of experience with testing AWS Data Lake and Data pipelines
• Experience with ALM Octane is a plus.
• Must have experience updating Requirements Traceability Matrix (RTM) to ensure that all the requirements are tested.
• Experience managing defect resolution.
• Experience developing a daily status report showing testing progress and defect resolution progress.
• Experience with ServiceNow is a plus.
• Proficient analytical and problem-solving skills with a keen attention to detail.
• Excellent communication and interpersonal skills with the ability to collaborate effectively with cross-functional teams.
• Ability to work independently and prioritize tasks in a fast-paced start-up like environment.