SUMMARY

• Over 8.5 years of experience in Information Technology with a strong background in Data Warehousing, Business Intelligence and ETL process using InformaticaPowerCenter 9.x/8.x
• Vast experience in development of ETL process for extracting, transforming and loading data used ETL tool InformaticaPower Center 9.x/8.x
• Performed teh data profiling and analysis making use ofInformatica Data Explorer (IDE) and Informatica Data Quality (IDQ)
• Extensive experience inInsurance, Financial and Transportation domains
• Good knowledge of Data warehouse concepts and principles (Kimball/Inman) - Star Schema, Snowflake, SCD, Surrogate keys, Normalization/De normalization, Fact and Dimensional tables
• 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, XML files
• Well acquainted with Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer
• Worked extensively with complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups and Aggregators, Stored Procedures and Normalizers
• Implemented Slowly Changing Dimensions (SCD, Both Type 1 & 2)
• Designed IDQ mappings which is used as Mapplets in Power center
• 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
• Experience with SQL Plus and TOAD, PL/SQL Developer, Oracle SQL Developer as an interface to databases- to analyze, view and alter data
• Experience in ETL Error Handling, Performance Tuning and Code Optimization
• Team player and self-starter with good communication skills and ability to work independently and as a part of teh team

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 8.X/9.1/9.6, Informatica Power Exchange (PWX) 9.x, IDE, IDQ

RDBMS: MS SQL Server 2000/2005/2008/2012, DB2, Oracle 11g/10g, SAP BW

Programming GUI: SQL, PL/SQL, SQL Plus, Java, HTML, C and UNIX Shell

Tools/Utilities: TOAD, Winscp, Putty, SQL developer

Platforms: UNIX, Windows NT/2003/XP/7

PROFESSIONAL EXPERIENCE

Sr. Informatica Developer

Confidential, Minneapolis

Environment: Informatica 9.1 / 9.6, IDQ, Oracle11gR2, SQL,PL/SQL, DB2, SAP BW,XML,SQL Developer, Linux

Responsibilities:

• Worked on ETL Production Support and participate in root cause analysis
• Involved in requirement, analysis and understanding of business requirements identify teh flow of information and analyzing teh existing systems
• Analyzed teh source data coming from Oracle, Flat Files, andDB2coordinated with data warehouse team in developing Dimensional Model
• Integration of various data sources like Oracle,SQL Server,Fixed Width and DelimitedFlat Files
• Involved in enhancements and maintenance activities of teh data warehouse including tuning, modifying of stored procedures for code enhancements
• Involved in informaticaupgradation from 9.1 to 9.6
• Migrationof New and Changed Informatica objects across teh environments using Folder to Folder and Deployment Group methods
• Extensively worked with XML files as teh Source and Target, used transformations like XML Generator and XML Parser to transform XML files, used Oracle XMLTYPE data type to store XML files.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Developed several complex mappings in Informatica a variety of PowerCenter transformations, Mapping Parameters, Mapping Variables, Mapplets& Parameter files in Mapping Designer using both teh InformaticaPowerCenter and IDQ
• Mapplets and Reusable Transformations were used to prevent redundancy of transformation usage and modularity
• Designed and Developed Oracle PL/SQL and UNIX Shell Scripts, Data Import/Export.
• Created, updated and maintainedETLtechnical documentation for Production Migration
• Developed workflows with Worklets, Event waits, Assignments, Conditional flows, Email and Command Tasks using Workflow Manager
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections
• Worked on Joiner,Aggregator,Update Strategy, Rank, Router, Lookup, Stored Procedure,Sequence Generator, Filter, Sorter, and Source Qualifier

Sr. Informatica Developer

Confidential, New York, NY

Environment: Informatica 8.6 / 9, IDQ, Oracle, SQL Server,XML, DB2

Responsibilities:

• Worked on ETL production support
• Created Complex ETL Mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, Dynamic Lookup, and Connected and unconnected lookups, Filters, Sequence, Router and Update Strategy
• Fixed teh invalid mapping's and troubleshoot teh technical problems of teh database.
• Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations
• Responsible for testing, modifying, debugging, documenting and implementation ofInformatica mappings
• Created Informatica mapping documents to outline data flow from sources to targets.
• Extracted teh data from teh flat files and other RDBMS databases into staging area and populated onto Data warehouse
• Extensively used Informatica Power Center to extract data from various sources, which included Flat files, Sqlserver, Oracle, DB2 and XML
• Involved in teh design, development and testing of teh PL/SQL stored procedures, packages for teh ETL processes.
• Modified existing mappings for enhancements of new business requirements
• UsedInformatica Power Exchangefor loading/retrieving data frommainframe system
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager
• Developed slowly changed dimensions(SCD) Type 2for loading data into Dimensions and Facts
• Performed unit testing at various levels of teh ETL and actively involved in team code reviews

Sr. Informatica Developer

Confidential, Washington DC

Environment: Informatica 8.6, Oracle, SQL Server, Flat Files, Unix

Responsibilities:

• Responsible for developing, support and maintenance for teh ETL (Extract, Transform and Load) processes using Informatica Power Center 8.6
• Analyzed requirements from teh users and created, reviewed teh specifications for teh ETL
• Prepare detailed technical document and modified teh existing specifications based teh new requirement
• Created mappings, workflows, sessions and analyzed teh Sources, targets, transformed teh data, mapped teh data and loaded teh data into Targets using Informatica
• Transformations like Expression, Router, Joiner, Lookup, Update Strategy, and Sequence Generator are mainly used
• Used session and workflow logs to debug teh session and analyze teh problem associated with teh mappings and generic scripts
• Designed Incremental strategy and Reusable Transformations
• Worked on Transformation Developer, Mapping Designer, Mapplets, Sessions and Workflows
• Involved in writing UNIX shell scripts for Informatics ETL tool to run teh Sessions
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values
• Developed Complex ETL Mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, Dynamic Lookup, and Connected and unconnected lookups, Filters, Sequence, Router and Update Strategy
• Identified teh bottlenecks in teh sources, targets, mappings, sessions and resolved teh problems
• Used different tasks to manage in sessions in workflow designer
• Monitored jobsrelated to Informatica and UNIX

Jr InformaticaDeveloper

Confidential, New York

Environment: Informatica 8.6, Oracle, SQL Server, Flat Files, Unix

Responsibilities:

• Understanding teh Business requirements based on Functional specification to design teh ETL methodology in technical specifications
• Worked on integration of heterogeneous data sources like Oracle, DB2, SQL Server and Flat Files (Fixed& delimited) into Staging Area
• Worked on Informatica tools -Designer Workflow monitor and Workflow Manager, Source Analyzer, Warehouse Designer, Mapping Designer, Mapplets and Transformation Developer
• Designed and developed mappings using Source Qualifier, Expression, Lookup, Router, Aggregator, Filter, Sequence Generator, Stored Procedure, Update Strategy, joiner and Rank transformations
• Worked with Functional team to make sure required data has been extracted and loaded and performed teh Unit Testing and fixed teh errors to meet teh requirements
• Improved session Performance by enabling property incremental aggregation to load incremental data into target table
• Debugging and validating teh mappings and Involved in Code Review
• Used various Performance tuning Techniques to improve teh session performance
• Worked on correcting and reloading rejected files