Posted 169 months ago
BI-Informatica Developer
@ system canada technologies
Toronto, Ontario
Overview
SCT resources is hiring a contract BI-Informatica Developer to build and maintain ETL processes for large OLAP and OLTP data sets. The role involves Informatica PowerCenter workflows, Oracle SQL and performance tuning, and gathering requirements from end users. Healthcare industry knowledge is a plus.
Responsibilities:
- Create, tune and test complex ETL processes for OLAP/OLTP data sets
- Create and maintain Informatica 8.x/9.x workflows
- Gather requirements with end users
- Validate business rules and transformations
Requirements summary:
- Expertise in Informatica PowerCenter 8.6 and 9.x suite
- Strong Oracle SQL and query optimization skills
- Experience with incremental loads and performance tuning
- Healthcare industry knowledge a plus
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
| Department | Software development |
| 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
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
Journal
Only you can see this. Kept on this device, and in your account when you sign in.