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

Providence Health & Services

OB Surgical Technician - Labor and Delivery *F/T Day* Job at Providence Health & Services

 ...Surgical Technician at Providence Little Company of Mary Hospital in Torrance, CA. Positions available are full-time and will work 12-hour Day shifts. The Obstetrical Surgical Technician is a non-licensed health care employee or Licensed Vocational Nurse with additional... 

Charger Logistics Inc

Carrier Payable Manager Job at Charger Logistics Inc

Carrier Payable Manager Location Dallas, TX : Job Title: Carrier Payable Manager Location: Dallas, Texas Category: Accounting and finance...  ...payments, cheque signing). Prepare vendor cheque for mailing. Manage and create POs for various members of the organization... 

Glass Roots Construction, LLC

Fiber Optic Splicer - Denver, CO Job at Glass Roots Construction, LLC

 ...construction professionals and is in need of a Fiber Splicer to help us flourish. GRC looks to...  ...to build a first-class nationwide fiber optic utility construction firm. This position...  ..., installing aerial and underground cabling, and pulling it through conduits. Follow... 

The Staff Pad

Director of Patient Access Job at The Staff Pad

 ...Director of Patient Access Blue Ridge Medical Center Overview: The Director of Patient Access will lead initiatives to...  ...role involves improving operational efficiencies, patient experience, and revenue integrity, while collaborating with cross-functional... 

SeaBreeze Homes and Living

Admin Assistant-Work From Home Job at SeaBreeze Homes and Living

 ...Responsibilities: Booking and Coordination: Assist clients in planning and booking travel...  ...workload effectively in a remote work environment Problem-Solving: Capacity to...  ...Work: Enjoy the flexibility of working from home with a supportive team environment Competitive...