Job Description:Job DescriptionDetailsProject DetailsCommentsBusiness TitleLead QAYears of ExperienceMin 6 and max upto 10.Job DescreptionThe 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 skills1.Experience & Knowledge in DWH and Database Testing2. SQL and ETL testing knowledge3.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 principles6. Any ETL Tool knowledge7.Experience on Cloud technologies AZURE prefered.8. Experience on JIRA and Agile9.Good Communication skillsGood to have skills1.Familiarity with Cloud technologies2.Working experience on JIRA and Agile3.Experience with testing SOAP / API projects4.Stakeholder communication5. Microsoft OfficeKey responsibiltes1. 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 results3. Actively participates in test planning by identifying testing requirements, scope and estimates4. Ensures optimal test coverage comprising of positive, negative and exception scenarios5. Logs defects with right priority, tracking them to closure and understanding the root cause for an issue6. Work on DWH / Database testing7. 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 cycles9. 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/accounts12. Mentoring a team of 2 to 3 QA AssociatesEducation Qulification1. Bachelor’s or Master Degree or equivalent Degree or related IT field Certification If Any1. Azure certifications such as Azure Data Engineer Associate.2. Snowflake Associate / Core Shift timing12 PM to 9 PM and / or 2 PM to 11 PM - IST time zoneLocation:DGS India - Pune - Indiqube OrchidBrand:MerkleTime Type:Full timeContract Type:Permanent