Automation Test Engineer (ETL/Database) Job at Algobrain, New York, NY

dDdNRFZvMURSZVE2aGZ3RHZBR0d4R3B5L3c9PQ==
  • Algobrain
  • New York, NY

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.

Job Tags

Full time, Local area, 3 days per week,

Similar Jobs

Mike Anderson Chevrolet of Chicago

Union Parts Counter Person Job at Mike Anderson Chevrolet of Chicago

 ...years. Summary:Sells parts to all customers, over the counter, through the shop or on the phone.What We Offer:* Local 731 Union Benefits* Discounts on products and services* Career advancement opportunities, promote from within* Clean and... 

Sylvan Learning Center

Reading Teacher (K-6) Job at Sylvan Learning Center

 ...and evening schedule No lesson planning, grading, or parent conferences Small group setting with no more than 4 students per teacher Fun and supportive work environment with fellow teachers and staff Enjoy the satisfaction of teaching without taking work home... 

Superbeo

Administrator - Direct Hire Job at Superbeo

 ...Position: Long Term Care Administrator (Permanent) Facility: Good Samaritan Society Location: Larimore, ND, 58251 Assignment...  ...8:00am - 5:00pm Patient Population: Skilled Nursing and Assisted Living Specialty: LTC Hiring Wage: $41 - $68 (salaried/... 

Southern New Hampshire University

Admission Counselor Job at Southern New Hampshire University

 ...initiatives. Provide insights and feedback to enhance the admission process and student experience. Requirements Bachelor's degree in a relevant field preferred. Prior experience in admissions, recruitment, or student services is a plus. Strong... 

Crystal Clear Building Services

Part-Time Evening Cleaning in Columbus Ohio Job at Crystal Clear Building Services

 ...janitorial services for industrial, commercial and construction customers throughout Northeast Ohio for the past...  ...needed Monday thru Sunday from 9pm -1am work days may vary especially if you are available for weekend work. pay rate $15.00hr. To schedule an interview...