ETL Tester
Posted 2 days ago by Prabhav Services Inc
Negotiable
Undetermined
Remote
Remote
Summary: We are seeking an experienced ETL Tester with a strong background in ETL testing, data validation, and SQL. The role involves analyzing requirements, designing test scenarios, and ensuring data quality across systems. The ideal candidate will collaborate with various stakeholders to resolve data-related issues and prepare test reports. Strong analytical skills and communication abilities are essential for success in this position.
Key Responsibilities:
- Analyze business and functional requirements related to data integration projects.
- Design, develop, and execute ETL test scenarios, test cases, and test scripts.
- Validate data extraction, transformation, and loading processes.
- Perform source-to-target data validation to ensure data accuracy and completeness.
- Verify data mappings, transformation logic, and business rules.
- Execute data quality, integration, regression, and end-to-end testing.
- Write and execute SQL queries for data validation and reconciliation.
- Identify, document, track, and retest defects throughout the testing lifecycle.
- Collaborate with developers, business analysts, and stakeholders to resolve data-related issues.
- Prepare test reports and provide regular status updates on testing activities.
- Ensure compliance with data governance and quality standards.
Key Skills:
- Strong experience in ETL Testing and Data Warehouse Testing.
- Proficiency in SQL for data analysis and validation.
- Good understanding of ETL concepts, data migration, and data integration processes.
- Experience with source-to-target mapping validation.
- Knowledge of relational databases and data warehousing concepts.
- Experience in defect management and test lifecycle processes.
- Strong analytical and problem-solving skills.
- Excellent communication and stakeholder management skills.
Salary (Rate): undetermined
City: undetermined
Country: undetermined
Working Arrangements: remote
IR35 Status: undetermined
Seniority Level: undetermined
Industry: IT
Job Description:
We are seeking an experienced ETL Tester The ideal candidate should have strong experience in ETL testing, data validation, SQL, and ensuring data quality across source and target systems.
Key Responsibilities:
- Analyze business and functional requirements related to data integration projects.
- Design, develop, and execute ETL test scenarios, test cases, and test scripts.
- Validate data extraction, transformation, and loading processes.
- Perform source-to-target data validation to ensure data accuracy and completeness.
- Verify data mappings, transformation logic, and business rules.
- Execute data quality, integration, regression, and end-to-end testing.
- Write and execute SQL queries for data validation and reconciliation.
- Identify, document, track, and retest defects throughout the testing lifecycle.
- Collaborate with developers, business analysts, and stakeholders to resolve data-related issues.
- Prepare test reports and provide regular status updates on testing activities.
- Ensure compliance with data governance and quality standards.
Required Skills:
- Strong experience in ETL Testing and Data Warehouse Testing.
- Proficiency in SQL for data analysis and validation.
- Good understanding of ETL concepts, data migration, and data integration processes.
- Experience with source-to-target mapping validation.
- Knowledge of relational databases and data warehousing concepts.
- Experience in defect management and test lifecycle processes.
- Strong analytical and problem-solving skills.
- Excellent communication and stakeholder management skills.