SUMMARY:

• 7+ years of IT professional experience in designing, analysis, programming and testing using Informatica Power Center 9.x/8.x/7.x/6.x.
• Extensive experience in design, development and implementation of Data marts, Enterprise Data Warehouses and Business Intelligence Solutions.
• Extensive experience in Developing Informatica complex mappings/ Mapplets using various Transformations for Extraction, Transformation and Loading of data from multiple sources of data warehouses and creating workflows with work lets & tasks and scheduling using workflow manager.
• Extensive experience in Insurance, Financial and Healthcare domains.
• Extensive experience of gathering requirement, Proof of concept, gap analysis, design, development, and Implementation of the ETL/Data warehouse projects.
• Intelligent Gathering of Business requirements to map legacy and other sources to integrate into the Warehouse.
• Expertise with ETL processes utilizing Informatica PowerCenter 9.1/8.6/8.1to design data conversions from a variety of relational, XML and flat file source systems to data marts/EDW.
• Experience with data analysis and Dimensional Data Modeling (specific to a data warehouse / Business Intelligence environment), Star schema/Snowflake schema, fact and dimension tables.
• Responsible for all activities related to the development, implementation, administration and support of ETL processes for large - scale data warehouses using Power Center and Power Mart.
• Expertise in tuning mappings, identifying and resolving performance bottlenecks at various levels like sources, targets, mappings, and sessions.
• Experience in designing and developing efficient Error handling methods for ETL mappings and workflows.
• Strong hands on experience using Teradata utilities (SQL, BTEQ Fast Load, MultiLoad, FastExport, TPump, Visual Explain, Queryman, WinDDI, AMpUsage reports)
• Extensive experience in UNIX programming and shell scripting for Informatica pre & post session operations and database administration activities.
• Ability to communicate design solutions to both technical and non-technical audience.
• Experience in full life cycle development and implementation.
• Good understanding of overall data warehouse design principles and best practices.
• Good Team Player with excellent communication, analytical, and documentation skills.
• Experience in preparing documentation for data requirements and on performing data modeling.
• Hands on experience in tuning mappings, identify and resolve performance bottlenecks in various levels like source, target, mappings and session.
• Hands on experience in scheduling jobs through Control-M / WLM (Workload Manager) Jobs.
• Very good exposure to Oracle 10g, 9i, 8.x, Teradata databases
• Hands on experience working in UNIX and Windows environments.
• Experience on Business Requirements Analysis, Application Design, Development, testing, implementation and maintenance of client/server Data Warehouse and Data Mart systems in the Industrial, Insurance, Pharmaceutical industries
• Excellent Verbal and Written Communication Skills. Have proven to be highly effective in interfacing across business and technical groups.

TECHNICAL SKILLS:

ETL Tools: Teradata, Informatica Power Center 9.x/8.x/7.x/6.2

Databases: Oracle 11x/10g/9i and Teradata.

Programming Skills: SQL

Scripting Languages: UNIX Shell Scripting

Operating Systems: UNIX (Sun Solaris 2.x, HP/UX) and Windows NT/ 8/7/2003/2000/98.

Utilities: BTEQ, Fast load and Multi Load.

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Informatica Consultant

Responsibilities:

• Worked on Informatica Power Center 9.5 tools - Source Analyzer, Target designer, Mapping Designer, Mappings & Transformations
• Created several mappings using various active and passive transformations like Source Qualifier, Lookup, Router, Aggregator, Filter, Joiner and Expression.
• Developed Conceptual Business Model, Logical Data Model, Physical Data Model and Star-Schema design.
• Researched operational data store (ODS) and Legacy systems to find qualified source data.
• Coordinated with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema design (Star Schema) and maintenance.
• Defined, designed, configured, and implemented a suitable architecture for data integration from multiple, disparate data sources (including legacy systems, relational databases, flat files, message queues, spreadsheets) to Oracle 10g environment.
• Better alignment of CP to Income Statement
• Allocation of non-client/overhead activity down to the project/activity/client level.
• High level view that can be used in the future for “global” CP consolidations and reporting.
• Worked on Informatica Power Center 9.5 tools - Source Analyzer, Target designer, Mapping Designer, Mappings & Transformations.
• Designed and developed transformation rules (business rules) to generate consolidated (fact/summary) data using Informatica ETL (Power center) tool.
• Checked Sessions and error logs to troubleshoot problems and also used debugger for complex Problem troubleshooting.
• Identified and fixed bottlenecks and tuned the complex Informatica mappings for better Performance.
• Performed extensive debugging and performance tuning of mappings, sessions and workflows including

Environment: Informatica 9.5.0/9.0.1 , IBM DB2, SQL, PL/SQL, TSRM, WLM, UNIX, Windows XP.

Confidential, Richmond, VA

Informatica Consultant

Responsibilities:

• Analyzed, designed, developed, implemented and maintained moderate to complex initial load and incremental Informatica mappings and workflows to provide data for Data Warehouse.
• Created several mappings using various active and passive transformations like Source Qualifier, Lookup, Router, Aggregator, Filter, Joiner and Expression.
• Identified and fixed bottlenecks and tuned the complex Informatica mappings for better Performance.
• Developed Conceptual Business Model, Logical Data Model, Physical Data Model and Star-Schema design.
• Researched operational data store (ODS) and Legacy systems to find qualified source data.
• Coordinated with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema design (Star Schema) and maintenance.
• Defined, designed, configured, and implemented a suitable architecture for data integration from multiple, disparate data sources (including legacy systems, relational databases, flat files, message queues, spreadsheets) to Oracle 10g environment.
• Worked on Informatica Power Center 9.5 tools - Source Analyzer, Target designer, Mapping Designer, Mappings & Transformations.
• Designed and developed transformation rules (business rules) to generate consolidated (fact/summary) data using Informatica ETL (Power center) tool.
• Checked Sessions and error logs to troubleshoot problems and also used debugger for complex Problem troubleshooting.
• Identified and fixed bottlenecks and tuned the complex Informatica mappings for better Performance.
• Performed extensive debugging and performance tuning of mappings, sessions and workflows including
• Developed, tested and implemented break/fix change tickets for maintenance and enhancement of Operational Data Store.

Environment: Informatica 9.5.0/9.0.1 , Teradata 14.10, SQL, PL/SQL, TSRM, WLM, UNIX, Windows XP.

Confidential, Pleasanton, CA

ETL / Informatica Developer

Responsibilities:

• Based on the business requirements created High level and low level Design Documents.
• Coordinated with team and Performed code review.
• Interacted with Data modular and DBA and Source systems and resolved the Issues.
• Created Source definitions from SQL Server, Flat Files, Oracle, Teradata, and Mainframe COBOL Sources.
• Created mappings involving various transformations like joiner, aggregator, lookup, sequence generator, stored procedure, update strategy, filter and router transformations to implement business logic.
• Imported/Created Target definitions and created Reusable Transformations, mapplets in Shared folder.
• Involved in creating Informatica mapping to populate staging tables and data warehouse tables from Mainframe sources.
• Performed dimensional and 3NF modeling according to enterprise standards.
• Extensively involved in writing ETL Specs for Development and conversion projects.
• Created shortcuts for source and target and also created Reusable Transformations, mapplets in Shared folder.
• Creating sessions, work lets and workflows for carrying out test loads.
• Extensively created BTEQ scripts to implement post load processes.
• Extensively created MLOAD, FLOAD and TPUMP control files to load data in to EDW tables.
• Designed and developed transformation rules (business rules) to generate consolidated (fact/summary) data using Informatica ETL (Power center) tool.
• Checked Sessions and error logs to troubleshoot problems and also used debugger for complex Problem troubleshooting.
• Extensively used sequence generator for key generation in the data warehouse.
• Identified and fixed bottlenecks and tuned the complex Informatica mappings for better Performance.
• Worked on Parameterize of all variables, connections at all levels in UNIX.
• Automation of job processing, establish automatic email notification to the concerned persons.
• Coordinated with testing team in all three phases of testing including end-to-end testing.

Environment: InformaticaPower Center 8.1, Teradata 13, windows 2000, Teradata SQL, UNIX, Microsoft Excel.

Confidential, SFO, CA

ETL Informatica Developer

Responsibilities:

• Extensively used Informatica power center for extraction, transformation and loading process.
• Designed and developed Star Schema, Snowflake Schema and created Fact Tables and Dimension Tables for the Warehouse and Data Marts and Business Intelligence Applications.
• Used Informatica Repository Manager to create Repositories and Users and to give permissions to users.
• Used Informatica Designer to create mappings using different transformations to move data from source to a Data Warehouse.
• Designed and Developed mappings in Informatica using different transformations like Source Qualifier, Expression, Lookup, Aggregator, and Router, Rank, Filter and Sequence Generator transformations.
• Created Update Strategy and Stored Procedure transformations to populate targets based on business requirements.
• Created and Configured Workflows, Worklets and Sessions to transport the data to target warehouse tables using Informatica Workflow Manager.
• Created SCD type 2 mappings using lookup, Expression, Update Strategy and Router Transformations.
• Scheduled the sessions to extract, transform and load data into warehouse database as per Business requirements. Improved the session performance by pipeline partitioning.
• Optimized the performance of the mappings by various tests on sources, targets and transformations. Developed Procedures and Functions in PL/SQL for Data ETL.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.

Environment: Informatica Power Center 7.x, windows 2000, Teradata SQL, UNIX, Microsoft Excel.

Confidential

Informatica ETL Developer

Responsibilities:

• Interacted with business analysts, data architects, application developers to develop a data model.
• Designed and developed complex aggregate, join, look up transformation rules (business rules) to generate consolidated (fact/summary) data identified by dimensions using Informatica Power Center 6.x/7.0 tool.
• Created sessions, database connections and batches using Informatica Server Manager/Work flow Manager.
• Optimized mappings, sessions/tasks, source, and target databases as part of the performance tuning.
• Design of ETL Mappings and Workflows using powercenter designer and workflow manager.
• Involved in the extraction, transformation and loading of data from source flat files and RDBMS tables to target tables.
• Developed various Mappings, Mapplets, and Transformations for data marts and Data warehouse.
• Used Shell Scripting to automate the loading process.
• Used Pipeline Partitioning feature in the sessions to reduce the load time.
• Analyzed and Created Facts and Dimension Tables.
• Used Informatica features to implement Type I, II, and III changes in slowly changing dimension tables.
• Used command line program pmcmd to communicate with the server to start and stop sessions and batches, to stop the Informatica server and recover the sessions.
• Designed processes to extract, transform, and load data to the Data Mart.
• Performed impact analysis, remedial actions and documented on process, application failures related with Informatica ETL and Power Analyzer.
• Performed regular backup of data warehouse, backup of various production, development repositories including automating and scheduling processes. As part of optimization process, performed design changes in Informatica mappings, transformations, sessions.

Environment: Informatica Power Center 6.x, ETL, Oracle 8i, MS Access, SQL, PL/SQL, Windows NT.