Senior ETL Test Automation Engineer
Location: Quincy, MA 02171
Work Model: Hybrid (Onsite/Remote)
Experience Required: 10+ Years
Interview Process: Face-to-Face Interview Required
<.>Job Summary
We are seeking a Senior ETL Test Automation Engineer with strong experience in Data Warehouse Testing, ETL Testing, Cloud Testing, and Python Automation. The ideal candidate will have hands-on experience validating large-scale data platforms, testing ETL pipelines, and automating test processes in cloud and big data environments.
<.>Required Skills
- 10+ years of QA and Testing experience
- Strong experience in Data Warehouse and ETL Testing
- Experience with Cloud Testing and Big Data platforms
- Strong Python Automation skills
- Experience with API Test Automation
- Strong SQL skills for complex data validation and reconciliation
- Oracle Database Testing experience
- Experience with Java Automation
- Experience working in Agile environments
- Hands-on experience with JIRA, HP ALM, and Octane
- Experience creating Test Plans, Test Strategies, and Test Closure Reports
<.>Preferred Skills
- Experience with Generative AI (Gen AI)
- Capital Markets or Financial Services domain experience
<.>Key Responsibilities
- Perform ETL and Data Warehouse testing for large-scale enterprise applications
- Validate source-to-target data mappings and transformation logic
- Develop and maintain Python-based automation frameworks
- Execute API, functional, and regression testing
- Perform Cloud and Big Data testing across modern data platforms
- Create and execute test plans, test cases, and test strategies
- Analyze test results and coordinate defect triage activities
- Work closely with developers, business analysts, and stakeholders in Agile teams
- Ensure data quality, accuracy, and integrity across enterprise systems
<.>Technical Skills
- ETL Testing
- Data Warehouse Testing
- Python Automation
- Java Automation
- API Testing
- Complex SQL
- Oracle Database
- Cloud Testing
- Big Data Testing
- HP ALM / Octane / JIRA
- Agile Methodologies
<.>Domain Experience
- Capital Markets experience preferred