Informatica Administrator/Developer Resume Atlant, GA - Hire IT People

EXPERIENCE SUMMARY:

7+ years of professional experience with expertise in Design, Development, Data Conversion and Implementation of Data warehouse applications and Database business systems.
Playing a role as Informatica Developer/Administrator
Having strong Experience in Onsite offshore Model
7+ years of ETL experience using Informatica Power Center 9.x/8.x/7.x Expert level skills in developing strategies for extraction, transformation and loading mechanism Architect
7+ Years of experience in Informatica Development
4+ years of experience in INFORMTAICA ADMINISTRATOR.
Strong experience in installation of informatica on UNIX, Migration of repositories, up gradation of repositories.
Strong experience in entire life cycle of Data warehouse/Data mart using Informatica Power Centre (Designer, Repository manager, Workflow manager and Workflow monitor).
Extensively used Informatica Workflow manager and Workflow monitor for creating and monitoring workflows, worklets and sessions.
Experience with relational and dimensional models using Facts and Dimensions tables.
Strong experience in database applications such as Oracle 10g/9i/, TOAD,, SQL, PL/SQL, Functions, Procedures, Triggers, Cursors, SQL*Plus and Control - m.
Experience in Dimensional Modeling using Star schema and Snowflake schema.
Strong experience in Business Intelligence tools.
Versatile team player with excellent analytical, communication and presentation skills.

PROFESSIONAL EXPERIENCE

Confidential, Atlant, GA

Informatica Administrator/Developer

Responsibilities:

Worked as a Informatica Administrator/Developer
Developed complex mappings in Informatica to support for Health Care Enterprise application
Installed Informatica 8.1.1, 8.5.1,8.6, 9.0.1 and 9.1.0
Upgraded Informatica 8.1.1 to Informatica 8.5.1 and 8.6.1,9.0.1,9.1.0 HF4
Applied Informatica Patches to the Informatica servers
Troubleshooting the issues in Informatica
Involved and resolving the issues (Tickets) in Informatica Power center
Interacted with Business Analyst to gather sources and their requirements
Involved in the performance tuning
Creation of folders/user permissions
Implementing the standards in the release basis
Giving L2/L3 Support.
Giving 24/7 Production Support.

Environment: Informatica Power Center 9.x/8.x,Cognos 8.x/10.x,Control-M, Oracle 10g, SQL*Plus, TOAD 8.5, Windows XP, AIX5.x/6.1.

Confidential, Sunnyvale, CA

Informatica Administrator/Test Lead

Responsibilities:

Environment: Informatica Power Center 7.1.4, Tivoli, SQL Server 2003, XML, PL/SQL, SQL*Plus, TOAD 8.5, Windows XP, AIX.

Confidential,Suisse, LA

Informatica Administrator/Consultant

Responsibilities:

Working as Informatica Administrator.
Playing a role as Technical lead.
Installing and configuration of Informatica 7.x on UNIX.
Having Experience in Allocation of space on Sun Solaris server for various operations to the ETL
Migration of informatica Repositories (DEV-UAT, UAT-Prod).
Upgrading the Informatica Repositories from 6.x to 7.x.
Given the informatica supporting for all the applications in Credit-Suisse.
Involved and resolving the issues (Tickets) in Informatica Power center.
Giving L2/L3 Support for all applications in Credit-Suisse.
Giving 24/7 Production Support for all application.

Environment: Informatica 7.x/6.x, UNIX (Sun Solaris), Oracle 10g

Confidential

ETL/Data Warehouse Developer

Responsibilities:

Worked on the project that involved development and implementation of a data warehouse for CFL
Responsible for extracting, transforming, and loading data from oracle, flat files and placing it into data warehouse
Designed, developed, and tested the mappings, using Informatica 7.1
Interacted with management to gather sources and their requirements
Involved in the some part of performance tuning.
Developed simple and complex mappings using Informatica to load dimensions and fact tables as per STAR schema techniques.

Environment: Informatica PowerCenter 6.x/7.1, BO 6.5, Microsoft Visio, Oracle 9i HIGHER EDUCATION: Education