ETL Tester Resume Sample

The following ETL Tester sample resume is created using Timeline Resume Builder. Click the button below to make your resume in this design.

Jake Welch

ETL Tester

Verifying the data behind the dashboards is right

[email protected]
github.com/jakewelch
linkedin.com/in/jake-welch-data

ETL tester with seven years validating data pipelines and warehouses for a data and analytics company in Sheffield. Tests the layer most QA misses — verifying that ETL processes extract, transform and load data correctly, so the dashboards and reports built on top are actually accurate. Built an ETL-validation test suite that caught transformation errors before they reached production reports. Writes SQL-based test cases, validates source-to-target mappings and transformations, tests data quality and reconciliation, and manages defects with data engineers. Strong on both deep SQL skill and the data understanding the role demands, where a quiet data bug can mislead a whole business. Methodical and protective of data accuracy. Looking for an ETL-tester, data-QA or data-quality role on platforms where the numbers have to be right.

LocationSheffield, UK
NationalityBritish
GenderMale
Notice Period1 month
Date of Birth1993-09-22
Work Summary
(April 2017 to Present)9 years & 3 months

Sheffield Data & Analytics - Sheffield, UK

ETL Tester

Validate all the ETL pipelines and the warehouses so all the reports and dashboards are accurate.
Built an ETL-validation test suite that caught the transformation errors well before they reached production.
Write all the SQL-based test cases to verify all the source-to-target mappings and the transformations.
Test all the data quality, the completeness and the reconciliation right across all the pipelines.
Manage and triage all the defects with the data engineers right through to a resolution.
Protect all the data accuracy, where a quiet data bug can mislead the whole business.
(August 2015 to March 2017)1 year & 8 months

Yorkshire Data Systems - Sheffield, UK

QA / Data Tester

Tested the data feeds, the reports and application data against the requirements.
Wrote the SQL queries to validate the data and logged defects.
Learned the ETL testing, validation and test design on the job.
Gained the SQL and data-testing certification and then an ETL-tester role.
(June 2013 to July 2015)2 years & 2 months

Yorkshire Data Systems - Sheffield, UK

Data Analyst

Worked as a data analyst running SQL, reports and data checks.
Validated the data and the reporting for all of the business teams.
Learned the databases, the SQL and where the data goes wrong.
Then moved into a QA and data-tester role from there.
Qualification
(September 2012 to June 2015)2 years & 10 months

University of Sheffield

BSc in Computer Science - Computer Science

Computer science degree covering databases, SQL and software testing, with a placement. The data focus led directly into ETL testing. Built the technical foundation the role requires.
(January 2017 to May 2017)5 months

ISTQB / Industry Training

SQL & Data Testing Certification - Data Testing

Certification in advanced SQL and data testing covering validation, mappings and test design. It formalised the data-testing toolkit used daily. Applied directly to ETL and warehouse test work.
ETL Validation Framework

ETL Validation Framework

ETL Tester (January 2018 to September 2018)

Built an ETL-validation test framework covering source-to-target mapping, data quality and reconciliation checks, which caught transformation errors before they reached production reports and became the team's standard for data testing.

BI Report Reconciliation

ETL Tester (January 2020 to August 2020)

Built a reconciliation check between the warehouse and the BI reports, comparing the numbers automatically so any mismatch surfaced and was fixed before the dashboards reached the business.
Certifications

SQL & Data Testing

ISTQB / Industry Training (May 2017 to Present)

Certification in advanced SQL and data testing covering validation, mappings and test design. It formalised the data-testing toolkit used daily. Applied directly to ETL and warehouse test work.

ETL & Data Warehouse Testing

ISTQB (April 2019 to Present)

Certification in ETL and data-warehouse testing covering mappings, reconciliation and quality checks. It supports the source-to-target validation run across the pipelines and the warehouse.
Languages

English (UK)

Native or Bilingual Proficiency

German

Limited Working Proficiency
Highlights

Caught transformation errors

Built an ETL-validation test suite that caught transformation errors before they reached production reports. Catching bad data before it ships protects every decision built on it.

Guards the data

Tests the ETL and data layer that most QA overlooks but that the whole business trusts. A silent data bug is invisible until it has already misled someone.
Technical Skills
  • ETL Testing
  • SQL
  • Source-to-Target Validation
  • Data Quality Testing
  • Data Reconciliation
  • Test Case Design
  • Data Warehousing
  • Defect Management
  • Transformation Logic
  • Data Integrity
Personal Skills
  • Attention to Detail
  • Analytical Thinking
  • Methodical Approach
  • Persistence
  • Communication
Activities & Interests
Tennis
Ski
Traveling
Talking
Singing

More resume samples

Explore more resume sample from our library and choose your favorite resume template

View all samples