ETL Test Lead
At a glance
Senior Data Engineering role at Fa Ewjt Saasfaprod1. Pune · full-time.
Pay not stated Data Engineering salary
dataroles summary, based on the employer's posting.
What you'll do
- Check migrated SAS data in GCP for completeness, accuracy and consistency, including historical and incremental loads
- Test DBT pipelines across Bronze, Silver and Gold layers, checking business rules, joins, calculations and SAS output matches
- Find data quality issues such as duplicates, nulls, type mismatches and broken referential integrity
- Build test plans and cases, run SIT, UAT and regression checks, and carry defects through resolution
- Reconcile SAS results with GCP outputs and prepare reports for business and regulatory sign-off
What you bring
- A degree in computer science, data science, information technology or a related discipline
- Six to eight years working in data quality or data management
Who this fits
This role suits a senior data testing lead who can work across SAS, DBT and GCP migration validation. You’ll collaborate with engineering, architecture and business teams and take part in Agile ceremonies and testing sign-offs. The role is hybrid in Pune.
From the employer
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
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. 6-8 years of experience in data quality or data management.
Data Engineering work from LinkedIn, X, Reddit and Upwork, in one list.
Each morning you get everything that fits, strongest first.
Data Engineering
Find me workBy the team behind dataroles.