SUMMARY

• Around 7 years of expertise on ETL Data Warehousing using Informatica Power Center 9.x/8.x/7.x.
• Strong Experience as ETL Developer in Analysis, Design, Development, Testing and Implementation of various Data Warehousing implementations across various organizations.
• Strong experience on Informatica Power Center wif strong business understanding and knowledge of Extraction, Transformation and Loading of data from source systems like Flat files, Excel, XML, Oracle, SQL Server.
• Involved in all phases of Software Development Life Cycle (SDLC) includes gathering requirements and transforming teh business requirement to technical requirement document,developing, reviewing and testing teh ETL - code.
• Extensively involved in ETL Data warehousing using Informatica Power Center 7.x/8.x/9.x Designer tools like Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor.
• Experience in creating Reusable Transformations (Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Normalizer and Rank) and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Experience wif dimensional modeling using star schema.
• Hands on experience in identifying and resolving performance bottlenecks in various levels like sources,mappings and sessions.
• Involved inUnit Testingto check whether teh data loads into target are accurate.
• Good Working Knowledge in writing SQL Joins, Nested Queries, Unions.
• Worked extensively wif slowly changing dimensions (SCD’s).
• Good in coding using SQL, SQL*Plus, PL/SQL, Procedures/Functions.
• Experienced in using Erwinin terms of Data modeling, Expertise in Dimensional modeling.
• Good experience in performing and supporting Unit testing, System Integration testing (SIT), UAT and production support for issues raised by application users.
• Knowledge of reporting tools like MicroStrategy and Cognos.
• A team player wif good Technical, Communicationand Interpersonal skills wif fast Learning and creative Analytical abilities.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.5, 9.0.1, 8.x, 7.x (Designer, Workflow Manager, Workflow Monitor, Repository Manager)

Data Modeling Tools: Erwin

Databases: Oracle11g / 10g / 9i, MS SQL Server 2000/2005/2008

Operating System: Windows NT/2000/XP/7/8

Languages: C, C++, JAVA, SQL, PL/SQL, XML, UNIX

Testing Tools: Quality Center, QTP

PROFESSIONAL EXPERIENCE

Confidential, Miami, Florida

Informatica Developer

Responsibilities:

• I was involved in extracting teh data from teh stage, which is coming from SQL database and created mappings to load teh data from staging area tables into star.
• Responsible for developing extraction/transformation/load (ETL) software, using Informatica.
• Worked on TYPE I and TYPE II mappings (Slowly changing dimensions).
• Worked on incremental loading for all dimensions after initial load from stage to Data Mart (Star schema).
• Created reusable mapplet transformations to load data from operational data source to Data Warehouse.
• Implemented Aggregate, Expression, Filter, Join, Lookup and Rank transformations.
• Analyzed teh session, event and error logs for trouble shooting mapping sessions.
• Experience in creation, backup, restoring and performance tuning of Repository.
• Created sequential batches to run batch sessions one after teh other and concurrent batches to start all teh sessions in teh batch at once.
• Involved in migrating teh ETL application from development environment to testingenvironment.
• Performance tuning by identifyingbottlenecksand applyingsystem optimization.
• Analyzed teh session, event and error logs for trouble shooting mapping sessions.
• Created test cases for carrying out unit testing and part of functional testing.
• Responsible for documentation, version controlling of schema and version releasing.
• Worked wif SQL Override in teh Source Qualifier and Lookup transformations.

Environment: Informatica Power Center 9.5,Oracle 10G, SQL Server 2008 R2, Flat Files,SQL Developer and Windows 7.

Confidential, Sunnyvale, CA

Informatica Developer

Responsibilities:

• Extracted data from multiple sources, which included relational sources, Flat-Files.
• Used various Informatica Transformations like Expressions, Filters, Joiners, Aggregators, Routers and Lookups to load better and consistent data.
• Developed maps that include Slowly Changing Dimensions Type III.
• Developed mapping using parameters and variables.
• Created reusable/non reusable Session and used them by changing session attributes
• Extensively used Email task for success, failure or abort job notification to client.
• Effectively used decision and timer task to assure teh successful execution of teh workflow.
• Identified bottlenecks using various methods and resolved teh performance issues of teh Informatica Mappings and Sessions
• Created test cases for carrying out unit testing and part of functional testing.
• Analyzed teh log files and applied teh system optimization
• Worked wif Informatica Debugger to debug teh mappings in Designer.

Environment: Informatica Power Center 9.1,Oracle 10G, Flat Files, Windows7.

Confidential, Denver

Informatica Developer

Responsibilities:

• Used Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database.
• Worked on theIdentify Management System by extracting teh data from teh 3 different third party (Sales Vision, SDFC, Sales Connect) systems to identifying teh non-duplicate master copy.
• Created mappings using Designer and extracted data from various sources, transformed data according to teh requirement.
• Involved in extracting teh data from teh Flat Files and Relational databases into staging area.
• Mappings, Sessions, Workflows from Development to Test and tan to UAT environment.
• Developed Informatica Mappings and Reusable Transformations to facilitate timely Loading of Data of a star schema.
• Developed teh Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator to create robust mappings in teh Informatica Power Center Designer.
• Imported various heterogeneous files using Informatica Power Center 8.x Source Analyzer.
• Developed several reusable transformations and mapplets that were used in other mappings.
• Involved in Unit Testing and Resolution of various Bottlenecks came across.
• Implemented various Performance Tuning techniques.

Environment: Informatica Power Center 8.6, Oracle 10G, Flat Files, Windows7.

Confidential, Denver

Informatica Systems Analyst/Developer

Responsibilities:

• Involved in requirement gathering,preparing teh design document as per teh requirement
• Developed a standard ETL framework to enable teh reusability of similar logic across teh board
• Developed common routine mappings. Made use of mapping variables, mapping parameters and variable functions.
• Worked on XML sources, XML source qualifier.
• Developed Mapplets, reusable transformations, source and target definitions and mappings using Informatica.
• Involved in teh performance tuning of mappings in Informatica.
• Created technical design document.
• Scripts to archive teh files and delete teh file older than teh specific time.
• Closely in touch wif teh admin team to create teh process, and get teh permissions.
• Created unit test cases and executed.
• Worked wif Informatica Debugger to debug teh mappings in Designer.
• Worked closely wif testing team to implementing teh changes in teh code for fixing teh bugs.
• Set upon Success and on Failure emails to send reports to teh team.
• Worked wif Variables and Parameters in teh mappings to pass teh values between sessions.
• Analyze and troubleshoot problems and make recommendations for remediation.

Environment: Informatica Power Center 8.6, Oracle 10G, Flat Files, WindowsXP.

Confidential, San Antonio, TX

Informatica Systems Analyst/Developer

Responsibilities:

• Created mappings and sessions to implement technical enhancements for data warehouse by extracting data from sources like Oracle and Delimited Flat files.
• Development of ETL using Informatica 8.6 to load data from PeopleSoft System.
• Applied slowly changing dimensions like Type 1 and 2 effectively to handle teh delta Loads.
• Worked wif PMCMD to interact wif Informatica Server.
• Designed Complex mappings for slowly changing Dimensions Type 2, Used Lookup (connected and unconnected), Update strategy and filter transformations for loading historical data.
• Responsible for migration of Informatica mappings, workflows between different environments.
• Developed robust Informatica mappings and fine-tuned them to process millions of input records wif estimated throughput.
• Responsible for monitoring scheduled, running completed and failed sessions. Involved in debugging teh failed mappings and developing error-handling methods.
• Extracted data from Oracle, SQL Server, Flat files.
• Responsible for four types of performance tuning Mapping Level, Session Level, source Level, and target level.
• Coordinate wif teh reporting team in modifying teh existing Informatica ETL code as per teh new business requirements.

Environment: Informatica Power Center 8.6, Oracle 10G, Flat Files, WindowsXP.

Confidential, Richardson, Texas

Informatica Developer

Responsibilities:

• Created Source and Target Definitions in teh repository using Informatica Source Analyzer, Target Designer, Transformation Developer and Mapping Designer.
• Developed several complex Informatica mappings using transformations like Lookup, Router, Update Strategy, Aggregator, Filter, Joiner, and Sorter to in corporate business rules in transformation.
• Involved in Error Handling through user defined tables ETL layer to data warehouse Layer.
• Performance tuned teh mappings by optimizing teh Transformations, Informatica functions, filtering source data at teh source qualifier.
• Created mappings and sessions to implement technical enhancements for data warehouse by extracting data from sources like Oracle and Delimited Flat files.
• Worked wif PMCMD to interact wif Informatica Server.
• Designed Complex mappings for slowly changing Dimensions Type 2, Used Lookup (connected and unconnected), Update strategy and filter transformations for loading historical data.
• Responsible for monitoring scheduled runningcompleted and failed sessions. Involved in debugging teh failed mappings and developing error-handling methods.
• Extracted data from Oracle, SQL Server, Flat files, and DB2 source systems.
• Involved in Unit testing and Integration Testing of teh developed code.

Environment: Informatica Power Center 8.6, Oracle 10G, Flat Files, Windows XP.