SUMMARY

• Highly Skilled Professional 8 years of Experience in the Data Warehouse and Business Intelligence Applications, that include Analysis, Design, Development, Testing and Maintain large scale Data Warehousing marts using Informatica PowerCenter.
• Experience in ETL using Informatica Power Center 9.x/8.x/7.x and SSIS (Sql Server Integration services) Tools.
• Extensively worked on Informatica power center as Senior ETL Consultant to build End - To-End Data warehousing Solutions, Data Integration, ODS (Operational Data Source), Dimensional Data marts and Data Migrations.
• Experience in working on various domains including Finance, Insurance, Fleet Card and Payment Solutions, Telecom.
• Involved in complete project life cycle of implementing Enterprise data warehouse, and Enterprise Data Integrations.
• Extensively worked on ETL Source to Target mapping documents, Data Analysis, Data profiling, Data testing, Migrating ETL code to different environments, Scheduling ETL jobs using Control-m Enterprise scheduler tool and ETL map optimization techniques to meet SLA’s.
• 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 Databases like Oracle 11g/10g/9i, MS Access 2000/2002, SQL Server 2005, 2008, DB2, COBOL, XML and Flat files.
• Extensively Worked with Informatica Client/Server tools like Designer, Workflow Manager and Workflow Monitor and Repository Manager.
• 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.
• Highly Experienced in implementing Error Handling Strategy, Testing & Debugging Errors with in ETL Transformations with Informatica Debugger.
• Implemented Type-1, Type-2 Slowly Changing Dimensions to capture the changed data.
• Experienced in Unit Testing and Test Cases for Data Ware housing projects ensuring Quality of data meets the business requirements.
• Extensively worked with Advanced Transformations like XML Parser, XML Generator and SQL Transformations.
• Posses good knowledge on Informatica PowerExchange, Informatica Data Quality(IDQ) and Master Data Management(MDM).
• Good Knowledge on SSRS, Cognos Reporting Tool for generating Reports.
• 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, and good team player with very good analytical and technical skills

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.x, 8.x, 7.x, SSIS.

Operating Systems: UNIX, Linux, and Windows 2003/2007/XP/NT.

Languages: SQL, PL/SQL, C, C++, java.

Database: Oracle 11g/10g/9i/8i, MS SQL Server 2005/2008DB2 8.0/7.0, MS Access 2000/2003.

Tools: TOAD, SQL Developer, Autosys, Control M, Erwin 4.xNetezza, SSRS, Cognos 8.

Technologies: VB, VB.net, ASP.net

Scripting: HTML, DHTML, XML, XSTL, VB Script, and JavaScript & Jscript.

Office Tools: MS Office and Acrobat Reader.

PROFESSIONAL EXPERIENCE

Confidential, South Portland, ME

Sr ETL Consultant

Responsibilities:

• Gather and Analyze Business requirements and Business processes with Business Analysts to understand data flows.
• 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).
• 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.
• Created E-mail notifications tasks using post-session scripts.
• Wrote SQL, PL/SQL & triggers for implementing business rules and transformations.

Environment: Informatica PowerCenter 9.5/9.1, Oracle 11g/10g/9i, Siebel, People Soft, Tandem, Control-M, SQL, PL/SQL, MS Access, UNIX,TOAD 8.3, XML files, Windows XP.

Confidential, Cherry Hills, NJ

Sr.ETL Consultant

Responsibilities:

• Collected and analyzed business requirements with the management and converted them in to project documentation.
• Designed the complete Data warehouse Schema using Erwin with proper relationships defined.
• 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 PowerCenter 9.1/8.6.1,Oracle 11g/10g/9i, SQLServer 2008,SQL, PL/SQL, UNIX,TOAD 11, Erwin 7.3.3, Windows XP.

Confidential, Plano, Texas

Sr.ETL Consultant

Responsibilities:

• Involved in complete SDLC including Requirement Specifications, Analysis, Design, Development, & Testing of application.
• Designed and developed the Staging Database and loaded from source to staging and from staging to the Destination tables applying different transformations.
• Developed complex SQL queries and designed SSIS packages to load the data into warehouse.
• Designing SSIS Packages using several transformations to perform Data profiling, Data Cleansing and Data Transformation.
• 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, SSIS, Oracle 10g/9i,MS Sql Server 2005, SQL, PL/SQL, SSRS, Autosys, UNIX, TOAD, SQL Developer, Windows XP.

Confidential, Pittsburgh, PA

ETL Consultant

Responsibilities:

• Developed many custom UNIX scripts, Informatica maps, PL/SQL programs and SQL*Loader scripts to provide a best-fit solution for varying data sources
• Used business requirements and functional specifications to generate logical data models
• Worked on complete SDLC from Extraction, Transformation and Loading of data.
• Responsible for the design, development and implementation of mappings /transformations based on source-to-target specifications, defining ETL (extract, transform, load) development standards and conventions
• 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.
• Generating reports for the end users using Cognos Reporting Tool.

Environment: Informatica Power Center 8.6.1/8.1,Oracle 10g/9i, Cognos 8, DB2, SQL, PL/SQL, UNIX, TOAD, Erwin,Windows 2003.

Confidential

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/7.6.1, Oracle 10g/9i, MS Access, TOAD SQL, PL/SQL, Windows 2003 server.