ETL SDET (Data Quality Automation Engineer)

First Soft Solutions

Monmouth Junction, NJ(remote)

JOB DETAILS
SKILLS
Agile Programming Methodologies, Amazon Simple Storage Service (S3), Amazon Web Services (AWS), Atlassian JIRA, Automation, Automation Engineering, Big Data, Bug Tracking/Defect Management, Business Analysis, Cloud Computing, Communication Skills, Data Lake, Data Migration, Data Quality, Database Extract Transform and Load (ETL), Electronic Medical Records, Healthcare, Identify Issues, Informatica, Information Technology & Information Systems, Problem Solving Skills, Python Programming/Scripting Language, Quality Engineering, Regression Testing, Root Cause Analysis, SQL (Structured Query Language), Scripting (Scripting Languages), Scrum Project Management and Software Development, Simple Queue Service (SQS), Software Design for Test (SDET), Strategic Planning, Test Automation, Test Harness, Test Strategy, Testing, United States Citizen, Validation Testing
LOCATION
Monmouth Junction, NJ(remote)
POSTED
3 days ago

Work Authorization:US Citizen or Green Card Holder Only (No Sponsorship)

Required Experience
  • 10+ years of overall IT experience
  • 5+ years of hands-on experience in ETL/Data Quality Test Automation
  • Strong Healthcare/Payer domain experience preferred
  • Experience testing large-scale data platforms and cloud-based ETL pipelines
  • Strong communication and stakeholder interaction skills
Mandatory Technical Skills
  • PySpark (Hands-on experience required)
  • Python scripting/programming
  • Advanced SQL
  • ETL/Data Validation Testing
  • Test Automation Framework Development
  • AWS Cloud Services:
    • S3
    • Glue
    • EMR
    • Data Catalog
    • Crawler
    • SQS
    • EventBridge
  • Athena
  • Redshift Spectrum
  • Data Lake / Data Lakehouse architectures
  • AWS CLI
  • JIRA
  • Regression Testing
  • Defect Tracking & Root Cause Analysis
  • Agile/Scrum methodology
Nice to Have
  • Informatica
  • DBT (Data Build Tool)
  • Healthcare Data Migration Projects
  • Cloud Data Quality Automation Frameworks
Key Responsibilities
  • Build and maintain automated testing frameworks for ETL and Big Data applications.
  • Validate data transformations, data migrations, and cloud-based ETL workflows.
  • Perform end-to-end data quality testing and automation.
  • Execute SQL, PySpark, and AWS-based validation scripts.
  • Work closely with Data Engineers, Developers, and Business Analysts.
  • Identify, troubleshoot, and resolve complex data quality issues.
  • Participate in Agile ceremonies and testing strategy planning.

About the Company

F

First Soft Solutions