Manager

EXL

Discussion

Manager

Show

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

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.

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