ETL Testing

The Senior ETL Database Tester will be responsible for validating the Extract Transform Load ETL processes and ensuring the accuracy completeness and integrity of data across data pipelines and warehouses This role demands handson experience with SQL ETL tools and data validation frameworks along with strong analytical and problemsolving skillsShapeKey ResponsibilitiesETL TestingValidationDesign develop and execute?test plans test cases and test scripts?for ETL workflowsValidate?data extraction transformation and loading?procedures across staging DWH and DataMart layersPerform?data reconciliation row count checks and columnlevel validations between source and target systemsCollaborationDocumentationWork closely with?ETL developers data engineers and business analysts?to understand transformation logic and business rulesMaintain documentation in tools like?JIRA HP ALM and create traceability matrices and defect logsAutomationOptimizationAutomate repetitive testing tasks using scripting languages eg Python ShellAnalyze test results and provide detailed reports to stakeholdersEnsure compliance with?data governance and quality standardsShapeRequired SkillsExperienceTechnical SkillsSQL expertise Joins subqueries analytical functions and performance tuningETL Tools Informatica Talend SSISDatabase Platforms Oracle SQL Server Teradata PostgreSQLOperating Systems Windows UnixLinuxScripting Shell scripting Python preferredTesting Tools JIRA HP ALM