DGS India - Pune - Indiqube Orchid / Technology

Merkle Inc.; Pune District; On-site; INR 900,000 - 1,300,000; Full time

Job summary

Merkle Inc. is seeking a QA Lead to ensure software meets client requirements and quality standards within the release cycle. You will lead QA initiatives, optimize test approaches and tools, and mentor a small team to deliver robust data validation and testing across DWH and cloud environments.

The role emphasizes translating requirements into test cases, implementing SQL-based data validations, and collaborating with stakeholders to ensure high-quality releases in a complex data environment.

Qualifications

• Experience in data warehousing and database testing.
• Design and translate requirements into test cases.
• Experience with SQL and ETL testing and tooling.
• Knowledge of cloud technologies (Azure preferred) and related data services.
• Hands-on experience with JIRA and Agile methods.
• Strong communication and stakeholder management.

Responsibilities

• Define scope and objectives for QA testing at all levels.
• Write test plans, test cases, and SQL scripts; document expected results.
• Participate in test planning with estimates and requirements.
• Ensure comprehensive test coverage including positive/negative scenarios.
• Log defects with priority and drive root-cause analysis.
• Conduct DWH/Database testing and end-to-end testing (functional, regression, UAT).
• Validate fixes and ensure coverage across test cycles.
• Suggest remediation for data quality issues and process failures.
• Communicate test status to project teams and clients.
• Develop best practices and standards across projects.
• Mentor a small QA team (2-3 associates).

Skills

DWH testing

Database testing

SQL & ETL testing

Test design & cases

SQL proficiency

Data warehousing

ETL tools

Azure

JIRA & Agile

Communication

Education

Bachelor’s or Master Degree in IT/related field

Azure Data Engineer Associate

Snowflake Associate/Core

Tools

Microsoft Excel

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.

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

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