Data Quality Assurance Engineer (3-8 yrs)

We are hiring a Data QA Engineer for our client.

This role requires expertise in testing ETL processes, validating data quality, and ensuring data integrity across different stages.

The ideal candidate will have a strong background in SQL, data validation, and experience working with large datasets.

Roles and Responsibilities :

- Perform end-to-end testing of ETL processes and data pipelines to ensure accuracy and reliability.

- Validate data transformations, quality, and integrity at different stages of data processing.

- Write, execute, and maintain test cases and advanced SQL queries for data validation.

- Identify, analyze, and report data-related defects, inconsistencies, and anomalies.

- Collaborate with developers, business analysts, and data engineers to resolve data quality issues.

- Work with large datasets, performing data reconciliation to ensure correctness.

- Validate and test data warehouse implementations and data migration processes.

- Create and manage test data for various testing scenarios.

- Perform schema verification and business rule validation to ensure compliance with requirements.

- Ensure comprehensive data validation throughout the data lifecycle.

- Exposure to Oracle Integration Cloud (OIC), PL/SQL for database testing and validation.

Skills and Qualifications Required :

- 3 to 8 years of experience in Data Quality Assurance, ETL testing, or Data Engineering.

- Strong SQL skills to write complex queries for data validation and verification.

- Hands-on experience in testing ETL processes, data pipelines, and data warehouses.

- Experience in data transformation testing, data reconciliation, and data integrity validation.

- Knowledge of PL/SQL and Oracle Integration Cloud (OIC) is a plus.

- Familiarity with schema validation, business rule testing, and data migration validation.

- Ability to work with large datasets and perform root cause analysis on data inconsistencies.

- Strong analytical skills, problem-solving abilities, and attention to detail.

- Experience with test automation tools for data validation is an added advantage