Informatica ETL

336-***-**** / *****.**********@*****.***

SUMMARY

. Over Five years of IT experience as an ETL

developer/programmer/analyst, including Data Warehouse / Database

Developer experience using Informatica Power Center 9.x/8.x as ETL

tool.

. Extensive experience in Data warehousing tools including ETL process

using different modules of Informatica Power Center and Power Mart.

. Experience in the areas of Healthcare, Banking and Consumer

Electronics domain.

. Worked with Agile Software Development Methodology.

. Good knowledge of OLTP / OLAP system, analysis and E-R modeling,

developing Database schemas like Star schema and Snowflake schema.

. Experience in developing Transformations and Mappings using

Informatica Designer and processing tasks using Workflow Manager to

move data from multiple sources into targets.

. Worked extensively on Informatica Power Center and Informatica Power

Exchange.

. Implemented Slowly Changing Dimensions (SCD) Type 1, Type 2, and Type

3 methodology for accessing the full history of accounts and

transaction information.

. Extensively worked in tuning and troubleshooting the mappings to

perform maximum efficiency and performance.

. Experience in integration of various data sources with multiple

Databases like Oracle, SQL Server, Teradata, Access and worked on

integrating data from flat files, CSV files and XML files.

. Extensively worked on Data Modeling.

. Good knowledge of Master Data Management (MDM),data profiling, data

quality, data cleansing

. Working knowledge of SSIS, SSRS and SSAS.

. Expert in SQL, PL/SQL, Procedures/Functions, Triggers and Packages.

. Knowledge of software testing and quality assurance.

SKILLS

ETL Tools Informatica Power Center 9.x / 8.x

Operating Systems Windows XP, Vista, 7, UNIX, MS-DOS

Scripts Shell Scripting

Languages SQL, PL/SQL, T-SQL, Visual Basic 6.0

Databases Oracle 11g/10g, SQL Server 2008, Teradata and

DB2

Web Technologies HTML, DHTML, XML

Application Software MS office, MS Visio

Others Toad, SQL Developer,

PVCS, Remedy, Erwin, Tivoli, AutoSys.

EXPERIENCE

Sr. Informatica Developer

Nov'10 - Present

Cree Inc, Durham, NC

Description: Cree Inc. is a multinational manufacturer of semiconductor

light-emitting diode (LED) materials and devices, headquartered in Durham,

North Carolina. Most of its products are based on Silicon carbide.

Responsibilities:

. Created Technical Design Document along with Data Discovery sheet

. Closely worked with SME's, Application owners and end users to get

details on their apps and requirements

. Implemented Slowly Changing Dimension Type 1, Type 2 and Type 3.

. Worked on Performance Tuning to optimize the Session performance by

utilizing, partitioning, push down optimization, Index Cache, Data

Cache and incremental aggregation.

. Worked on different databases such as Oracle, DB2 and Teradata

. Implemented various Transformations like Joiner, Aggregate,

Expression, Lookup, Filter, Update Strategy, Stored Procedures, and

Router etc.

. Used Power Exchange for Mainframe VSAM file

. Developed Mapplets, created mappings in pipeline structure

. Used Target Load Plan in order to execute the mappings sequentially in

a pipeline structure

. Used mapping parameters and variables

. Used Session level parameters such as connection strings

. Closely worked with DBAs on Performance Tuning

. Used Constraint Based Loading, partitioning, performance tuning on

existing mapping

. Developed workflows with sequential and parallel sessions

. Worked on command tasks, event wait tasks, event raise tasks, timer

tasks to implement business logic

. Worked with DBA's for performance tuning and to get privileges on

different tables in different environments

. Worked with Change Management Team to roll-out final solution

. Created UNIX script to run batch jobs according to business

requirements

. Created technical documents for end user - Instruction Manuals for the

solution provided

Environment: Informatica 8.6/9.0, Oracle 11g, DB2 9.7, Teradata, Toad for

Oracle and Toad for DB2, SQL Assistant, IBM AIX, Visio, Citrix Client.

Sr. Informatica Developer

Dec'09 - Nov'10

First Tennessee, Memphis, TN

Description: First Tennessee is a financial services company based in

Memphis, Tennessee. It is a subsidiary of First Horizon National

Corporation.

Responsibilities:

. Converted business requirements into technical documents.

. Developed Data Flow diagrams to create Mappings and Test plans.

. Developed complex Informatica mappings using various transformations-

Source Qualifier, Normalizer, Filter, Connected Lookup, Unconnected

Lookup, Update strategy, Router, Aggregator, Sequence Generator,

Reusable sequence generator transformation.

. Extensively used SCD's (Slowly Changing Dimension) to handle the

Incremental Loading for Dimension tables, Fact tables.

. Designed various mappings for extracting data from various sources

involving Flat files, Oracle, Sybase and Sql Server, IBM DB2, XML

files.

. Worked on Performance Tuning to optimize the Session performance by

utilizing, Partitioning, Push down optimization, Index Cache, Data

Cache and incremental aggregation.

. Used Target load plan, constraint base loading, partitioning, and

performance tuning the existing mapping.

. Used mapping parameters and variables.

. Involved in Change Data Capture (CDC)

. Worked on complex Informatica Mappings for Household dimension, Multi

valued dimension and Point in time dimension.

. Worked on Debugging and Troubleshooting of the Informatica

application. For debugging utilized Informatica debugger.

. Modified existing shell script to suite the existing business logic

and developed the utility script to archive, move and copy files and

also to automate the batch jobs.

. Developed UNIX shell scripts to automate manual tasks.

. Developed Test plan to verify the logic of every Mapping in a Session.

. Utilized Quality Center 9 web based test management tool to keep track

of all the releases, requirements, test plans, labs and defects.

. Worked with DBA and infrastructure team to implement the DDLs, refresh

data, create DB links, setup environment and delete the log files from

the Unix boxes.

. Migrate the code and release documents from DEV to QA and Production.

. Extensively worked on Integration testing and User Acceptance Testing

(UAT). Reviewed UAT with business users.

. Utilized Autosys to schedule all the jobs and closely worked with the

production team.

Environment: Informatica Power Center 8.6, Oracle 10g, DB2 UDB, UNIX (Sun-

Solaris), UNIX (AIX 6.2), Harvest, SQL Loader, Autosys, Visio, Synsort,

TOAD for Oracle, SQL Developer, Windows XP.

Informatica Developer

Aug'08-Dec'09

Abbott Laboratories, Columbus, OH

Description: Abbott Laboratories is an American-based global, diversified

pharmaceuticals and health care products company. Abbott's broad range of

medical tests and diagnostic instrument systems are used worldwide by

hospitals, laboratories, blood banks, and physicians.

Responsibilities:

. Created complex mappings in Power Center Designer using Aggregate,

Expression, Filter, Sequence Generator, Update Strategy, Rank, Joiner

and Stored procedure transformations.

. Designed mapping document, which is a guideline for ETL Coding

following Standards for naming conventions and Best Practices were

followed in mapping development.

. Extensively used Informatica Decision, Command, Event Wait, Event

Raise, and Email tasks.

. Optimized the SQL override to filter unwanted data and improve session

performance.

. Used Debugger to track the path of the source data and to check the

errors in mapping.

. Prepared unit testing document covering field to field's validations

and source to target count.

. Scheduling the workflow comprising of different sessions for their

respective mappings in order to load data into Oracle database.

. Created, Modified, and documented Oracle Packages, Procedures,

Functions, and Indexes.

. Assisted the other ETL Developers in resolving complex scenarios.

. Migrated final code from Development to Test, Test to QA and finally

to Production.

Environment: Informatica Power Center 7.1, Oracle l0g, Toad 7.6, Autosys,

PL/SQL, SQL*Plus, SQL*Loader, XML, Windows NT 4.0, DB2, Sun Solaris Unix

2.6, Shell Scripting.

Contact this candidate