SUMMARY

• Over 7 years of Data Warehousing experience using Informatica Power Center 9.1/9.0/8.6.1/8.1.1/8.0/7.1.1/7.1.2/7.0, Warehouse Designer, Power Connect for SAP/Oracle Apps/DB2, Power Analyzer, Power Plug, Power Exchange, ETL, Data Mart, OLAP, OLTP.
• Extensiveexperience in Business Analysis, Application Design,Data Modeling, Development, Implementation and Testing Data warehouse and Database applications forInvestment Banking, Health Care and Insurance.
• Extensive experience in creating theWorkflows, Worklets, Mappings, Mapplets, Reusable transformationsand schedulingWorkflows and sessionsusingInformatica Power Center.
• Designed and developed complex mappings, from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner Update Strategy and more.
• Developed Mappings, Sessions and Workflows for relational & flat file sources and targets.
• Proficiency in data warehousing techniques for data cleansing, slowly changing dimensions types (1, 2 and 3).
• Experienced in Installation, Configuration, and Administration of Informatica Power Center/Power Mart Client, Server.
• Extensive experience in all areas of Project Life Cycle including requirements analysis, system analysis, design, development, documentation, testing, implementation and maintenance.
• Experience in integration of various data sources like IMS, Oracle, DB2, SQL server, Flat Files, MQ series and XML Files into ODS and extensive knowledge on Oracle 10g/9i/8i, DB2 8.0/7.0, Teradata V2R5/V2R4/V2R3, MS SQL Server 2005/2000/7.0/6.5, Sybase 12.x/11.x, MS Access 7.0/2000.
• Expertise in SQL/PLSQL in developing & executing Stored Procedures, Functions, Triggers and tuning on queries while extracting and loading data.
• Have experience in creating documents like support documents, Unit test documents.
• Experience in Performance Tuning and Debugging of existing ETL processes.
• Experience in UNIX shell scripting and configuring Cron jobs for Informatica job scheduling, backup of repository and folder.
• Strong experience in interacting with business users, gathering requirements through interviews, workshops, and existing system documentation or procedures, defining business processes, identifying and analyzing risks using appropriate templates and Analyst tool.
• Having knowledge about data replication tool.

TECHNICAL SKILLS

Operating System: Solaris, HP - UX, Red Hat Linux, Windows NT/2000/XP

Packages: MS Office Suite, MS Visio, Rational Rose, Lotus Notes, XML, Spy

ETL: Informatica Power Center 9.1/8.6.1/8.1.1/8.0/7.1, SSIS

Dimensional Data Modeling: Dimensional Data Modeling using Star & SnowFlake schema, Ralph Kimball, Erwin.

Reporting Tools: COGNOS Series 8/7,Cognos Decision Stream 7

Programming Languages: C, C++,Java,VB,SQL,PL SQL,UNIX Shell ScriptingPERL, Linux

DB Tools: TOAD, SQL Navigator, SQL LOADER.

RDBMS: Oracle 8/8i/9i/10g/11g, MS-Access, TeraData, MS SQLServer 2000/2005/2008 IBM DB2,Sybase 12.0/11.x

GUI: Visual Basic 6.0/5.0

Scheduling: Autosys, Cron, Control-M

PROFESSIONAL EXPERIENCE

Confidential, East Providence, RI

Informatica ETL developer

Responsibilities:

• Created Data Maps / Extraction groups in Power Exchange Navigator for legacy IMS Parent sources.
• Used Informatica ETL to load data from flat files, which includes fixed-length as well as delimited files and SQL Server to the Data mart on Oracle database.
• Designed Sources to Targets mapping from primarily Flat files to Database using Informatica Power Center.
• DevelopedUNIXShellScripts and SQLs to get data from Oracle tables before executingInformatica workflows.
• Created Sessions and Workflows to load data from the SQL Server, Oracle, flat file, and XML file sources that exist on servers located at various locations all over the country.
• Staged Data from legacy Proclaim IMS system into Oracle 11g Master Tables.
• Performed CDC capture registrations.
• Assisted in building the ETL source to Target specification documents by understanding the business requirements.
• Developed mappings that perform Extraction, Transformation and load of source data into Derived Masters schema using various Informatica power center transformations like Source Qualifier, Aggregator, Filter, Router, Sequence Generator, look up, Rank, Joiner, Expression, Stored Procedure, SQL, Normalizer and update strategy to meet business logic in the mappings.
• Reusable transformations and Mapplets are built wherever redundancy is needed.
• Performance tuning is performed at the Mapping level as well as the Database level to increase the data throughput.
• Creating Jobs and Job streams in Control-M scheduling tool to schedule Informatica, SQL script and shell script jobs.
• Designed the Process Control Table that would maintain the status of all the CDC jobs and thereby drive the load of Derived Master Tables.
• Used Teradata utilities like BTEQ, fast load, fast export, multiload for data conversion.
• Created Post UNIX scripts to perform operations like gunzip, remove and touch files.

Environment: PWX 9.1 HF2, Informatica Power Center8.6.1/9.1, Oracle 11g, Toad 10g, SQL Server, RHEL 5.5, Harvest R12, Control-M, Mainframe (IMS), SQL, Unix, Teradata

Confidential, Pittsburgh, PA

ETL developer

Responsibilities:

• Worked with the PCS financial services staff and Business analysts for requirements gathering, business analysis, testing, metrics and project coordination.
• Worked with huge tables that consisted of around 256 columns and 100 million records per each table.
• Involved in creating Low Level ETL Design Documents.
• Worked on different OLTP data sources such as Oracle, SQL Server and Flat files for data extraction.
• Extracted data from different sources likeSQL server 2005, flat files and loaded into oracle DWH.
• Improved the performance of the mappings by moving the filter transformations early into the transformation pipeline, performing the filtering at Source Qualifier for relational databases and selecting the table with fewer rows as master table in joiner transformations.
• Implemented various transformations like Expression, Lookup, Sequence Generator, Source Qualifier, Rank, and Aggregator to load the data from Staging area to ODS to Data Marts.
• Used Informatica Power Center 8.6 for extraction, transformation and load (ETL) of data in the data warehouse.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator and Stored Procedure.
• Developed complex mappings in Informatica to load the data from various sources.
• Implemented Error Handling Strategy in all dimension mappings.
• Created reusable worklets and maplets transformations.
• Extensively worked with mapping parameters and session parameters.
• Created Partitions to concurrently load the data into targets.
• Configured the sessions in workflow with various dependency’s using Decision, Command, Event Raise and Event Wait Tasks.
• Created sessions, tasks, partitions, Worklets, Workflows, shared objects, reusable objects. Used Parameters and Variables, Pre SQL/Post SQL.
• Tuned mappings and sessions for better performance of the data loads.
• Written UNIX shell Scripts & PMCMD commands for FTP of files from remote server and backup of repository and folder.
• Performed Unit Testing and verified the data.
• Extensively used ETL to load data using Power Center/from source systems like Flat Files and Excel Files into staging tables and load the data into the target database Oracle.
• Involved in Production support for session failure and recovery, and monitoring informatica ETL jobs.
• Involved in Full Life Cycle Development of the Project.
• Insure that all enterprise procedures are followed such as system testing, change management, project prioritization, promotion to production and time entry, etc.

Environment: Informatica Power Center 8.6.1, Oracle8i/9i, SQL, PL/SQL, TOAD, SQL Server2008, DB2, UNIX, Windows NT and Control-M.

Confidential, Portland, Oregon

Informatica Developer

Responsibilities:

• Analyzed business requirements, performed source system analysis, prepared technical design document and source to target data mapping document.
• Involved in design and development ofInformatica mappings, UNIX Scripts, PL/SQL Procedures, wrote SQL, PL/SQL scripts, Function andPackage code.
• Assisted in creating fact and dimension table implementation inStar Schema modelbased on requirements.
• Extracted data from various sources likeOracle, flat files and SQL Server.
• Extensively worked in thePerformance tuning of the programs, ETL Procedures and Processes.
• Used SQL tools likeTOAD to run SQL queries and validate the data loaded in to the target tables.
• Appliedpartitioning at session level for the mappings which involved loading data to target using target lookup to avoid duplicates records.
• Performancetuning by session partitions, dynamic cache memory, and index cache.
• Createdreusable transformations and mappletsbased on the business rules to ease the development.
• Worked extensively onSource Analyzer, Mapping Designer, Mapplet designer and Warehouse Designer and Transformation Developer.
• Extracted data from source systems to a staging database running on Teradata using utilities like MultiLoad and FastLoad.
• Designed and developedInformatica Mappings and sessionsbased on business rules.
• Developed severalMappings and Mappletsusing correspondingSources, Targets and Transformations.
• Designed and developedData TransformationProcess and used advanced features of T-SQL in order to design and tune T-SQL to interface with the database and other applications in the most efficient manner.
• Created flexiblemappings/sessionsusingparameters, variablesand heavily usingparameter files.
• Improved session run times by partitioning the sessions. Was also involved into database fine tuning (creating indexes, stored procedures, etc), partitioning oracle databases.
• CreatedMaterialized viewfor summary data to improve the query performance.
• Performed unit testing, knowledge transfer and mentored other team members.

Environment: Informatica Power Center 8.1/7.1,Tera data,Oracle 9i/10g,SQL server 2005, PL/SQL, SQL* Loader, ERwin 4.0, TOAD 7.0, Star Schema, UNIX Shell Scripts, Flat files, MS-Office, Windows XP, IBM AIX, Teradata .

Confidential, Piscataway, NJ

Informatica Developer

Responsibilities:

• Involved in Business Analysis and Requirements collection.
• Designed Sources to Targets mapping from primarily Flat files to Database using Informatica Power Center.
• Coordinated with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema design (Star Schema) and maintenance.
• Created Informatica Workflows with built-in dependencies for session execution with a view to minimize run-time.
• Various kinds of the transformations were used to implement simple and complex business logic. Transformations used were: Stored Procedure, connected & unconnected lookups, Expressions, source qualifier, aggregators, filters, sequence generator etc.
• Developed various slowly changing Type1, Type2 and slowly growing dimensional mappings according to the data mart schemas.
• Created and configured workflows, worklets & Sessions to transport the data to target warehouse Database tables using Informatica Workflow Manager.
• Configured sessions using Workflow manager to have multiple partitions Source data & to improve performance.
• Developed Procedures and Functions in PL/SQL.
• Tuned Informatica Mappings and Sessions for optimum performance.
• Created reusable transformations and Mapplets and used them in various mappings.
• Used Teradata utilities like fast load, multiload, fast export, BTEQ.
• Extracted data from Teradata source systems to a flat file.
• Improved the performance of the mappings by moving the filter transformations early into the transformation pipeline, performing the filtering at Source Qualifier for relational databases and selecting the table with fewer rows as master table in joiner transformations.
• Created List, Sub and Cross-Tab reports using Cognos Power play and distributed Catalog to users for Ad-Hoc reporting and analysis.

Environment: Informatica Power Center 7.1.3, Power Exchange 5.1,Workflow Manager, Workflow Monitor, Designer, Erwin4.1, Unix, Cognos Report Net 1.1, Oracle 10g, SQL Server 2005, DB2, PL/SQL, Sun Solaris8.0, HP-UX, WindowsXP/2000.