Sr ETL TesterExperience: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 experienceGood 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.- Robust 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 (ref:hirist.tech)

📌 Senior ETL Tester - Data Validation - Data Warehousing (Chennai)
🏢 Growel Softech
📍 Chennai