SUMMARY

• 8+ years of extensive experience in Data warehousing and Data Analysis, design, development and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL and Reporting on Windows and UNIX platforms.
• Extensive experience with ETL tool Informatica Power Center 9.1/ 8x/7x/6x, Power Exchange 8.6.1/8.5 in designing and developing complex Mappings, Mapplets, Transformations, Workflows, Worklets and scheduling the Workflows .
• Experience in complete Software Development Life cycle (SDLC) including Requirement, Analysis, estimations, Design, Construction, Unit and System Testing and implementation.
• Used Type 1 SCD and Type 2 SCD mappings to update Slowly Changing Dimensions for accessing the full history of accounts and transaction information.
• Experience in writing, testing and implementation of thePL/SQL triggers, stored procedures, functions, packages.
• Used Informatica IDE/IDQ for data cleansing and data profiling.
• Experience in data mapping and transformation technologies like XML, XSD, WSDL
• Experience with Teradata utilities (Mload, FastLoad, TPump) to perform data load into Teradata data warehouse.
• Involved in Data Modeling techniques like normalization, denormalization, Star Schema/Snowflake modeling, Fact and Dimensions tables, Physical and logical data modeling.
• Worked with Informatica power exchange CDC to capture changed data in the source system.
• Used pushdown optimization in the Informatica mapping to improve performance of data load.
• Experience in Repository Configuration, creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources systems into targets.
• Involved in the data analysis for source and target systems and good understanding of Data Warehousing concepts, staging tables, Dimensions, Facts and Star Schema.
• Experience in integration of various data sources from Databases like MS Access, Oracle, DB2, SQL Server and formats like flat - files, CSV files, COBOL files, XML, DTD, XSD files, legacy system files etc.
• Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, and Sequence Generator, Java transformation.
• Extensive work in ETL process consisting of data transformation, data sourcing, mapping, conversion and loading
• Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, and sessions.
• Involved in fixing bugs in production environment and was a part of the production support team.
• Excellent interpersonal and communication skills, technically competent and result-oriented with problem solving skills and ability to work independently and use sound judgment.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.1/8.x/7.x/6.x (Repository Admin Console, Repository Manager, Designer, Workflow Manger, Workflow Monitor),Power Exchange, Informatica B2B data exchange

Data Modeling: Dimensional Data Modeling, Data Modeling, Star Join Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, ERWIN 4.5/4.0/3.5, Oracle Designer, MS Visio.

DBMS: Oracle 11g/10g/9i/8i, DB2, MS SQL Server 2005/2000, MS Access, Excel, Teradata (Fast-Load, Multi-Load, Fast Export, BTEQ), ODBC

Programming Languages: SQL, PL/SQL, Unix Shell scripting

BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Objects

Operating Systems: Windows XP/ 2008/2003/2000/ NT/98/95, UNIX, LINUX

Other tools: VISIO, ERWIN, TOAD, NEXUS, CITRIX, Autosys, Control-M (Batch Scheduling), cognos (Reporting tool)

PROFESSIONAL EXPERIENCE

Confidential, NYC

Informatica Developer

Responsibilities:

• Prepared technical design/specifications for data Extraction, Transformation and Loading.
• Worked on Informatica Utilities Source Analyzer, warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Analyzing the sources, transforming data, mapping the data and loading the data into targets using Informatica Power Center Designer.
• Created reusable transformations to load data from operational data source to Data Warehouse and involved in capacity planning and storage of data.
• Developed complex mappings such as Slowly Changing Dimensions Type II-Time stamping in the Mapping Designer.
• Used various transformations like Stored Procedure, Connected and Unconnected lookups, Update Strategy, Filter transformation, Joiner transformations to implement complex business logic.
• Created Informatica mappings to load from various external sources like MS SQL Server, Oracle, SAP R/3 into Teradata data warehouse using Teradata external loading utilities like fast load, Mload.
• Used Informatica Workflow Manager to create workflows, database connections, sessions and batches to run the mappings.
• Worked on performance tuning to increase the performance ofHyperionproduct (heap size tuning, OS tuning etc)
• Used Variables and Parameters in the mappings to pass the values between mappings and sessions.
• Implemented restart strategy and error handling techniques to recover failed sessions.
• Used UNIX Shell scripting for automation of the process, invoking PL/SQL procedures, and Informatica sessions.
• Did performance tuning to improve Data Extraction, Data process and Load time.
• Creating and executing test cases for Informatica mappings. Documenting ETL design and test results.
• Migrated Mappings, Sessions and Common Objects from Development to Test and to Production.
• Re-designed ETL mappings to improve data quality.
• Wrote complex SQL Queries involving multiple tables with joins.
• Performed error handling of sessions by using terse, normal, verbose initialization and verbose data tracing levels.
• Implemented best practices as per the standards while designing technical documents and developing Informatica ETL process.

Environment: Informatica Power center 9.5/9.1, Power Exchange, Autosys, Hyperion EPM 11.1.1.2,Oracle 11g, Teradata, Windows XP, UNIX, SQL/PLSQL, control-M.

Confidential, CT

Informatica developer/lead

Responsibilities:

• Co-ordinated Joint Application Development (JAD) sessions with Business Analysts and source developer for performing data analysis and gathering business requirements.
• Analyzed, inspected and laid the framework for Claims process Engine, a process designed and customized by external vendors for the client.
• Designed the Source - Target mappings and involved in designing the Selection Criteria document.
• Worked on design and development of Informatica mappings, workflows to load data into staging area, data warehouse and data marts in SQLServer and Oracle.
• Used Informatica Power Center to create mappings, sessions and workflows for populating the data into dimension, fact, and lookup tables simultaneously from different sourcesystems (SQL server, Oracle, Flat files).
• Created mappings using various Transformations like Source Qualifier, Aggregator, Expression, Filter, Router, Joiner, Stored Procedure, Lookup, Update Strategy, SequenceGenerator and Normalizer.
• Deployed reusable transformation objects such as mapplets to avoid duplication of metadata, reducing the development time.
• Used version mapping to update the slowly changing dimensions to keep full history to the target database.
• Involved in migration of Informatica from 8.x to 9.x.
• Implemented sending of Post-Session Email once data is loaded.
• Created and Monitored Workflows using Workflow Manager and Workflow Monitor.
• Used Debugger to test the mappings and fixed the bugs.
• Tuned performance of mapping and sessions by optimizing source, target bottlenecks and implemented pipeline partitioning.
• Worked with DBA for partitioning and creating indexes on tables used in source qualifier queries.
• Involved in Performance/Query tuning. Generation/interpretation of explain plans and tuning SQL to improve performance.
• Scheduled various daily and monthly ETL loads using Control-M
• Involved in writing UNIX shell scripts to run and schedule batch jobs.
• Involved in unit testing and documentation of the ETL process
• Involved in Production Support in resolving issues and bugs.

Environment: Informatica Power Center 9.1/8.6, SQL Server 2005, PL/SQL, Oracle 10g, Toad 8.0, XML, Windows, UNIX Shell Scripting.

Confidential, Chicago, IL

ETL Consultant

Responsibilities:

• Creation of the design documents and test cases for Informatica mappings.
• Worked closely with executive sponsors and user decision makers to develop the transformation logic to be used in Informatica.
• Created different transformations for loading the data into targets like Source Qualifies, Joiner transformation, Update Strategy, Lookup transformation, Rank Transformations, Expression, Aggregator.
• Created Mapplets and used them in different Mappings for maintaining the standards.
• Worked with SCD tables using Lookup and Update Strategy transformations.
• Developed Informatica mappings and tuned them for better performance.
• Modified coded procedures to extract daily incremental data.
• Scheduling and Loading data process and monitoring the ETL Process using Autosys.
• Used debugger to test the mapping and fixed the bugs.
• Optimized query, session performance.
• Involved in documenting the entire ETL process including mapping and unit testing documents.
• Performance Tuning of SQL queries, views etc.
• Wrote and deployed UNIX Shell Scripts.
• Scheduled and monitored jobs using UNIX Shell Scripting.
• Made use of Unix Shell scripts to load flat files and cleanse data.
• Used Repository Manager for managing the users and privileges.
• Utilized SQL Loader in the staging area to minimize loading time.
• Used Variables and Parameters in the mappings to pass the values between mappings and sessions.
• Used and developed Shell Scripts used for Pre and Post Session commands for the developed Mappings and scheduling

Environment: Informatica 8.1, Designer, Workflow Manager, Workflow Monitor, Repository Manager, Oracle 10g, SQL Server 2000, flat files, UNIX shell scripting, Windows XP

Confidential, Texas

ETL Developer

Responsibilities:

• Studying the existing environment and accumulating the requirements by querying the Clients on various aspects.
• Identification of various Data Sources and Development Environment.
• Was involved in Data modeling and design for data warehouse and data marts in star schema methodology with confirmed and granular dimensions and FACT tables.
• Prepared user requirement documentation for mapping and additional functionality.
• Extensively used ETL to load data using Power Center / Power Connect from source systems like Flat Files and Excel Files into staging tables and load the data into the target database Oracle.
• Worked on Toad for Oracle.
• Created PL/SQL packages, Stored Procedures for data transformation on the data warehouse
• Used Update strategy and Target load plans to load data into Type-2 Dimensions.
• Created and used reusable Mapplets and transformations using Informatica Power Center.
• Improved performance by identifying the bottlenecks in Source, Target, Mapping and Session levels.
• Involved in configuring the database parameters for optimal use of huge databases.
• Involved in Unit Testing the Informatica mappings.
• Design and Development of ETL routines, using Informatica Power Center Within the Informatica Mappings
• Usage of Lookups, Aggregator, Ranking, Stored procedures / functions, SQL overrides usage in Lookups and source filter usage in Source qualifiers and data flow management into multiple targets using Routers was extensively done.

Environment: Informatica Power Center 7.1, Informatica Power Exchange, DB2, Oracle 10g,Toad, UNIX Shell Scripting, XML, Windows NT.

Confidential

ETL Developer

Responsibilities:

• Analyzing the existing ETL process and developed the mappings as requested by the Client.
• Worked on the Analysis, design and Implementation of the Business requirement using Informatica mappings
• Involved in the Data Model schema designs using the Data Model Tools like Erwin.
• Was involved in the Business Objects Universe Design following the Dimensional Modeling.
• Maintained the Data of the Data Marts using Informatica Power Exchange.
• Assisted in the Meta Data management of the schema designs.
• Created the mapping documents from Business requirement documents
• Developed the mappings using various transformations like Aggregators, Sequence generators, Joiners, Source qualifiers, Lookups, Update Strategy etc.,
• Extensively used connected and unconnected lookups in the mappings.
• Worked in the various types of slowly changing dimensions using Update Strategy.
• Used Teradata utilities like FastLoad and MultiLoad for loading purpose.
• Created the Sessions and Workflows and scheduled them.
• Run the mappings using Korn shell scripts in UNIX environment.
• Was involved in debugging the mappings and Performance tuning.
• Involved with the reporting team and created OLAP reports with using Business Objects Data Integrator
• Was Involved in Creating the Business Objects reports on Web.
• Created Workflows and used various tasks like Email, Event-wait and Event-raise, Timer, Scheduler, Control, Decision, Session in the workflow manager.

Environment: Informatica 7.x and 6.x, Business Objects, Data Integrator, Oracle 9i/10g, PL/SQL, Teradata, UNIX and Win XP.