SUMMARY

• 7 years of experience in all the phases of the Data warehouse life cycle involving design, development and Implementation of Data warehouses/Data marts using ETL, Data Modeling, Online Analytical Processing & reporting tools
• Strong experience in performing ETL operations like Data Extraction, Data Transformation and Data Loading with Informatica Power Center 8.x,7.x,6.x
• Extensive experience in Informatica Power Exchange to create data maps which involved creating, debugging and executing mappings, sessions, tasks, and workflow.
• Extensive knowledge of various kinds of Informatica Transformations ( Source Qualifier, Java, SQL, Transaction Control, Aggregate, Lookup,.
• Rank, Joiner, Filter, Router, Sorter, Sequence, Union, Update Strategy, Stored Procedure).
• Experience on Informatica designer tools like transformations, reusable transformations, mappings, mapplets, workflows and worklets. Extensively worked with Slowly Changing Dimensions (Type I, Type II and Type III).
• Extensively worked in creating Mappings using Informatica Designer and processing tasks using Workflow Manager to configure data flows from multiple data sources (Oracle, DB2, SQL server, Teradata, Flat files) to targets persistent data stores.
• Strong experience in RDBMS Concepts, Dimensional Data Modeling (Star Schema, Snow - flake Schema, FACT and Dimension tables), Logical and Physical Data Modeling.
• SQL/Database developer experience in writing efficient SQL queries, PL/SQL Scripts, fine tuning queries and wrote several SQL queries for adhoc reporting.
• Experience in Creating Tables, Views, Triggers, Stored Procedures, User Defined Functions and other PL/SQL statements for various applications.
• Expert in using Informatica Power Exchange CDC (Change Data Capture) with Oracle database.
• Created Workflows with worklets, event wait, decision box, email and command tasks using Workflow Manager and monitored them in Workflow Monitor
• Experience in maintenance and enhancement of existing data extraction, cleansing, transformation, and loading processes to improve efficiency.
• Participated in the installation and configuration of Oracle BI EE 10.1.3.1.0 in the windows Experience in UNIX Shell Scripting and Autosys for scheduling the workflows.
• Extensive experience in performance tuning, identified and fixed bottlenecks, and tuned the complex Informatica mappings for better performance.
• Strong knowledge of Software Development Life Cycle (SDLC) including requirement analysis, design, development, testing, and implementation. Provided End User Training and Support.
• Experience in performance by dropping indexes, truncating stage tables, rebuilding the indexes, and analyzing the tables during the process by using DAC
• Experienced in administrative work by creating users, user groups, folders, configure security and giving permissions in folders and to users in Repository manager.
• Extensively worked for monitoring scheduled, running, completed and failed sessions. Involved in debugging the failed mappings and developing error handling methods.
• Ability to quickly grasp available technology, tools and existing designs.
• Excellent written and communication skills, analytical skills with the ability to perform independently as well as in a team.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 8.x/7.x/6.x (Workflow Manager, Workflow Monitor, Warehouse Designer, Transformation developer, Mapplet Designer, Mapping Designer, Repository manager, and Informatica server), Power exchange 8.x/7.x

Database & Related Tools: Oracle 10g/9i/8i, MS SQL Server 2005/2008, Sybase, Teradata, DB2, SQL*Plus, SQL Loader, Ms Access

Data Modeling Tools: TOAD 9, Erwin 4.0 (Dimensional Data Modeling, Star schema, Snowflake schema), Physical and Logical Data Modeling

BI & Reporting Tools: OBIEE 10.1.3.4, Cognos 8.0, Business Objects 6.5, DAC 10.1.3.4, Autosys, Control-M.

Languages: SQL, PL/SQL, C, C++, JAVA, Unix Shell Scripting

Operating Systems: Window 95/98/2000/2003/ XP, Unix.

Other: MS Word, MS Excel, MS Office 2003/2007/2010 , Outlook, PowerPoint

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Sr. Informatica Developer

Responsibilities:

• Involved in designing, developing and documenting of the ETL (Extract, Transformation and Load) strategy to populate the Data Warehouse from various source systems feeds using Informatica, PL/SQL scripts
• Designed and developed complex mappings in Informatica to load the data from various sources such as SQL server, Flat files, Oracle using different transformations such as, Source qualifier, Look up (connected and unconnected), Expression, Aggregate, Update strategy, Sequence generator, Joiner, Filter, Rank, and Router transformations.
• Designed and developed mappings, defined workflows and tasks, monitored sessions, exported and imported mappings and workflows, backups, and recovery.
• Extensively worked with database and Informatica for performance tuning.
• Created and configured workflows, worklets, and sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager.
• Created Mapping Parameters and Variables.
• Implemented Change Data Capture (CDC) to extract information and Partitioned sessions for concurrent loading of data into the target tables
• Implemented Slowly Changing Dimensions (SCD) to update the dimensional schema.
• Developed PL/SQL stored procedures and UNIX commands shell scripts for pre and post session commands and batch jobs.
• Executed sessions, both sequential and concurrent for efficient execution of mappings and used other tasks like event wait, event raise, email, command and pre/post SQL
• Worked with PMCMD command line program to talk with the Informatica server
• Performed extensive testing on the mappings and wrote queries in SQL to check if the data was loading to the dimension tables and fact tables properly.

Environment: Informatica PowerCenter 8.6, (Repository Manager, Mapping Designer, Workflow Manager and Workflow Monitor), Oracle 9i, SQL, PL/SQL, SQL Server, Windows 2000 and UNIX, Cognos

Confidential, Richmond, VA

Sr. Informatica Developer

Responsibilities:

• Involved in planning, building, and managing successful large-scale Data Warehouse and decision support systems
• Responsible for Informatica ETL development & DAC Execution Plan creation. In order to develop OBIEE report, implemented star schemas.
• Created users and user groups with appropriate privileges and permissions, folders and folder permissions in Repository manager.
• Worked on Informatica Power Center 8.6 tools - Source Analyzer, Mapping Designer, Power Exchange and Transformations.
• Extracted source data using power exchange from Siebel System.
• Created complex mappings using Lookup, Sorter, Aggregator, and Router transformations for populating target table in efficient manner.
• Created Transformations like Aggregator, Expression, Filter, Router, Sequence Generator, Update Strategy, Joiner, and Source Qualifier Transformations in the Informatica Designer.
• Developed Informatica mappings, sessions and workflows for all mappings.
• Implemented Type II slowly changing dimension to keep a full history of dimensional data in the tables.
• Worked on Dimension as well as Fact tables, developed mappings and loaded data on to the relational database.
• Used SQL tools like SQL Plus to run SQL queries and validate the data pulled in OBIEE reports.
• Extensively used debugger to trace errors in the mapping.
• Performed Developer testing, Functional testing, and Unit testing for the Informatica mappings.
• Worked on creating and customizing DAC (Datawarehouse Administration Console) Tasks, Subject Areas and Execution plans to load data from Siebel CRM application to Siebel Relationship Management Warehouse (SRMW) using Informatica PowerCenter 8.6 pre-built vanilla mapping.
• Created DAC Execution plan to schedule the Informatica mappings to load the data incrementally on a daily basis.
• Created BI Publishers in OBIEE Repositories. Created Aggregation tables in OBIEE and Created Job Scheduling for Aggregation Tables.

Environment: Informatica Powercenter 8.6, DAC 10.1.3.4, Siebel 8.1.1, OBIEE 10.1.3.4, Oracle 10g, SQL*Plus, TOAD, BI APPS 7.9.6

Confidential, Memphis, TN

Sr. ETL Consultant

Responsibilities:

• Team member of the Data Warehousing module. Involved in designing, developing and documenting of the ETL (Extract, Transformation and Load) strategy to populate the Data Warehouse from various source systems feeds using Informatica, PL/SQL scripts
• Designed and developed complex mappings in Informatica to load the data from various sources using different transformations such as Java, SQL, Transaction control, Source qualifier, Look up (connected and unconnected), Expression, Aggregate, Update strategy, Sequence generator, Joiner, Filter, Rank, and Router transformations.
• Designed and developed mappings, defined workflows and tasks, monitored sessions, exported and imported mappings and workflows, backups, and recovery.
• Extensively worked with database and Informatica Partitioning for performance tuning.
• Extensively designed and developed reusable transformations & aggregations and created target mappings that contain business rules.
• Extensively used Informatica Power Exchange.
• Created and configured workflows, worklets, and sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager.
• Implemented Change Data Capture (CDC) to extract information and Partitioned sessions for concurrent loading of data into the target tables.
• Fixed invalid mappings, tested stored procedures and functions, and performed unit testing of Informatica Sessions and Workflows.
• Implemented Slowly Changing Dimensions (SCD) to update the dimensional schema.
• Developed PL/SQL stored procedures and UNIX shell scripts for pre and post session commands and batch jobs.
• Executed sessions, both sequential and concurrent for efficient execution of mappings and used other tasks like event wait, event raise, email, command and pre/post SQL
• Wrote shell scripts and control files to load data into staging area and then into database tables.
• Provided extensive support in UAT (user acceptance testing) and deployment of mappings.
• Performed extensive testing on the mappings and wrote queries in SQL to check if the data was loading to the dimension tables and fact tables properly.

Environment: Informatica Power Center 8.1.1(Repository Manager, Designer, Workflow Manager, Workflow Monitor, Repository Administration Console), Power Exchange, UNIX, Oracle 10g

Confidential, Minneapolis MN

Informatica Developer

Responsibilities:

• Involved in business analysis and technical design sessions with business and technical staff to develop Entity Relationship/data models, requirements document, and ETL specifications.
• Analyzed and Created Fact tables and Dimension Table for storing the historical data.
• Developed various mappings for extracting the data from different source systems using Informatica Power Center 8.5.2 - Server, Workflow Manager, Repository Manager and Designer
• Worked on Informatica tools like Source Analyzer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Developed various Mappings, Mapplets and Transformations for migration of data from various existing systems to the new system using Informatica Power Center Designer.
• Involved in designing and developing logical & physical data models to support strategic business decisions, Managed Users, User Groups and Privileges in the Repository Manager.
• Experience in extracting and loading data into Teradata.
• Developed mappings between multiple sources such as flat files, oracle and multiple targets.
• Strong experience in using Expressions, Joiners, Routers, Lookups, Update strategy, Source qualifiers and Aggregators.
• Created Informatica mappings with PL/SQL stored procedures/functions to in corporate critical business functionality to load data.
• Developed Informatica mappings for Type 2 Slowly Changing Dimensions.
• Created Mapplets for reusable business rules.
• Created UNIX shell script to transport flat files from different ordering systems to the ETL server.
• Worked on performance tuning of mappings, sessions, Target and Source.
• Used the Debugger to run Debug sessions setting Breakpoints across instances to verify the accuracy of data.
• Involved in creating and running Sessions & Workflows using Informatica Workflow Manager and monitoring using Workflow Monitor.
• Developed UNIX Shell scripts for data extraction, running the pre/post processes and PL/SQL procedures. Wrote test plans and implemented Unit testing.
• Created Autosys scripts for Scheduling the ETL jobs
• Involved with business objects developers for creating list and cross tab reports.

Environment: Informatica - Power Center 8.x/7.x, Oracle 9i, Erwin 4.0, SQL, PL/SQL, UNIX, Autosys, BO 6.x, Teradata, TOAD 8.6 and Windows NT/2000.

Confidential

Data Warehouse/ Informatica ETL Developer

Responsibilities:

• Analyzed the systems, architecture, met with end users and business units in order to define the requirements.
• Involved in the requirement definition and analysis in support of Data Warehousing efforts.
• Developed ETL mappings, transformations using Informatica PowerCenter 6.x
• Extensively used Informatica tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer,
• Implemented various Informatica transformations like Expression, filter, Aggregator, Router, Ranker, update strategy, joiner, Lookup, Sequence generator, stored procedure and Source Qualifier. To load the data from Staging area to DW
• Developed data Mappings between source systems and warehouse components using Mapping Designer.
• Involved in the Performance Tuning.
• Created and ran sessions and workflows using Workflow Manager.
• Monitored the sessions and workflows using Workflow Monitor.
• Trouble shooting of connectivity problems. Looked up and read session, event and error logs for troubleshooting.
• Helped in generating reports using Cognos Powerplay.

Environment: Informatica PowerCenter 6.2.1, Cognos 6.x, Oracle 8i, Erwin, UNIX Shell Scripts, TOAD, SQL * Loader, Windows NT.

Confidential

PL/SQL Developer

Responsibilities:

• User requirement analysis and documentation.
• Constructed PL/SQL by using cursors, triggers and procedures to bring data into database based on the design.
• Developed several procedures, packages in Oracle.
• Prepared test cases based on the test plan for procedures and packages.
• Performed unit testing and integration testing.

Environment: Oracle 8i,MS Access, PL/SQL, SQL Plus, SQL*Loader, UNIX, Windows 2000.