Spmi-qa l2-dbtesting

**Description**

Ness is a full lifecycle digital engineering firm offering digital advisory through scaled engineering services. With 20+ years of specialization in product and platform engineering, Ness is a global leader in digital transformation. We design, build, & integrate digital platforms and enterprise software that help organizations to engage with customers, differentiate their brands, and drive profitable growth for them. Our experience designers, software engineers, data experts, and business consultants, partner with clients to develop roadmaps that identify ongoing opportunities to increase the value of their digital solutions and enterprise systems. The exciting work happens through 11 innovation hubs with 4000+ Nessians located across the globe.

Key Roles & Responsibilities:

- Design and develop automation/performance solutions that meet organization standards and build reliable, reusable, and maintainable automated regression suites & test harnesses
- Create tools and frameworks with quality code to simplify testing scenarios.
- Design and develop test plans, test cases based upon functional and design specifications, execute test cases and analyze and report test results to the teams
- Work in partnership with the development teams to deliver business functionality on time with required quality that meets the acceptance criteria
- Acts as a test lead, planning the work of other testing staff and assigning tasks to meet project deadlines.
- Uses strong testing skills to provide guidance and assist project staff
- Reviews and approves the work of project team members in the writing of scripts, expected results, test results and defect descriptions. Ensures best practices are followed and testing activities stay on schedule.
- Focus on building efficient solutions for Database testing requirements.
- Participate in internal/cross team meetings, project scoping, functional reviews, test specifications, technical reviews for assigned projects in an Agile environment
- Involved in requirements review and participate in architecture/design reviews with an emphasis on test automation/performance strategy and ensuring best practices
- Participate actively in functional, system and regression testing activities
- Capture quality assurance data and metrics to provide insights and conclusions
- Estimate and perform risk analysis for quality delivery
- Agile evangelist

Qualifications and

**Required Skills**:

- 5+ years of software testing experience in all phases of testing including test planning, test execution and test closure
- Excellent understanding of QA and testing methodologies, best practices
- Excellent knowledge and 3+ years of experience in MS SQL (Must) along with exposure to.net Applications.
- Experience of working with API service and understanding of SOA architecture.
- Expertise using complex SQL to query MSSQL databases required.
- Expertise in understanding and testing Stored Procedures and automation.
- Expertise at MSSQL, SQL, Various SQL Work benches, TOAD like tools
- Experience on UNIX and should be familiar with UNIX commands.
- Intermediate level understanding of HIVE
- Good hands-on experience on Database Testing
- Experience creating, maintaining, and executing automation tests utilizing tools such as Selenium with Python preferred.
- Experience with test data management techniques.
- Experience creating and maintaining automation frameworks preferred.
- Exposure to distributed source control systems such as Git.
- Experience with change management and defect tracking tools.
- Well versed with Defect Triage process and identification, tracking of corrective actions.
- Zeal to be domain expert and learn new technologies.
- Demonstrated analytical and problem-solving skills.
- Excellent interpersonal skills and written communications.
- High standards of confidentiality; ability to handle sensitive information with integrity and trust.
- Knowledge of cloud technologies like AWS/Azure and experience of testing micro-services, containers, Dockers is preferred
- 5+ Years of experience in Agile processes (Scrum preferred)

Minimum and Preferred Education
- Bachelor's or higher qualification in Computer Science, Information Systems or equivalent is preferred

Minimum and Preferred Experience/Skills
- 8+ years of relevant experience with bachelor’s degree or higher qualification