ETL Test Analyst

We are looking for an experienced ETL Tester / ETL Test Analyst with 4-6 years of experience in ETL testing, data warehouse testing, database validation, and data quality testing. The candidate will be responsible for validating data extraction, transformation and loading processes across enterprise applications and data platforms in a large-scale insurance environment.

Responsibilities:

• Design and execute ETL test scenarios, test cases and test scripts based on business and technical requirements.
• Validate source-to-target data mapping, transformation rules, business rules and data flows.
• Perform ETL, Data Warehouse and Database Testing across multiple data sources and target systems.
• Validate data extraction, transformation, loading and reconciliation processes.
• Perform data validation, data completeness, data accuracy and data integrity testing.
• Write complex SQL queries for backend data validation, reconciliation and defect analysis.
• Validate source-to-target mappings and identify data discrepancies.
• Perform database testing involving joins, stored procedures, views, functions, indexes and constraints.
• Test incremental loads, full loads, CDC and batch processing where applicable.
• Validate ETL workflows, schedules, dependencies and error-handling mechanisms.
• Perform data reconciliation between source and target systems and investigate mismatches.
• Validate duplicate records, missing records, null values, data truncation and transformation errors.
• Execute regression, integration, system and end-to-end testing for ETL/data pipelines.
• Validate large-volume datasets and perform data quality and consistency checks.
• Work with developers, data engineers, business analysts and product teams to resolve data-related issues.
• Analyse ETL job failures and assist development teams with root-cause analysis (RCA).
• Log, track and manage defects using tools such as Jira, Azure DevOps or similar.
• Prepare test execution reports, defect reports and testing status updates.
• Participate in requirement analysis, test planning, estimation and defect triage meetings.
• Support UAT, production validation and post-release data verification.
• Ensure testing complies with enterprise data governance, security, privacy and quality standards.
• Work in an Agile/Scrum environment and participate in sprint planning, daily stand-ups, reviews and retrospectives.
• Collaborate with globally distributed teams and stakeholders across business and technology functions.
• Understanding insurance-domain data such as policy, customer, claims, billing, premium and financial data is an advantage.

Requirements:

• 4-6 years of hands-on experience in ETL Testing / Data Warehouse Testing / Database Testing.
• Strong understanding of ETL concepts, data warehousing and data integration processes.
• Strong hands-on SQL skills including complex joins, subqueries, CTEs, aggregations and data reconciliation queries.
• Experience with ETL tools such as Informatica, IBM DataStage, SSIS, Talend, Azure Data Factory or similar.
• Experience testing large-volume data and enterprise data pipelines.
• Good understanding of Dimensional Data Modelling, Star Schema, Snowflake Schema, Fact and Dimension tables.
• Strong knowledge of source-to-target mapping and transformation validation.
• Experience with Oracle, SQL Server, DB2 PostgreSQL or other relational databases.
• Knowledge of batch processing, scheduling, incremental/full loads and data migration testing.
• Experience with API, web service or downstream application data validation is preferred.
• Good understanding of SDLC, STLC, defect lifecycle and Agile methodologies.
• Experience with Jira, Azure DevOps, ALM or similar test/defect management tools.
• Exposure to cloud data platforms such as Azure/AWS is an added advantage.
• Exposure to Python or scripting for test-data validation/automation is desirable.
• Knowledge of data quality, reconciliation, data lineage and data governance.
• Strong analytical and problem-solving skills with the ability to investigate complex data issues.
• Excellent communication and stakeholder-management skills.
• Prior experience in Insurance, BFSI or other regulated enterprise environments will be highly preferred.

Skills

azure data factory, data warehouse, database, datastage, etl, informatica, sql, ssis, talend