Developer in Test II
- Chennai, Tamil Nadu
- Permanent
- Full-time
- Collaborate with the QA team and developers to define the overall testing strategy, test plans, and test cases.
- Creating and managing test data, especially for complex scenarios, to ensure thorough testing.
- Identify, report, and track defects, working closely with the development team to facilitate timely resolution.
- Conduct performance and load testing to identify bottlenecks and optimize ETL performance.
- Maintain comprehensive test documentation, including test plans, test cases, and test results.
- Reviewing test cases and scripts to ensure they are effective and meet quality standards.
- Create and inject synthetic and permutation-based test data to thoroughly test positive, negative, and error scenarios, as well as new and existing logic.
- Perform various types of testing, including standard testing, comparison testing, error handling, performance testing, end-to-end testing, and security testing.
- Develop and execute comprehensive test plans specifically for data pipelines, ETL processes, and data warehouse solutions, identifying optimal test cases for data completeness, integrity, and corner cases.
- Create comprehensive test-related documents, including data validation reports and test summaries, and effectively communicate test results, data quality issues, and other relevant information to data stakeholders and team members.
- Guide users through User Acceptance Testing (UAT) for data products and reports, ensuring they understand data validation points and how to provide valuable feedback on data accuracy.
- Review automated test results, investigate failures, identify root causes, write detailed bug reports, track defects, and drive bug triage by prioritizing issues and providing clear reproduction steps.
- Create and maintain test data for current and future regression testing.
- Collaborate with development teams to integrate automated tests into the CI/CD pipeline.
- Lead and execute data and data warehouse QA efforts, ensuring the completeness, integrity, and accuracy of data across various systems, including on-premise to cloud migrations.
- Develop and maintain automated test scripts for data validation using scripting languages and automation frameworks (e.g., Playwright) to ensure the continuous quality of data assets.
- Continuously improving test scripts and automation processes to enhance efficiency and effectiveness.
- Provide guidance and mentorship to junior members of the Testing team, sharing knowledge and best practices.
- 6-12 years of experience in ETL testing and Data Validation.
- Proven experience in establishing and executing QA processes within a development team.
- Experience in test automation using tools like Selenium, Playwright, Pytest, or similar.
- Proficiency in SQL, Scripting for data validation and test case data comparison.
- Experience with automation frameworks (e.g., Playwright) for automating data-related tests.
- Strong analytical, problem-solving and Communication skills.
- Excellent analytical skills with a keen eye for detail.
- Knowledge of Kafka, Master Data Management, Data Warehousing and Business Intelligence architecture.
- Experience in automation testing for ETL workflows.
- Understanding of CI/CD pipelines in a data context.
- Familiarity with cloud-based data storage solutions and best practices.
- Solid understanding of API testing tools and techniques.
- Relevant certifications (e.g., ISTQB, Selenium WebDriver) a plus.
- Understanding of the transportation/global logistics industry.
- Team Manager, Enterprise Data & Analytics
- Paid Vacation, Holiday
- Health Plan: Medical Insurance
- Employee Stock Purchase Plan
- Training and Education Programs
- Unlimited opportunities for career advancement