Full-Time
BI-Informatica Developer
System Canada Technologies
No salary listed
Toronto, ON, Canada
In Person
Category
 Data & Analytics (1) |
|---|
Required Skills
SQL
ETL
Informatica
Oracle
Requirements
- Informatica
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
- Conforming and merging data from multiple data source types (ie MSSQL, Oracle, flat files, etc.)
- Incrementally loading large tables with complex keys
- Using transformations to implement complex business rules
- Workflow management
- Designing incremental load logic
- Error handling
- Using Informatica to restart failed jobs
- Tracking performance and job status and job scheduling
- Performance tuning
- Workflow optimization
- Mapping optimization
- Transformation optimization
- ETL documentation
- 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.)
- 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