BI-Informatica Developer
1 week ago
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 DescriptionJob 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
-
OBIEE Architect and Developer
1 week ago
Suite, Canada system canada technologies Full time $85,000 - $95,000 per yearCompany 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...
-
ETL Developer
2 days ago
Suite, Canada system canada technologies Full time $80,000 - $120,000 per yearCompany 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...
-
System Canada Hiring Coast to Coast
1 week ago
Suite, Canada system canada technologies Full time $60,000 - $120,000 per yearCompany 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...
-
BI Reporting Analyst SAP
2 days ago
Suite, Canada system canada technologies Full time $80,000 - $120,000 per yearCompany 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...
-
ETL/Java Developer
2 days ago
Suite, Canada system canada technologies Full time $60,000 - $120,000 per yearCompany 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...
-
Microstrategy BI Consultant
1 week ago
Suite, Canada system canada technologies Full time $90,000 - $120,000 per yearCompany 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...
-
OBIEE Solutions Architect
1 week ago
Suite, Canada system canada technologies Full time $120,000 - $180,000 per yearCompany 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....
-
BI Report Developer
1 week ago
Suite, Canada system canada technologies Full time $80,000 - $120,000 per yearCompany 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...
-
Congnos Reports Developer
2 days ago
Suite, Canada system canada technologies Full time $90,000 - $120,000 per yearCompany Description System Canada 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...
-
Suite, Canada system canada technologies Full time $120,000 - $180,000 per yearCompany 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...
