ETL QA Analyst

Highbrow LLC; Remote; EUR 50.000 - 70.000; Vollzeit

Zusammenfassung

A tech consulting firm is seeking an experienced ETL QA Analyst to work remotely. The role involves reviewing specifications, developing test scenarios, and analyzing test results, with a strong emphasis on ETL, SQL, and data warehouse testing. Ideal candidates will have a background in automation and cloud technologies. Join a dynamic team dedicated to quality assurance in data management.

Qualifikationen

• Hands-on experience with testing in ETL and Data warehouse.
• Strong SQL skills and experience in testing SQL reports.
• Experience with automation tools and Jira, Scrum, Kanban.

Aufgaben

• Review and analyze functional and design specifications documents.
• Involve in test planning, writing test cases/scripts, and test execution.
• Independently create Test Scenarios & Test Cases.

Kenntnisse

ETL testing

Data warehouse

SQL skills

Experience with DBT

Data analysis

Power BI

Jira

Automation tools

Cloud technologies

Tools

Validator

SQL reports

SSRS

Jobbeschreibung

Job Title: ETL QA Analyst

Job ID: 2023-12357

Job Location: Remote (EST or CST)

Job Travel Location(s):

# Positions: 1

Employment Type: W2

Candidate Constraints:

Duration:Long term

# of Layers:0

Work Eligibility:All Work Authorizations are Permitted – No Visa Transfers

Key Technology:ETL, Data Warehouse, SQL, Power BI

Job Responsibilities:

• Review and analyze functional and design specifications documents
• Identify test requirements from design document and mapping documents
• Involve in test planning, writing test cases/scripts, creating reusable test data, test case automation, and test execution
• Develop automation test scenarios and enhance automation test platform
• Create and facilitate test plans/reviews with team
• Execute manual and automated test cases
• Manage UAT
• Enhance existing Test scripts, identify end-to-end test scenarios
• Independently create Test Scenarios & Test Cases
• Use gathered data to analyze test results and trends

Skills and Experience Required:

Required:

• Hands on experience with testing in ETL and Data warehouse.
• Hands on with ETL tools like DBT.
• Strong SQL skills and strong experience in testing SQL reports, paginated reports, etc.,
• Must be able to understand stored procs, PL/SQL (Nice to have coding skills).
• Strong experience in data warehouse concepts and Snowflake or similar databases.
• Good experience in data analysis, data profiling, preparing test data, etc.,
• Prior experience working on migration projects.
• Experience with Power BI and SSRS.
• Experience with Jira, Scrum, and Kanban.
• Experience in automation tools like Validator.
• Experience documenting QA efforts such as acceptance criteria, Source-target mapping, RTM, test plans, test cases, test results, bug reporting, etc.,
• Experiencing working independently as a full QA resource and adaptability to work in multiple teams at the same time.
• Rich experience in functional, integration, end to end, regression, performance, and user acceptance testing.
• Experience in cloud technologies.
• Experience with XML.
• Experience with MS Office.
• Experience in handling health data.