Data Quality & Validation Engineer

Comptech Associates · Hyderabad, India

About the Role:

Role : Data Tester (Data Quality & Validation Engineer)

Location: Remote, India

Job Description:

Data Tester (Data Quality & Validation Engineer)

Position Overview

We are seeking a highly analytical and detail-oriented Data Tester to join our Quality Engineering team supporting complex enterprise applications. The ideal candidate will be responsible for validating data integrity, testing SQL Server database changes, stored procedures, batch processing jobs, and enterprise integrations across a large-scale distributed environment.

This role requires a proactive tester who can think beyond standard functional testing and identify potential system failures, data anomalies, edge cases, and business risks before production deployment. The Data Tester will work closely with developers, business analysts, data architects, and QA leadership to ensure the reliability and accuracy of enterprise data systems.

Key Responsibilities

Data Validation & Testing

• Validate data transformations, migrations, and integrations across multiple systems.
• Test new tables, fields, data elements, and database enhancements.
• Verify data accuracy, completeness, consistency, and referential integrity.
• Perform source-to-target reconciliation testing and audit data movement across platforms.
• Identify and investigate data quality issues, defects, and anomalies.

Database Testing

• Develop and execute test cases for SQL Server database changes.
• Validate stored procedures, functions, triggers, views, and complex queries.
• Analyze query results and confirm business rule implementation.
• Verify database deployments and data conversion activities.
• Conduct regression testing to ensure existing functionality remains intact.

Advanced Test Design

• Create comprehensive positive, negative, boundary, and edge-case test scenarios.
• Perform risk-based testing focused on identifying system weaknesses.
• Challenge assumptions and proactively identify potential failure points.
• Execute exploratory testing to uncover hidden defects.

Reporting & Collaboration

• Maintain test plans, test cases, test data, and execution results.
• Provide status updates, risk assessments, and quality metrics.
• Participate in sprint ceremonies, design reviews, and release planning activities.
• Collaborate with technical leads and business stakeholders to ensure complete test coverage.

Required Qualifications

Education

• Bachelor's degree in Computer Science, Information Systems, Engineering, or related field.

Experience

• 6+ years of Data Testing, Database Testing, or QA Engineering experience.
• Experience testing complex enterprise applications and data-intensive systems.
• Strong experience with SQL Server databases and advanced SQL queries.
• Experience validating stored procedures, triggers, views, and ETL processes.
• Experience with defect management and test management tools.

Technical Skills

• Microsoft SQL Server
• Advanced SQL query development and analysis
• Stored Procedure Testing
• Data Validation and Reconciliation
• Database Objects Testing (Views, Functions, Triggers)
• Integration Testing
• API Testing
• Test Case Design and Execution
• Defect Lifecycle Management

Preferred Qualifications

• Experience testing .NET applications.
• Experience supporting Angular-based applications.
• Experience working with mainframe-integrated environments.
• Familiarity with DevOps, CI/CD pipelines, and automated testing frameworks.

Key Competencies

Analytical Thinking

• Ability to analyze complex data flows and identify inconsistencies.

Attention to Detail

• Strong focus on data accuracy and quality assurance.

Problem Solving

• Ability to investigate defects and identify root causes.

Risk-Based Testing Mindset

• Think beyond the \"happy path\" and proactively identify system vulnerabilities.

Communication Skills

• Ability to communicate findings effectively to technical and non-technical stakeholders.

Ownership & Accountability

• Demonstrate proactive ownership of testing activities and quality outcomes.

Sample Success Metrics

• Defect leakage reduction
• Data accuracy and reconciliation rates
• Test coverage across database and batch processing components
• Production incident reduction
• On-time completion of testing activities
• Quality and completeness of test artifacts
• Identification of high-risk defects prior to production release

Environment Overview

The successful candidate will work in a large enterprise ecosystem that includes:

• SQL Server Databases
• .NET Applications
• Angular Front-End Platforms
• AI-Assisted Development and Testing Tools (GitHub Copilot, Devin AI)

This position is ideal for a tester who enjoys uncovering complex data issues, validating mission-critical business processes, and ensuring the highest level of data quality in enterprise systems.