Closed listing
ETL Informatica Developer
- Markham, ON, Canada
$90,000 to $125,000 CAD / year · Full-time
This opening has closed.
The original listing is kept below for reference.
Job details
- Pay
- $90,000 to $125,000 CAD / year
- Job type
- Full-time
- Closing date
- Posting language
- English
- Posted
Similar jobs hiring now
Search current openingsOriginal job description
Archived listing. The details below describe a past opening.
Job Title: ETL Informatica
Job Location: Markham, ON (3 Days Onsite)
Employment Type: Fulltime
Duration: Permanent
Compensation Range: 90k-120k + Benefit
This is an active job and application deadline is Sep 30, 2026
(This posting may close earlier if a suitable candidate is found)
Job Description
- We are seeking an ETL Developer with strong hands-on experience in Informatica PowerCenter to design, develop, and maintain robust data integration workflows.
- The candidate will build and optimize ETL mappings, sessions, and workflows to extract, transform, and load data from diverse source systems into target data warehouses.
- Strong proficiency in SQL is required for writing complex queries, stored procedures, and performance tuning of large datasets.
- The role involves troubleshooting data quality issues, ensuring data integrity, and collaborating with cross-functional teams to support business intelligence and reporting needs.
- Prior experience in a data warehousing environment and familiarity with job scheduling tools is preferred.
- We use AI-enabled tools to assist in screening applications based on job-related criteria.
Avanciers Incorporated is an equal opportunity employer committed to creating an inclusive and accessible workplace. We welcome applications from all qualified individuals regardless of race, color, religion, sex, sexual orientation, gender identity, national origin, disability, age, or any other protected characteristic. We are committed to providing accessible employment practices that comply with the Accessibility for Ontarians with Disabilities Act (AODA).
Important Information for Applicants
- Only candidates selected for an interview will be contacted
- Proof of qualifications may be requested
- Background checks may be conducted as part of the hiring process
- Avanciers Incorporated does not use Canadian Social Insurance Numbers (SIN) during the application process
Avanciers Incorporated
www.avanciers.com
More about this job
Responsibilities
Design, develop, maintain, and optimize Informatica PowerCenter ETL mappings, sessions, and workflows to move data from diverse sources into target data warehouses. Troubleshoot data quality and integrity issues, tune SQL and large-dataset performance, and collaborate with teams supporting business intelligence and reporting.
Requirements
The role calls for strong hands-on Informatica PowerCenter experience and strong SQL skills, including complex queries, stored procedures, and performance tuning. Data warehousing experience and familiarity with job scheduling tools are preferred.
Skills
- Informatica PowerCenter
- ETL Development
- Data Integration
- ETL Mapping
- ETL Sessions
- ETL Workflows
- SQL
- Complex Queries
- Stored Procedures
- Performance Tuning
- Data Warehousing
- Data Quality
- Data Integrity
- Job Scheduling
- Troubleshooting
- Business Intelligence
Benefits
- Benefits (unspecified)
Visa sponsorship
Not detected in the job text
Categories
- Technology
- Data & Analytics
- Software
Keywords
- Informatica PowerCenter
- ETL
- Data Integration
- ETL Mappings
- ETL Sessions
- ETL Workflows
- SQL
- Complex Queries
- Stored Procedures
- Performance Tuning
- Data Warehousing
- Source Systems
- Target Data Warehouses
- Data Quality
- Data Integrity
- Large Datasets
- Job Scheduling Tools
- Business Intelligence
- Reporting
- Data Integration Workflows