VS01769 - Functional and Database Tester

E4 Software Services Pvt Ltd.; India; On-site; INR 550,000 - 950,000; Full time

Job summary

E4 Software Services Pvt Ltd. seeks a dedicated QA tester to validate both functional and database aspects of our applications in an Indian context. The role emphasizes translating business needs into robust test scenarios and ensuring data integrity across systems.

You will work with cross-functional teams including business analysts, developers, and product owners, performing manual tests, SQL data checks, and API validations while supporting UAT and defect management.

Qualifications

• Bachelor’s or master’s degree in engineering or a related discipline with relevant experience in manual functional and database testing.
• Functional knowledge of finance, investments, portfolio management, OCIO applications, trading, cash management, compliance, risk, or capital markets is must-have.
• Strong understanding of SDLC, STLC, test design techniques, defect management, and Agile Scrum delivery.
• Ability to translate business requirements and acceptance criteria into clear test scenarios, expected results, and comprehensive test coverage.
• Hands-on experience testing application features, business workflows, calculations, role-based access, and integration points.
• Experience validating data across application, reports, database tables, and integrated systems, including source-to-target reconciliation.
• Strong SQL skills, including joins, subqueries, grouping, and aggregate functions, with experience in Oracle/SQL Server/PostgreSQL/MySQL.
• Practical knowledge of database tables, keys, relationships, constraints, and transactions, with the ability to investigate data integrity issues.
• Experience using Jira, Azure DevOps, or equivalent tools for test management, defect reporting, and progress tracking.
• Experience supporting UAT and working effectively with business users, business analysts, developers, and product owners.
• Strong analytical and problem-solving skills, attention to detail, clear written and verbal communication, and the ability to manage competing priorities.
• Experience testing stored procedures, ETL processes, data migrations, or data warehouse workflows is preferred.
• Exposure to API testing using Postman or Bruno, or functional test automation, is an added advantage.

Responsibilities

• Test application features, business workflows, calculations, and integrations.
• Validate data across source and target systems and reports.
• Support UAT and collaborate with business users, analysts, developers, and product owners.
• Identify, report, and track defects through resolution.
• Analyze requirements to create test scenarios and acceptance criteria.
• Create comprehensive test coverage for reports and data validation.
• Run API tests using Postman or Bruno and explore automation options.

Skills

Manual testing

Database testing

SQL

SDLC/STLC

Test design

Defect management

Agile Scrum

Data validation

UAT support

Stakeholder communication

Analytical skills

API testing

ETL testing

Tools

Jira

Azure DevOps

Postman

Bruno

Job description

Bachelor’s or master’s degree in engineering or a related discipline, with relevant experience in manual functional and database testing.

Functional knowledge of finance, investments, portfolio management, portfolio construction, OCIO applications, trading, cash management, compliance, risk, or capital markets is must-have skill.

Strong understanding of SDLC, STLC, test design techniques, defect management, and Agile Scrum delivery.

Ability to translate business requirements and acceptance criteria into clear test scenarios, expected results, and comprehensive test coverage.

Hands-on experience testing application features, business workflows, calculations, role-based access, and integration points.

Experience validating data across application, reports, database tables, and integrated systems, including source-to-target reconciliation.

Strong SQL skills, including joins, subqueries, grouping, and aggregate functions, with experience in a relational database such as Oracle, SQL Server, PostgreSQL, or MySQL.

Practical knowledge of database tables, keys, relationships, constraints, and transactions, with the ability to investigate data integrity issues.

Experience using Jira, Azure DevOps, or equivalent tools for test management, defect reporting, and progress tracking.

Experience supporting UAT and working effectively with business users, business analysts, developers, and product owners.

Strong analytical and problem-solving skills, attention to detail, clear written and verbal communication, and the ability to manage competing priorities.

Experience testing stored procedures, ETL processes, data migrations, or data warehouse workflows is preferred

Exposure to API testing using Postman or Bruno, or functional test automation, is an added advantage.