Professional Summary:

• Over 8 years of experience in Information Systems with strong background in SDLC, Data Warehousing and Data base Development. Seven plus years of experience in ETL using Informatica Power Center 9.x/8.x/7.x.
• Good exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, Documentation, Production Support.
• Good understanding in Logical, Physical and Dimensional data modeling Star Schemas and Snow Flake Schemas .
• Extensively worked on Informatica Power Center Components Power Center Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Extensively worked on Informatica Designer Components Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer and Mapplet Designer.
• Extensively worked on 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 different Informatica Performance Tuning issues like Source, Target, Mapping, Transformation, session to make them more efficient in terms of session performance.
• Extensive Database experience using Oracle 11g/10g/9i/8i, Teradata, DB2, MS SQL Server, Sybase, MS Access, SAP. Worked on various Source files like flat files, XML files, COBOL files, CSV files.
• Expertise in SQL/PLSQL programming development and execution of Stored Procedures, Functions and Packages. Experience in Loader utilities including SQL Loader and Teradata Tpump, Fast Load, Multiload.
• Good understanding knowledge on Teradata Utilities.
• Excellent working knowledge of UNIX shell scripts and scheduling of jobs by using tools like Control M, Autosys and Good Exposure in Business Intelligence tools like Business Objects, Cognos.
• Maintained outstanding relationship with Business Analysts and Business Users to gather information needs as per the business requirement. Experience in working with offshore and onsite co-ordination.
• Critical thinker who is self-starter and willing to take initiative and work with little or no supervision.
• Systematic, disciplined and has an analytical and logical approach in problem solving. Ability to work in tight Schedules and efficient in time management
• Excellent Written, Communications and Analytical skills with ability to perform independently as well as in a team.

Skill Set:

Informatica Power Center 9.x/8.x/7.x/6.x, ETL, Data mart, OLAP, OLTP, Erwin 4.5/4.0, MS Visio, ER Diagrams, Oracle 11g/10g/9i/8i, Oracle SQL PL/SQL, SQL Plus, TOAD, SQL Navigator, SQL Developer, SQL Loader, MS SQL Server 2005/2008, IBM DB2 UDB 8.0/7.0, Sybase, Teradata, MS Access 7.0/97/2000, Control M, CA Autosys, Unix, Unix Crontab, Windows XP, Windows 2000/NT.

Project Summary:

Confidential

ETL/ Informatica developer

The objective of the project was to design and develop sales Datamart to provide data analysis for sales, Claims Adjudication and Product information. The ETL Process involved extraction and migration of the data from SQL server and Flat files, implementing the business logic and populating the data into the target datamart Oracle .

Hardware/Software: Informatica Power Center 9.5, Cognos, Oracle 10g/11g, MS Access, MS SQL Server 2008, MySQL Database, IBM DB2, Teradata V2R5, SQL, PL/SQL, SQL Plus, TOAD, Oracle Applications 11i, Erwin, Unix, Windows XP

Responsibilities:

• Extensively used Informatica Client tools - PowerCenter Designer, Workflow Manager, Workflow Monitor and Repository Manager
• Extracted data from various heterogeneous sources like Oracle, SQL Server, Flat Files, Teradata
• Developed complex mapping using Informatica PowerCenter tool and configured Informatica with DAC.
• Extracting data from Oracle and Flat file, Excel files and performed complex joiner, Expression, Aggregate, Lookup, Stored procedure, Filter, Router transformations and Update strategy transformations to load data into the target systems.
• Created Sessions, Tasks, Workflows and worklets using Workflow manager.
• Worked with Data modeler in developing STAR Schemas
• Involved in performance tuning and query optimization.
• Experience in converting SAS scripts to Informatica.
• Good understanding on SAS functions.
• Used TOAD, SQL Developer to develop and debug procedures and packages.
• Involved in developing the Deployment groups for deploying the code between various environment Dev, QA .
• Experience developing and supporting complex DW transformations
• Excellent understanding of Star Schema Data Models Type 1 and Type 2 Dimensions.
• Created pre sql and post sql scripts which need to be run at Informatica level.
• Worked extensively with session parameters, Mapping Parameters, Mapping Variables and Parameter files for Incremental Loading
• Used Debugger to fix the defects/ errors and data issues.
• Expertise in using both connected and unconnected Lookup Transformations.
• Extensively worked with various Lookup caches like Static cache, Dynamic cache and Persistent cache.
• Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD
• Monitored and improved query performance by creating views, indexes, hints and sub queries
• Extensively involved in enhancing and managing Unix Shell Scripts.
• Developed workflow dependency in Informatica using Event Wait Task, Command Wait.

Confidential

Informatica/ETL Developer

Confidential protect individuals and families from financial risks that can affect their investments, retirement savings, and businesses. Pacific Life provides a wide range of insurance products, annuities, and mutual funds, and offers a variety of investment products and services to individuals, businesses, and pension plans.The primary Objective of project is to build the data warehouse framework with existing General Ledger , Non-Financial Policy Info and ACP to provide data to complete analysis of ACP and its validity as a Key Performance Indicator KPI , provide better transparency and access for analytical numbers . The data used to come in as flat files, relational sources and is loaded into target database using Informatica. Various summary reports were generated using Cognos to cater to the needs of top management, as well as the detail reports for the low level management.

Hardware/Software: Informatica Power Center 9.1/8.6, Cognos, Oracle 11g, MS SQL Server 2008, SQL PL/SQL, SQL Plus, TOAD, Oracle Applications 11i ,Erwin, Unix, ,Sun Solaris, Windows XP.

Responsibilities:

• Extracted data from various sources Flat files and Oracle database files .
• Designed and developed Informatica Mappings and sessions based on business user requirements and business rules.
• Co-ordinated with Bussiness users and functional consultants to make sure if the data transformed was according to the business rules.
• Moved objects across the Respositories from DEV to QA.
• Scheduled jobs in background using shell scripts and parameter files.
• Co-ordinated with DBA Team, Functional Team and offshore teams.
• Worked extensively on Source Analyzer, Mapping Designer, and Warehouse Designer.
• Developed several Mappings and Mapplets using corresponding Sources, Targets and Transformations
• Creating source and target table definitions using Informatica Designer. Source data was extracted from Oracle, flat files, COBOL sources and XML sources
• Analyzing the source data and deciding on appropriate extraction, transformation and loading strategy.
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• Extensively developed informatica mappings tuned them for better performance.
• Extensively used connected and unconnected lookup transformations.
• Coordinated with source system owners, monitored day-to-day ETL progress, performed Data warehouse target schema Design Star Schema and maintenance.
• Identified key dimensions and facts for analytical reporting and decisions support reporting to develop custom reports in Cognos.

Confidential

ETL/ Informatica developer

Confidential high number of validations and required Product and Marketing Attributes is cumbersome and not conducive to collecting large volumes of data quickly. There are too many steps in the current process flow to get an item set up with the marketing data associated to be available for purchase online. PCM core and marketing data will be collected through the Informatica tool that will validate the data and will map it to the existing PCM DB2 tables.

Hardware/Software: Informatica Power Center 8.6, ControlM ,Cognos, Oracle 10g/11g, MS Access, MS SQL Server 2008, Sybase, IBM DB2, Teradata V2R5, SQL PL/SQL, SQL Plus, TOAD, Oracle Applications 11i ,Erwin, Unix, ,Sun Solaris, Windows XP

Responsibilities:

• Involved in requirement analysis, ETL design and development for extracting data from the heterogeneous source systems like MS SQL Server, Oracle, Oracle Hyperion Planning System, flat files, XML files and loading into Staging and PCM DB2 tables.
• Used utilities of Teradata to process data like Teradata Tpump, Fast Load, Multiload
• Involved in massive data cleansing prior to data staging.
• Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
• Design and Development of ETL Mappings, Using Informatica Mapping Designer within the Informatica Power Center, Usage of Lookups, Joiner, Expression ,Aggregator, XML, Rank, Mapplet, connected and unconnected stored procedures, Lookups, SQL Overrides usage in Lookups, Source filter and SQL Override usage in Source Qualifiers and data flow management into multiple targets using Routers were extensively done.
• Invoked and Executed Stored Procedures to transform the Data and worked extensively with PL/SQL for various needs of the transformations while loading the data into DB2 Database. Converted MS SQL Server DTS and SSIS Packages logic into Informatica Mappings.
• Created Mappings with shared objects/Reusable Transformations/Mapplet using Mapping/Mapplet Parameters/Variables.
• Created Workflow, Worklets and Tasks to schedule the loads at required frequency using Workflow Manager.
• Configured workflows with Email Task, which would send mail with session log file for Failure of a sessions and for Target Failed Rows.
• Extensively used pmcmd commands on command prompt and executed Unix Shell scripts to automate workflows and to populate parameter files.
• Worked with UNIX shell scripts for job execution and automation. Scheduled Informatica workflows using ControlM to run at regular intervals.
• Documented ETL Design Documents for entire ETL processes.

Confidential

ETL/ Informatica Developer

Confidential Global Investment Bank which provides financing and risk management services to large companies, institutions and government clients. The project was to design, develop and maintain a data warehouse and data marts Customer and Purchasing Data Marts to understand the client needs, undertake trend analysis, provide better customer service and assess current and future profitability, to increase revenue generation from the most profitable customers.

Hardware/Software: Informatica Power Center 8.5, Teradata, Oracle 10g/9i, SQL Server 2005 /SQL Server 2008, Ms-Visio, IBM DB2, Windows 2000/NT, Business Objects 6.5, Autosys, Windows XP, UNIX.

Responsibilities:

• Prepared low level mapping specs based on the process flow given by data modelers. Participated in peer reviews to validate the mapping specs
• Created mappings to project Interest payment, Principal repayment, Interest income and lease rentals on Liabilities and Assets. Created separate operational data marts for financial transactions done regularly basis.
• Created Mappings to load extracted data into staging tables. Used XML Source Qualifier transformations to extract data from XML sources.
• Developed Mappings to transform the data according to the business rules and integrated with other sources like ODS, legacy marts, before loading into target tables
• Used various transformations like Source Qualifier, Expression, Sorter, Lookup, Stored Procedure, Update Strategy, Router, Filter, Sequence Generator and Joiner on the extracted source data according to the business rules and technical specs to load data into Data Marts.
• Used utilities of Teradata to process data like Teradata Tpump, Fast Load, and Multiload.
• Optimized the mappings using various optimization techniques and also debugged some existing mappings using the Debugger to test and fix the mappings.
• Written SQL Queries for SQL Overrides and Executed Stored Procedures/Functions/Packages on different databases Oracle, MS SQL Server, IBM DB2 for Extractions and Updates
• Created Parameter files to use in Workflows and Sessions for passing parameter values into Mappings to meet the frequently changing business requirements.
• Responsible for identifying and removing bottle necks, fine-tuning of Mappings, Sessions and SQL Queries to improve performance. Involved in Root cause Analysis.
• Administrated Workflow Manager to run Tasks Workflows. Involved in performance monitoring.
• Involved in Scheduling of the ETL jobs daily, Weekly and monthly based on the business requirements. Worked on Autosys for scheduling of the jobs by using UNIX shell script.
• Involved in creating the Business Object's Universe, queries and reports for Customer Service and good CRM.

Confidential

ETL Informatica Developer

Confidential is the world's second largest banking and financial group. The Purpose of the project was to maintain the Accounts and Transactions History. Transactional data was populated into Operational data Store ODS with data feeds from legacy source systems, transformed using business rules and then populated into the Data warehouse. Based on this data, numerous data marts are designed and developed using Informatica Power Center.

Hardware/Software: Informatica 7, Power center, ORACLE 9i, TOAD, PL/SQL Developer, XML, DB2, Micro strategy, SQL Server 2000, UNIX, Business Objects 5, Windows XP

Responsibilities:

• Involved with all the phases of the life cycle starting from gathering requirements for designing DS systems, data modeling involving in the design of the logical and physical databases, Data warehouse design with decision support in mind and development.
• Involved in designing the Dimensional Data Model of the Data warehouse by using Erwin 4.1 to identify the business process, grain of the data representation, dimensions and fact tables with measured facts.
• Extensively used transformations like Source Qualifier, Lookup, Expression, Aggregator, Joiner, Router, Normalizer, Filter, Sequence generator, Expression, Sorter, and Update Strategy to create Mappings.
• Used Source Analyzer and Warehouse Designer to import the source and target database schemas and used mapping designer to map the source to the target.
• Transformation Developer, Workflow Manager and Monitor
• Extensively used Informatica client tools like Source Analyzer, Warehouse designer, Mapping designer,
• Identified all the confirmed dimensions to be included in the target warehouse design and confirmed the granularity of the facts in the fact tables.
• Mapplets and Reusable Transformations have been part of the mappings since different data types conversions have to be dealt multiple times which are similar and also most of the lookups have been similar.
• Wrote Informatica ETL design documents, established ETL coding standards, developed Informatica mappings and perform reviews of the same.
• Created reusable email tasks in workflows to send post session and suspension emails as per user requirements.
• Created and maintained folders in the repository manager to logically organize all the metadata in the repository including mappings, schemas and sessions.