Job Description

3.00 to 10.00 Years
Title: Senior Informatica DeveloperLocation: Brampton, ONJob Description:· Creating ETL mappings to extract data from multiple legacy systems;· Transforming and loading the data into the Enterprise Data Warehouse using Informatica;· Developing complex ETL programs using Informatica Power Center Transformations such as Informatica Aggregator, Sorter, Router, Filter, Joiner, Lookup, mapplet, SQL transformation, Stored Procedure API,HTTP,XML;· Understanding of API calls, JSON and its implementation in Informatica Powercenter.· Unix Shell scripting for creating batch scripts, automate cleansing and file manipulations.· Setting up batches and work flow sessions to run these mappings using control-m;· Designing Informatica mappings and data model structural changes including partitions create and drop for better loads performance.;· Designing and creating transformer models;· Developing and optimizing complex SQL programs and writing SQL queries, stored procedures, database triggers, cursors, database constraints, in-line views, PL/SQL records and tables;· Understanding business challenges and translating them into process/technical solutions;· Creating documents related to the ETL process and Testing; and· Producing change control documentation, implementation plan creation and STM creation.· Experience with Informatica BDM to read from various external sources.