SUMMARY

• Over 8 years of professional IT experience in developing data warehouse and Informatica PowerCenter in all phases of Analysis, Design, Development, Implementation and support of Data Warehousing applications using Informatica 9.x/8.x/7.x (Designer, Repository Manager, Workflow Manager and Work Flow Monitor).
• Experienced in integration of various data sources like Oracle 11g,10g/9i/8i, MS SQL Server 2005/2000, XML files,DB2, Flat files, XML, SQL, PL/SQL, Erwin 4.0/3.5, SQL Developer, TOAD, Stored procedures, heterogeneous sources into staging area and different target databases.
• Developed mappings in Informatica IDQ using different transformations Labeler, Standardizer, Address Doctor, Expression, Sorter etc.
• Extensive experience in Data Warehousing with Informatica, OLTP and OLAP.
• Experienced in developing logical and physical models and implementing them in Oracle.
• Experienced on implementing Change Data Capture(CDC)techniques and slowly changing Dimensions (SCD) - Type I, II & III.
• Experienced in creating entity relational and dimensional relational data models with Kimball Methodology (Star schema and Snow flake schema architectures, Fact/dimension tables).
• Experienced in creating the Workflows, Worklets, Mappings, Mapplets, Reusable transformations and scheduling the Workflows and sessions using Informatica PowerCenter.
• Strong data modeling experience using Star/Snowflake schemas, Re-engineering, Dimensional Data modeling, Fact and Dimension tables, Physical and logical data modeling.
• Installed & configured Informatica 9.5.1 B2B Data Transformation.
• Experienced in Informatica mapping specification documentation, tuning mappings to increase performance, proficient in creating and scheduling workflows and expertise in Automation of ETL processes with scheduling tools such as AutoSys and Control-M.
• Experienced in the development, modification and testing of Unix Shell scripts.
• Experienced in Performance Tuning, identifying and resolving performance bottlenecks at various levels Performance tuning at Mapping, Session and database level.
• Advanced knowledge of Oracle PL/SQL programming, stored procedures and functions, cursors and tuning the SQL query.
• Experienced in the Development, Implementation of Database/Data Warehousing /Client/Server /Legacy applications and implementation of various Mainframe and Informatica applications for using Data Extraction, Data Transformation, Data Loading and Data Analysis.
• Performed Testing at various levels including Unit Testing, UAT.
• Experienced in healthcare, petroleum, networking, and entertainment industry.
• Outstanding communication and interpersonal skills, ability to learn quickly grasp new concepts, both technical and business related and utilize as needed. Active participation in Knowledge Transfer and Documentation.

TECHNICAL SKILLS

ETL Informatica: Informatica PowerCenter 9.5.1/8.x/7.x/6.x, Repository Admin Console, Repository Manager, Designer, Workflow Manager, Workflow Monitor, Informatica Developer

Data Modeling Tools: Dimensional Data Modeling, Data Modeling, Star Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling

Databases: Oracle 10g/11g/9i, MS SQL 200x, MS SQL Server 2005/7.0

Languages: SQL, PL/SQL, Unix, XML Files, Flat files, Stored Procedure, C, C++

Operating Systems: Windows 7/95/98/XP, Unix, Linux

Application Tools: MS Office (Word, Excel, PowerPoint), HTML

Scheduling Tools: AutoSys, Control-M

PROFESSIONAL EXPERIENCE

Confidential, Irving, TX

Sr. Informatica Developer

Responsibilities:

• Work closely with Business Analyst to get the requirement.
• Develop Power Center Code as per Business Requirement.
• Implemented mapping level optimization with best route possible without compromising with business requirements.
• Develop Reusable components wherever applicable i.e. Transformations, Mapplets, Worklets and UDF etc.
• Handle huge volume of data and optimize the code.
• Performing Unit Testing and involve Integration testing by coordinating with other dependency teams to complete test cycles.
• Worked with different databases such as Oracle and Flat files and used Informatica to extract data.
• Involve in UAT to get Client GoLive Approval.
• Creating Deployment Groups and Harvest Packages to move the code to production.
• Used IDE tool to load the data from file to stage tables.
• Used UNIX shell scripts to FTP the source files from EDI servers using the CONFIG files.
• Worked with UNIX commands and used Unix shell scripting to automate jobs.
• Performed Data Profiling to assess the risk involved in integrating data for new applications, including the challenges of joins and to track data quality standards.
• Developing new, modifying and analyzing the already existing Mapping and workflows in Informatica and shell scripts in UNIX.
• Worked as a fully contributing team member, under broad guidance with independent planning & execution responsibilities.

Environment: Informatica PowerCenter 9.5.1, Informatica Power Exchange, Informatica Data QualityDB2, HARVEST, Track Plus, SSH Secure Shell, Putty, WinSCP, Toad, Windows 7/XP/NT

Confidential, Southfield, MI

Informatica Developer

Responsibilities:

• Instrumental in Analysis, Requirements Gathering and documentation of Functional and Technical specifications.
• Involved in Dimensional modeling to Design and develop STAR Schemas using ERwin to identify Fact and Dimension Tables.
• Work extensively on Informatica client tools such as Designer, Workflow manager, Workflow Monitor.
• Use ETL to load data from sources such as Flat Files, Oracle to Oracle, Teradata Target Database. Based on the business requirements Reusable transformations are created in transformation developer and Mapplets in the Mapplet designer.
• Develop complex mappings to transform the data using Rank, Sorter, Stored Procedure, Joiner, Aggregator, Filter, Connected lookup, unconnected lookup and Router transformations.
• Implement slowly changing dimensions type 2 to keep track of historical data.
• Use dynamic lookup cache for slowly changing dimensions.
• Used B2B data transformation for getting the data from unstructured sources (XML).
• Use workflow manager for creating, validating, testing and running the Sequential and Concurrent batches and sessions and scheduling them to run at specified time with required frequency.
• Implement performance tuning techniques by identifying and resolving the bottlenecks in source, target, transformations, mappings and sessions.
• Use Workflow Monitor to monitor the jobs, review error logs that were generated for each session, and resolved them. Perform unit testing and system testing.
• Perform Database end tuning using Explain Plan and analyze table queries.

Environment: Informatica PowerCenter 8.6, Data Exchange (B2B), Oracle 10g, DB2, AutoSys, SQL Server 2008, PL/SQL, Teradata, Toad, ERwin 3.5, Unix

Confidential, Houston, TX

ETL Informatica Developer

Responsibilities:

• Worked with Informatica PowerCenter client tools like Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Extracted data from Oracle, SQL Server database tables and flat files.
• Created Informatica Development Standards. This document describes the general guidelines for Informatica developers, the naming conventions to be used in the Transformations and also development and production environment structures.
• Worked in the performance tuning for mappings and ETL procedures both at mapping and session level. Implementing performance tuning the objects to increase the Performance of the loads.
• Worked closely with database administrators and application development team(s) on the design and implementation of the database.
• Participated in weekly end user meetings to discuss data quality, performance issues. Ways to improve data accuracy and new requirements, etc.
• Developed shell scripts in Unix to automate jobs in DEV and QA.
• Worked with various active and passive transformations in Informatica PowerCenter.
• Understood of Software Development Life Cycle (SDLC), involved in various phases like Requirements, Analysis/Design, Development and Testing.
• Worked with Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Developer, and Mapping Designer.
• Worked with Slowly Changing Dimensions Type1, Type2 for Data Loads.
• Handled various loads like Intra Day Loads, Daily Loads, Weekly Loads, Monthly Loads, and Quarterly Loads using Incremental Loading Technique.
• Worked with re-usable objects like Re-Usable Transformation and Mapplets.
• Worked with Incremental Loading using Parameter Files, Mapping Variables and Mapping Parameters.
• Involved in unit testing and writing simple test scripts and eliminating the bottlenecks for optimum performance.
• Involved in error handling using Session Logs, Reject Files, and Session Logs in the Workflow Monitor.
• Developed Unix shell scripts to run the workflows and automated the scripts to run daily loads using Control-M scheduler.
• Worked with the Debugger for handling the data errors in the mapping designer.
• Involved in bug fixes for production issues.

Environment: Informatica PowerCenter 9.1, Oracle 11g, SQL Server 2005, Flat Files, Control-M, PL/SQL, Rapid SQL, Quality Center, Unix, Linux

Confidential, Orlando, FL

Informatica Developer

Responsibilities:

• Designed and developed ETL process using Informatica tool.
• Worked with various Active transformations in Informatica PowerCenter like Filter Transformation, Aggregator Transformation, Joiner Transformation, Rank Transformation, Router Transformation, Sorter Transformation, Source Qualifier, and Update Strategy Transformation.
• Worked with various Passive transformations in Informatica PowerCenter like Expression Transformation, Sequence Generator, and Lookup Transformation
• Worked with Task Developer, Worklet Designer, and Workflow Designer in the Workflow Manager. Responsible for extracting data from Oracle and Flat files. Responsible for Performance Tuning in Informatica PowerCenter.
• Worked with both Connected and Un-Connected Lookups.
• Made use of sorted input option for the performance tuning of aggregator transformation.
• Used SQL Override function in Source Qualifier Transformation.
• Used Normal Join, Full Outer Join, Detail Outer Join, and Master Outer Join in the Joiner Transformation.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator to create robust mappings in the Informatica PowerCenter Designer.
• Imported various heterogeneous files using Informatica PowerCenter Source Analyzer.
• Developed several reusable transformations and mapplets that were used in other mappings.
• Prepared Technical Design documents and Test cases. 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.

Environment: Informatica PowerCenter 9.1(Repository Manager, Designer, Workflow Manager, and Workflow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Designer, Task Developer), Oracle 10g, SQL, PL/SQL, Flat Files, Star Team

Confidential, New York, NY

ETL Developer

Responsibilities:

• Used Informatica PowerCenter 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 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.
• Created events and various tasks in the work flows using workflow manager.
• Tuned ETL procedures to optimize load and query Performance.
• Set up Batches and sessions to schedule the loads at required frequency using Informatica workflow manager and external scheduler.
• Extensive Data modeling experience using Dimensional Data modeling, Star Schema modeling, Snowflake modeling, and FACT and Dimensions tables.
• Tested the mapplets and mappings as per Quality and Analysis standards before moving to production environment.
• Took part of Informatica administration. Migrated development mappings as well as hot fixes them in production environment.
• Wrote shell scripts for file transfers, file renaming and several other database scripts to be executed from Unix.
• Migrated Informatica Objects using Deployment groups.
• Troubleshot issues in Test and Prod. Did impact analysis and fixed the issues.
• 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.

Environment: Informatica PowerCenter 8.6.0/8.6.1 , Informatica Power Exchange 8.1, Stored procedures, Pl/SQL, Informatica Data Quality, Unix (Solaris), HP Quality Center

Confidential

Jr. Informatica Developer

Responsibilities:

• Used Workflow Manager for creating, validating, testing and running the sequential and concurrent sessions and scheduling them to run at specified time.
• Tested the Informatica mappings with manual testing and assisted QA team.
• Used Informatica Designer tools to design the source definition, target definition and transformations to build mappings.
• Studied the existing environment and accumulating the requirements by querying the Clients on various aspects.
• Identified various Data Sources and Development Environment.
• Data modeling and design of data warehouse and data marts in star schema methodology with confirmed and granular dimensions and FACT tables.
• Designed and developed data validation, load processes, test cases, error control routines, audit and log controls using PL/SQL, SQL.
• Used Update strategy and Target load plans to load data into Type-2 /Type1 Dimensions.
• Created and used reusable Mapplets and transformations using Informatica PowerCenter.
• Created different transformations for loading the data into target database using Aggregator, Upgrade strategy, Router, Rank, Sorter, Source Qualifier, Filter, Expression, Look-up, Sequence Generator, Normalizer, Joiner, etc.
• Developed joiner transformation for extracting data from multiple sources.
• Designed and developed pre-session, post-session routines and batch execution routines using Informatica Server to run Informatica sessions.
• Involved in fixing invalid Mappings, testing of Stored Procedures and Functions, testing of Informatica Sessions, and the Target Data.

Environment: Informatica PowerCenter 7.1.3, MSSQL Server 2005, PL/SQL, Stored Procedures, Informatica Data Quality, Unix (Solaris), HP Quality Center