PROFESSIONAL SUMMARY:

• About 9+ years of Information Technology Experience in Data Warehouse using Tools like Informatica Power Center 9.1/ 8.6.1/8.1.1 /7. x/6.x/5.x and Teradata.
• Extensive experience in Insurance, Banking & Financial Services(BFS), Retail, Pharmacy and Healthcare Domains
• Good experience in Full Life Cycle Implementation of applications on multi - platforms.
• Data Processing experience in designing and implementing Data Mart applications using ETL tool and developed ETL mappings and ETL workflows and also monitoring the Production Environment.
• Developed Complex mappings from varied transformation logics like Unconnected /Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Union, Update Strategy and more.
• Well versed in Extracting, Transforming and Loading(ETL) from different Source systems to WarehouseSystem.
• Performed Data Analysis to summarize data with the intent to extract useful information and develop conclusion using the IDE and IDQ tools.
• Experienced in configuring Nodes and Repositories in Informatica Power Center 9.1/8.6/8.1.1
• Experienced with ETL tools like Informatica and Teradata utilities.
• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional modeling
• Experience in Dimensional Data Modeling (Dimensions and Fact Table) using Erwin Modeling (Erwin 4.0/3.5.5) like Physical & logical data modeling.
• Experience in Teradata with Fast Export, Fast Load, Multi Load, BTEQ.
• Experience in Trouble shooting and implementing Performance tuning at various levels such as Source, Target, Mapping, Session and System in ETL Process
• Used T-SQL for creating Triggers and stored Procedures using SQL Server to create reports from the database.
• Conducted System, UAT and Functionality testing and investigated software bugs.
• Worked on UNIX shell scripts used in scheduling Informatica pre/post session operations, Increasing Cache size, database administrations and database connections.
• Extensive experience in conducting Requirement-gathering sessions, writing Business Requirement Document (BRD), Functional Requirement Document (FRD).
• Worked with wide variety of sources like Oracle, MSSQL, Excel sheets, Flat Files, Teradata and DB2
• Well versed in Teradata 12.0/ V2 R6.
• Worked with Oracle and SQL Server Stored Procedures, Triggers, Cursors and Indexes and experienced in loading data into Data Warehouse/Data Marts.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.1/8.X/7.x/6.2/5.1

Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical/Logical Data ModelingErwin 7/4/3

Databases: Oracle 11g/10g/9i/8i, SQL Server 2000/05/08, DB2, Teradata, MS Access 2000, TOAD, SAP BI

Reporting Tool: Congo s

Tools: & Utilities: BTEQ, Fast Export, Fast Load, Mload, Autosys

Testing Tools: TestDirector, Rational Clear Quest, HP Quality Center

Programming: C, C++, SQL, PL/SQL, HTML, and XML

Environment: Windows98/2000/XP/2003, WinNT4.0, UNIX

PROFESSIONAL EXPERIENCE:

Confidential, Mc Lean, VA

Sr ETL/Informatica Developer

Responsibilities:

• Involved in Analyzing the requirements & Involved in designing and development of Complex Solutions.
• Prepared TSD and ETL Specification documents based on BSD and Mapping document.
• Conducted walk through on TSD internally with the development team and also externally with client technical leads, team leads and Data Architects and DBAs.
• Worked extensively on Source Analyzer, Mapping Designer, Target Designer, Workflow Manager and Workflow Monitor
• Used various Transformations like Joiner, Aggregate, Expression, Lookup, Filter, Union, Update Strategy, Stored Procedures, and Router, Normalizer etc. to implement the business logic.
• Created Complex mappings using Connected and Unconnected Lookups, Aggregate, Update Strategy, Stored Procedure and Router transformations for populating target table in efficient manner.
• Worked with Normalizer transformation to for Data Pivoting
• Extensively worked with flat file sources to read data and write the data into the flat files.
• Created Informatica mappings with PLSQL Procedures, Functions to build business rules to load data.
• Developed SCD Type1 and SCD Type2 Mappings to track the Change Data Capture(CDC)
• Prepared SDLC Document and conducted walk through while moving from Development to Test and Test to Integration Test environments and so forth.
• Co-ordinate with testing team in providing explanations and resolutions to the observations and defects raised by the testers.
• Involved in Performance Tuning of SQL Queries, Sources, Targets and sessions by identifying and rectifying performance bottlenecks.
• Creating job setup document for job scheduling tool.
• Worked on Unix shell scripts used in scheduling Informatica pre/post session operations
• Implemented different Tasks in workflows which included Session, Command, E-mail, Event-Wait etc.
• Migrated the Code from Informatica Power center 8.6.1 to 9.1.0.
• Involved in Folder Migrations from one environment to the other environments.
• Performed extensive Unit Testing on the developed Mappings and was also involved in the documentation of Test Plans and testing with the users (UAT)
• Conducting weekly status meetings to discuss about the progress in that week.
• Uploading/downloading the documents to/from sub version

Environment: Informatica Power Center 9.1.0, Oracle 11g/9i, SQL Developer, UNIX, Windows XP, sub version

Confidential, Salt Lake City, UT

Sr ETL/Informatica Developer

Responsibilities:

• Involved in Analyzing the requirements & Involved in designing and development of Complex Solutions.
• Prepared TSD and ETL Specification documents based on BSD and Mapping document.
• Conducted walk through on TSD internally with the development team and also externally with client technical leads, team leads and Data Architects and DBAs.
• Worked extensively on Source Analyzer, Mapping Designer, Target Designer, Workflow Manager and Workflow Monitor
• Used various Transformations like Joiner, Aggregate, Java, Expression, Lookup, Filter, Union, Update Strategy, Stored Procedures, and Router etc. to implement the business logic.
• Created Complex mappings using Connected and Unconnected Lookups, Aggregate, Update Strategy, Stored Procedure and Router transformations for populating target table in efficient manner.
• Created Informatica mappings with PLSQL Procedures, Functions to build business rules to load data.
• Developed SCD Type1 and SCD Type2 Mappings to track the Change Data Capture(CDC)
• Prepared SDLC Document and conducted walk through while moving from Development to Test and Test to Integration Test environments and so forth.
• Co-ordinate with testing team in providing explanations and resolutions to the observations and defects raised by the testers.
• Involved in Performance Tuning of SQL Queries, Sources, Targets and sessions by identifying and rectifying performance bottlenecks.
• Creating job setup document for job scheduling tool.
• Worked on Unix shell scripts used in scheduling Informatica pre/post session operations
• Implemented different Tasks in workflows which included Session, Command, E-mail, Event-Wait etc.
• Migrated the Code from Informatica Power center 8.6.1 to 9.1.0.
• Involved in Folder Migrations from one environment to the other environments.
• Performed extensive Unit Testing on the developed Mappings and was also involved in the documentation of Test Plans and testing with the users (UAT)
• Conducting weekly status meetings to discuss about the progress in that week.

Environment: Informatica Power Center 9.1.0/8.6, Oracle 11g/9i, TOAD, Congo’s 8, UNIX, Windows XP

Confidential, Indianapolis, IN

ETL/Informatica Developer

Responsibilities:

• Involved in analyzing the requirements, designing and development of data warehouse environment.
• Preparing TSD and ETL Specs based on BSD and Mapping document.
• Conducting walk through on TSD with client tech leads, team leads and Data Architects and DBAs.
• Prepared SDLC Work book and conducted walk through before moving to SIT, UAT and Production.
• Conducting weekly status meetings to discuss about the progress in that week.
• Creating job setup document for job scheduling tool.
• Given Technical clarifications and assigned work to off-shore team and monitored their work status daily.
• Worked on Informatica tools like Power Center Designer, Workflow Manager, and Workflow Monitor.
• Used various Transformations like Joiner, Aggregate, Expression, Lookup, Filter, Union, Update Strategy, Stored Procedures, and Router etc. to implement complex logics while coding a Mapping.
• Developed Informatica Type-1 and Type-2 Mappings based on the requirements.
• Involved in Mapping, Session and database level optimization techniques to improve the performance
• Worked on Unix shell scripts used in scheduling Informatica pre/post session operations
• Involved in creating complex workflows which utilize the various tasks like Event Wait, Command, Mail decision and session tasks.
• Extracted data from Flat files and Oracle and loaded them into Teradata.
• Implemented different Tasks in workflows which included Session, Command, E-mail, Event-Wait etc.
• Involved in Performance Tuning of SQL Queries, Sources, Targets and sessions by identifying and rectifying performance bottlenecks.
• Worked on WLM Scheduler to automate the Workflows.
• Tested all the mappings and sessions in Development environment.

Environment: Informatica Power Center 8.6.1, Teradata V12, Oracle 11g/10g, DB2, WLM, UNIX, Windows XP

Confidential, Jacksonville, FL

ETL/Informatica Consultant

Responsibilities:

• Involved in Analyzing the System requirements, implementation of star schema & Involved in designing and development of data warehouse environment.
• Preparing TSD and ETL Specs based on BSD and Mapping document.
• Conducting walk through on TSD with client tech leads, team leads and Data Archs and DBAs
• Involved in development of the Code and executed Unit Test Cases.
• Prepared SDLC Work book and conducted walk through before moving to SIT, UAT and Production.
• Conducting weekly status meetings to discuss about the progress in that week.
• Creating job setup document for job scheduling tool.
• Given Technical clarifications and assigned work to off-shore team and monitored the work status daily.
• Worked on Informatica tools like Repository Manager, Workflow Manager and Workflow Monitor.
• Extracted data from Flat files, SQL Server and Oracle and loaded them into Teradata.
• Implemented different Tasks in workflows which included Session, Command, E-mail, Event-Wait etc.
• Worked with complex SQL queries for data validation and reporting in SQL Assistant.
• Transformed bulk amount of data from various sources to Teradata database using BTEQ scripts.
• Written the scripts needed for the business specifications (BTEQ Scripts).
• Transferred data using Teradata utilities like Fast Export, Fast Load and MLoad.
• Involved in tuning of SQL Queries by identifying and rectifying performance bottlenecks.
• Worked on WLM to automate and Schedule the Workflows and jobs.
• Tested all the mappings and sessions in Development, UAT environments and also migrated into Production environment after everything went successful.

Environment: Informatica Power Center 8.6.1/8.1.1 , Teradata V12.0, SQL Server 2008, Oracle 10g/9i, TOAD, WLM (Work Load Manager), UNIX AIX, Windows XP.

Confidential, Carlsbad, CA

ETL/Informatica Consultant

Responsibilities:

• Working on Informatica tools like Source Analyzer, Mapping Designer, Target Designer, Workflow Manager, and Workflow Monitor.
• Used various Transformations like Joiner, Aggregate, Java, Expression, Lookup, Filter, Union, Update Strategy, Stored Procedures, and Router etc. to implement complex logics while coding a Mapping.
• Involved in Data Profiling & Analysis on heterogeneous Databases Oracle, SQL Server, flat files.
• Used the Integration service in Power Center 8.6 to start multiple instances of the same workflow.
• Implemented different Tasks in workflows which included Session, Command, E-mail, Event-Wait etc.
• Created Data Breakpoints & Error Breakpoints for debugging the mappings using Debugger Wizard.
• Worked with complex queries for data validation and reporting using SQL and PL/SQL.
• Developed BTEQ scripts to transform bulk amount of data in Teradata database.
• Transferred data using Teradata utilities like SQL Assistant, Fast Export and Fast Load.
• Involved in Performance Tuning of SQL Queries, Sources, Targets and sessions by identifying and rectifying performance bottlenecks.
• Worked on Autosys Scheduler to automate the Workflows.
• Tested all the mappings and sessions in Development, UAT environments and also migrated into Production environment after everything went successful.

Environment: Informatica Power Center 8.6/8.1.1, XIR3, Teradata, SQL Server2008, Oracle 11g/9i, DB2 8.x, PL/SQL, TOAD, Autosys Scheduler, Windows 2003 Server.

Confidential

Data Warehouse Developer

Responsibilities:

• Responsible for analyzing the Existing Source System, Data nature, Business roles and Involved in Requirement gathering from various business and application experts.
• Extracted data from Sources like Oracle, Excel Spread sheets, XML, Teradata and Flat Files.
• Designed and developed Informatica Mappings to load data from Source Systems to EDH (Enterprise Data Hub) and then to Data Mart using IDE and IDQ toolset.
• Created Complex mappings using Connected & Unconnected Lookups, Aggregate, Update Strategy, Stored Procedure and Router transformations for populating into target table
• Transformed bulk amount of data from various sources to Teradata database by using BTEQ scripts.
• Developed (or edited existing) Informatica mappings and sessions to accomplish Data Migrations.
• Involved in Performance Tuning of the mappings using various components like Parameter files and Variables
• Integrated the new and existing tasks and then scheduled jobs using Autosys.
• Managed Change control implementation and coordinating daily, monthly releases and reruns.
• Created Informatica mappings with PLSQL Procedures, Functions to build business rules to load data.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
• Developed various Mapplets, Transformations and was responsible for Validating and Fine-Tuning the ETL logic coded into mappings to improve Data Quality.
• Responsible for validating the Informatica mappings against the pre-defined ETL design standards.
• Performed extensive Unit Testing on the developed Mappings and was also involved in the documentation of Test Plans and testing with the users (UAT).

Environment: Informatica Power Center 8.1.1/7.1.4 , Oracle 10g, SQL Server 2005, Autosys, TOAD, LINUX, Windows 2003.

Confidential

Data Warehouse Developer

Responsibilities:

• Involved in the Requirements gathering, Analysis and support of Data Warehousing efforts.
• Worked extensively on Informatica Designer, Workflow Manager and Workflow Monitor.
• Loaded data from OLTP Tables (which are in DB2 Database) to Staging table (ORACLE database) and Staging table to OLAP Tables (ORACLE tables).
• Involved in designing the Star schema and populating the fact tables.
• Utilized DB2 loaders (i.e.) load replace, load append to feed the data into the targets.
• Involved in identifying bugs in the business logic using Debugger.
• Involved in designing and development of pre and post session routines and batch execution routines.
• Implemented Performance tuning by utilizing dynamic cache for Lookups partitioning the sessions
• Coordinated with Developers, Testing team and DBA for the System testing and Performance testing.
• Have used Autosys Scheduler to schedule workflows and automate sessions in the workflow manager.
• Creating Low level documents for creating maps to load the data from the ODS through the warehouse.

Environment: Erwin, Informatica Power Center 7.1, SQL Server 2005, DB2, Autosys, Flat files, TOAD, Oracle 10g, UNIX and Windows 2003.