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