Jobs → QA & Testing → ETL Tester

About the Role We are looking for a strong ETL Tester with solid Data Warehouse / Data Validation experience to join our team in Boston. Key Responsibilities • Validate ETL jobs, Data Loads, Transformations and Business Rules • Perform Data Profiling, Data Quality Checks, Reconciliation • Write complex SQL queries to validate Source vs Target • Prepare Test Strategy, Test Cases, Test Data for ETL / DWH projects • Report defects, work closely with ETL Developers & Business Analysts • Automate ETL validation where possible - Python / QuerySurge / iCEDQ Requirements • Up to 6 Years experience in ETL / Data Testing • Strong SQL - Complex Queries, Joins, Stored Procedures, Data Validation • Hands-on ETL Tools - Informatica PowerCenter / IICS, Talend, SSIS, DataStage • Data Warehouse Concepts - Star Schema, Snowflake Schema, Facts, Dimensions, SCD • Source to Target Mapping Validation, Data Completeness, Data Accuracy Testing • Experience with Snowflake / Oracle / SQL Server / Teradata • Test Cases, Test Plans, Defect Reporting - JIRA, ALM, Zephyr • Unix / Shell Scripting - Basic • Agile / Scrum Experience