ETL data tester

Robotics Prcocess Automation, LLC; Boston (MA); Hybrid; USD 80,000 - 100,000; Part time

Job summary

A technology consulting firm in Boston is seeking a Senior Data Tester with strong skills in data validation and SAP knowledge. The ideal candidate will design ETL test cases, validate data from SAP systems, and collaborate with teams to ensure data integrity. This is a contract role with a hybrid work model, requiring onsite presence three days a week. Candidates should have over 6 years of data testing experience and proficiency in SQL and Python.

Qualifications

• 6+ years of experience in data testing or ETL testing.
• Strong knowledge of SAP modules and data structures.
• Proficiency in SQL for validation.

Responsibilities

• Design and execute test cases for ETL from SAP systems.
• Validate data accuracy across SAP and downstream systems.
• Collaborate to resolve data issues.

Skills

SQL writing queries

Data testing experience

Understanding SAP data structures

Experience with ETL Testing

Tools

Informatica

Talend

SSIS

DataStage

dbt

Python

Job description

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 number 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.

ROBOTIC PROCESS AUTOMATION LLC is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status. ROBOTIC PROCESS AUTOMATION LLC will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters. Nor will ROBOTIC PROCESS AUTOMATION LLC require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract.