What are the responsibilities and job description for the Automation Test Engineer (ETL/Database) position at Algobrain?
Job Description
Job Description
This is a 3-4 days a week onsite opportunity
Only local candidates will be considered
Our client is seeking a highly skilled Automation and Functional Tester with 4-8 years of experience to join our dynamic team. The ideal candidate will possess a strong background in automation testing, functional testing, ETL / database testing, and API testing. The candidate should also have experience with various testing tools and methodologies, particularly in Agile environments.
Responsibilities : Automation Testing :
Build, maintain, and enhance Playwright / Selenium test suites using TypeScript or Java.
Develop automation scripts in languages such as Python or Java for efficient test execution.
Functional Testing :
Execute end-to-end functional testing to ensure comprehensive test coverage.
Perform E2E testing across various stages from ETL processes to user interface validation.
ETL / Database Testing :
Conduct data validation and backend testing on SQL Server, MySQL, and NoSQL databases (e.g., MongoDB, Cassandra).
Automate data pipeline testing from SQL to NoSQL databases, ensuring data integrity and accuracy.
Perform testing related to Redshift, Data Warehousing (DWH), Datamarts, and ETL processes.
SQL Proficiency :
Write and execute medium to complex SQL queries for data validation and testing purposes.
Understand and interpret stored procedures (SP code) as part of the testing process.
Requirement and Impact Analysis :
Collaborate with stakeholders to analyze requirements and assess the impact on upstream and downstream systems.
Demonstrate a strong understanding of data workflows and their implications on testing activities.
BI Reporting Testing :
Conduct testing on Business Intelligence (BI) reports, dashboards, and self-service reporting tools to ensure data accuracy and functionality.
Version Control :
Manage codebase and test scripts using Git to ensure version control and collaboration.
Test Management :
Organize test cases in QTest and integrate testing activities with CI / CD processes using Bitbucket and Bamboo.
API Testing :
Perform API testing using Postman and engage in API automation testing to validate endpoints and data responses.
Agile Methodologies :
Work within Agile principles, utilizing JIRA for bug tracking and management of testing tasks.
Participate actively in Scrum ceremonies and contribute to continuous improvement initiatives.
Tools :
Utilize tools such as Confluence, Bitbucket, JIRA, and QTest for documentation, collaboration, and test management.
Requirements :
Bachelor's degree in Computer Science, Information Technology, or a related field.
4-8 years of relevant experience in automation and functional testing.
Proficiency in automation testing tools (Playwright, Selenium) and programming languages (TypeScript, Java, Python).
Strong experience in ETL testing, data validation, and database testing (SQL, NoSQL).
Familiarity with BI reporting tools and experience in testing dashboards and reports.
Solid understanding of Agile methodologies and experience with JIRA.
Excellent analytical, problem-solving, and communication skills.
Ability to work collaboratively in a fast-paced environment.
Keep a pulse on the job market with advanced job matching technology.
If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution.
Compensation Planning
Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right.
Surveys & Data Sets
What is the career path for a Automation Test Engineer (ETL/Database)?
Sign up to receive alerts about other jobs on the Automation Test Engineer (ETL/Database) career path by checking the boxes next to the positions that interest you.
