
Open since Dec 2012
ETL Developersystem canada technologies · Toronto
ETL Developer
TorontoOn-siteContract
AI Summary
Design and develop ETL jobs in Informatica against relational databases and flat files, gather business requirements, create technical specifications and ETL mapping documents, and troubleshoot production issues.
About this role
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.
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.
Skills
Error HandlingETL DevelopmentFlat FilesInformaticaOraclePerformance TuningRelational DatabasesSIT/UAT TestingSQLTeradataUnit TestingUnix Shell Scripting
Explore related jobs
More jobs at system canada technologies
- S
Immediate job oppurtunity - Web Analyst with BIG DATA / HADOOP experience ( Philadelphia )Philadelphia, PA - S
ASP.net developer with C# experience with strong knowledge of databasesToronto, Canada - S
Immediate requirement - SENIOR APPLICATION PERFORMANCE TESTERToronto, Canada - S
QTP Automation DeveloperToronto, Canada
Similar Flat Files jobs
- K
Informatica Cloud Real Timekrg technology inc · Universal City, CA - FSenior Workato Integration EngineerFive9 · India (Remote)
- U
Boomi Integration EngineersUnison Group · Chennai, Tamil Nadu - C
Datawarehouse and ETL with Informatica Power Center (Technology Lead)Career Guidant · Phoenix, AZ - B
Sr Workato EngineerBayrock Labs · Sunnyvale, CA - P
Applikations-Entwickler (MS Dynamics)PROSTAFF Schweiz GmbH · Zürich, Switzerland
Browse these categories
Market data for this role
All reports →- SeriesRole reportsOne role family at a time: how many openings, what changed this week, who is hiring, what it pays.
- SeriesSalary reportsWhat employers publish in job postings, by level and workplace. Not self-reported pay.
- Market overviewState of tech hiring, September 2026: up 4.8%Tech hiring rose 4.8% month over month in September 2026, with 411,122 new listings. Customer support and account executive roles led the growth.