SENIOR QUALITY ANALYST

Merkle; New Delhi; On-site; INR 1,400,000 - 2,200,000; Full time

Job summary

Merkle is seeking a Lead QA in Pune to ensure software quality across the project release cycle. The role focuses on DWH and database testing, SQL/ETL verification, and cloud-enabled QA initiatives. The candidate will mentor 2-3 QA Associates and coordinate with cross-functional teams.

Responsibilities include crafting test plans, designing SQL scripts, and overseeing functional/regression/UAT testing, while ensuring high-quality data outcomes and process improvements in a fast-paced environment.

Qualifications

• Bachelor’s or Master Degree or equivalent IT field
• Professional experience in QA for data/ETL projects is required
• Experience leading QA initiatives and mentoring a small team

Responsibilities

• Define scope and objectives of QA testing at all levels
• Write test plans and SQL scripts, design test cases and expected results
• Lead QA planning, determine requirements, scope and estimates
• Ensure comprehensive test coverage (positive/negative/edge cases)
• Log defects with priorities, drive to closure and root-cause analysis
• Perform DWH/Database testing and various testing types (functional, regression, load, UAT)
• Validate fixes across test cycles and remediation strategies for data quality
• Communicate test status to project team and clients
• Develop best practices for QA across multiple projects/accounts
• Mentor a QA team of 2-3 members

Skills

DWH testing

SQL/ETL testing

SQL proficiency

ETL tools

Azure cloud

JIRA & Agile

Communication skills

Root cause analysis

Test planning

Education

Bachelor’s or Master’s degree in IT or related field

Tools

JIRA

Azure

Snowflake

Job description

Job Description:

Job Description:

Job Description

Details

Project Details

Comments

Business Title

Lead QA

Years of Experience

Min 6 and max upto 10.

Job Descreption

The purpose of this role is to ensure the developed software meets the client requirements and the business’ quality standards within the project release cycle and established processes. To lead QA technical initiatives in order to optimize the test approach and tools.

Must have skills

• 1.Experience & Knowledge in DWH and Database Testing
• 2. SQL and ETL testing knowledge
• 3.Debug the differences and document the issues identified
• 4.Understand Requirements and translate them into test cases
• 5.Proficiency with SQL language and Data Warehousing principles
• 6. Any ETL Tool knowledge
• 7.Experience on Cloud technologies AZURE prefered.
• 8. Experience on JIRA and Agile
• 9.Good Communication skills

Good to have skills

• 1.Familiarity with Cloud technologies
• 2.Working experience on JIRA and Agile
• 3.Experience with testing SOAP / API projects
• 4.Stakeholder communication
• 5. Microsoft Office

Key responsibiltes

• 1. Define scope and objectives of all levels of QA testing.
• 2. Write test plans, design test cases, develop test SQL scripts, test conditions, test procedures and expected results
• 3. Actively participates in test planning by identifying testing requirements, scope and estimates
• 4. Ensures optimal test coverage comprising of positive, negative and exception scenarios
• 5. Logs defects with right priority, tracking them to closure and understanding the root cause for an issue
• 6. Work on DWH / Database testing
• 7. Perform all aspects of testing, including functional, regression, load, system testing, and user acceptance testing (UAT)
• 8. Validate fixes and ensure follow through to all test cycles
• 9. Investigate and recommend remediation strategies for data quality conditions, and process failures
• 10. Communicate test status to internal project team and clients(s)
• 11. Develop and contribute best practices and standards for a solution or across multiple medium/large scale projects/accounts
• 12. Mentoring a team of 2 to 3 QA Associates

Education Qulification

• 1. Bachelor’s or Master Degree or equivalent Degree or related IT field

Certification If Any

• 1. Azure certifications such as Azure Data Engineer Associate.
• 2. Snowflake Associate / Core

Shift timing

12 PM to 9 PM and / or 2 PM to 11 PM - IST time zone

Location:

DGS India - Pune - Indiqube Orchid

Brand:

Merkle

Time Type:

Full time

Contract Type:

Permanent

Requirements: