Automation/ETL Testing Engineer

Hi,

I hope you are doing well!

We have an opportunity “Automation/ETL Testing Engineer” with one of our clients for “NYC,NY”

Please see the job details below and let me know if you would be interested in this role.

If interested, please send me a copy of your resume, contact details and a good time to connect with you.

Title: Automation/ETL Testing Engineer

Location: NYC,NY

Contract

We are 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.

Key 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.

Qualifications:

• 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.

Thanks & Regards

S.K.Singh