ETL Test Engineer

Essential Duties:

• Examine business requirements and create source-to-target mapping documents along with data models
• Develop and implement ETL test cases and scenarios
• Confirm the accuracy of data extraction, transformation, and loading processes
• Conduct source-to-target data validation and reconciliation efforts
• Ensure data completeness, accuracy, integrity, and consistency
• Perform functional regression, system, and integration testing
• Construct complex SQL queries for the purpose of data validation
• Identify, document, and monitor defects using defect management software
• Assess data in data warehouses, data marts, and reporting systems
• Conduct backend database testing
• Work collaboratively with developers, business analysts, data engineers, and various stakeholders
• Engage in Agile Scrum ceremonies

Technical Qualifications:

• Expertise in Technology Data Services Testing, Data Warehouse Testing, ETL tool technology, ETL Data Quality, and other related ETL technologies

Preferred Competencies:

Technology->Data Services Testing->Data Warehouse Testing->ETL tool, Technology->ETL & Data Quality->ETL - Others