ETL data tester

Cloud Analytics Technologies LLC
Boston, MA

Summary

Total Exp 13+ yrs

Ideal Candidate We are seeking a Data Tester, not a traditional QA tester. The ideal candidate will be responsible for testing data flows from SAP source systems. This role requires:

  • A basic understanding of SAP functional modules (e.g., FI, MM, SD, etc.)
  • Experience in extracting data from SAP systems
  • Strong skills in writing and executing SQL queries to validate data
  • The ability to combine technical data testing with functional SAP knowledge

Skill Matrix:
SQL writing queries:
Data testing experience:
Understanding of SAP data structures, tables, and functional modules (e.g., FI/CO, MM, SD, HR, etc.) -
Experience with ETL Testing:

Role:

Senior Data Tester -ETL local to Boston MA

Employment Type: Contract

Contract Duration 6 months + high possibility of extending further

Work location: Remote/Onsite (mention no. of Onsite days)

Hybrid - Onsite 3 days a week @ client location Boston, MA or Springfield, MA

About the Role

We are looking for a detail-oriented Data Tester with hands-on experience in data validation and a strong understanding of SAP data and business processes .
The ideal candidate will be responsible for testing data flows from SAP source systems to downstream data warehouses, analytics platforms, and reporting tools.
This role combines technical data testing skills with functional knowledge of SAP modules to ensure accuracy, completeness, and reliability of enterprise data.

Job Responsibilities

  • Design, develop, and execute test cases for data extraction, transformation, and loading (ETL) from SAP systems (e.g., SAP ECC, S/4HANA, BW) to target data environments.
  • Validate data accuracy and integrity across SAP source tables and downstream systems (data lakes, DWH, BI tools).
  • Verify data mappings between SAP modules (such as FI, CO, MM, SD, or HR) and target models.
  • Perform data reconciliation and ensure that business rules and KPIs derived from SAP data are correctly implemented.
  • Collaborate with data engineers , SAP functional consultants , and business analysts to resolve data issues.
  • Develop and maintain automated data validation scripts using SQL and Python.
  • Document test results, defects, and data quality metrics; communicate findings with technical and functional teams.
  • Support UAT (User Acceptance Testing) and provide guidance on data validation best practices.

Required Experience

  • 13 years of experience of which 6+ years of experience in data testing, ETL testing , or data quality assurance .
  • Strong knowledge of SAP data structures, tables, and functional modules (e.g., FI/CO, MM, SD, HR, etc.).
  • Proficiency in SQL for validating and reconciling data across SAP and non-SAP systems.
  • Experience with ETL tools (Informatica, Talend, SSIS, DataStage, or dbt).
  • Experience writing Python scripts for automated data validation.
  • Understanding of data warehouses , data lakes , and data modeling concepts .
  • Excellent analytical skills, attention to detail, and ability to interpret SAP business data.

Preferred Skills

  • Experience working with SAP extractors , IDOCs , or BW data flows .
  • Familiarity with Snowflake , BigQuery , AWS Redshift , or other cloud data platforms.

Posted 2025-11-06

Recommended Jobs

Benefit & Advocacy Specialist

Patient Funding Alternatives
Woburn, MA

ChasmTeam is partnering with a growing national company, to build a team that provides real benefits to patients! We are seeking hard working, self-starters who enjoy a challenge as we work together …

View Details
Posted 2025-10-24

Deputy Leader

Veolia Water Technologies & Solutions
Lynn, MA

Company Description Veolia in North America is the top-ranked environmental company in the United States for three consecutive years, and the country's largest private water operator and technology…

View Details
Posted 2025-11-04

Project Engineer

Manafort Brothers, Inc.
Worcester, MA

Manafort Brothers Incorporated is seeking Project Engineers for its Plainville, CT and Cumberland, RI offices, and also for our subsidiaries Manafort-Precision, LLC and Manafort Transit, LLC in MA. We…

View Details
Posted 2025-11-05

Registered Nurse ( RN ) Supervisor

Smithfield Manor Rehabilitation and Healthcare Center
Berkshire County, MA

Are you a dedicated and experienced Registered Nurse ( RN ) with a passion for leading and supporting a clinical team? Do you excel in a leadership role where you can make a significant impact on pat…

View Details
Posted 2025-10-22

Medical Assistant / Patient Service Specialist I

Boston Medical Center
Brighton, MA

POSITION SUMMARY: This position is to function as a member of both the clinical and administrative team and complete all assigned daily tasks to ensure smooth day to day operations in the physic…

View Details
Posted 2025-10-30

Day / teacher - private school

TORIT MONTESSORI SCHOOL
Boston, MA

POSITION AVAILABLE: EXTENDED DAY TEACHER (2pm-6pm) Torit Montessori School is an infant through sixth-grade independent school on Boston’s historic Beacon Hill. Our mission is to educate bright a…

View Details
Posted 2025-11-06