ETL Test Engineer – Data Warehouse Testing, SQL, ETL, Data Validation
Astra North Infoteck Inc. · Toronto, Canada ·
- Category
- QA
agileautomationdata-pipelinesdata-warehousingetllinuxpythonroot-cause-analysissqltest-automationunix
ETL Data Tester – ETL Testing, Data Warehouse, SQL, UNIX/Linux, Informatica
Key Responsibilities
• Perform end-to-end testing of ETL processes, data pipelines, and Data Warehouse solutions
• Validate source-to-target data mappings, data transformations, and business rules
• Design, develop, and execute test cases, test scenarios, and test scripts for data validation
• Perform data reconciliation, completeness, accuracy, and integrity checks across systems
• Write complex SQL queries for data analysis, validation, and defect investigation
• Utilize UNIX/Linux commands for file validation, batch job monitoring, and troubleshooting
• Collaborate with developers, business analysts, and stakeholders to understand requirements and resolve defects
• Support defect tracking, root cause analysis, and test reporting activities
• Exposure to Informatica workflows, mappings, and ETL jobs is preferred
• Experience with Python automation for test automation, data validation, and reporting will be considered a strong advantage
Required Skills
• ETL Testing
• Data Warehouse Testing
• Strong SQL
• UNIX/Linux
• Basic Informatica Knowledge
Good to Have
• Python Automation
• Data Validation Automation Frameworks
• Agile Testing Experience