ETL SDET (Data Quality Automation Engineer)

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

• 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

• 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

• Informatica
• DBT (Data Build Tool)
• Healthcare Data Migration Projects
• Cloud Data Quality Automation Frameworks

• 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.