About this opportunity
Accord Technologies Inc lists this Sr. ETL Tester opportunity in piscataway township, New Jersey. Review the employer’s description below for duties, qualifications and application requirements.
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.
#J-18808-Ljbffr
Who can apply
Review the original listing for work authorization, qualifications and employer requirements.