Sr. ETL Tester

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