SUMMARY

• Over 8 years of experience in Information Technology with a strong background in Data warehouse design, development, testing and Support.
• Expertise in OLTP/OLAP System Study, Analysis and E - R modeling, developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional modeling
• Experience in writing, testing and implementation of SQL scripts and macros.
• Extensively used Informatica Repository manager, Power center Designer, Workflow manager, Workflow Monitor and Repository Admin Console.
• Hands on solid experience in Performance Tuning of source, target, mappings, transformations and sessions.
• Performed all dimensions of development including Extraction, Transformation and Loading data from various sources into Data Warehouses and Data Marts using Power Center (Repository Manager, Designer, Workflow Manager, and Workflow Monitor).
• Very good understanding of ‘Versioning’ and ‘Deployment Groups’ concepts in Informatica 8.X. Worked extensively with versioned objects and deployment groups
• Excellent knowledge and experience in creating source to target mapping, edit rules and validation, transformations, and business rules.
• Extensive experience in Extraction, Transformation and Loading (ETL) of data from multiple sources into Data Warehouse and Data Mart
• Well experienced in Performance Tuning of Informatica (sources, mappings, sessions and targets) and Da tabases.
• Extensively worked on Informatica Designer Components - Source Analyzer, Target Designer, Transformation Developer, Mapplet Designer and Mapping Designer.
• Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Ware Housing and using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL)
• Hands on solid experience in Performance Tuning of source, target, mappings, transformations and sessions
• Expert in design and development of complex ETL mappings and scripts using Informatica Power center.
• Performed all dimensions of development including Extraction, Transformation and Loading data from various sources into Data Warehouses and Data Marts using Power Center(Repository Manager, Designer, Workflow Manager, and Workflow Monitor).
• Designed and developed complex mappings, from various transformations like Unconnected /Connected lookups, Router, Filter.
• Firm footing in concepts and understanding of Ralph Kimball’s Dimensional modeling.
• Strong knowledge of Software Development Life Cycle (SDLC) including requirement analysis, design, development, testing, and implementation. Provided End User Training and Support.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.5.1/9.1.0/8.6/8.5/8.1/8.0/7.1/6.2/5. (Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer, Transformation Developer, Workflow Manager, Workflow Monitor).

Reporting: Cognos 10.2.1(Framework Manager, Data Manager, Report Studio, Analysis Studio, Query Studio and Event Studio), SQL Services Reporting Services (SSRS) RED HAT UNIX.

Databases: Oracle 11g/9i/8i

CRM: SalesForce.Com(SFDC)

Languages: SQL, PL/SQL

Scheduling Tools: Informatica Work Flow Scheduler.

Operating Systems: Windows 2003/2000/NT, Windows XP and Windows 7

PROFESSIONAL EXPERIENCE

Confidential, SAINT PAUL, MN

ETL Developer

Responsibilities:

• Excellent knowledge in creating source to target mapping, edit rules and validation, transformations based on business
• Complete documentation of the understanding including sign-off of Application Implementation Document.
• Involved in all stages ETL - requirement gathering, designing and developing various mappings, unit testing, integration testing and regression testing.
• Data Validation and Profiling based on the business and functional requirements.
• Used various database client tools like TOAD, SQL developer, SQL server, Teradata SQL Assistant to access/create/change database objects and create scripts.
• Extensively worked with Teradata, Oracle and SQL Server.
• Automation and scheduling of Informatica jobs using AutoSys.
• Involved in Unit Testing, User Acceptance testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements
• Created Customized BI reports to meet the user requirements using Cognos Query Studio.
• Developed List, Cross tab, Drill through, Master-Detail, Chart and complex reports which involved Multiple Prompts, multi-query, Cubes in Report Studio.
• Performance tuning by analyzing and comparing the turnaround times between SQL and COGNOS.
• Migrating developed reports from Dev to Test and tan to PROD environments
• Designed and developed table structures, stored procedures and functions to implement business rules
• and used application development tools like TOAD (Oracle) to develop SQL queries and stored procedures.
• Teradata as backend database.
• Designing and developing Fastload, Multiload, Bteq, Fastexport and shell scripts
• Provided/reviewed detailed technical specifications and ETL documentations required in each phase of the SDLC, and comply with internal standards and guidelines Handled Knowledge transfer to Support Team after Implementation of the product.
• Created TeraData Loader Connections in Informatica.
• Loaded Data using Tload, Mload Utilities in TeraData.
• Preparation of Test Case document, Test Summary Report, Operational Manual, Support Manual.

Environment: Informatica Power Center 9.1.0 (Power Center Designer, workflow manager, workflow monitor), Cognos 10.2.1(Framework Manager, Data Manager, Report Studio, Analysis Studio, Query Studio and Event Studio), Oracle 10g, TOAD 10.1.1, TeradataDelear Track

ETL Informatica Developer

Confidential

Responsibilities:

• Participated in gathering, analyzing, and documenting business requirements, functional requirements and data specifications.
• Good working knowledge on Teradata components such as FLOAD, MLOAD, BTEQ and Fast export.
• Involved in creating the design and technical specifications for the ETL process based on Functional specifications.
• Extracted data from various sources like Oracle, flat files, SalesForce.com (SFDC) and XML.
• Written Teradata Stored Procedures, Teradata scripts and calling at pre and post session.
• Developed mappings using Informatica Power Center Designer to transform and load the data from source systems to target database.
• Used various transformations like Source Qualifier, Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure and Lookup to develop robust mappings in the Informatica Designer.
• Implemented Real-Time Change Data Capture (CDC) for SalesForce.com (SFDC) sources using Informatica Power Center.
• Facilitate knowledge transition to new members joining the team. Maintain Knowledge Repository with current training materials and project specific documents.
• Implemented Slowly Changing Dimension Type 1 for applying INSERT else UPDATE to Target tables.
• Involved in Version Control of Repository Objects using Check-in and Check-out.
• Worked on Informatica Power Center tools - Designer, Repository Manager, Workflow Manager and Workflow Monitor
• Extensively worked on Workflow Manager and Workflow Monitor to create, schedule and monitor Workflows.
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters for the delta process to extract only the additional data added during dat period.
• Worked with mappings to dynamically generate parameter files used by other mappings
• Update Strategy, Joiner, Stored Procedure and Lookup to develop robust mappings in the Informatica Designer.
• Worked on data profiling, source-target mappings, ETL development, SQL tunings and optimization, testing and implementation in Tera data.
• Implemented Real-Time Change Data Capture (CDC) for SalesForce.com (SFDC) sources using Informatica Power Center.
• Implemented Slowly Changing Dimension Type 1 for applying INSERT else UPDATE to Target tables.
• Involved in Version Control of Repository Objects using Check-in and Check-out.
• Worked on Informatica Power Center tools - Designer, Repository Manager, Workflow Manager and Workflow Monitor
• Extensively worked on Workflow Manager and Workflow Monitor to create, schedule and monitor Workflows.
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters for the delta process to extract only the additional data added during dat period.
• Worked with mappings to dynamically generate parameter files used by other mappings.
• Informatica Scheduler was used to schedule jobs on daily and hourly basis.
• Responsible for monitoring all the sessions dat are running, scheduled, completed and failed. Debugged the mapping of the failed session.

Environment: Informatica Power Center 9.5.1/8.6.1 (Power Center Designer, Teradata, workflow manager, workflow monitor), Oracle 11g, TOAD, Windows XP, Reporting Services (SSRS), MS visual Studio.

Confidential, Atlanta, GA

Sr. Informatica Developer

Responsibilities:

• Interacted with Business Analyst to understand the business requirements and implement the same into a functional Data warehouse design.
• Involved in creating the design and technical specifications for the ETL process based on Functional specifications.
• Responsible for Developing Informatica development life cycle process documents.
• Involved in Testing (SIT) in Teradata & Oracle Apps
• Created various PL/SQL stored procedures,, functions, views, Cursors, indexes on target tables
• Extracted data from various sources like Oracle, flat files and XML.
• Development of mappings as per the technical specifications approved by the client.
• Developed mappings using Informatica Power Center Designer to transform and load the data from source systems to target database.
• Worked on various types of transformations like Expression, Joiner, update strategy, Aggregator, Filter and Lookup.
• Created Mapplets to reduce the development time and complexity of mappings and better maintenance and Worked on different sources like Oracle, flat files.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Involved in enhancements and maintenance activities of the data warehouse including performance tuning.
• Used mapping variable for imparting flexible runs of workflows based on changing values.
• Involved in the debugging of the mappings by creating break points to gain trouble shooting information about data and error conditions.
• Responsible for testing and validating the Informatica mappings against the pre-defined ETL design standards.
• Created sessions and workflows to run with the logic embedded in the mappings using Power center Designer.
• Played a key role in designing the application and migrate the existing data from relational sources to corporate warehouse effectively by using Informatica Power center
• Created various tasks like sessions, decision, timer and control to design the workflows based on dependencies.
• Coordinating with users and establishing good relations between users and development team.
• Scheduling the session’s tasks comprising of different mappings for data conversion, extractions in order to load data into oracle database.

Environment: Informatica Power Center 8.6.1 (Power Center Designer, workflow manager, workflow monitor), Oracle 11g, TOAD.

Confidential

Informatica Developer

Responsibilities:

• Participated in gathering, analyzing, and documenting business requirements, functional requirements and data specifications.
• Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.
• Created mappings for dimensions and facts.
• Designing and creation of complex mappings involving transformations such as expression, joiner, aggregator, lookup, update strategy, and filter.
• Extracted data from various sources like Oracle, flat files and XML.
• Worked extensively on Source Analyzer, Mapping Designer, Mapplet designer, Warehouse Designer and Transformation Developer.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Published and Migrated reports in Development/Test to production Domains.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Created various tasks like sessions, decision, timer & control to design the workflows based on dependencies
• Created sessions and workflows to run with the logic embedded in the mappings using Power center Designer and Worked on issues with migration from development to testing.
• Developed several Mappings and Mapplets using corresponding Sources, Targets and Transformations.
• Optimizing/Tuning mappings for better performance and efficiency.
• Responsible for testing and validating the Informatica mappings against the pre-defined ETL design standards.
• Used workflow manager for session management, database connection management and scheduling of jobs.

Environment: Informatica Power Center 8.1 (Power Center Designer, workflow manager, workflow monitor), Oracle 9i, Windows XP, TOAD, SQL Server Reporting Services (SSRS).

Confidential, Jersey City, NJ

Informatica Developer

Responsibilities:

• Responsible for monitoring all the sessions dat are running, scheduled, completed and failed. Debugged the mapping of the failed session.
• Created sessions, configured Workflow to extract data from various sources, transformed data, and loading into data warehouse.
• Provide support and assist to onshore and offshore Team members.
• Extracted data from excel files and high volume of data from flat files, Oracle, SalesForce.com (SFDC) using ETL Informatica Mappings.
• Used various transformations like Source Qualifier, Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure and Lookup to develop robust mappings in the Informatica Designer.
• Involved in migrating the mappings and workflows from Development to Testing and tan to Production environments.
• Involved in Unit Testing, User Acceptance testing to check whether the data loads into target.
• Standardized parameter files to define session parameters such as database connection for sources targets, last updated dates for Incremental loads and many default values of fact tables.
• Used Debugger to test the data flow and fix the mappings.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Tested the data and data integrity among various sources and targets.
• Used Rapid SQL to test the SQL’S and to view the data coming from different systems.
• Involved in Unit, Integration, system, and performance testing levels.

Environment: Informatica Power Center 8.1/7.1, Oracle 11g, SalesForce.com (SFDC), MS-Office, Windows XP, TOAD.

Confidential

Informatica Developer

Responsibilities:

• Analyzed the data models of the source systems to develop comprehensive mapping sections
• Designing a Database for the loading and Staging Area.
• Used Oracle Stored Procedures, Functions, Packages and Triggers.
• Extracted data from Oracle and flat files to pull it into the Staging area.
• Produced specifications for mapping from various source Systems to Data Warehouse.
• Performed Informatica Administrator functions like creating repository, Groups Users, Folders, giving permissions on the folders to the users etc.
• Extensively used Informatica client tools-Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager. The objective is to extract data stored in different databases such as Oracle and SQL server and to load finally into a single Data Warehouse.
• Extensively worked in the performance tuning of the ETL mappings and workflows using partitioning, external loaders, lookup cache etc.
• Extensively created mapping, reusable transformations using transformations like.
• Lookup, Filter, Expression, Stored Procedure, Aggregator, Update Strategy etc.
• Coordination with the off-shore development team to fix release issues.

Environment: Informatica Power Center 7.1, Oracle 9i/10g, SQL Server Reporting Service (SSRS), TOAD, Windows XP