Summary of Qualifications:

• Over Eight 8 years of experience in IT industry with 7 years of core expertise in Analysis, Design, Development, Implementation, Modeling, Testing, and Support for Data Warehouse applications.
• Strong DWH ETL experience in Informatica Power Center 9.X/8.X/7.x/6.x development, design, process and best practices experience as ETL Analyst and Developer in US.
• Well acquainted with Informatica client tools Designer Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer , Repository Manager, Workflow Manager and Workflow Monitor.
• Extensive database experience and highly skilled in Oracle.
• Good Knowledge in Relational and Dimensional Modeling techniques like Star, Snowflake Schema, Fact and Dimensional Tables.
• Extensive experience in designing and developing complex Mappings using transformations like Source qualifier, Aggregator, Expression, Connected Unconnected lookup, Filter, Joiner, Sequence generator, Sorter, Router, Normalizer and Update Strategy.
• Extensively worked in developing ETL for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Involved in Migration of SAP BEX Queries to BI 7.0 Queries.
• Experience in ETL performance tuning of sources, transformations, targets, mappings, work lets, workflows, and sessions.
• Optimized the Solution by using the performance tuning methods in the Oracle SQL queries like Indexing techniques, Hints, Partitioning and Parallel execution process.
• Extensively used Debugger in Informatica Designer tool to test the data and fix errors in the mapping.
• Implemented complex business rules in Informatica by creating Reusable transformations to reduce the development time and complexity of mappings.
• SCD Management including Type 1, 2, 3, Hybrid Type 3, De-normalization, Cleansing, Conversion, Aggregation, Performance Optimization etc.
• Expertise in Tuning the DW environment including Oracle SQL query tuning, Database tuning and in Informatica Power center to identify bottlenecks, tune and remove bottlenecks. Query Rewrite, tuning Mappings and Sessions.
• Design Source to Target maps, Code Migration, Version control, scheduling tools, Auditing, shared folders, data movement, naming in accordance with ETL Best Practices, Standards and Procedures.

Technical Competencies:

• Data Warehousing/ ETL: Informatica Power Center 9.5.0/9.1.0/8.6.1/8.6/8.1/7.1.2/7.1.1/7.0
• Databases Tools: Oracle 11g/10g/9i/8i
• Programming Languages: UNIX Shell Scripting, SQL

Environment: UNIX, Win XP

Professional Experience:

Confidential

Informatica Lead /Senior Informatica Developer

Responsibilities:

• Used Informatica Power Center for ETL extraction, transformation and loading data from heterogeneous source systems into target database.
• Created mappings using Designer and extracted data from various sources, transformed data according to the requirement.
• Involved in Migration of SAP BEX Queries to BI 7.0 Queries.
• Involved in extracting the data from the Flat Files and Relational databases into staging area.
• Mappings, Sessions, Workflows from Development to Test and then 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.
• Created Sessions and extracted data from various sources, transformed data according to the requirement and loading into data warehouse.
• 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 Source Analyzer.
• Developed several reusable transformations and Mapplets that were used in other mappings.
• Prepared Technical Design documents and Test cases.
• Involved in Unit Testing and Resolution of various Bottlenecks came across.
• Implemented various Performance Tuning techniques.
• Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used Informatica scheduler to schedule jobs.
• Reviewed and analyzed functional requirements, mapping documents, problem solving and trouble shooting.
• Performed unit testing at various levels of the ETL and actively involved in team Peer reviews.
• Identified problems in existing production data and developed one time scripts to correct them.
• Fixed the invalid mappings and troubleshoot the technical problems of the database.
• Implemented aggregate, filter, join, expression, lookup and update strategy transformations.
• Implemented variables and parameters in transformations for incremental data extraction and complex transformation logic.
• Used mapping and Mapplet designer to generate different mappings for different loads.
• Created transformations like source qualifier, joiner transformation, filter, update strategy, lookup transformation, rank transformations, expressions, aggregator and sequence generator to load the data from staging area to ODS and to DW in oracle.
• Created, scheduled and monitored sessions and batch process based on demand and run only once using Informatica server manager.
• Responsible for requirement gathering by direct interaction with users.
• Used transformation developer, mapping and Mapplet designer to generate various mappings for different loads.

Environment: Informatica9.5.0, 9.1.0, UNIX, Oracle 11g, DB2, Teradata

Confidential

Senior Informatica Developer

Responsibilities:

• Implementation of Informatica Push Down Optimization technology
• Extensively worked on Implementing current project in Agile Methodology
• Using Teradata tools utilities like M load, Fast load, etc.
• Used Debugger within the Mapping Designer to test the data flow between source and target and to troubleshoot the invalid mappings.
• Involved in Performance Tuning of SQL Queries, Sources, Targets and sessions by identifying and rectifying performance bottlenecks.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential, parallel, and initial and Incremental Load.
• Using Unit testing and Integrated testing for various Informatica Mappings
• Getting Business Requirements from Users for Developing Analysis of the system
• Extensively analyzed IBM BDW model their approach in Banking Sector.
• Development of Informatica Guidelines, Naming conventions Development Standards.
• Implementation of Surrogate key assignment using stored Procedures
• Experienced in Handling Very high volumes of data Onsite Offshore Model.
• Extensively used transformations like router, aggregator, lookup, source qualifier, joiner, expression, aggregator and sequence generator transformations in extracting data in compliance with the business logic developed.

Environment: Informatica Power Center 8.6.1,DB2, UNIX,Teradata, Windows XP

Confidential

Informatica Developer

Responsibilities:

• Gathered requirements from business analysts for designing and development of the system
• Developed Transformation logic and designed various complex Mappings in the Designer for data load and data cleansing.
• Assessed data to understand its quality challenges using data profiler
• Created Mappings using Mapping Designer to load the data from various sources, using different transformations like Source Qualifier, Expression, Lookup Connected and Unconnected , Aggregator, Update Strategy, Joiner, Filter, and Sorter transformations.
• Experience with high volume datasets from various sources like Oracle, Flat Files, Sybase, MS SQL Server, and XML.
• Using Informatica Power Center Designer analyzed the source data to Extract Transform from various source systems oracle 11g, SQL server and flat files by incorporating business rules using different objects and functions that the tool supports.
• Implemented Slowly Changing Dimension Type 1 and Type 2 for inserting and updating Target tables for maintaining the history
• Extensively used the capabilities of Power Center such as File List, pmcmd, Target Load Order, Constraint Based Loading, Concurrent Lookup Caches etc.
• Created and Monitored Workflows using Workflow Manager and Workflow Monitor.
• Worked on multiple RDBMS like Oracle to import and integrate source data.
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters.
• Used shortcuts Global/Local to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Used the Workflow manager to create workflows, work lets and sessions
• Used debugger to test the mapping and fixed the bugs.
• Developed Unit Test Cases to ensure successful execution of the data loading processes.
• Documented Informatica mappings, design and validation rules

Environment: Informatica PowerCenter 8.6.1,Oracle 11/10g, Red Hat Linux AS Release 4, Windows XP, Oracle SQL Developer

Confidential

Informatica developer

Responsibilities:

• Involved in the full life cycle development of the project including Analysis, design, development, and testing
• Interacted actively with Business Analysts and Data Modelers on Mapping documents and Design process for various Sources and Targets.
• Worked closely with Business Analyst and the end users in writing the functional specifications based on the business requirement needs
• Prepared high-level design document for extracting data from complex relational database tables, data conversions, transformation and loading into specific formats.
• Involved in Dimensional Modeling using Star schema and Snow Flake schema for faster, effective query processing and Business Analysis Requirements.
• Loaded data from OLTP Tables which are in MS SQL Server to Staging table ORACLE database and Staging table to OLAP Tables ORACLE tables .
• Experience with high volume datasets from various sources like Oracle, Flat Files, MS SQL Server and XML.
• Extensively used transformations like router, aggregator, lookup, source qualifier, joiner, expression, aggregator and sequence generator transformations in extracting data in compliance with the business logic developed.
• Worked with Memory cache for static and dynamic cache for the better throughput of sessions containing Rank, Lookup, Joiner, Sorter and Aggregator transformations.
• Developed SQL overrides in Source Qualifier/Lookup according to business requirements.
• Used SQL tools like TOAD to run SQL queries and validate the data in warehouse.
• Extended logic for some of the existing mappings in the system to meet enhancement procedures.
• Implemented Slowly Changing Dimensions Type II in various mappings.
• Applied partitioning at session level for the mappings which involved loading data to target using target lookup to avoid duplicates records.
• Used Debugger within the Mapping Designer to test the data flow between source and target and to troubleshoot the invalid mappings.
• Involved in Performance Tuning of SQL Queries, Sources, Targets and sessions by identifying and rectifying performance bottlenecks.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential, Parallel, Initial and Incremental Load.
• Worked on different tasks in Workflows like sessions, events raise, event wait, command, Worklets, decision-mail, Assignment, Timer and scheduling of the workflow.
• Developed pre-session and post session scripts using UNIX.
• Performed Unit testing and Integrated testing for the mappings created.
• Used various performance enhancement techniques to enhance the performance of the sessions and workflows.

Environment: Informatica PowerCenter 8.6.0, Sun Solaris 10, Oracle 10g, Windows XP

Confidential

ETL Informatica Developer

Responsibilities:

• Assisted gathering business requirements and worked closely with various Application and Business teams to develop Data Model, ETL procedures to design Data Warehouse.
• Designed and developed star schema model for target database using ERWIN Data modeling.
• Extensively used ETL Informatica tool to extract data stored in MS SQL 2000, Excel, and Flat files and finally loaded into a single Data Warehouse.
• Used various active and passive transformations such as Aggregator, Expression, Sorter, Router, Joiner, connected/unconnected Lookup, and Update Strategy transformations for data control, cleansing, and data movement.
• Designed and developed Mapplets for faster development, standardization and reusability purposes.
• Implemented Slowly Changing Dimension Type 1 and Type 2 for inserting and updating Target tables for maintaining the history.
• Used Debugger to validate transformations by creating break points to analyze, and monitor Data flow.
• Tuned performance of Informatica Session by increasing block size, data cache size, sequence buffer length and Target based commit interval, and mappings by dropping and recreation of indexes.
• Worked along with the QA Team and provided production support by monitoring the processes running daily.
• Involved in pre and post session migration planning for optimizing data load performance.
• Interfaced with the Portfolio Management and Global Asset Management Groups to define reporting requirements and project plan for intranet applications for Fixed Income and Equities.

Environment: Informatica PowerCenter 7.1.3, Oracle 10g, Sun Solaris 9, UNIX, Windows XP

Confidential

ETL Developer

Responsibilities:

• Responsible for requirement gathering by direct interaction with users.
• Responsible for analyzing of the existing OLTP design and involved in design discussions for OLAP.
• Responsible for Data Staging Development and Deployment
• Developed Informatica mappings to load data into various fact tables and dimension tables.
• Created various active and passive transformations to support voluminous loading of data target table using Informatica PowerCenter
• Determining the folder structure to reflect the business terms.
• Used transformation developer, mapping and Mapplet designer to generate various mappings for different loads.
• Created transformations like source qualifier, joiner transformation, filter, update strategy, lookup transformation, rank transformations, expressions, aggregator and sequence generator to load the data from source to Data Staging Area and to DW in oracle.

Environment: Oracle 10g, Informatica PowerCenter 7.1.3, Windows 2003 Server

Confidential

Informatica Developer

Responsibilities:

• Involved in designing and building data marts for provider division.
• Loaded data to the stage tables in oracle from multiple data sources using Informatica.
• Designed data transformation from staging to fact and dimension tables in the warehouse.
• Implemented aggregate, filter, join, expression, lookup and update strategy transformations.
• Implemented variables and parameters in transformations for incremental data extraction and complex transformation logic.
• Created mappings between source and target using Informatica power center designer.
• Used mapping and Mapplet designer to generate different mappings for different loads.
• Created transformations like source qualifier, joiner transformation, filter, update strategy, lookup transformation, rank transformations, expressions, aggregator and sequence generator to load the data from staging area to ODS and to DW in oracle.
• Created, scheduled and monitored sessions and batch process based on demand and run only once using Informatica server manager.

Environment: Informatica Power Center 6.2.2, Oracle9i, Windows 2003 Server