Sr. ETL Tester

Accord Technologies Inc; Piscataway Township (NJ); Hybrid; USD 90,000 - 130,000; Full time

Job summary

Accord Technologies Inc is seeking a Sr. ETL Tester to design and execute end-to-end test plans for ETL pipelines built on AWS Lambda, Step Functions, SQS, S3, and Airflow.

The role emphasizes data validation, schema checks, and robust test data management in a hybrid onsite setting in Piscataway, NJ. Responsibilities include writing SQL queries against Athena and PostgreSQL, validating cross-account data flows, monitoring CloudWatch logs, and coordinating UAT with business analysts to ensure

Qualifications

• 3+ years ETL or data pipeline testing experience.
• Strong SQL writing validation queries against large datasets (Athena or Postgres).
• AWS hands-on experience S3, Lambda, SQS, Step Functions, CloudWatch.
• Experience testing JSON-based data transformations and schema checks.
• Understanding of event-driven architectures how S3 events, SQS, and triggers work end-to-end.
• Experience with test data management creating, maintaining, and isolating test datasets.
• Ability to read Python code well enough to understand what a Lambda is doing.

Responsibilities

• Design and execute end-to-end test plans for ETL pipelines on AWS services.
• Validate data transformations; confirm input JSON is correctly adapted and output matches schema.
• Write SQL test queries against Athena and Postgres to validate data.
• Test cross-account data flows; verify files land correctly and pipelines trigger as expected.
• Create reusable test data sets and mock events (S3, SQS).
• Perform negative testing with malformed files, missing fields, and duplicates.
• Monitor CloudWatch logs during test runs and verify structured output.
• Coordinate UAT with business analysts; validate reporting in QuickSight / Athena.

Skills

ETL testing

SQL

Data validation

Test case writing

QTEST

Education

Tools

Athena

Postgres

CloudWatch

Job description

Title: Sr. ETL Tester

Location: Piscataway, NJ (Day 1 onsite Hybrid)

Position type: W2 contract

Responsibilities

• Design and execute end-to-end test plans for ETL pipelines built on AWS Lambda, Step Functions, SQS, S3, and Airflow
• Validate data transformations confirm input JSON is correctly adapted and output matches expected schema
• Write SQL test queries against Athena and Postgres to validate row counts, column values, and data completeness
• Test cross-account data flows verify files land correctly, pipeline triggers fire, and status tracking updates as expected
• Build reusable test data sets sample JSON files, mock S3 events, SQS messages
• Perform negative testing malformed files, missing fields, duplicate events, network failures
• Validate DynamoDB state transitions PENDING IN_PROGRESS COMPLETED / FAILED
• Monitor CloudWatch logs during test runs and verify structured log output
• Regression test existing Retirement pipeline after any new Connect changes
• Document test cases, defects, and sign-off criteria per release
• Coordinate UAT with business analysts set up test data and validate reporting output in QuickSight / Athena
• Hands on QTEST, QUMO

Qualifications

• 3+ years ETL or data pipeline testing experience
• Strong SQL writing validation queries against large datasets, Athena or Postgres
• AWS hands-on experience S3, Lambda, SQS, Step Functions, CloudWatch
• Experience testing JSON-based data transformations field-level validation, schema checks
• Understanding of event-driven architectures how S3 events, SQS, and triggers work end-to-end
• Experience with test data management creating, maintaining, and isolating test datasets
• Ability to read Python code well enough to understand what a Lambda is doing not necessarily write it
• Strong defect documentation and test case writing and Qtest execution knowledge.