PROFESSIONAL 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 with 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 with Informatica Designer Components - Source Analyzer, Target Designer, Transformation Developer, Mapplet and Mapping Designer.
• Worked extensively with 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 the 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 the data flow and evaluating transformations.
• Hands on experience in Performance Tuning of sources, targets, transformations and sessions.
• Good experience in documenting the ETL process flow for better maintenance and analyzing the process flow.
• Worked with 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 effectively with 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 with the end users in writing the functional specifications based on the 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 the requirements by meeting the client and designing the 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 the Update Strategy Transformation to update the Target Dimension tables.
• Created connected and unconnected Lookup transformation to look up the data from the 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 the Data Marts loads, runs on time accurately.
• Developed batch file to automate the task of executing the different workflows and sessions associated with the mappings on the 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 the datawarehouse.
• Involved in versioning the whole process and retiring the old records using the 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 the existing mappings
• Involved in the ETL Source to Target documents walkthrough process with QA team.
• Involved in creating the migration documents to deploy the 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 with Informatica Power Center client tools like Repository Manager, Designer, Workflow Manager, and Workflow Monitor.
• Worked with Source Analyzer, Target Designer, Transformation Developer, Mapplet Developer, and Mapping Designer.
• Worked with Task Developer, Worklet Designer, and Workflow Designer in the Workflow Manager.
• Designed and developed mappings utilizing the Source qualifier, Expression, Filter, Joiner, Lookup, Router, Sorter, Union, Normalizer, Rank, sequence generator and Update Strategy.
• Implemented Type I slowly changing dimension to update dimensional data in the table.
• Implemented performance tuning of Sources, Targets, Mappings and Sessions by identifying bottlenecks and used Debugger to debug the complex mappings and fix them.
• Implemented the error-handling process using relational database tables.
• Code review, fixed the invalid mappings and troubleshoot the technical problems of the database.
• Performance tuning of mappings during UAT stage and maintenance phases.
• Tracking Production failures and debug the sessions by utilizing the logs of the sessions.
• Optimized Query Performance, Session Performance and Reliability.
• Used SQL tools like SQL developer and Toad to run SQL queries and validate the data.
• Used CA7 Passport Scheduler and Informatica Scheduler for scheduling the jobs.
• Perform Code review and unit testing at various levels of the ETL.
• Defined business needs and assists in developing appropriate manufacturing data model.
• Worked with business users to define and analyze problems, create logical data model, helped in implementing physical data model.
• Involved in migrating the Mappings, Sessions, Workflows from Test environment to Production environment.
• Integration of Unix shell scripting with Informatica PMCMD command utilities.

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

Informatica Developer

Confidential

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 the Accounts Payable, Manufacturing Execution, Inventory Management, and Production Planning functional areas.
• Analyzing the existing model and making the changes as per the Change Requests from the Client.
• Translated and designed maps for the requirements and codes for Informatica and performed the 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.
• Effectively resolved production issues and taking responsibility for seeing those issues thru resolution.
• Supported ETL routines required for populating the 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 the 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 the Aggregator transformation to load the summarized data for Sales and Finance departments.
• Created Reusable Transformations and Mapplets to use the transformation logic in multiple mappings.
• Worked on Repository manager to create and manage user profiles, and used Repository manager extensively while migration the code from development to production and compared both codes.
• Extensively worked on error handling.
• Worked on connected and unconnected lookups.
• Used the Informatica Workflow Manager to create and run the Workflows, Worklets and Sessions for loading the data using the 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 the complex mappings and fix them.
• Implemented Type II slowly changing dimension to keep a full history of dimensional data in the table

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

Informatica Developer

Confidential

Responsibilities:

• Design and Unit test different Modules and Applications.
• Worked on the 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 the requirement gathering and analysis in support of data warehousing efforts.
• Involved in Designing the Data warehouse using Informatica ETL tool.
• Performing unit testing on the 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 with Business analysts and the DBA for requirements gathering, business analysis and designing of the data marts.
• Analyzed the 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 the deleted records in the source systems.
• Developed PL/SQL stored procedures for database updates and to create the necessary indexes in the 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 with flat files to define parameter files and to create pre and post session commands.
• Used Debugger in troubleshooting the existing mappings.

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