What are the responsibilities and job description for the ETL SDET (Data Quality Automation Engineer) position at First Soft Solutions LLC?
Work Authorization: US Citizen or Green Card Holder Only (No Sponsorship)
Required Experience
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
- 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.