Professional Summary:

• Over 7 years of IT experience and extensive ETL tool experience using Informatica Power Center 9.x/8.x with strong working experience in Oracle SQL, PL/SQL.
• Responsible for all phases of the System Development Life Cycle SDLC , from Requirement gathering , Analysis, Design, Development, Production in various industries viz., Insurance, Telecom, Banking.
• Strong understanding of the principles of DWH using Fact Tables, Dimension Tables and Star Schema models.
• Proficient in the Integration of various data sources like Oracle10g/9i,Flat Files into the staging area, Data Warehouse, Data Mart and SalesForce
• Extensively worked with Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator and XML Source Qualifier
• Expertise in developing Mappings and Mapplets, Sessions, Workflows, Worklets and Tasks using Informatica Designer, Workflow Manager and Batch processes using PMCMD command.
• Expertise in unit testing of Informatica mappings using debugger.
• Experience in Performance Tuning and Debugging of existing ETL processes.
• Excellent communication skills, good organizational skills, self-motivated and extremely hardworking with ability to implement business concepts quickly and efficiently.
• Excellent communicator with exceptional team-building skills.

Summary of Qualifications:

Projects Summary:

Confidential

Role: ETL / Informatica Onshore Lead

Hardware/Software:

Informatica Power Center 9.1 Repository Manager, Designer, Workflow Manager, Workflow Monitor, Repository Administration Console , Netezza, Toad 10.6, UNIX, Autosys scheduling

Responsibilities:

• Involved from initial stage of requirement gathering, to understand the Business Requirements and Business Rules Subjected to Business.
• Prepared ETL Specifications to help develop mapping.
• Worked with Power Center Designer tools in developing mappings and Mapplets to extract and load the data from flat files, Oracle into Oracle database.
• Implemented code using various Informatica Transformations like Aggregator, Expression, Filter, Sequence Generator, Update Strategy, Source qualifier,Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
• Developed SQL overrides in Source Qualifier/Lookup according to business requirements.
• Developed mappings/Reusable Objects/mapplets by using mapping designer, transformation developer and mapplet designer , since different datatype conversions have to be dealt multiple times which are similar and also most of the lookups have been similar
• Worked with different caches in optimizing the transformations such as Index cache, Data cache and Lookup cache Static, Dynamic, Persistence and Shared .
• Used Informatica Power Center Workflow manager to create sessions, batches to run the mappings.
• Implemented different Tasks in workflows which included Session, Command, E-mail, Event-Wait etc.
• Involved in Performance Tuning of SQL Queries, Sources, Targets and sessions by identifying and rectifying performance bottlenecks.
• Created pre-session and post session scripts using UNIX/PL-SQL.
• Tuned the Sources, Targets, Transformations and Mapping to remove bottlenecks for better performance.
• Migrated mappings, sessions, and workflows from development to testing and then to Production environments
• Created deployment groups, migrated the code into different environments.
• Worked closely with reporting team to generate various reports

Confidential

Role: ETL / Informatica Developer

Hardware/Software:

Informatica Power Center 8.6 Repository Manager, Designer, Workflow Manager, Workflow Monitor, Repository Administration Console , Oracle 10g, Toad 9.5, Delimited Flat Files, UNIX Shell Programming

Responsibilities:

• Interacted with Business Analysts to understand the requirements.
• Prepared HighLevel Design documents according to the Functional Specification document to help in development.
• Maintained Technical specification documents according to the Source to Target mapping documents.
• Prepared ETL Specifications to help in developing mappings.
• Used Informatica PowerCenter 9.1 for extraction, loading and transformation ETL of data into the target systems.
• Worked on Informatica Power Center tools like Source Analyzer, Target Designer, Mapping Designer, Workflow Manager, and Workflow Monitor.
• Created mappings in PowerCenter Designer using Aggregator, Expression, Filter, Sequence Generator, Update Strategy, Union, Lookup, Joiner, Source Qualifier and Stored procedure transformations.
• Developed Informatica workflows and sessions associated with the mappings using Workflow Manager.
• Tuned the Sources, Targets, Transformations and Mapping to remove bottlenecks for better performance.
• Have monitored the jobs in QA environment for shakeout purpose.
• Migrated mappings, sessions, and workflows from development to testing then to Prod environments
• Documented the process for further maintenance and support
• Worked on a module for integrating informatica with SalesForce
• Developed Reusable components in Informatica which helps for other projects to use the reusable components for with overriding properties
• Automated the process to monitor the source and target count difference on daily basis

Confidential

Informatica Developer.

Hardware/Software:

Informatica Power Center 8.1, oracle 9i, Unix Shell scripts

Responsibilities:

• Data Analyzing and Data Profiling of the source data.
• Interacted with business analysts, data architects, application developers to develop a data model.
• Upgrade of Data warehouse tools Informatica
• ETL development and automation of complete process.
• Understanding Business needs and implementing the same into a functional database design.
• Optimizing the mappings by changing the logic to reduce run time.
• Designing and Implementing the Data mart access methods on different tools and Data mart.
• Documented the process for further maintenance and support.
• Migrated mappings, sessions, and workflows from development to testing then to Production environments
• Contributed to development effort and served as key technical resource.
• Worked closely with reporting team to generate various reports.