Data Quality Testing & Validation Engineer

Greetings from Maneva!

Job Title- Data Quality Testing & Validation Engineer

Experience- 3 8 Years

Location-PAN India

Notice-Immediate to 15 days

Requirement:-

Develop and maintain test cases, test plans, and test scripts for data validation based on the business requirements / Data Products requirements.

Focus on 100% coverage of functional test cases.

Align Test Scenarios & Cases with overall test strategy / Plan, if applicable.

Interpret source to target mapping documents for understanding the business logic.

Execute functional, regression, and performance testing of data pipelines and transformations Validate data accuracy, completeness, and consistency across various sources.

Perform data reconciliation between source and target systems to identify discrepancies.

Test Automation & Scripting:

Write Python scripts and SQL queries to automate data validation and reconciliation.

Utilize data testing frameworks for automation.

Work with engineers to integrate automated tests into CI/CD pipelines. Develop anomaly detection scripts to monitor data integrity.

Collaboration & Defect Management:

Work closely with data engineers, analysts, and data product teams to understand data requirements. Identify, log, and track data quality issues and defects using defect management tools.

Participate in root cause analysis and troubleshooting of data-related issues. Communicate test results and data quality metrics to stakeholders.

Analyze defects reported during UAT and identify root cause to avoid recurrence.

Required Skills:

3-5 years of experience in data testing, ETL/ELT, API services testing, validate real-time data.

Strong SQL skills for querying and validating large datasets in Big Query, comfortable validating data in JSON schema, and XML format.

Experience and proficiency with MDM concepts and data validation techniques required for MatchMergeSurvivor Testing.

Experience with Python scripting for data testing automation.

Hands-on experience with data quality testing tools and frameworks.

Experience in GCP - Big Query, Spanner DB and Strong problem-solving and analytical skills for debugging data issues.

Experience in validating semi structured & unstructured data.