SUMMARY

• 7+ years of experience inETL process using Informatica Power Center.
• Good knowledge of Data warehouse concepts and principles Star Schema, Snowflake, SCD Types, Surrogate keys, Normalization/De normalization.
• Experience in integration of various data sources wif Multiple Relational Databases like Oracle, SQL Server and Worked on integrating data from flat files like fixed width and delimited.
• Have extensively worked in developing ETL for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Well acquainted wif Informatica Designer Components - Source Analyzer, Target Designer, Transformation Developer, Mapplet and Mapping Designer.
• Worked extensively wif complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Update Strategy, Unconnected / Connected Lookups and Aggregators.
• Worked extensively on SCD Type1 and SCD Type 2 mappings.
• Strong Experience in developing Sessions/tasks, Worklets, Workflows using Workflow Manager Tools - Task Developer, Workflow & Worklet Designer.
• Experience in using teh Informatica command line utilities like pmcmd to execute workflows in non-windows environments. Extensively used Informatica Repository Manager and Workflow Monitor.
• Experience in debugging mappings. Identified bugs in existing mappings by analyzing teh data flow and evaluating transformations.
• Hands on experience in Performance Tuning of sources, targets, transformations and sessions.
• Good experience in documenting teh ETL process flow for better maintenance and analyzing teh process flow.
• Worked wif Stored Procedures, Triggers, Cursors, Indexes and Functions.
• Strong in UNIX Shell scripting. Developed UNIX scripts using PMCMD utility and scheduled ETL load using utilities like Autosys, Control-M and CA7 Passport.
• Migrating data mapping to test environment and monitoring, troubleshooting and restarting batch processes using Informatica Power Center.
• Demonstrated ability to work and communicate TEMPeffectively wif both business and technical audiences.
• Highly motivated to take independent responsibility as well as ability to contribute and be a productive team member.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center

Databases: Oracle, SQL Server, and DB2

GUI Tools: Toad, SQL Navigator, SQL* PLUS, SQL Developer, SQL Assistant.

Scheduling Tools: Informatica Scheduler, Autosys, Control-M

Scripting Languages: UNIX Shell Scripting

Operating Systems: Windows NT/2000/XP Professional/2003 Server, LINUX, UNIX

Oracle Tuning: SQL Tuning, Explain Plan, Table Partitioning, Materialized views, Hints.

PROFESSIONAL EXPERIENCE

Informatica Developer

Confidential, Pittsburgh PA

Responsibilities:

• Worked closely wif teh end users in writing teh functional specifications based on teh business needs.
• Responsible for gathering suit of business requirements, prepare Source to Target Mapping specifications and Transformation rules.
• Created Source to Target Mapping Specification Document.
• Involved in system study, analyze teh requirements by meeting teh client and designing teh system.
• Developed mappings/reusable objects/ transformation mapplets by using mapping designer, transformation developer and mapplet designer in Informatica Power Center.
• Extracted data from different sources like SQL Server, Oracle, Flat files and loaded into ODS.
• Designed and developed complex aggregate, join, lookup transformation rules (business rules) to generate consolidated (fact summary) data identified by dimensions using Informatica ETL tool.
• Used teh Update Strategy Transformation to update teh Target Dimension tables.
• Created connected and unconnected Lookup transformation to look up teh data from teh source and target tables.
• Involved in Performance tuning for sources, targets, mappings, sessions and server.
• Wrote SQL, PL/SQL, stored procedures for implementing business rules and transformations.
• Ensured teh Data Marts loads, runs on time accurately.
• Developed batch file to automate teh task of executing teh different workflows and sessions associated wif teh mappings on teh development server.
• Created test cases and completed unit, integration and system tests for Data Warehouse.
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Warehouse.
• Used SCD Type 2 to load historical data into teh datawarehouse.
• Involved in versioning teh whole process and retiring teh old records using teh built-in’s DD UPDATE, DD DELETE, and DD INSERT
• Identified sources, targets, mappings and sessions and tuned them to improve performance.
• Used Debugger in troubleshooting teh existing mappings
• Involved in teh ETL Source to Target documents walkthrough process wif QA team.
• Involved in creating teh migration documents to deploy teh code from one environment to another.

Environment: Informatica, Windows7, Oracle 11g, Toad, SQL Developer, SQL Plus and UNIX, OLTP and OLAP Systems

Informatica Developer

Confidential, Cincinnati OH

Responsibilities:

• Team co-ordination for design discussions, code review and mentoring.
• Worked wif Informatica Power Center client tools like Repository Manager, Designer, Workflow Manager, and Workflow Monitor.
• Worked wif Source Analyzer, Target Designer, Transformation Developer, Mapplet Developer, and Mapping Designer.
• Worked wif Task Developer, Worklet Designer, and Workflow Designer in teh Workflow Manager.
• Designed and developed mappings utilizing teh Source qualifier, Expression, Filter, Joiner, Lookup, Router, Sorter, Union, Normalizer, Rank, sequence generator and Update Strategy.
• Implemented Type me slowly changing dimension to update dimensional data in teh table.
• Implemented performance tuning of Sources, Targets, Mappings and Sessions by identifying bottlenecks and used Debugger to debug teh complex mappings and fix them.
• Implemented teh error-handling process using relational database tables.
• Code review, fixed teh invalid mappings and troubleshoot teh technical problems of teh database.
• Performance tuning of mappings during UAT stage and maintenance phases.
• Tracking Production failures and debug teh sessions by utilizing teh logs of teh sessions.
• Optimized Query Performance, Session Performance and Reliability.
• Used SQL tools like SQL developer and Toad to run SQL queries and validate teh data.
• Used CA7 Passport Scheduler and Informatica Scheduler for scheduling teh jobs.
• Perform Code review and unit testing at various levels of teh ETL.
• Defined business needs and assists in developing appropriate manufacturing data model.
• Worked wif business users to define and analyze problems, create logical data model, helped in implementing physical data model.
• Involved in migrating teh Mappings, Sessions, Workflows from Test environment to Production environment.
• Integration of Unix shell scripting wif Informatica PMCMD command utilities.

Environment: Informatica, Oracle 11g, SQL developer, Toad, SQL Plus and UNIX, OLTP and OLAP Systems.

Informatica Developer

Confidential, Tulsa

Responsibilities:

• Responsible for design, development, and support of new and existing ETL processes utilizing best practices into Enterprise Data Warehouse.
• Help for support activities in teh Accounts Payable, Manufacturing Execution, Inventory Management, and Production Planning functional areas.
• Analyzing teh existing model and making teh changes as per teh Change Requests from teh Client.
• Translated and designed maps for teh requirements and codes for Informatica and performed teh tasks.
• Prepare documentation on all aspects of ETL processes, definitions and mappings
• Performed tuning of SQL queries for extraction of data and Troubleshoot and resolved production Issues.
• Involved in creating Informatica Mapping / Sessions and Workflows.
• TEMPEffectively resolved production issues and taking responsibility for seeing those issues thru resolution.
• Supported ETL routines required for populating teh Data Warehouse and Experience in loading high-volume data, Tuning and troubleshooting of mapping.
• Extensively worked on Informatica Designer, Workflow Manager, and Workflow Monitor.
• Created different transformations for loading teh data into targets using various transformations like Source Qualifier, Joiner transformation, Router, Update Strategy, Lookup transformation, Rank Transformations, Expressions, Aggregator, and Sequence Generator etc.
• Used teh Aggregator transformation to load teh summarized data for Sales and Finance departments.
• Created Reusable Transformations and Mapplets to use teh transformation logic in multiple mappings.
• Worked on Repository manager to create and manage user profiles, and used Repository manager extensively while migration teh code from development to production and compared both codes.
• Extensively worked on error handling.
• Worked on connected and unconnected lookups.
• Used teh Informatica Workflow Manager to create and run teh Workflows, Worklets and Sessions for loading teh data using teh logic from mappings.
• Create/Maintain database stored procedures, functions, views, types, tables.
• Implemented performance tuning of Sources, Targets, Mappings and Sessions by identifying bottlenecks and used Debugger to debug teh complex mappings and fix them.
• Implemented Type II slowly changing dimension to keep a full history of dimensional data in teh table

Environment: Informatica, Oracle 11g, Toad, SQL Plus and UNIX.

Informatica Developer

Confidential

Responsibilities:

• Design and Unit test different Modules and Applications.
• Worked on teh Master test plan and test cases.
• Worked on integration testing.
• Physical and logical data modeling using ERWIN.
• Wrote triggers and stored procedures in PL/SQL.
• Involved in teh requirement gathering and analysis in support of data warehousing efforts.
• Involved in Designing teh Data warehouse using Informatica ETL tool.
• Performing unit testing on teh data and reports validation.
• Wrote re-usable mapplets to create Error handling routines.
• Performance tune ETL code.

Environment: Informatica Power center, UNIX, Oracle, TOAD, SQL Plus, MS Office.

Informatica Developer

Confidential

Responsibilities:

• Collaborated wif Business analysts and teh DBA for requirements gathering, business analysis and designing of teh data marts.
• Analyzed teh data from various sources such as PeopleSoft, AVR, etc. to maintain consistency and performed validation.
• Extensively used Informatica Client tools - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Informatica Repository Manager and Workflow Manager.
• Developed various mappings using Aggregator, Lookup and Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator.
• Created Complex Mappings which involved SCDs to implement Business Logic and capturing teh deleted records in teh source systems.
• Developed PL/SQL stored procedures for database updates and to create teh necessary indexes in teh target tables.
• Created PL/SQL packages and stored procedures to load data from various sources to staging area.
• Created and scheduled Sessions, Jobs based on demand, run on time and run only once using Workflow Manager.
• Performed Unit testing, Integration testing and System testing of Informatica mappings.
• Wrote UNIX shell scripts to work wif flat files to define parameter files and to create pre and post session commands.
• Used Debugger in troubleshooting teh existing mappings.

Environment: Informatica Power center, UNIX, Oracle, TOAD, SQL Plus, MS Office