Description

Testing Skills

- Data Testing
- ETL/ELT Testing
- System Integration Testing (SIT)
- User Acceptance Testing (UAT)
- Regression Testing
- Defect Management

Data Technologies

- SQL
- DBT Testing Framework
- BigQuery
- Data Validation Techniques
- Reconciliation Testing

SAS Knowledge

- SAS Datasets
- PROC SQL
- SAS Reports
- SAS Data Validation Concepts

Tools

- Jira
- Azure DevOps
- Git
- Test Management Tools

Cloud Platforms

- Google Cloud Platform (GCP)
- BigQuery
- Cloud Storage

Responsibilities

Data Migration Testing

- Validate migrated data from SAS to GCP platforms.
- Perform source-to-target data validation and reconciliation.
- Verify completeness, accuracy, and consistency of migrated data.
- Execute historical and incremental data validation testing.

ETL/ELT Testing

- Test DBT transformation pipelines and business rules.
- Validate data movement across Bronze, Silver, and Gold layers.
- Verify joins, aggregations, calculations, and derived attributes.
- Ensure transformation logic matches SAS outputs.

Data Quality Validation

- Validate data quality rules and controls.
- Identify duplicates, null values, data type mismatches,



and referential integrity issues.
- Perform anomaly detection and exception analysis.
- Support implementation of automated data quality checks.

Test Planning & Execution

- Create test plans, test scenarios, and test cases.
- Prepare test data and execute SIT, UAT, regression, and production validation testing.
- Track and manage defects through closure.
- Support release and deployment validation activities.

Reconciliation & Reporting

- Perform record count, field-level, and aggregate-level reconciliation.
- Compare SAS results with GCP outputs.
- Produce reconciliation reports and defect summaries.
- Support business and regulatory sign-off activities.

Collaboration

- Work closely with Data Engineers, DBT Developers, SAS SMEs, Data Architects, and Business Analysts.
- Participate in Agile ceremonies and sprint activities.
- Support stakeholder reviews and testing sign-offs.

Qualifications

Graduate in Computer Science, Data Science, Information Technology, or a related field. 4-6 years of experience in data quality or data management.

📌 Manager (Bengaluru)
🏢 EXL
📍 Bengaluru