6 Month Contract for Programmer/Developer (ETL Specialist – Informatica)

Start Date: 2020-09-14

End Date: 2021-03-17

Work Location: Remote Working

Please see below requirement. Referral appreciation fee is offered! To apply, please provide your resume, availability and rate expectation. For immediate consideration, please respond ASAP.

Email:  jobs@itcadtech.com

Phone: (416) 838-8797

ITCAD Tech Inc.

IT Services Vendor for Government of Ontario and Canada

Must have skills (in addition to what is below):

-10+ Informatica ETL tools such as Informatica Power Center, Power Mart

-SQL, UNIX, Korn shell, C, other RDBMS (SQL Server, SSIS)

-Big Data experience


-Ability to present technical requirements to the business


Rated Criterion Criterion Details
Informatica Development Demonstrated experience in Informatica software development and a number of years of practical experience (minimum 10+ years)

Experience in application mapping to populate data vault and dimensional data mart schemas

ETL experience Demonstrated experience in Extract, Transform & Load software development and a number of years of practical experience (minimum 8+ years)

Experience in providing ongoing support to Cluster Informatica/ETL and Cognos developers

Assist in the development of the pre-defined and adhoc reports and meet the coding and accessibility requirements.

Design Documentation and Analysis Skills Demonstrated experience in creating both Functional Design Documents (FDD) & Detailed Design Documents (DDD). –

Experience in Fit-Gap analysis, system use case reviews, requirements reviews, coding exercises and reviews.

Experience in the development and maintaining a plan to address contract deliverables, through the identification of significant milestones and expected results with weekly status reporting.

Work with the Client & Developer(s) assigned to refine/confirm Business Requirements

Participate in defect fixing, testing support and development activities for Informatica/ETL tool. Assist with defect fixing and testing support for Cognos reports.

Analyse and document solution complexity and interdependencies by function / track for purpose of effort and cost estimation.

Database and Related Demonstrated experience with Oracle and interfaces to Informatica

Implementing logical and physical data models and create/update Reporting Database and Data Models for new datamart.