Post Job Free

Resume

Sign in

Informatica Developer

Location:
Toronto, ON, Canada
Posted:
January 29, 2015

Contact this candidate

Resume:

Faheem Mohammed E-mail: acn2v7@r.postjobfree.com

Informatica Developer Telephone: +1-647-***-****

Overview:

5+ Years of Total rich software services industry experience that spans Data Warehousing,

Managing client relations, Project delivery and hands on development gained by working with

Oracle, DB2 and SQL.

IT Experience in Data Loading, Analysis, Design, Development, and Coding by using Various

Technologies like Informatica Power Center and Oracle in Data Warehousing.

Development and Coding Experience on ETL processes by using Informatica Power Center

9x8.6.0 & Oracle 11g, Oracle 10g like PL/SQL Coding, Shell Scripting on UNIX Platform.

Extensive experience with Data Warehouse and BI methodologies and strong understanding of

Relational, Multi-Dimensional Database concepts and OLAP.

Experience working with different Databases like Oracle 11, Oracle10g, Oracle 9i/8i, SQL Server

2000/2005 and MS Access.

Hands-on experience in designing, tuning, and leveraging large data warehouses using RDBMS

databases like Oracle, SQL Server database applications and Data warehouse appliances.

Strong experience in designing/modeling and developing Business Intelligence solutions in

staging, populating Operational Data Store (ODS), Master Data Management (MDM), Metadata

Management, Enterprise Data Warehouse (EDW), Data Marts / Decision Support Systems using

ETL tools, Informatica PowerCenter 8.x/7.x/6.x, PowerExchange 8.0,Data explorer, OLTP &

OLAP.

Experienced in Global Delivery Model and management of Onsite/Offshore teams.

Developed PL/SQL stored procedures, functions, packages, SQL queries, indexes, triggers and

materialized views.

Worked on Informatica Power Center Client Tools like Designer, Workflow Manager, Workflow

Monitor & Repository.

Extensive experience in extraction, transformation and loading of data directly from different

heterogeneous source and target systems like flat files, MS SQL, Oracle.

Extensively worked on Informatica Designer Components - Source analyzer, Transformations

Developer, Mapplet and Mapping Designer.

Hands on experience with complex mappings using varied transformation logics like

Unconnected and Connected lookups, Router, Aggregator, Joiner, Update Strategy and re-usable

transformations.

Faheem Mohammed E-mail: acn2v7@r.postjobfree.com

Informatica Developer Telephone: +1-647-***-****

Developing ETL processes like Data Extraction, Transformation, and Loading using various

Versions like Informatica Power Center 9.1.0/ 8.6.0 and 7.1.1.

Strong knowledge in Informatica Architecture.

Extensively worked on Informatica Power Center Designer, Workflow Manager and Workflow

Monitor tools.

Strong Knowledge on ETL tool like Informatica and Clear understanding of Software

Development Life Cycle (SDLC) in Data Warehousing.

Have clear understanding of Data warehousing Concepts like BI, Star Schema, Snowflake

Schema, OLTP, OLAP, Staging Area and ODS.

Extensively worked on third party tool like TOAD, SQL*PLUS and PL/SQL Developer.

Good Knowledge on RDBMS Concepts in Oracle.

Ability to work with any Environment based on client requirement and Ability to interact with

Client regularly.

Ability to manage project issues and Risks, Deliver work on time with multiple, competing

priorities.

Ability to work in a team or individual and handling multiple tasks simultaneously and Ability to

pick up new skills quickly.

Good Analytical and strong Interpersonal skills and Excellent Communication Skills.

Technical Competencies:

ETL Tool : Informatica Power Center 9.1/8.x/7.x

Databases & Tools : Oracle 8i, 9i and 10g (SQL*Plus, PL/SQL with Stored Procedures) SQL Server

2005, DB2

Operating Systems : Windows 2007/2003/2000/NT/ XP. Linux, UNIX Shell Scripting.

Languages : PL/SQL, advanced SQL, Unix Shell Scripting.

Reporting tools : Cognos

Present Status:

Canada Permanent Resident

Work Experience:

Sr. Informatica Developer Symcor

June 2013 to Present

Faheem Mohammed E-mail: acn2v7@r.postjobfree.com

Informatica Developer Telephone: +1-647-***-****

Roles and Responsibilities:

• Worked closely with client in understanding the Business requirements, data analysis and deliver the

client expectation.

• Used Informatica PowerCenter 9.x and its all features extensively in migrating data from OLTP to

Enterprise Data warehouse.

• Worked with Business Analysis team in gathering the requirements and created Functional and ETL

specification documents. •

Analyzed the Business Requirement Documents (BRD) and laid out the steps for the data extraction,

business logic implementation & loading into targets.

• Extracted data from different sources like Oracle, flat files, XML and SQL Server loaded into DWH.

• Created complex mappings in PowerCenter Designer using Aggregate, Expression, Filter, and Sequence

Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure

transformations. •

Created sessions and batches for incremental load and schedule them to run daily.

• Developed mappings/Reusable Objects/Mapplets by using mapping designer, transformation developer

and Mapplet designer in Informatica PowerCenter 9.X

• Used Informatica PowerCenter 9.X for extraction, loading and transformation (ETL) of data in the data

warehouse.

• Handle slowly changing dimensions (Type I, Type II and Type III) based on the business requirements.

• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic

embedded in the mappings.

• Involved in creation of Folders, Users, Repositories and Deployment Groups using Repository

Manager.

• Involved in PL/SQL and UNIX Shell scripting for scheduling the sessions in Informatica.

• Involved in scheduling the Informatica workflows using Autosys.

• Migrated mappings, sessions, and workflows from development to testing and then to Production

environments.

• Involved in Performance tuning for sources, targets, mappings and sessions.

• Performed unit testing on the Informatica code by running it in the Debugger and writing simple test

scripts in the database thereby tuning it by identifying and eliminating the bottlenecks for optimum

performance.

• Worked extensively with different caches such as Index cache, Data cache and Lookup cache (Static,

Dynamic, Persistence and Shared)

• Created deployment groups, migrated the code into different environments.

• Worked closely with reporting team to generate various reports.

• involved in documentation for KT for the support team.

Environment: Informatica PowerCenter 9.1, Oracle 11i, Oracle SQL Developer, Windows, BO

ETL Developer

Aug 2011 to May 2013 Moneris

Description: The application is Customer Business Management, of a Company that keeps track of the

Assets, which are given to lease. The source system is capable of accepting request for Assets and

processes it, when there is an Exception then it is the Analyst duty to manually process that request. The

company want to keep track of what sort of exception are Raised, to reduce the number of exceptions so,

as to reduce the burden on analyst. This is implemented using tool like Informatica Power Center and

Oracle PL/SQL with SP then to load the Data Warehouse.

Roles:

Faheem Mohammed E-mail: acn2v7@r.postjobfree.com

Informatica Developer Telephone: +1-647-***-****

• Understanding the Customer Requirements and the Technical specifications Documents.

• Extraction of data from Different Sources like Oracle and Flat files.

• Extensively used Designer Tools - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet

Designer and Transformation developer. •

Creation of Mappings using Different Transformations like Joiner, Filter, Router, Lookups (Connected &

unconnected) Transformations. •

Implemented Type I, Type II and Type III slowly changing Dimensions based on business requirements.

• Development and Testing, Performance Tuning of Mappings.

• Creation of Sessions & Batches to Schedule ETL Mappings.

• Preparation of Design Documents, Test Cases and Test Scripts

• Involved in PL/SQL Coding like Stored Procedures, Triggers and Packages

• Validating the Required data at the database level by using 3rd party tool like TOAD.

• Played an effective team member's role in the team of 6.

Environment: Informatica Power Center 9.1, Oracle 10 (SQL, PL/SQL), TOAD, VISIO

Informatica Developer

June 2009 to July 2011 Infosys

Roles:

• Extensively used ETL to load data from multiple sources to Staging area (Oracle 9i) using

Informatica PowerCenter 7.1

• Worked with pre and post sessions, and extracted data from Transaction System into Staging Area.

Knowledge of Identifying Fact and Dimension tables.

• Created reusable transformations and mapplets and used them in mappings

• Extensively used transformations such as Source Qualifier, Aggregator, Expression, Lookup, Router,

Filter, Update Strategy, Joiner, Transaction Control and Stored Procedure.

• Created Several Informatica Mappings to populate the data into dimension and fact tables.

• Involved in Performance tuning for sources, targets, mappings, and sessions.

• Performed unit testing on the Informatica code by running it in the Debugger and writing simple test

scripts in the database thereby tuning it by identifying and eliminating the bottlenecks for optimum

performance.

• Automated the load process using UNIX shell scripts.

• Created sessions and batches for incremental load and schedule them to run daily.

• Implemented Type II slowly changing Dimension to maintain all historical information in Dimension

Tables.

• Investigated and fixed problems encountered in the production environment on a day to day basis.

• Actively involved in the production support and also transferred knowledge to the other team members.

• Co-ordinate between different teams across circle and organization to resolve release related issues.

Environment: Informatica Power Center 8.6, Oracle 9i, Oracle SQL Developer, Windows.



Contact this candidate