ETL Developer
systemcanadatechnologies· Canada
About this role
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.
Qualifications
Additional Information
Frequently Asked Questions
Is the salary disclosed for the ETL Developer position at systemcanadatechnologies?
The salary for this ETL Developer role at systemcanadatechnologies is not publicly listed. Click "Apply Now" to learn more about the compensation package on their official careers page.
Where is the ETL Developer position at systemcanadatechnologies located?
This ETL Developer role at systemcanadatechnologies is based in Toronto, Toronto, , Canada, ca. The position is listed as on-site or hybrid. Check the full job description or apply directly to confirm the work arrangement.
Is the ETL Developer role at systemcanadatechnologies full-time or part-time?
This is listed as a Contract position. It is posted as a ETL Developer role in the Canada department at systemcanadatechnologies.
Which team or department does the ETL Developer at systemcanadatechnologies belong to?
This ETL Developer position is part of the Canada department at systemcanadatechnologies. See the full job description for more information about the team structure and responsibilities.
How do I apply for the ETL Developer position at systemcanadatechnologies?
Click the "Apply Now" button on this page. You will be redirected to systemcanadatechnologies's official application portal hosted on smartrecruiters where you can submit your application directly.
When was the ETL Developer job at systemcanadatechnologies posted?
This ETL Developer position at systemcanadatechnologies was posted on Dec 31, 2012. Apply as soon as possible — early applications are often reviewed first.
ETL Developer
systemcanadatechnologies
You'll be redirected to systemcanadatechnologies's official application page on SmartRecruiters.