Senior Quality Analyst

dentsuaegis; Pune District; On-site; INR 1,500,000 - 2,500,000; Full time

Job summary

Merkle India (Dentsu) Pune is seeking a Lead QA to ensure software quality across the release cycle. You will lead QA initiatives, design test strategies, and coordinate with stakeholders to meet client requirements.

Ideal candidate has 6–10 years in QA, strong DWH/ETL expertise, SQL, Azure experience, and hands-on leadership for a small QA team. The role is on-site in Pune with a permanent contract.

Qualifications

• Bachelor's or master's degree in IT or related field.
• Minimum 6 years and up to 10 years of QA experience.
• Strong background in data warehousing, SQL and ETL testing.
• Experience with cloud tech (Azure) and testing data platforms.
• Proven ability to define test plans and mentor a small team.

Responsibilities

• Define scope and objectives for QA testing at multiple levels.
• Write test plans, design cases, develop test SQL scripts and expected results.
• Lead test planning, identify requirements, scope and estimates.
• Ensure coverage across positive, negative and edge cases.
• Log and track defects, determine root cause, ensure closure.
• Perform DWH/database testing and end-to-end testing including UAT.
• Validate fixes and drive testing across test cycles.
• Suggest remediation for data quality issues and process failures.
• Communicate status to project teams and clients.
• Develop best practices and mentor 2–3 QA associates.

Skills

DWH testing

SQL testing

ETL testing

Translate requirements to test cases

Data warehousing concepts

ETL tool knowledge

Azure cloud technologies

JIRA & Agile

Clear communication

Education

Bachelor's or Master's degree in IT/related field

Tools

JIRA

Snowflake

Job description

Job Description

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.

Business Title

Lead QA

Years of Experience

Min 6 and max upto 10.

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