QA Analyst (DB & ETL)

dentsu
1 month ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior
Compensation
£ 39K

Job location

Tech stack

API
JIRA
Cloud Computing
ETL
Data Warehousing
Database Testing
Software Debugging
Simple Object Access Protocol (SOAP)
SQL Databases
System Testing
Test Data
Information Technology

Job description

  • Define scope and objectives of all levels of QA testing
  • Write test plans, design test cases, develop test SQL scripts, test conditions, test procedures and expected results
  • Work on DWH / Database testing
  • Perform all aspects of testing, including functional, regression, load, system testing, and user acceptance testing (UAT)
  • Create large volumes of test data if required
  • Track and reports defect using appropriate tools such as JIRA
  • Validate fixes and ensure follow through to all test cycles
  • Investigate and recommend remediation strategies for data quality conditions, and process failures
  • Communicate test status to internal project team and clients(s)
  • Develop and contribute best practices and standards for a solution or across multiple medium/large scale projects/accounts
  • Mentoring a team of 2 to 3 QA Associates

Requirements

  • Ability to understand Requirements and translate them into test cases and test SQL scripts
  • Ability to debug the differences and document the issues identified
  • Experience in DWH/Database Testing
  • Proficiency with SQL language
  • Knowledge of DataWarehousing principles is essential

Good to have Skills :

  • Familiarity with Cloud technologies & JIRA
  • Experience with testing SOAP / API projects, * Bachelor's degree in Computer Science or equivalent, * Communication
  • Learnability
  • Teamwork
  • Result Orientation
  • Problem Solving
  • Client interaction

About the company

Merkle, a dentsu company, is a leading data-driven customer experience management enterprise specializing in delivering unique, personalized customer experiences across platforms and devices. With over 30 years of experience, Merkle partners with Fortune 1000 companies and non-profit organizations to optimize their customer portfolios. Its expertise in data, technology, and analytics enables it to gain insights into consumer behavior, driving hyper-personalized marketing strategies. Merkle's consulting, creative, media, analytics, data, identity, CX/commerce, technology, and loyalty & promotions capabilities combine to drive improved marketing results and a competitive edge. With over 14,000 employees, Merkle is headquartered in Columbia, Maryland, with more than 50 additional offices worldwide. Its innovative solutions enable brands to build meaningful customer relationships and enhanced customer experience.

Apply for this position