QA Analyst (Database & ETL)

Company Description

Merkle, a subsidiary of Dentsu, is a premier data-focused customer experience management firm dedicated to providing unique, personalized customer experiences across platforms and devices. With over three decades of practice, Merkle collaborates with Fortune 1000 companies and non-profit organizations to refine their customer portfolios. Harnessing expertise in data, technology, and analytics, it obtains insights into customer behavior, propelling hyper-personalized marketing approaches. Merkle's consulting, creative, media, analytics, data, identity, and customer experience/commerce, technology, and loyalty & promotion solutions synergize to enhance marketing outcomes and competitive advantage. Merkle, home to over 14,000 employees, is based in Columbia, Maryland, and maintains over 50 additional offices globally. Its innovative solutions empower brands to forge meaningful customer relationships and enrich customer experience.

Job Description

Total Experience: 5 to 8 years

Must-have skills:

1. Competency in understanding requirements and translating them into test cases and SQL test scripts
2. Capability to debug differences and document the identified issues
3. Experience in data warehouse/database testing
4. Mastery over SQL language
5. Understanding of data warehousing principles is imperative

Good to have skills:

1. Familiarity with Cloud technology and JIRA
2. Experience in testing SOAP / API projects

Roles and Responsibilities:

• Determine scope and objectives of all QA testing levels
• Author test plans, formulate test cases, develop test SQL scripts, establish testing conditions, design procedures and anticipate results
• Undertake data warehouse / Database testing
• Cover all testing aspects, including functional, regression, load, system testing, and user acceptance testing (UAT)
• Generate extensive volumes of test data if needed
• Document and report flaws using suitable tools like JIRA
• Validate solutions and pursue all testing cycles
• Examine and propose remediation strategies for quality deficits in data, and process failures
• Brief internal project team and client(s) on testing status
• Develop and impart best practices and standards for a solution or across multiple medium-to-large scale projects/accounts
• Mentor a team of two to three QA associates

Qualifications

1. Bachelor's degree in Computer Science or equivalent

Additional Information

1. Communication
2. Learnability
3. Teamwork
4. Outcome Orientation
5. Problem Solving
6. Interacting with Clients