Summary

Six plus (6+) years of Data warehousing experience using Informatica Power Center 8.6/8.1/7.1/6.2/5.1.1, Informatica PowerMart 5.1.1 ,Warehouse Designer, Power Connect, Power Analyzer, Data Analyzer, ETL, Datamart.

• Data Processing experience in designing and implementing Data Mart applications, mainly transformation processes using Informatica.
• Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter and Sequence Generator.
• Proficiency in using Informatica Power Center tool to design data conversions from wide variety of sources.
• Strong in Data Warehousing concepts, Star Schema and Snowflake schema methodologies.
• Extensively worked with large databases in Development/Production environments.
• Proficient in using Informatica Workflow Manager, Workflow Monitor to create, schedule and control workflows, tasks, and sessions.
• Performance tuning of the Informatica and Databases.
• Extensive work in ETL process consisting of data transformation, data sourcing, mapping, conversion and loading.
• Proficient in understanding business processes, requirements and translating them into technical requirements.
• Strong knowledge of Entity-Relationship concept, Facts and dimensions tables, slowly changing dimensions and Dimensional Modeling (Star Schema and Snow Flake Schema).
• Experience in creating Reusable Transformations (Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank) and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Experience in creating Reusable Tasks (Sessions, Command, Email) and Non-Reusable Tasks (Decision, Event Wait, Event Raise, Timer, Assignment, Worklet, Control).
• Experienced in UNIX work environment, file transfers, job scheduling and error handling.
• Extensively worked on developing and debugging Informatica mappings, mapplets, sessions and workflows.
• Worked on Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Experience in writing, testing and implementation of the PL/SQL triggers, stored procedures, functions, packages.
• Involved in Unit testing, System testing to check whether the data loads into target are accurate.
• Experience in support and knowledge transfer to the production team.
• Proficient in interaction with the business users by conducting meetings with the clients in Requirements Analysis phase.
• Extensive functional and technical exposure. Experience working on high-visibility projects
• Assign work and provide technical oversight to onshore and offshore developers
• Excellent analytical/ communication skills and good team player.

Education: Bachelor of Computer Engineering

Technical Skills

Informatica Power Center 9.0/8.6/8.1/8.0/7.1/6.2/5.1.1, Informatica a PowerMart 5.1.1, Warehouse Designer, Power Connect, Power Analyzer, Data Analyzer, ETL, DataMart, IDQ, IDE.

Dimensional Data Modeling:

Dimensional Data Modeling, Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimension Tables, Physical and Logical Data Modeling, Erwin 7.2/4.5/4.0.

Databases:

Oracle 11g/10g/9i/8i, SQL Server 2000/2005, MS SQL Server 2008/2005/7.x

Reporting Tools:

Business Objects XI/6i/6.0/5.1, Cognos Series 7.0

Programming:

TOAD, SQL,PL/SQL, Unix Shell Scripting, T-SQL, SQL

Environment:

Sun Solaris 2.6/2.7, Unix HP9000

Professional Experience:

Client: Confidential,Columbus, OH December11– Present
Role: ETL Developer

• Participated in User meetings, gathering requirements, discussing the issues to be resolved.
• Translating user inputs into ETL design docs.
• Participate in Design Reviews of Data model and Informatica mapping design.
• Assisted in creating Logical and Physical data modeling.
• Performed Data Analysis.
• Developed mappings, sessions and workflows in Informatica Power Center.
• Wrote Unix scripts and SQL commands to test and analyze the data.
• Worked extensively with Oracle SQL and PL/SQL coding.
• Designing and creation of complex mappings using SD type II.
• Extracted data from various sources like Sybase, Oracle, flat files and SQL Server.
• Creating the weekly project status reports, tracking the progress of tasks according to schedule and reporting any risks and contingency plan to management and business users.
• Extensive use of Informatica Metadata Manager for data lineage and where used analysis, metadata browsing, metadata reporting & metadata document.
• Performed various testing processes unit testing, end to end test, and regression testing.

Environment: Informatica Power center 8.6, Oracle 11g/10g, SQL Server 2005,PL/SQL, SQL Loader, Toad, Unix shell scripting

Client: Confidential,Atlanta, GA October 2010 – December 2011 Role: Sr. ETL Developer

Responsibilities:

• Implemented CDC by tracking the changes in critical fields required by the user.
• Developed standard and reusable mappings and mapplets using various transformations like Expression, Aggregator, Joiner, Router, Lookup (Connected and Unconnected) and Filter.
• Extensive use of Persistent cache to reduce session processing time.

Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance.

• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Used Workflow Manager for creating, validating, testing and running the sequential and concurrent sessions.
• Implemented screen door process for cleaning flat files as per the business requirements.
• Preparing ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.
• Involved in Unit testing, Iterative testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Preparing and using test data/cases to verify accuracy and completeness of ETL process.
• Actively involved in the production support and also transferred knowledge to the other team members.
• Co-ordinate between different teams across circle and organization to resolve release related issues.

Environment: Informatica PowerCenter 8.6.1, Informix, SQL Server 2005\\2008, Erwin 4.1, Windows XP, UNIX.

Client: Confidential,Rhode Island, NY July 2008- August 2010
Role: Sr. ETL Developer

Responsibilities:

• Interacted with the Business users to identify the process metrics and various key dimensions and measures. Involved in the complete life cycle of the project.
• Developed FRD (Functional requirement Document) and data architecture document and communicated with the concerned stakeholders. Conducted Impact and feasibility analysis.
• Extensively involved in Data Extraction from Mainframe source (VSAM), Oracle using Power Exchange when there was change in the source data sets.
• Created mappings using the Transformations like Source qualifier, Aggregator, Expression, lookup, Router, Filter, Rank, Sequence Generator, and Update Strategy.
• Created Mapplets, reusable transformations and used them in different mappings.
• Created Workflows and used various tasks like Email, Event-wait and Event-raise, Timer, Scheduler, Control, Decision, Session in the workflow manager.
• Made use of Post-Session success and Post-Session failure commands in the Session task to execute scripts needed for clean up and update purposes.
• Implemented parallelism in loads by partitioning workflows using Pipeline, Round-Robin, Hash, Key Range and Pass-through partitions.
• Validation of Informatica mappings for source compatibility due to version changes at the source.
• Trouble shooting of long running sessions and fixing the issues.
• Worked with Informatica DT tool to transform XML data of one format into another XML output format.
• Implemented daily and weekly audit process for the Claims subject area to ensure Data warehouse is matching with the source systems for critical reporting metrics.
• Involved in writing SQL scripts, stored procedures and functions and debugging them.
• Prepared ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.
• Involved in Unit testing, System testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Worked with reporting team to help understand them the user requirements on the reports and the measures on them. Helped them in creating canned reports.
• Migrated repository objects, services and scripts from development environment to production environment. Extensive experience in troubleshooting and solving migration issues and production issues.
• Actively involved in production support. Implemented fixes/solutions to issues/tickets raised by user community.

Environment:Informatica PowerCenter 8.6.1,PowerExchange 8.1, Informatica DT, Oracle 10g/11g, SQL Server 2005, DB2, Mainframe, XML, Unix, Erwin.

Client: Confidential,Columbus, OH June 2007 - May 2008
Role: Sr. ETL Developer

Responsibilities:

• Participated in User meetings, gathering requirements, discussing the issues to be resolved.
• Translating user inputs into ETL design docs.
• Participate in Design Reviews of Data model and Informatica mapping design.
• Assisted in creating Logical and Physical data Modeling.
• Performed Data Analysis.
• Developed Logical and Physical Data Model using Erwin, followed Star Schema to build the Data mart.
• Developed mappings, sessions and workflows in Informatica Power Center.
• Wrote Unix scripts and SQL commands to test and analyze the data.
• Worked extensively with Oracle SQL and PL/SQL coding.
• Designing and creation of complex mappings using SD type II.
• Extracted data from various sources like XML, Sybase, Oracle, flat files and SQL Server.
• Creating the weekly project status reports, tracking the progress of tasks according to schedule and reporting any risks and contingency plan to management and business users.
• Extensive use of Informatica Metadata Manager for data lineage and where used analysis, metadata browsing, metadata reporting & metadata document.
• Performed various testing processes unit testing, end to end test, and regression testing.
• Generated ad-hoc reports for the end users, as well was involved in administering the reports using Cognos

Environment: Informatica Power center 6.2/7.1, Oracle 11g/10g, SQL Server 2005,PL/SQL, SQL Loader, Toad, Erwin, Unix shell scripting, Cognos.

Confidential,India May 2005 - April 2007
Role: ETL\\Informatica Developer

Responsibilities:

• Participated in User meetings, gathering requirements, discussing the issues to be resolved.
• Translating user inputs into ETL design docs.
• Participate in Design Reviews of Data model and Informatica mapping design.
• Assisted in creating Logical and Physical data Modeling.
• Performed Data Analysis.
• Developed Logical and Physical Data Model using Erwin, followed Star Schema to build the Data mart.
• Developed mappings, sessions and workflows in Informatica Power Center.
• Design and deploy ETL job workflows with exemption handling and reporting strategy.
• Implemented Type2 Dimension logic in mappings using Informatica Designer.
• Unit tested the mapping logic for correctness.
• Designed and implemented change data capture and web services.
• Extensively utilized the Debugger utility to test the mappings.
• Provided support for the implemented code for defects and enhancements.
• Extensively used Power Center to design multiple mappings with embedded business logic.
• Tuned performance of Informatica mappings using components like Parameter files, variables and Dynamic cache.
• Using Workflow Manager, Server Manager for creating, validating, Testing and running the Batches and Sessions and scheduling them to run at specified time.
• Performance tuning of databases and mappings.
• Tuning the Informatica Mappings for optimum performance.
• Used transformation logic to cleanse the data.
• Extensively worked on all the transformations like Filter, Aggregator, Expression, Router, Lookup, Update Strategy, Sequence Generator, Rank, Union, Joiner, Source Qualifier, etc.
• Developed Slowly changing Dimensions mapping to accommodate the passive mode phase.
• Developed number of complex Informatica Mappings, Mapplets and Reusable Transformations for weekly loading of data.
• Developed several Mappings and Mapplets using corresponding Source, Targets and Transformations.
• Worked with Informatica Power center 8.1/8.6- Source Analyzer, Warehouse Designer, Mapping Designer and Mapplet and Transformation Developer for creating mappings.
• Used Informatica Workflow Manager for creating, running the Workflows and Sessions and scheduling them to run at specified time.
• Worked on Data Extraction, Data Transformations, Data Loading, Data Conversions and Data Analysis,
• Extensively designed data mapping using filters expression, update strategy transformations in power center designer.
• Created target load order group mappings and scheduled them daily loads.
• Worked extensively with Oracle SQl and PL/SQL Coding.
• Extracting the data from different sources that involved flat files, XML, DB2, Siebel, Oracle, MS SQL Server relational tables.
• Used different transformations for Extraction/transformation, data cleansing and loading data into staging areas and Presentation Tables.
• Worked with workflow manager and workflow monitor to schedule batches and run the workflow and monitor session logs.
• Effectively tuned the performance of Informatica Transformations, mappings, sessions and workflows.
• Used various partitioning schemes in order to improve the overall session performance.
• Worked on the performance tuning of databases (dropping & re-building indexes, partitioning on tables).
• Involved in developing Unix shell and Perl scripts to invoke the workflows and Informatica batches including the pre and post analysis.

Environment: Informatica Power center 6.2/7.1, Oracle 11g/10g, SQL Server 2005, PL/SQL, SQL Loader, Erwin, Unix shell scripting.