ETL DB Testing

Key Responsibilities :

• Analyze business and technical requirements for data movement and transformation processes.
• Create and execute test plans , test cases , and test scripts for ETL pipelines.
• Perform source-to-target mapping (S2T) validation and data reconciliation .
• Validate ETL transformation logic , data loads , aggregations , and data quality rules .
• Conduct black-box , white-box , and integration testing on data flows.
• Write complex SQL queries to validate data accuracy across databases (Oracle, SQL Server, PostgreSQL, etc.).
• Work with ETL developers to understand mappings and raise defects using tools like JIRA , ALM , or Bugzilla .
• Participate in regression testing during code changes or production deployments.
• Automate database testing scripts and contribute to continuous integration testing pipelines (if applicable).
• Document test results and create reports for QA sign-off and audits.

Required Skills and Qualifications :

Preferred Qualifications :

Skills Required

Aws Redshift, snowflake , Azure Synapse, Oracle, Sql Server, Mysql, Informatica, Talend