ETL Informatica Developer

Toronto, ON Canada
Contract Employment
Start the conversation: This is the recruiter hiring for this position. Start networking here:
Job Description
Position: ETL Informatica Developer
Location: Toronto
Contract: 5 Months

Participate in the analysis, design, development, and testing on the new Projects
Analyzing the new development needs and design, developing and unit testing all the project’s ETL components (i.e. mappings, sessions, and workflows).
Developing ETL Process Overview and ETL Design documents, including Informatica Batches, Load Flows document.
Participating in the SIT testing and supporting the System Acceptance and User Acceptance Testing.
Developing, testing, and deploying full code package for Elementary Secondary Data Warehouse (ESDW) in Visual Source Safe.
Developing ETL deployment plan for the production environment.
Creating Operation Manual documents and developing and/or updating other technical documentation.
Participating in project design and code walkthroughs.

Based on the Scope, the ETL Programmer/Developer must have a minimum of 10 years of the following skills and experience:
Strong working experience in an environment where Informatica (v 9.x or higher), DB2, MS Visual Source Safe and Sun Solaris are used together.
Experience in designing RDBMS SQL, DML and DDL (DB2 and Oracle) and the architectural implications associated with each platform in regards to ETL.
Proven design and development experience as Informatica ETL Programmer/Developer.
Working experience in debugging mappings, transformations, mapplets and source qualifier files and unit testing the newly developed ETL components.
Experience developing the Application Code package using MS Visual Source Safe.
Experience conducting System Integration Testing.
Knowledge of MS Project and Visio.
Proven Informatica ETL development experience in a complex environment.
Experience working with Oracle 10.x and 11.x databases.
Experience working with DB2 Databases.
Good communication skills, both written and oral.

Experience Skills:
ETL development experience
Experience development ETL routines using Informatica
Experience enhancing the performance of ETL scripts and SQL queries
Experience enhancing performance of ETL code and SQL queries
Experience designing data warehouse components and ETL scripts
Experience performing the design of data warehouse and related components
Experience working with Kornshell scripts
Experience working with complex Kornshell scripts
Experience working with Oracle
Experience working with Oracle Databases
Experience working the DB2
Experience working with DB2 Databases
Report this Job as Spam

Hi, I'm 3K Consulting Inc.

Indicates a required field