Summary:

• Over 7+ years of extensive experience with Informatica Power Center in all phases of Analysis, Design, Development, Implementation and support of Data Warehousing applications usingInformatica Power Center 9.X/8.X/7.X/6.X/5.X, SQL, PL/SQL, Oracle and Unix.
• Expertise in using Oracle 8i/9i/10g/11g and had hands on experience in building advanced relational database objects which uses Oracle 8i/9i/10g database.
• Experience in full life cycle implementation of Data Warehouses.
• Involved in all the phases Analysis and Design, Data Modeling - ER Diagrams and Normalization, System Testing, Development, documentation and implementation.
• Strong experience in Extraction, Transformation and Loading of data from multiple sources into Data Warehouse and administrating the Informatica PowerCenter environment such as maintainingInformatica Repository and Server processes.
• Experiencein Migrating the Data from Oracle to Netezza Database
• Performing code migration from Dev to Test, backup and restoring of Informatica Repository, upgrades, security administration and versioning.
• Involved in ETL Architecture and Data modeling tool like Erwin.
• Troubleshooting and problem solving applications with Informatica Debugger.
• Validating,TESTING & Debugging ERRORS with in ETL Transformations.
• Experienced in creating entity relational & dimensional relational data models using Kimball/Inmon Methodology i.e. Star Schema and Snowflake Schema.
• Experience in Slowly Changing Dimensions (Type 1, Type 2 and Type 3), OLTP, OLAP, Data Reports and Surrogate keys, Normalization/De normalization.
• Designed complex mappings using Source Qualifier, Filter, Normalizer, Aggregator, Router, Updated Strategy, Union, Lookup, Joiner, Sorter and Stored Procedure Transformations.
• Developed various Data Documentation Standards and ETL Mapping Documentation using Informatica Velocity as a guideline to document the Mappings, Workflows and Data marts.
• Designed Reusable Transformations and Mapplets.
• Hands on experience in Performance Tuning of sources, targets, transformations and sessions
• Experience in all phases of the project life cycle and production support.
• Experience in writing PL/SQL stored procedures, functions, packages and triggers using PL/SQL developer.
• Experience working with unstructured data
• Over two years of Extensive Experience in Netezza.
• Experience in Informatica Power Exchange for Netezza.
• Worked with DAC for job scheduling.
• Expertise in fine performance tuning of SQL statements and PL/SQL modules using Explain Plan, SQL Trace for optimizing the cost and evaluating the performance.
• Experience in translating business requirements into creation of database objects: tables, indexes, constraints, packages, stored procedures, functions, and triggers using Oracle PL/SQL tool.
• Extensive experience in analysis and design of database, database modeling, ER Diagrams, normalization and de-normalization.
• Knowledge of working with tools like Toad, Eclipse and utilities like SQL*Loader.
• Experience in UNIX Shell Scripting (Korn & Bourne) on UNIX & Linux platform.
• Experienced in Installation, Configuration, and Administration of Informatica Power Center/Power Mart on Client/Server environment.
• Highly Proficient in Informatica Designer Components like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Transformation Developer, Workflow Managerand Workflow Monitor.
• Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals. Excellent written and verbal communication skills including experience in proposal and presentation creation.
• Experience in UNIX and WINDOWS environment
• Hands on experience on scheduling tools

Technical Skills:

ETL Informatica- 7.x/8.x/9.x, SQL Server 2005 (SSIS) Scheduling Tool DAC (Data Warehousing Admin Console) 

Reporting Tool- Oracle Business Intelligence (OBIEE) 10.1.3X, SiebelAnalytics 

Databases- Oracle11g/10g/9i/8i, MS SQL Server 2005/2000, Netezza 4.5.1 

Operating Systems- Windows 95/98/2000/2003 Server/NT Server Workstation 4.0, UNIX

Programming- Visual Basic 6.0/5.0, PowerBuilder 6.0, C, SQL, PL/SQL, Java, HTML, XML, DHTML 

Other Tools- SQL*Loader, SQL*Plus, TOAD, Eclipse, MS Visio, MS Excel, Eclipse Platform 

Scripting Languages- UNIX Shell Scripting - bash 

Methodologies-E-R Modeling, Star Schema, Snowflake Schema 

Data Modeling Tool- Erwin 3.5/4.1

Professional Experience:

Confidential, Charlotte, NC AUG 11 - Present 
Sr.Informatica Developer

Responsibilities:

• Worked closely with business analysts to understand and document business needs for decision support data.
• Used the Update Strategy Transformation to update the Target Dimension tables.
• Developed ETL procedures to transform the data in the intermediate tables according to the business rules and functionality requirements.
• Involved in the development of Informatica mappings and also tuned for better performance.
• Migration of data from Oracle to Netezza
• Created Netezza database, users, base table and views using proper distribution key structure.
• Worked on Eclipse platform and also SVN interface.
• Used Informatica Power Connect for Netezza to pull data from Netezza data warehouse.
• Developed mapping parameters and variables to support connection for the target database as Netezza and source database as Oracle OLTP database.
• Created Mapplets and used them in different Mappings.
• Used designer debugger to test the data flow and fix the mappings. Tuned Informatica Mappings and Sessions for optimum performance.
• Provided detailed technical, process and support documentation like daily process rollback and detailed specifications and very detailed document of all the projects with the workflows and their dependencies.
• Worked with mapping parameters and variables to load data from different sources to corresponding partition of the database table.
• Worked extensively in NZSQL to migrate the data from Oracle to Netezza database.
• Created Schema objects like Indexes, Views, and Sequences.
• Extracting the data from .BRD files, Flat files & Orcale and load them through Informatica.
• Worked with DAC for job scheduling.
• Worked on Unstructured data mainly on word and text data.
• Production Support and issue resolutions.
• Involved in Unit testing of Mappings, Workflows and debugging mappings for failed sessions.
• Worked on unit testing of shell scripts mainly bash
• Created partitions, SQL over ride in source qualifier, session partitions for improving performance.
• Performed unit testing and system testing of the mappings developed and documented with various scenarios.
• Written Unix Shell Scripting based on requirements

Environment: Informatica Power Center 9.1, Informatica Power Connect for Netezza, Netezza 4.5.2, Informatica Power Exchange, Oracle 11i/10g, SQL Server 2005, UNIX, Shell Scripting, DAC,NZSQL, Eclipse, MS Excel.

Confidential, Detroit, MI NOV 10 - AUG 11 
Sr.Informatica Developer

Responsibilities:

• Involved in system study, analyses of the requirements and designing of the complete system.
• Worked closely with business analysts to understand and document business needs for decision support data.
• Designed and developed complex aggregate, join, look up transformation rules (business rules) to generate consolidated (fact/summary) data identified by dimensions using Informatica ETL (Power Center) tool.
• Used Informatica features to implement Type I changes in slowly changing dimension tables.
• Worked on Unstructured data mainly on word documents.
• Used the Update Strategy Transformation to update the Target Dimension tables.
• Developed ETL procedures to transform the data in the intermediate tables according to the business rules and functionality requirements.
• Created Netezza database, users, base table and views using proper distribution key structure.
• Used Informatica Power Connect for Netezza to pull data from Netezza data warehouse.
• Developed mapping parameters and variables to support connection for the target database as Netezza and source database as Oracle OLTP database.
• Created Complex mappings using Connected/Unconnected Lookup, Aggregator and Router transformations for populating target table in efficient manner.
• Created Mapplets and used them in different Mappings.
• Used designer debugger to test the data flow and fix the mappings. Tuned Informatica Mappings and Sessions for optimum performance.
• Involved in writing various PL/SQL stored procedures, functions and packages.
• Provided detailed technical, process and support documentation like daily process rollback and detailed specifications and very detailed document of all the projects with the workflows and their dependencies.
• Worked with mapping parameters and variables to load data from different sources to corresponding partition of the database table.
• Created events and tasks in the work flows using workflow manager
• Created Schema objects like Indexes, Views, and Sequences.
• Created mappings using the Transformations such as the Source qualifier, Aggregator, Expression, lookup, Filter, Router, Rank, Sequence Generator, Update Strategy etc.
• Extracting the data from .BRD files, Flat files & Orcale and load them through Informatica.
• Used Informatica Workflow Manager and server to read data from sources to write to target databases, manage sessions/tasks and to monitor server ETL Implemented for Oracle and SQL Server.
• Worked with DAC for job scheduling.
• Production Support and issue resolutions.
• Created test cases and completed unit, integration and system tests for sales data mart system.
• Involved in writing procedures, functions in PL/SQL.
• Involved in Unit testing of Mappings, Workflows and debugging mappings for failed sessions.
• Created partitions, SQL over ride in source qualifier, session partitions for improving performance.
• Performed unit testing and system testing of the mappings developed and documented with various scenarios.
• Written Unix Shell Scripting based on requirements

Environment: Informatica Power Center 9.1, Informatica Power Center 8.6.1, Informatica Power Exchange, Informatica Power Connect for Netezza, Netezza 4.5.2, Oracle 11i/10g, SQL Server 2005, UNIX, Shell Scripting, DAC, Toad, MS Excel.

Confidential, Atlanta, GA AUG 09 – OCT 10 
Informatica Developer/Analyst

Responsibilities:

• Involved with Business Analysis team in collecting the business requirements based on user specifications and transformed them into ETL Specs.
• Created Design/Technical documents to handle various process and the necessary dependencies so that the developers can refer it as a design document.
• Have worked on ODS/Staging environment in Data ware house projects.
• Fine Tuned the SQL queries using hints for maximum efficiency and performance.
• Interacting with the users and troubleshooting the problems involved with the development of stored procedures, triggers and with the privileges.
• Extracted data from various sources like Flat files, Oracle and loaded it into Target systems Netezza 4.5.1 using Informatica Power Center 8.6.1
• Created Netezza database, users, base table and views using proper distribution key structure.
• Used Informatica Power Exchange for Netezza to pull data from Netezza data warehouse.
• Developed mapping parameters and variables to support connection for the target database as Netezza and source database as Oracle OLTP database.
• Partitioned session for concurrent loading of data in to the target tables.
• Extensively worked with stored procedure, Expression, Filter, Joiner, Source Qualifier, Look up, Router, Update strategy and Aggregator transformations.
• Analyzed performance bottlenecks, tuned various mappings and created reusable transformations to increase the performance.
• Have discussed/finalized standards for various ETL coding.
• Designed and developed complex mappings using various transformations in Designer to load data from Teradata, Flat Files, SQL Server, Oracle 9i into the target Data warehouse
• Developed several Informatica mappings for Extraction/Transformation, data cleansing and loading of data into staging areas and data marts.
• Developed pre-session, post-session routines to drop indexes and to reassign them and batch execution routines to run Informatica sessions.
• Created various tasks, arranging related tasks in different worklets, arranged different worklets in workflow depending upon their interdependencies in workflow manager.
• Developed parameter file templates and used parameters, variables to make mappings more flexible, also developed shell scripts to automate the process.
• Automated sending Car data files to the third party users through FTP
• Performed unit testing and system testing of the mappings developed and documented with various scenarios.
• Used ETL Metadata tables to verify performance of the various sessions used in the workflow and fine tune for the long running sessions.
• Closely worked with the production support team and data team to recover from issues and various defects that encounter while running the jobs and analyzing the data.
• Worked with DAC for job scheduling.

Environment: Informatica Power Center 8.6.1, Netezza 4.5.1, Informatica Power Exchange, Oracle 11i/10g, ERWIN, SQL Server 2005, Teradata , XML files, UNIX , Shell Scripting, DAC, MS Excel.

Confidential, Irving, TX AUG 08 – AUG 09
Informatica Developer/Analyst

Responsibilities:

• Working with Business analysts to understand business/system requirements in order to transform business requirements into effective technology solutions.
• Worked on Informatica tools like Designer, Workflow Manager, and Workflow Monitor.
• Working mostly on Lookup, Aggregator, Router and Expression Transformations to implement complex logics while coding a Mapping.
• Monitoring the Jobs, observing the performance of the individual transformations and tuning the code.
• Creating Indexes on tables for most retrieved fields of tables and views.
• Follow up with appropriate documents for the Change Management, Incident Management, and Problem Management.
• Worked with Informatica and other consultants to develop IDQ plans to identify possible data issues.
• Applied business rules using Informatica Data Quality (IDQ) tool to cleanse data.
• Integrated Informatica Data Quality with Informatica Power Center.
• Installed IDQ on a informatica power center server machine.
• Involved in jobs scheduling, monitoring and production support in a 24/7 environment (with a paging system).
• Made substantial contributions in simplifying the development and maintenance of ETL by creating shortcuts, re-usable Mapplets and Transformation objects.
• Implemented slowly changing dimensions Type 1, and Type 2 methodology for accessing the full history of accounts and transaction information.
• Provided data loading, monitoring, system support and general trouble shooting necessary for all the workflows involved in the application during its production support phase.
• Provided production support by monitoring the processes running daily.
• Created, optimized, reviewed, and executed SQL test queries to validate transformation rules used in source to target mappings/source views, and to verify data in target tables.
• Taken part of Informaticaadministration. Migrated development mappings as well as hot fixes them in production environment.
• Used Informatica scheduling for defining, scheduling, monitoring the jobs.
• Involved in analyzing the year end process and managed the loads that have yearend aggregations.
• Was involved in Informatica Power Exchange to import SQL Server Source.
• Was involved in Informatica Power Exchange to test the data at mainframe .dat files.
• Executed sessions, both sequential and concurrent for efficient execution of mappings and used other tasks like event wait, event raise, email, command and pre/post SQL.
• Created Workflows with worklets, event wait, decision box, email and command tasks using Workflow Manager and monitored them in Workflow Monitor.
• Creating stored procedures, sequences and triggers to insert key into the database table.
• Created Pre/Post Session/SQL commands in sessions and mappings on the target instance.
• Used the command line program pmcmd to run Informatica jobs from command line. And used these commands in shell scripts to create, schedule and control workflows, tasks and sessions.
• Provided detailed technical, process and support documentation like daily process rollback and detailed specifications and very detailed document of all the projects with the workflows and their dependencies.
• Involved in writing shell scripts for file transfers, file renaming and several other database scripts to be executed from UNIX.
• Created documents for data flow and ETL process using Informatica mappings to support the project once it implemented in production.
• Created and Documented ETL Test Plans, Test Cases, Test Scripts, Expected Results, Assumptions and Validations.

Environment: Informatica Power center 8.6.1, Informatica Power Exchange 8.6.1, Oracle 10g/11g, SQL Server 2008, Toad for Oracle,DB2, Flat Files, WinNT 4.0, UNIX, Linux, AIX and Business Objects 6.5, MS Excel.

Confidential, Houston, TX JAN 08– AUG 08 
Sr. Informatica Developer

Responsibilities:

• Coordinated/Managed the development and project implementation and production support activities.
• Participated in business analysis, ETL requirements gathering, physical and logical data modeling and documentation.
• Designing the data transformation mappings and data quality verification programs using Informatica and PL/SQL.
• Extracted source definitions from various databases like Oracle, Sybase, MS SQL Server, MS Access and Flat-files into Informatica repository.
• Developed and Tested Mappings using Informatica Power Center Designer.
• Designed Reusable Transformations and Mapplets. Used most of the Transformations like Source Qualifier, Joiner, Update Strategy, Lookup, Rank, Expressions, Aggregator, Filter, and Sequence Generator for loading the data into Oracle database.
• Designed Workflows, reusable Tasks and Worklets using Informatica Workflow Manager SQL and Database tuning.
• Investigate, debug and fix problems with Informatica Mappings and Workflows, BO reports
• Participated in Decision support team to analyze the user requirements and to translate them to technical team for new and change requests.
• Performed unit and integration testing in User Acceptance Test (UAT), Operational Acceptance Test (OAT), Production Support Environment (PSE) and Production environments.
• Technical Documentation.

Environment: Informatica Power Center 8.1, Oracle 9i, MS SQL Server 2000, PL/SQL, and MS Access.

Confidential, OK Sept 06– Dec 07
Informatica Developer

Responsibilities:

• Involved in gathering the business requirements and molding them in to the technical specifications required for the conversions team.
• Designed ETL mapping based on Existing ETL logic.
• Worked with various transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router transformations.
• Involved in the development of Informatica mappings and also tuned for better performance.
• Extensively used ETL to load data from flat files (excel/access) to Oracle.
• Load balancing of ETL processes, database performance tuning and Capacity monitoring.
• Made adjustments in Data Model and SQL scripts to create and alter tables.
• Worked extensively on SQL, PL/SQL, Perl and UNIX shell scripting.
• Analyzed the source system of ETL Maps.
• Developed the ETL routines.
• Designed and developed the fact/dimension entities.
• Involved in the Unit testing, Event & Thread testing and System testing of the individual
• Co-ordination with Client Business & Systems team for QA.
• Performed the tuning of ETL SQLs.

Environment: Informatica Power Center 7.1.2, Oracle9i, SQL, PL/SQL, SQL*PLUS, SQL Server, UNIX, Windows NT, and MS Excel.

Confidential, MN JAN 06– AUG 06 
Informatica Developer

Responsibilities:

• Worked with Data Modeler to understand the Business Requirements and Business Rules.
• Prepared ETL Specifications to help develop mapping.
• Extracted data from various sources (Flat files, SQL Server, Teradata, DB2 Databases).
• Designed and developed Informatica Mappings and sessions based on business user requirements and business rules.
• Worked extensively on Source Analyzer, Mapping Designer, and Warehouse Designer
• Developed several Mappings using corresponding Sources, Targets and Transformations.
• Creating source and target table definitions using Informatica Designer. Source data was extracted from Flat files, SQL Server Databases
• Analyzing the source data and deciding on appropriate extraction, transformation and loading strategy.
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• Created mappings to read from Flat files, RDBMS and to load into RDBMS tables.
• Based on business Rules Debugged code, tested and validated data after processes are run in development.
• Used Job scheduling software for Batch Scheduling.
• Modified the existing mappings for the updated logic and better performance
• Assisted QA Team to fix and find solutions for the production issues.
• Used UNIX Shell scripts in coding ETL Tasks.

Environment: Informatica 7.1.2 (power center), SqlServer2000, DB2 UDB V8.2, Teradata , Ms-Word, Excel.

Confidential JAN 04– Dec 05
Intern/ Trainee/ Informatica Developer

Responsibilities:

• Developed SQL queries to check the database.
• Creation of Triggers, Stored Procedures, Tables, Indexes, Rules, Defaults etc.
• Interaction with users and getting the enhancement requirements.
• Implementation and maintenance of the product in client sites.
• Worked on Power Center client tools like Source Analyzer, Warehouse Designer, Mapping Designer and Transformations Developer.
• Involved in designing the procedures for getting the data from all systems to Data Warehousing system. The data was standardized to store various Business Units info in tables.
• Creating mappings and different kind of transformations like Source qualifier, Aggregators, lookups, Filters, Sequence Generator, Stored Procedure and Update strategy.
• Involved in writing SQL Stored procedures to access data from Oracle 7.x

Environment: Informatica Power Center 5.1, Oracle 7.x, Flat Files, Erwin, SQL, PL/SQ, UNIX