Posted 169 months ago
ETL Developer
@ system canada technologies
Toronto, Ontario
Overview
System Canada Technologies is hiring a contract ETL Developer to design and build Informatica ETL jobs against relational databases and flat files. The role covers requirements gathering, technical specifications, Unix shell scripting for automation, testing, and production support including some off-hours work.
Responsibilities:
- Design and develop Informatica ETL jobs
- Gather requirements and write ETL mapping documents
- Develop Unix shell scripts for job automation
- Build error handling, tune performance, and run unit tests
- Troubleshoot and support production issues, including off-hours
Requirements summary:
- 6+ years data warehouse and BI design and development
- 5+ years Informatica ETL development
- Strong Unix and Windows scripting
- Strong SQL with Oracle 10g or later
- Teradata experience an asset
Tools & skills
Source and dates
Employer career site / ATS feed · smartrecruiters
- Employer posting date
- 2012-12-31
- First seen by our source
- 2026-10-14
- Source record updated
- 2026-10-14
These dates describe the source record, not a live verification that the employer is still hiring. Check the original posting.
Job details
| Seniority | Senior |
| Department | Data & analytics |
| Experience | 6+ years |
| 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.
system canada technologies
| Field | Value |
|---|---|
| Open jobs on Jobsy | 399 |
Company Description
SCT resources have a broad range of skills in different technologies. The large skill-set has been made possible by a conscious focus on strengthening our skills base. Every person selected for our team brings something new, something that adds to our offerings. We learn continuously, both on the job and through formal training programs.
Job Description
Responsibilities:
- Design and develop ETL jobs in Informatica against Relational databases and Flat files.
- Gathering business requirements and creating technical specifications and ETL mapping documents.
- Work closely with Datamodelling team and DBAs.
- Develop Unix Shell Scripts for jobs automation.
- Develop error handling capabilities and Performance tuning.
- Develop and execute Unit test plan and support SIT/UAT testing.
- Troubleshoot & analyze production issues and provide support (including off-hours at times)
Required Skills/Experience:
- 6+ years of Datawarehouse and Business Intelligence design and development
- 5+ years of experience in ETL Development, using Informatica. Informatica 8.6.1 would be plus
- Troubleshoot ETL failures, defects and remediate them. Experience in resolving ETL performance issues.
- Strong Unix and Windows Scripting skills.
- Strong SQL skills and experience with Oracle 10g or later, with a proven ability to perform thorough analysis. Teradata experience a plus.
- Knowledge of software development life cycle for Datawarehouse and Business Intelligence projects.
- Excellent written and verbal communication skills.
- Ability to work independently or on a team with high motivation and quick learning.
- Excellent analytical, technical aptitude and proven ability to solve problems and the ability to engage effectively with business and technical teams.
Journal
Only you can see this. Kept on this device, and in your account when you sign in.