Sr Information Technology Quality Assurance Analyst( SQL + DB Testing + Agile +

Senior IT QA Analyst, Assurant, GCC-India As a Sr IT QA Analyst, you will be an active member of your domains agile team and perform QA activities like analyzing stories, writing/executing test cases and documenting defects for application systems, programs, functions, services, and other related software components in response to the enterprise need for high quality. This position will be in Bengaluru & Hyderabad at our India Location Work Timings: 2:00 PM IST ~ 11:00 PM IST. What will be my duties and responsibilities in this job This job is responsible for developing or assisting in the development of functional requirements, testing applications, developing test plans, editing and/or writing test cases and test scripts, and evaluating test results to determine compliance with test plans and established business processes. The individual will interact with business development, system developers, end users, and all other groups involved in software development, testing, or test planning. Testing/QA Lead test initiatives/projectsDevelop test strategy for major features, user stories, and bugsEstimate test tasks and lead test cycleSuggest and implement QA process improvementsDevelop and execute test cases based on requirements/user storiesDocument, track, and retest issues found during testingDocument and communicate test activities and resultsResearch, suggest, and implement tools to enhance test efficiencyAutomate test cases and execute automated test suiteWrite SQL queries for test data set upWrite SQL queries to validate test resultsCollaborate with POs and BAs to understand feature and story conditions of acceptance and gain sign-off of written test casesPerform test execution and lead the defect management processParticipate and conduct non-functional testing (security, performance, load, stress, multitenancy, DR etc)Clearly document system defects with repeatable steps to reproduceContribute to automated script development and increased automationIdentify, coordinate, and perform end-to-end test execution with upstream and downstream domainsDemo completed features and stories to POs and businessDefine and participate in Regression, Integration, Smoke, and Platform testing activities.Support your team QA Lead in providing leadership, technical direction, and mentorship to both onshore and offshore QA team members within your domainBusiness/User Requirements: Analyze requirements/user stories for testability and completenessActively participate in requirements/user story gathering sessions and elaborationsInterpret user requirements/user stories and extend them into test casesCommunicate technical concepts in everyday languageUnderstand the needs of the user communityDemo new features/lead UAT activitiesProvide system support: Learn and enhance knowledge of the various multi-platform system support environments, utilities, and proceduresParticipate in on-call rotationsProvide timely, concise communication of incident status to appropriate personnelDocument incident occurrence and resolution(s) applied using designated repositoriesConsult with staff personnel as required for effective incident resolutionResolve development and support issues of moderate to high complexity or riskEnd User Support: Strong communication skills.Translate technical concepts in everyday language.Troubleshoot technical issues and drive for resolution.Build relationships.What are the requirements needed for this position Bachelors in Computer Science or related field8+ years of experience working in the Information Technology fieldStrong knowledge of Windows operating systemStrong knowledge of web browsers (i.e. Chrome and Internet Explorer/Edge)Strong knowledge of mobile and cloud-based technologyStrong SQL knowledge and experience with SQL Server 2016 (or similar RDBMS)Experience testing Data Migration, Data Quality, and ETLExperience in Automation Testing, Functional Testing, ETL Testing. JavaScript.Expert in Software Development Lifecycle/Agile conceptsExperience testing WCF and REST services within a Service Oriented ArchitectureFamiliarity with Team Foundation Server and Microsoft Test ManagerFamiliarity with Load and performance testing with tools like JmeterWhat are the Preferred requirements needed for this position 5+ years of technical and quality leadership testing enterprise level software5+ years of experience developing test pla .