EXL

ETL Test Lead

EXL  •  Pune, IN (Onsite)  •  2 days ago
Apply
AI can make mistakes so check important info. Chat history is never stored.

Job Description

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.

EXL

About EXL

Choosing a digital partner is about more than capabilities — it’s about collaboration and character.

Unrealistic overhauls and off-the-shelf products ignore what matters most — your unique needs, culture, goals, and your legacy data and technology environments.

At EXL, our collaboration is built on ongoing listening and learning to adapt our methodologies. We’re your business evolution partner—tailoring solutions that make the most of data to make better business decisions and drive more intelligence into your increasingly digital operations.

Whether your goals are scaling the use of AI and digital, redesign operating models, or driving better and faster decisions, we’re here to partner with you to help you gain—and maintain—competitive advantage with efficient, sustainable models at scale.

Our expertise in transformation, data science, and change management helps make your business more efficient and effective, improve customer relationships and enhance revenue growth. Instead of focusing on multi-year, resource- and time-intensive platform designs or migrations, we look deeper at your entire value chain to integrate strategies with impact.

We use our specialization in analytics, digital interventions, and operations management—alongside deep industry expertise — to deliver solutions that help you outperform the competition.

At EXL, it’s all about outcomes—your outcomes—and delivering success on your terms. Share your goals with us and together, we’ll optimize how you leverage data to drive your business forward.

For more information, visit www.exlservice.com.

Industry
Consulting & Advisory
Company Size
10,000+ employees
Headquarters
New York, NY
Year Founded
Unknown
Social Media