Job Title: Test Automation Developer (TAD) – ETL & Data Warehouse

Location: Toronto, ON

Work Model: Remote

Employment Type: Full time (FTE)

Experience: 8+ Years

Required Experience

- 7+ years of experience in ETL Testing, Data Warehouse Testing, and Data Validation
- Strong hands-on experience with SQL, UNIX/Linux , and enterprise data testing
- Experience testing ETL processes, data pipelines, and large-scale Data Warehouse solutions
- Familiarity with Agile testing methodologies and defect management processes

Key Responsibilities

- Perform end-to-end testing of ETL processes, Data Pipelines, and Data Warehouse solutions.
- Validate source-to-target 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, consistency, and integrity checks across multiple systems.
- Write and execute complex SQL queries for data validation, analysis, and defect investigation.
- Utilize UNIX/Linux commands for file validation, batch job monitoring, and troubleshooting.
- Execute ETL testing for batch jobs, data loads, and warehouse validations.
- Collaborate with Developers, Business Analysts, and stakeholders to clarify requirements and resolve defects.
- Support defect tracking, root cause analysis, test reporting,



and release validation.
- Review Informatica mappings, workflows, and ETL jobs to validate processing logic.
- Develop automation scripts using Python for data validation, regression testing, and reporting (preferred).

Required Technical Skills

- ETL Testing
- Data Warehouse Testing
- Data Validation
- Data Reconciliation
- Source-to-Target Mapping Validation
- SQL (Advanced)
- Database Testing
- UNIX/Linux
- Batch Job Monitoring
- Defect Management
- Root Cause Analysis
- Test Case Design & Execution
- Functional Testing
- Regression Testing
- Integration Testing

Preferred Skills

- Informatica PowerCenter
- Informatica Workflows & Mappings
- Python Automation
- Test Automation Frameworks
- Data Validation Automation
- Agile/Scrum Methodology
- CI/CD Exposure

Preferred Qualifications

- Experience with enterprise Data Warehouse platforms
- Hands-on experience with ETL automation and data quality testing
- Knowledge of Data Governance and Data Quality best practices
- Experience working in Agile development environments

Key Competencies

- ETL & Data Warehouse Testing
- SQL & Data Analysis
- Test Automation
- Data Quality & Validation
- Problem Solving & Root Cause Analysis
- Attention to Detail
- Cross-Functional Collaboration

Excellent Communication Skills

📌 Test Automation Developer (TAD) – ETL & Data Warehouse - Toronto, ON (Remote) - FTE
🏢 AceStack
📍 Toronto