echojobs.io
Login

System Canada Technologies

Business Intelligence Informatica Developer

Toronto, ON
Informatica SQL Oracle ETL
Search for More Jobs
Description

BI-Informatica Developer

Location: Toronto, ca

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

Job Responsibilities: 


Create, tuning and testing complex ETL processes for large and complex OLAP/OLTP data sets 
Create and maintain Informatica 8.x/9.x workflows 
Create ETL processes from business requirements. 
Participate in requirement meetings with end-users to understand and collect requirements. 
Validate the accuracy of business rules and transformations 

Required Skills/Qualification: 


Informatica 
Strong knowledge of HealthCare industry, a plus 
8.6 and 9.x suite of products 
Expertise in the entire PowerCenter suite (Repository Manager, Designer, Workflow Manager, and Workflow Monitor) 
Conforming and merging data from multiple data source types (ie MSSQL, Oracle, flat files, etc.) 
o Incrementally loading large tables with complex keys 
o Using transformations to implement complex business rules 
Workflow management 
o Designing incremental load logic 
o Error handling 
o Using Informatica to restart failed jobs 
o Tracking performance and job status and job scheduling 
Performance tuning 
o Workflow optimization 
o Mapping optimization 
o Transformation optimization 
ETL documentation 
o Experience using ASG-Rochade is a plus 
Oracle 
Experience with Oracle 11g preferred 
Experience writing complex SQL queries against large data sets 
Query optimization (indexing, partitioning, Oracle configuration, etc.) 
o Experience capturing and interpreting Oracle performance based statistics is a plus 
Creating, modifying and optimizing stored procedures and packages 
Familiarity with dimensional models and Operational Data Stores 
Experience gathering and implementing business rules 
Experience reconciling data output to existing reports and source data 
Excellent oral and written communication 
Self Starter who takes initiative 

System Canada Technologies
System Canada Technologies

0 applies

0 views

There are more than 50,000 engineering jobs:

Subscribe to membership and unlock all jobs

Engineering Jobs

60,000+ jobs from 4,500+ well-funded companies

Updated Daily

New jobs are added every day as companies post them

Refined Search

Use filters like skill, location, etc to narrow results

Become a member

đŸ„łđŸ„łđŸ„ł 452 happy customers and counting...

Overall, over 80% of customers chose to renew their subscriptions after the initial sign-up.

To try it out

For active job seekers

For those who are passive looking

Cancel anytime

Frequently Asked Questions

  • We prioritize job seekers as our customers, unlike bigger job sites, by charging a small fee to provide them with curated access to the best companies and up-to-date jobs. This focus allows us to deliver a more personalized and effective job search experience.
  • We've got over 200,000 jobs from 15,000+ vetted companies. No fake or sleazy jobs here!
  • We aggregate jobs from 15,000+ companies' career pages, so you can be sure that you're getting the most up-to-date and relevant jobs.
  • We're the only job board *for* software engineers, *by* software engineers
 in case you needed a reminder! We add thousands of new jobs daily and offer powerful search filters just for you. đŸ› ïž
  • Every single hour! We add 2,000-3,000 new jobs daily, so you'll always have fresh opportunities. 🚀
  • Typically, job searches take 3-6 months. EchoJobs helps you spend more time applying and less time hunting. 🎯
  • Check daily! We're always updating with new jobs. Set up job alerts for even quicker access. 📅

What Fellow Engineers Say