esting 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

📌 ETL Test Lead (Pune)
🏢 EXL
📍 Pune