Manager Data

(C) 612-***-****

Summary

* ***** ** ** ********** in Software Industry in Analysis, Development and Implementation of

business applications for Retail, Finance, Re-Insurance and health care domains

9 years of experience in ETL (Extract, Transform and Load) processes utilizing Informatica

Power Center 9.x/8.x/7.x/6.x (Repository Manager, Designer, Workflow Manager, and Workflow

Monitor)

Involved in all the stages of Software Development Life Cycle (SDLC) from analyzing the

Requirements, Designing, Implementing and developing ETL solutions, testing and implementing

the solution

Proficient in developing Informatica mappings, debugging, troubleshooting and performance

tuning.

Strong understanding of the principles of Data Warehouse using Fact Tables, Dimension

Tables, Star Schema modeling and Snowflake Schema modeling .

Expert in data warehousing techniques for data cleansing, slowly changing dimension

(SCDs) surrogate key generation and CDC (Change Data Capture).

Excellent experience in scheduling and monitoring the production jobs. Various scheduling tools

used are control m, Autosys and TWA (Tivoli Work Scheduler).

Experienced in fine tuning, troubleshooting of Informatica mappings and addressing production

issues like performance tuning.

Expert in unit testing, system integration testing, implementation and maintenance of mappings.

Dynamic, alert, and capable of producing high quality work under time constraints with excellent

communication and presentation skills.

Implemented complex business rules in Informatica by creating re-usable transformations, robust

mappings/mapplets.

Implemented Performance Tuning at various levels such as Source, Target, Mapping, Session

and Partitioning in Informatica

Experience in integration of various data source systems analysis and data extraction from

various sources like Flat files, Oracle and XML.

Experience in using the Informatica command line utility pmcmd to operate on workflows (start,

stop, suspend etc.) and control sessions and tasks in non-windows environments.

Experience in programming using PL/SQL, UNIX Shell Programming/Scripting and in writing

database triggers, stored procedures and functions.

Experience in creating UNIX Shell Scripts for data cleansing in the source files and validating pre

and post loading of data.

Excellent interpersonal and communication skills to work with user communities

Team Leader and team player with proven conceptual, analytical and problem solving capabilities

Ability to plan, organize, direct, implement and evaluate processes to lead people and manage

resources to achieve desired result

Well versed and experienced in onsite-offshore co-ordination

Creating comprehensive analysis reports, design documents, data flow diagrams and mapping

specifications

Technical Skills

ETL Tools Informatica 8.x, Informatica 7.x, Informatica 6.x and

DataStage

Operating System Windows NT/2000/XP, UNIX

Front End Tools Toad 9.x/8.x, SQL Developer and Aqua Data Studio

4.5.2

Database Oracle 11g/10.x/9.x/8.x and DB2 8.x

Scheduling Tool Control M, TWS (Tivoli Work Scheduler), Autosys

Metadata Tool Data Station, Share point

Technical Drawing Tool Microsoft Visio diagram

Versioning Tools PVCS, MKS and MSTFS

Software Deployment Tools WBSD and TAD

Document storage Microsoft share point

Data Modeling Tool Erwin

Request Tracking Tools MKS Integrity Client, HPSD and Peregrine Service

Center

Contact this candidate