Senior Etl Tester

Key Responsibilities

• Analyze business requirements, source-to-target mappings, and ETL design documents.
• Design and execute ETL test strategies, test plans, test cases, and test scenarios.
• Validate data accuracy, completeness, consistency, integrity, and traceability across source and target systems.
• Perform ETL, Data Warehouse, Data Migration, Regression, and Integration Testing.
• Write and execute complex SQL queries for data validation and reconciliation.
• Validate transformation rules, business logic, aggregations, calculations, and data mappings.
• Perform source-to-target data validation and investigate data discrepancies.
• Validate full-load, incremental-load, and Change Data Capture (CDC) processes.
• Create and maintain automated test scripts and data validation frameworks.
• Investigate data defects, perform root cause analysis, and collaborate with development teams for resolution.
• Validate data quality controls, exception handling, reconciliation reports, and audit requirements.
• Support Agile delivery teams and participate in sprint ceremonies.
• Perform performance and volume testing of data pipelines.
• Provide quality metrics, test execution reports, and release readiness assessments.

Required Skills

• 6+ years of experience in ETL/Data Warehouse Testing.
• Strong expertise in ETL testing methodologies and data validation techniques.
• Advanced SQL skills including:
• Complex Queries
• Joins
• CTEs
• Stored Procedures
• Data Reconciliation
• Experience with one or more ETL tools:
• Informatica
• SSIS
• DataStage
• Talend
• Azure Data Factory (ADF)
• Experience in Data Migration Testing and Data Warehouse Testing.
• Strong understanding of Agile/Scrum delivery models.
• Experience with defect management tools such as JIRA or Azure DevOps.
• Excellent analytical, troubleshooting, and communication skills.