Role: ETL QA Engineer (Finance Domain)

Location: Boston, MA

MUST HAVE

• LOCAL MA
• Finance/Banking/ Payment domain only
• ETL Tester
• SQL scripting
• Java-based automation

We are looking for an experienced ETL QA Engineer with strong expertise in ETL testing, SQL, Java-based automation, and financial domain knowledge. The ideal candidate should have hands-on experience validating large-scale data pipelines and ensuring data accuracy, integrity, and performance across enterprise systems.

Key Responsibilities

• Perform end-to-end ETL testing across data ingestion, transformation, and loading layers
• Validate data accuracy between source systems, staging, and target data warehouses
• Write and optimize complex SQL queries for data validation and reconciliation
• Work closely with data engineers and business analysts in the finance domain
• Build and maintain automation frameworks using Java (Selenium/TestNG/JUnit or similar)
• Develop reusable automation scripts for regression and data validation
• Identify data quality issues and perform root cause analysis
• Ensure data compliance, integrity, and performance standards are met
• Participate in Agile ceremonies and sprint deliverables

Required Skills & Experience

• Strong experience in ETL Testing (mandatory)
• Excellent hands-on knowledge of SQL (complex joins, subqueries, aggregations, window functions)
• Solid experience in Java for test automation
• Experience in automation testing frameworks (Selenium / TestNG / JUnit or similar)
• Strong understanding of Finance domain (banking, trading, payments, or risk systems)
• Experience in data validation, reconciliation, and backend testing
• Good analytical and problem-solving skills

Good to Have (Optional)

• Exposure to API testing tools (Postman/Rest Assured)
• Experience with CI/CD tools (Jenkins, Git, etc.)
• Basic understanding of cloud data platforms (AWS / Snowflake / Azure)
• Knowledge of AI prompt engineering is NOT required / not a priority
• Playwright knowledge is optional (not required, Selenium/Java is preferred)