SUMMARY

• 8 years of experience in Information Technology with a strong background in Data Warehousing, and ETL process using Informatica PowerCenter 9.x/8.x.
• Experience in using Informatica Power Center tools such as Source Analyzer, Transformation Developer,Mapplet Designer, Mapping Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Extensive experience in developing complex mappings from varied transformations like Router, Filter, Sorter,Connected and Unconnected lookups, Normalizer, Expression, Aggregator, Joiner, Union, Update Strategy, Stored Procedure and Sequence Generator etc.
• Expertise in design and implementation of Slowly Changing Dimensions (SCD) type1, type2, type3.
• Experienced in loading data, troubleshooting, Debugging mappings, performance tuning of Informatica(Sources, Targets, Mappings and Sessions) and fine - tuned transformations to make them more efficient in terms of session performance.
• Database experience using Oracle 11g/10g/9i/8.x/7.x, MS SQL Server 2008, Teradata and DB2.
• Extensive experience in developing Stored Procedures, Views, Triggers, XML and Complex Queries on SQLServer 2000/2005/2008.
• Strong experience using SQL, PL/SQL Procedures/Functions, Triggers and Packages.
• Experienced with Integration of data from heterogeneous sources such as Relational tables, flat files, MSExcel, and XML files.
• Good understanding of Views, Synonyms, Indexes, Joins, and Sub-Queries.
• Working knowledge of data warehouse techniques and practices, experience including ETL processes,dimensional data modeling (Star Schema, Snow Flake Schema, FACT & Dimension Tables), OLTP and OLAP.
• Experience in data mart life cycle development, performed ETL procedure to load data from different sources into Data marts, Data warehouse using Informatica Power Center.
• Experienced in all data processing phases, from the Enterprise Model, Data Model (Logical and Physical Model), and Data Warehousing (ETL).
• Experience in writing complex SQL queries and PL/SQL, including the use of stored procedures, functions and triggers to implement business rules and validations.
• Excellent skills in fine tuning the ETL mappings in Informatica.
• Experience with System Development Life Cycle (SDLC).
• Extensive experience using database tool such as SQL *Plus, SQL * Loader.
• Experience in Data Modeling tool - Erwin and Data Warehousing Concepts.
• Generated various reports including List, Charts, Crosstab, Master/detailed, Drill- through reports in report studio.
• Effective working relationships with client team to understand support requirements, and effectively manage client expectations.
• Excellent communication, presentation, project management skills, a very good team player and self-starter with ability to work independently and as part of a team.
• CDC implementation on loading of data forward into a table to save the change history for the data user to keep track on the change history.

TECHNICAL SKILLS

Data Warehouse/ETL: Informatica Power Center 8.x/9.x

Operating Systems: Windows XP, Red Hat Enterprise Linux, IBM-AIX, Solaris.

Languages: UNIX Shell Scripting, SQL, PL/SQL.

Databases: Oracle 11g/10g/9i, Teradata 14.0/13.0, MS SQL Server, DB2.

DB Utilities: TOAD, SQL Developer.

Scripting Languages: Unix Shell Scripting, Korn Shell Scripting (Kshell), HTML.

Other Tools: Erwin, MSExcel, PowerPoint,Access,visio and outlook

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN

Informatica Developer

Responsibilities:

• Developed and implemented Small Projects (SMP's) to support different partners.
• Worked with the project teams to implement new functionality to support business needs.
• Implemented technical data requirements for integrating partner data to be used for production support teams.
• Developed, maintained and supported the data exchange process between Development and production support team to ensure data quality and integrity.
• Created and Documented ETL Test Plans, Test Cases, Test Scripts, Expected Results, Assumptions and Validations.
• Importing client data files into Oracle (10g) databases.
• Developed database triggers, packages, functions, and stored procedures using PL/SQL and maintained the scripts for various data feeds.
• Created Workflows with worklets, event wait, email and command tasks using Workflow Manager and monitored them in Workflow Monitor.
• Performing quality assurance checks.
• Updating databases to ensure data integrity.
• Monitored sessions that were scheduled, running, completed or failed.
• Worked on Documentation to describe program development, logic, coding, testing, changes and corrections.
• Provide technical support and respond to error reports, problems or questions.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation.

Environment: Informatica Power Center 9.x, Oracle 10g, Windows XP, SQL/PLSQL, UNIX, XML.

Confidential, Phoenix, AZ

Informatica Developer

Responsibilities:

• Analyzed the source systems which include order processing system, quote system etc.
• Consolidated, Cleansed, Integrated, ETL, and customized the data.
• Responsible for Data Modeling and populating the business rules using mappings into the Repository for Meta Data management.
• Extensively involved in the Analysis, Design and Modeling.
• Design the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Created and Documented ETL Test Plans, Test Cases, Test Scripts, Expected Results, Assumptions and Validations.
• Implemented various loads like Daily Loads, Weekly Loads, and Quarterly Loads using Incremental Loading Strategy
• Created Workflows with worklets, event wait, email and command tasks using Workflow Manager and monitored them in Workflow Monitor.
• Extensively worked on the performance tuning of the Informatica PowerCenter Mappings as well as the tuning of the sessions.
• Monitored sessions that were scheduled, running, completed or failed.
• Worked on Documentation to describe program development, logic, coding, testing, changes and corrections.
• Involved in design and development of complex ETL mappings and stored procedures in an optimized manner.
• Used Power exchange for mainframe sources.
• Developed database triggers, packages, functions, and stored procedures using PL/SQL and maintained the scripts for various data feeds.
• Optimized Query Performance, Session Performance and Reliability.
• Developed test plans for unit testing and integration testing.
• Developed data conversion, integration, loading and verification specifications.
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process.
• Maintained the batch processes using Unix Shell Scripts.

Environment: Informatica Power Center 9.x, Oracle 9i, Windows XP, UNIX, XML.

Confidential - Abbott Park, IL

Informatica Developer

Responsibilities:

• Gathered user Requirements and designed Source to Target data load specifications based on Business rules.
• Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
• Developed slowly changing dimension Type 2 mappings to maintain the history of the data.
• Developed several mappings in Informatica, a variety of PowerCenter transformations, Mapping Parameters, Mapping Variables and Parameter files in Mapping Designer.
• Created reusable transformations and applets and used them in mappings.
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors that occur while loading.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
• Implemented performance tuning logic on Sources, Targets, mappings, and sessions to provide maximum efficiency.
• Used Informatica Version Control for checking in all versions of the objects used in creating the mappings and workflows and to keep track of the changes in the development, testing and production environments.
• Created and Documented ETL Test Plans, Test Cases, Test Scripts, Expected Results, Assumptions and Validations.
• Implemented various loads like Daily Loads, Weekly Loads, and Quarterly Loads using Incremental Loading Strategy
• Created Workflows with worklets, event wait, email and command tasks using Workflow Manager and monitored them in Workflow Monitor.
• Developed database triggers, packages, functions, and stored procedures using PL/SQL and maintained the scripts for various data feeds.
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process.
• Maintained the batch processes using Unix Shell Scripts.

Environment: Informatica PowerCenter 8.x, Oracle 10g/11g, Teradata 13, SQL, PL/SQL, UNIX, Flat files, XML, MS Access, Web services, DB2, SQL Server 2008.

Confidential - Detroit, MI

ETL Analyst

Responsibilities:

• Worked with the business analysts and DBA to gather business requirements to be translated into design considerations.
• This also gave some good expertise with some of the tool migration techniques.
• Identified and tracked the slowly changing dimensions to capture the changes in plans of customers, heterogeneous sources and determined the hierarchies in dimensions.
• Speeding up of work by using re-usable transformations and work-lets, for further lowering of errors and enhancing work flow performance.
• Developed schedules to automate the update process and Informatica Batches/Sessions.
• Extracted data from Oracle, and loaded them into Oracle.
• Worked with team, that was focused on capturing mainly changes in customer plans.
• Worked with Source Analyzer, Warehouse Designer, Transformation designer, Mapping designer and Workflow Manager
• Developed data Mappings between source systems and warehouse components.
• Created various Transformations like Joiner, Aggregator, Expression, Lookup, Filter, Update Strategy, Stored Procedures, and Router etc.
• Organized data in order to capture the basic nature of the business environment, providing a stable view of the data associated with the core business processes.
• Monitored sessions that were scheduled, running, completed or failed.
• To retrieve the data from various Tables and to test the database, wrote SQL Queries.
• Worked on Documentation to describe program development, logic, coding, testing, changes and corrections.
• Understanding the entire functionality and major algorithms of the project and adhering to the company testing process.

Environment: Informatica Power Center 8.x, Oracle 10g, Flat Files, SQLDeveloper.

Confidential

Data warehouse Developer

Responsibilities:

• Created parameter files and script for generating parameter files for different environments.
• Created Unix shell scripts.
• Involved in documents like AD, Component Design, UTP, UTR, KSD, and Support documents.
• Worked Extensively on Informatica tools -Repository Manager, Designer and Server Manager.
• Created the Source and Target Definitions using Informatica Power Center Designer.
• Developed and tested all the backend programs, Informatica mappings and update processes.
• Tuned the mappings to increase its efficiency and performance.
• Used Informatica Workflow Manager to create workflows, Workflow Monitor was used to monitor and run workflows.

Environment: Informatica 8.x, UNIX Scripts, Oracle, Flat files, Mainframes & DB2,LINUX.