Summary

• Over 8 years of experience in IT industry including 7 years of 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, SQL server Teradata.
• Good Knowledge in Relational and Dimensional Modeling techniques like Star, Snowflake Schema, Fact and Dimensional Tables.
• Experience in working on Enterprise Job scheduling tools like Tidal.
• 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.

Professional Work Experience

Confidential

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 mapplet's 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: Informatica 9.5.0/ 9.1.0, UNIX, Oracle 11g, DB2, Teradata, Tidal Scheduler.

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, SQL Server 2008, UNIX, Teradata, Windows XP,Autosys.

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, Opcon Jobs