Informatica

HARSH SHAH

** ******* ***** ******, ** ***** ****.*******@*****.*** 848-***-****

PROFESSIONAL SUMMARY:

• 2 years of strong Data Warehousing ETL experience of using Informatica Power Center Client tools – mapping

Designer, Repository Manager, Workflow Manager/Monitor and Server tools – Informatica Server, Repository

Server Manager

• Strong experience in Extraction, Transformation, and Loading (ETL) data from various sources into Data

Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow

Manager, Workflow Monitor), Power Exchange, Power Connect as ETL tool on Oracle, DB2, and SQL Server

Databases.

• Experience with all activities related to development, implementation and support of ETL processes for large

scale data warehouses using Informatica Power Center

• Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as

performance tuning of mapping and sessions

• Have knowledge in data modeling using Erwin, Star Schema Modeling, and Snowflake modeling with

capabilities of picking up other data modeling schemes

• Have knowledge on Kimball and Inmon methodologies

• Experience in ETL design, development, and maintenance using Oracle SQL, PL/SQL, SQL Loader,

Informatica Power Center 9.x

• Exposure in development of complex SQL queries

• Knowledge of the transformations, expressions, and functions on Informatica Designer

• Exposure with Installation and Configuring of Informatica tools

• Excellent problem solving, interpersonal and communication skills with experience working in fast paced,

challenging and dynamic environment. Highly motivated

• Exposure to Unix/Shell Scripting

EXPERIENCE:

Client: Bank Of America June 2014 – Jan 2015

Location: Columbus, OH

Role: Informatica Developer

• Extracted data from Oracle Database and spreadsheets and staged into a single place to load them into the

central Oracle Database

• Used Informatica Power Center for Extraction, Transformation, and Load (ETL) of data in the data warehouse

• Extensively used Transformations like Router, Aggregator, Joiner, Expression and Lookup, Sorter, Filter,

Update Strategy, Rank, and Sequence Generator to name a few

• Worked on different tasks in Workflows like creating sessions, linking tasks, timer, and scheduling of the

Workflows

• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency

and performance

• Exposed to the writing of complex SQL Queries

• Created Tables, Keys (Unique, Primary, Foreign) and Indexes in the SQL Server

• Involved in monitoring the workflows and optimizing the load times

• Modified existing mappings for enhancements of new business requirements

• Documented the entire process. The documents included the mapping document, unit testing document, an

system testing document among others

Client: Sirius XM Jan 2013 – May 2014

Location: New York, NY

Role: Informatica Developer

• Responsible for development, support, and maintenance of the ETL (Extract, Transform, Load) processes using

Informatica Power Center

• Developed an ETL Informatica mapping in order to load data into staging area. Extracted from files and

databases and loaded into Oracle target database

• Created mappings using the transformations like Source Qualifier, Aggregator, Expression, Router, Filter,

Sorter, Joiner, Rank, and Sequence Generators

• Worked with various Informatica Power Center tools – Source Analyzer, Target designer, Mapping Designer,

and Workflows just to name a few

• Used mapping Parameters and Variables

• Created, configured, scheduled, and monitored the sessions and workflows on the basis of run on demand, run

on time using Informatica Workflow Manager

EDUCATION:

• Rutgers University – Rutgers Business School, New Brunswick, NJ Sept 2009 – Jan 2013

(3 Core Classes required for completion of Bachelor’s)

Contact this candidate