ETL Test Engineer – Data Warehouse Testing, SQL, ETL, Data Validation
- Toronto, ON, Canada
Applications open in a new tab.
Job details
- Posting language
- English
- Posted
Original job description
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
More about this job
Responsibilities
The ETL Data Tester will test ETL processes and data warehouse solutions from end to end. They will check that data is moved and transformed correctly and write SQL to investigate and report defects.
Requirements
Candidates need solid ETL and data warehouse testing experience and strong SQL. Basic Informatica knowledge and UNIX/Linux skills are required, with Python automation and Agile testing as assets.
Skills
- ETL testing
- Data warehouse testing
- SQL
- Complex SQL queries
- UNIX/Linux commands
- Informatica
- Data validation
- Data reconciliation
- Source-to-target mapping
- Test case design
- Test script development
- Batch job monitoring
- Defect tracking
- Root cause analysis
- Test reporting
- Python
- Test automation
- Data validation automation frameworks
- Agile testing
- Stakeholder collaboration
Categories
- Technology
- Data & Analytics
- Software
Keywords
- ETL testing
- data warehouse testing
- SQL
- UNIX
- Linux
- Informatica
- data validation
- data reconciliation
- source-to-target mapping
- test automation
- Python
- batch job monitoring
- defect tracking
- root cause analysis
- Agile testing
- data quality
- data pipelines
- test cases
- test scripts
- data integrity
Tools
- SQL
- UNIX/Linux
- Informatica
- Python
Languages
- English