Senior ETL Tester - AWS Data Pipelines & QA (Hybrid)

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

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