ETL QA Analyst

Job Title: ETL QA Analyst

Job ID:

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.