Senior ETL Tester - Data Validation - Data Warehousing

Sr ETL Tester Experience: 5 - 7 Years (Must have 5+ years of relevant ETL Testing experience; candidates with more than 7 years of total experience will not be considered) Responsibilities: - Create, review, and execute test cases. - Perform data validation using SQL queries. - Conduct database and ETL testing activities. - Track and manage defects through Jira. - Handle day-to-day testing and reporting activities in Jira. Must-Have Skills: - SQL (Intermediate level) with scripting experience - Database Testing - ETL Tools experience (DataStage, Informatica, Data Warehouse tools, or similar) - Data Validation and Reconciliation - Reporting and Data Analysis experience - Experience validating data by executing SQL queries - Data Migration Testing - PostgreSQL Database experience Good to have: - Insurance domain and Guidewire. Primary Objective: Ensure high data reliability, validate data movement (ETL/ELT), uncover anomalies, and enforce data governance rules before data reaches analytics, reporting, or machine learning models. Key Responsibilities: - Data Profiling & Auditing: Analyze data structures, distributions, and patterns to spot anomalies, missing values, or formatting inconsistencies. - ETL & Pipeline Testing: Write complex SQL queries and test scripts to compare source versus target data and validate data warehouse (DWH) loads. - Data Cleansing & Standardization: Build or enforce processes for deduplicating, standardizing formats, and correcting data errors. - Root Cause Analysis: Investigate why data quality breaks (e.g., tracking back to upstream schema changes, system glitches, or user entry errors) and recommend fixes. Required Skills & Qualifications: - Advanced SQL for querying, aggregating, and validating large datasets. - Experience with ETL tools and data warehouses (e.g., Datastage, Postgres, Informatica, SSIS, Talend, Snowflake, Apache NiFi). - Programming or scripting knowledge in Python, R, or JavaScript. - Data visualization and reporting platforms like Power BI or Tableau. - Strong problem-solving for root-cause tracking. - Ability to translate technical data findings for non-technical business stakeholders. Education & Experience: - Typically 3 to 6 years of experience in data management, data warehousing, or software testing/QA