SUMMARY:

8 plus years of Professional Experience in Data Warehousing Solutions, that includes Design, Development, Testing and Maintain large scale Data Warehousing marts using Informatica Power Center.

7 plus years of Strong Experience with ETL tool Informatica PowerCenter 9.x/8.x/7.x.

• Extensively worked on Informatica power center as ETL Consultant to build End-To-End Data warehousing Solutions, Data Integration, ODS Operational Data Source , Dimensional Data marts and Data Migrations.
• Extensively worked on ETL Source to Target mapping documents, Data Analysis, Data testing, Migrating ETL code to different environments, Scheduling ETL jobs and ETL map optimization techniques.
• Excellent Data Analysis skills and ability to translate business logic into mappings using complex transformation logics for ETL processes.
• Extensively used ETL methodology for supporting Data Extraction, Transformation, Loading to process solution in a corporate wide ETL solution using Informatica.

Extracted data from various sources like Oracle, Flat file, SQL SERVER, DB2, XML files, COBOL files loaded into Oracle database.

• Extensively Worked with Informatica Client/Server tools like Designer, Workflow Manager and Workflow Monitor and Repository.
• Extensive experience in using various Informatica Designer Tools like Source Analyzer, Transformation Developer, Mapping Designer and Mapplet Designer.
• Strong Knowledge on Informatica Power Center Transformations like Expression, Sorter, Router, Joiner, Aggregator, Active and Passive Lookups, Stored procedure, XML Source Qualifier.
• Hands on experience in performance tuning of source, target, mappings and by implementing various techniques like partitioning techniques and push down optimization and also identify performance bottlenecks.

Experienced for implementing Error Handling Strategy, Testing Debugging Errors with in ETL Transformations with Informatica Debugger.

• Involved in complete life cycle of Enterprise data warehouse, and Enterprise Data Integrations.
• Implemented Type-1, Type-2 Slowly Changing Dimensions to capture the changed data.
• Extensively worked with Advanced Transformations like XML Parser, XML Generator and SQL Transformations.
• Sound Knowledge of RDBMS concepts,
• Sound Knowledge of Data Warehouse Concepts.
• Hands on experience in writing complex SQL queries.
• Experience with UNIX shell scripting for File validation and SQL programming.
• Extensively involved in production support and troubleshooting the production issues and actively involved with the users to understand the issues.
• Highly motivated, possesses quick grasping power and very good analytical and technical skills

TECHNICAL SKILLS:

• ETL Tools : Informatica Power Center 9.x, 8.x, 7.x.
• Operating Systems : UNIX, Linux, and Windows 2003/XP.
• Languages : SQL, PL/SQL, C, C , java.
• Database : Oracle 11g/10g/9i/8i, MS SQL Server
• 2008/2005, IBM-DB2, Microsoft Access
• Tools : TOAD, SQL Developer, Control M.
• Microsoft Technologies : VB, VB.net, ASP.net
• Scripting languages : HTML, DHTML, XML, XSTL, VB Script, JavaScript and
• Jscript.
• Office Tools : MS Office and Acrobat Reader.

PROFESSIONAL EXPERIENCE:

Confidential

Role: Sr.ETL Consultant

Responsibilities:

• Responsible for Creating ETL Logical and Physical designs to conforming heterogeneous data from multiple sources into standardized dimensions and fact Tables.
• Extracted data from flat files and oracle database, applied business logic to load them in to ware house.
• Responsible for building Replicable ETL Modules for handling slowly changing dimensions of different types Type-I, Type-II .
• Gather and Analyze Business requirements and Business processes with Business Analysts to understand data flows.
• Responsible for Designing Exception handling mechanism for reporting all instances of exceptions thrown by ETL processes.
• Developed Informatica mappings, transformation, reusable objects by using mapping designer, transformation developer and Mapplet designer.
• Created Reusable transformations, Mapplet, parameter files, Dynamic lookup's.
• Created Workflows, Worklets sessions to process the batch data.
• Responsible for create ETL Partitions, optimization technique's to improve the session performance.
• Used Aggregate, Expression, Filter, Sequence Generator, Update Strategy, Union, Lookup, Joiner, and Stored procedure transformations.
• Responsible for to build development/test/production suite of ETL processes.
• Responsible for to create and support of ETL, Database and Enterprise Scheduler Objects Migrations.
• Responsible for Day-to-Day operations and production issues.

Environment: Informatica Power Center 9.5/9.1,Oracle 11g/10g/9i, Siebel , People Soft, Tandem, FlatFiles, SQL, PL/SQL, MS Access, UNIX,TOAD,XML files, Windows XP.

Confidential

Role: Sr.ETL Consultant

Responsibilities:

• Collected and analyzed business requirements with the management and converted them in to project documentation.
• Created mapping documents with the required Transformation logic, Sources and Targets for Facts and Dimensions.
• Responsible for verification of functional specifications and review of deliverables.
• Developed Informatica mappings, transformation, reusable objects by using mapping designer, transformation developer and mapplet designer.
• Created reusable transformations and mapplets and used them in mappings.
• Created Workflows, worklets sessions to process the batch data.
• Used Aggregate, Expression, Filter, Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
• Worked with command line program pmcmd to interact with the server to start and stop sessions and batches, to stop the Informatica server and recover the sessions.
• Worked on different data sources such as Oracle, XML, Flat files, MS Access etc.
• Extracted data from flat files and oracle database, applied business logic to load them in to ware house.
• Wrote SQL, PL/SQL for implementing business rules and transformations.
• Created procedures to drop and recreate the indexes in the target Data warehouse before and after the sessions.
• Written documentation to describe program development, logic, coding, testing, changes and corrections using MS Word, and MS excel.

Environment: Informatica Power Center 9.1/8.6.1,Oracle 11g/10g/9i, SQL Server 2005, DB2, SQL, PL/SQL, MS Access, UNIX,TOAD, XML files, Windows XP.

Confidential

Role: Sr. Informatica Consultant

Responsibilities:

• Created detailed source target database mapping with required transformations.
• Designed complex mappings using Source Qualifier, Joiners, Lookups connected and Unconnected , Expression, Filters, Router, Aggregator, Sorter, Update Strategy, Stored Procedure and Normalizer Transformation.
• Implemented Informatica loading techniques like Incremental Loading Change data capture and slowly changing dimension Type 1, Type 2 .
• Worked with Informatica Deployment groups in migrating the ETL code across environments.
• Responsible for optimization of Informatica mappings, sessions, SQL queries.
• Responsible for scheduling the jobs using Informatica scheduler.
• Developed Complex mappings to provide End-to-End solution as per business requirements
• Design a mapping with the dynamic lookup cache to detect the duplicate records coming from the source

Environment: Informatica Power Center 8.6.1,Oracle 11g/10g/9i, SQL Server 2005, DB2, SQL, PL/SQL, MS Access, UNIX,TOAD, XML files, Windows XP.

Confidential

Role: ETL Consultant

Responsibilities:

• Analyze and understand the Technical Specification Document Source to Target matrix for all mappings and clarify the issues with Data Architects.
• Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Informatica Repository Manager and Informatica Workflow Manager.
• Created reusable transformations and mapplets and used them in mappings.
• Created Workflows, worklets sessions to process the batch data.
• Developed different mappings by using different Transformations like Aggregator, Lookup, Expression, update Strategy, Joiner, Router etc to load the data into staging tables and then to target.
• Involved in performance tuning by optimizing the sources, targets, mappings and sessions.
• Monitored transformation processes using Informatica Workflow monitor.
• Design the mapping with a Slowly Changing Dimension type1 and type2 to keep track of Current and historical data.
• Migrated code from one environment to other.
• Installed Informatica software in Window server machine.
• Providing access to the users and assigning privileges.

Environment: Informatica PowerCenter 8.6.1/8.1,Oracle 11g/10g/9i, DB2, SQL, PL/SQL, UNIX, TOAD, Windows XP.

Confidential

Role: Informatica Developer

Responsibilities:

• Gather and analyze information on existing Business processes in order to make recommendations that seek to improve business systems and processes.
• Analyze and document user requirements for enhancements to business processes and reporting. May involve investigation of third party vendors, procedures or systems.
• Produce clear and unambiguous documentation to detailed proposed solutions/recommendations.
• Work as part of a project team, reporting progress and escalating issues to management as appropriate.
• Create the Mappings, sessions, worklets workflows to load the data in ODS.
• Improved ETL Load 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.
• Identified and tracked the slowly changing dimensions, heterogeneous Sources and determined the hierarchies in dimensions.
• Wrote documentation of application development and subsequent revisions.
• Documented programming problems and resolutions for future reference.
• Debugging of existing code.

Environment: Informatica Power Center 8.1, Oracle 10g/9i, TOAD, SQL, PL/SQL, Windows 2003.

Confidential

Role: ETL Developer

Responsibilities:

• To prepare the detailed design document and requirement analysis document for the whole project execution phase by phase or module by module.
• Develop Informatica mappings and test separate modules on the client server. Use of various transformations like Source Qualifier, Filter, Router, sorter, Joiner, Lookup, Aggregator, Update strategy etc.
• Create workflow/Batches and set the session dependencies.
• Improved ETL Load 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.
• Identified and tracked the slowly changing dimensions, heterogeneous Sources and determined the hierarchies in dimensions.
• Wrote documentation of application development and subsequent revisions.
• Documented programming problems and resolutions for future reference.
• Debugging of existing code.
• Develop UNIX shell script to run Informatica batches. The shell scripts are full proof to trap the errors and also has enhanced feature to give required details to client by the means of mails.
• Perform Unit and Integration testing. Reporting of bugs and bug fixing.

Environment: Informatica Power Center 7.6.1, Oracle 9i, TOAD, SQL, PL/SQL, UNIX, Windows XP.