Posted 3 months ago
ETL Test Engineer – Data Warehouse Testing, SQL, ETL, Data Validation
@ Astra North Infoteck Inc.
Toronto, Ontario
Overview
Astra North Infoteck Inc. is hiring an ETL test engineer to validate data pipelines and data warehouse solutions end to end. The work covers source-to-target mapping checks, SQL-based data validation, and UNIX/Linux batch monitoring. Informatica exposure is preferred and Python automation is an advantage.
Responsibilities:
- End-to-end testing of ETL processes and data warehouse solutions
- Validate source-to-target mappings and transformation rules
- Write SQL for data analysis and defect investigation
- Monitor batch jobs and validate files using UNIX/Linux
- Support defect tracking, root cause analysis and test reporting
Requirements summary:
- ETL testing and data warehouse testing experience
- Strong SQL skills
- UNIX/Linux proficiency
- Basic Informatica knowledge
- Python automation experience is an asset
Tools & skills
Source and dates
Source type not verified · zoho
- Employer posting date
- 2026-08-06
- First seen by our source
- 2026-10-11
- Source record updated
- 2026-10-11
These dates describe the source record, not a live verification that the employer is still hiring. Check the original posting.
Job details
| Department | IT |
| Travel | air: none · ground: none |
| Work setting | Office |
| Position | Mostly sitting |
| Physical demands | physical low · computer high |
| Languages | English |
Summary and details written by AI from the posting; the employer’s posting is the authority.
Astra North Infoteck Inc.
| Field | Value |
|---|---|
| Open jobs on Jobsy | 426 |
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
Journal
Only you can see this. Kept on this device, and in your account when you sign in.