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 the business requirement to technical requirement document,developing, reviewing and testing the 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 the 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 the data from the stage, which is coming from SQL database and created mappings to load the 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 the 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 the other and concurrent batches to start all the sessions in the batch at once.
• Involved in migrating the ETL application from development environment to testingenvironment.
• Performance tuning by identifyingbottlenecksand applyingsystem optimization.
• Analyzed the 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 the 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 dat 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.
• TEMPEffectively used decision and timer task to assure the successful execution of the workflow.
• Identified bottlenecks using various methods and resolved the performance issues of the Informatica Mappings and Sessions
• Created test cases for carrying out unit testing and part of functional testing.
• Analyzed the log files and applied the system optimization
• Worked wif Informatica Debugger to debug the 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 the data from the 3 different third party (Sales Vision, SDFC, Sales Connect) systems to identifying the non-duplicate master copy.
• Created mappings using Designer and extracted data from various sources, transformed data according to the requirement.
• Involved in extracting the data from the 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 the 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 the Informatica Power Center Designer.
• Imported various heterogeneous files using Informatica Power Center 8.x Source Analyzer.
• Developed several reusable transformations and mapplets dat 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 the design document as per the requirement
• Developed a standard ETL framework to enable the reusability of similar logic across the 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 the performance tuning of mappings in Informatica.
• Created technical design document.
• Scripts to archive the files and delete the file older TEMPthan the specific time.
• Closely in touch wif the admin team to create the process, and get the permissions.
• Created unit test cases and executed.
• Worked wif Informatica Debugger to debug the mappings in Designer.
• Worked closely wif testing team to implementing the changes in the code for fixing the bugs.
• Set upon Success and on Failure emails to send reports to the team.
• Worked wif Variables and Parameters in the mappings to pass the 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 TEMPeffectively to handle the 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 the 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 the reporting team in modifying the existing Informatica ETL code as per the 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 the 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 the mappings by optimizing the Transformations, Informatica functions, filtering source data at the 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 the 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 the developed code.

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