Title: Data Validation Tester
Duration: Full time
Location: Newark, NJ (Hybrid. As needed to go onsite 3 days a week)
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.