SUMMARY

• Around 7+ years of IT experience with a strong background in SDLC and Data Integration tool Informatica Power Center.
• Expertise in Informatica Power Center 9.1/8.6/7.1 extracting data from Oracle, SQL Server, Teradata and DB2 databases.
• Involved in different phases of Data Warehouse Life Cycle including business reporting requirements gathering, source system analysis, logical/physical data modeling, ETL design/development, project deployment, production support.
• Strong ability to analyze source systems and business requirements, identify and document business rules, design data architecture for cohesive decision support and participated in dimensional data models.
• Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes.
• Extensive knowledge of Dimensional Data Modeling like Star and Snowflake schemas, fact and Dimensions tables, physical and logical modelling.
• Very skilled in development of Informatica Mappings and Informatica Workflows.
• Experience with Informatica Advanced Techniques like Dynamic Caching, Parallel Processing to increase Performance throughput.
• Extensively involved in Optimization and Performance Tuning of mappings and sessions in Informatica by identifying and eliminating bottlenecks, partitioning.
• Experience in creating and using Stored Procedures, Functions, Triggers, Views, Synonyms, and Packages in SQL Server 2000/2005/2008, Oracle 10g/9i/8i and DB2.
• Expertise in Unix Shell Scripting and experience on different UNIX platforms.
• Knowledge in developing reports using Business Intelligence tools like Business Objects, SSRS and Cognos.
• Experience in working in an onsite - offshore structure and effectively coordinated tasks between onsite and offshore teams.
• Experience in the full-cycle software development including requirements gathering, prototyping, and proof of concept, design, documentation, implementation, testing, maintenance and production support.
• Excellent communication, documentation and presentation skills using PowerPoint.

TECHNICAL SKILLS

Data Warehousing: InformaticaPowerCenter 9.1/ 8.6.1/8.1.1/7.1 (Source Analyzer, Informatica Power Mart 6.2/5.1,Workflow Manager, Workflow Monitor, Warehouse Designer,Warehouse Designer, Transformation developer, Mapplet Designer, Mapping Designer, Repository manager, Workflow Monitor, and Informatica server, PowerConnect, Power Analyzer, ETL, Cobol, Siebel Warehouse 6.3, Siebel 7.0/2000/5.5, Metadata, Data Mining, Datamart, OLAP, OLTP, SQL* Plus, SQL*Loader.

Databases: IBM DB2,Oracle 11g/10g/9i/8i, MS SQL Server 2008/2000, Teradata 12/10/2.4, DB2, Unix Shell Scripting, SQL, PL/SQL, ANSI SQL, Transact SQL, MS Access 7.0/97/2000

Languages: C, C++, Java, SQL, PL/SQL, HTML, XML, UNIX Shell Scripting

DB Tools: TOAD, SQL Developer

Operating Systems: Windows 98/2000/2003/ NT/XP/2008, MS-DOS, UNIX/LINUX

Microsoft Office suite: Word, Excel, Power Point, Outlook, Access.

Reporting Tools: Cognos, SSRS, BO

PROFESSIONAL EXPERIENCE

Confidential, Chicago IL

ETL/Informatica Developer

Responsibilities:

• Involved in designing Informatica mappings by understanding Business Requirements/Technical Requirement Document (TRD).
• Extracted data from flat files and oracle database, applied business logic to load them in the central oracle database.
• Developed mappings/ReusableObjects/Transformation/mapplets by using mapping designer, transformation developer and mapplet designer.
• Created reusable transformations and mapplets and used them in mappings.
• Used Informatica Power Center for extraction, loading and transformation (ETL) of data in the data warehouse.
• Expertise in designer using mapping, transformations, data validation,using oracle.
• Developed strategies for Incremental data extractions as well data migration to load into the Teradata.
• Implemented slowly changing dimension to maintain current information and history information in dimension tables by using SCD Type 2.
• To change data types in Informatica using XML data types such as Name Spaces, Binary types, Logic types, XML types, Date Time types, Number types.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Worked on different data sources such as Oracle, SQL Server, Flat files etc.
• Scheduling of workflows / Monitoring.
• Migration from several data sources to Oracle Data warehouse.
• Involved in Unit Testing.
• Strong in ETL Unit Testing using MYSQL and Oracle 10g/11g.
• Developed PL/SQL and UNIX Shell Scripts for scheduling the sessions in Informatica.
• Created E-mail notifications tasks using post-session scripts.
• Worked with command line program pmcmd to interact with the server to start and stop sessions and batches, to stop the Informatica server and recover the sessions.
• Wrote SQL, PL/SQL, stored procedures & triggers, cursors for implementing business rules and transformations.
• Expertise in writing and modified UNIX Shell script, .Good Knowledge in writing programming C.
• Created deployment groups, migrated the code into different environments. Worked on reviewing the requirements for project and designs for performance risks.

Environment: Informatica Power Center 9.1 (Power Center Repository Manager, Designer, Workflow Manager, and Workflow Monitor), Teradata, OBIEE, Oracle 11g/10g,, XML,TOAD, SSIS, SQL, PL/SQL, UNIX.

Confidential, Austin TX

ETL/Informatica Developer

Responsibilities:

• Responsible for requirement definition and analysis in support of Data Warehousing efforts.
• Extensively used ETL Tool Informatica to load data from Flat Files, Oracle.
• Developed data Mappings between source systems and target system using Mapping Designer.
• Responsible for error handling using Session Logs, Reject Files, and Session Logs in the Workflow Monitor.
• Developed reusable Mapplets and Transformations.
• Developed and tested all the Informatica mappings and update processes.
• Extensively worked with the Debugger for handling the data errors in the mapping designer.
• Hands on experience with mappings from varied transformation logics like Unconnected and Connected Lookups, Router, Aggregator, Joiner, Update Strategy and Re-usable transformations.
• Created events and tasks in the work flows using workflow manager.
• Responsible for tuning ETL procedures to optimize load and query Performance.
• Setting up Batches and sessions to schedule the loads at required frequency using Power Center Workflow manager.
• 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.
• Migrated development mappings as well as hot fixes them in production environment.
• Created Pre/Post Session/SQL commands in sessions and mappings on the target instance.
• Involved in writing shell scripts for file transfers, file renaming and several other database scripts to be executed from UNIX.
• Created debugging sessions before the session to validate the transformations and also used existing mappings in debug mode extensively for error identification by creating break points and monitoring the debug monitor.
• Worked closely with business analysts and gathered functional requirements.
• Developed Unit test cases and Unit test plans to verify the data loading process.

Environment: Informatica Power Center 8.6, Oracle 10g/11g, DB 2 8.1.6/8.2.0, UNIX, Windows NT 4.0, UNIX Shell Programming, Cognos, PL/SQL, TOAD.

Confidential, Milwaukee WI

ETL/ Informatica Developer

Responsibilities:

• Worked extensively with extraction, transformation and loading of data from different sources to the database.
• Extensively used Informatica Client tools - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Informatica Repository Manager and Informatica Workflow Manager.
• Developed Informatica mappings, mapplets involving transformation such as lookup, router, filter, update strategy, sequence generator, joiner, and stored procedure.
• Worked on creation of tables, views, triggers, stored procedures, functions, sequences in the database using SQL and PL/SQL.
• Created pre-session and post-session SQLs to drop/create indexes for fast loading of the data.
• Implemented the Snowflake Schema Methodology during our Data Modelling.
• Knowledge of Entity-Relationship concept, Facts and dimensions tables, slowly changing dimensions.
• Knowledge of the session logs and handled the rejected load with reject files.
• Performing unit test, functional test and integration test depending upon the environments along with testing team.
• Involved in creation of Low Level Design (LLD) document for Informatica mappings.
• Created and scheduled Sessions, Jobs based on demand, run on time and run only using Workflow Manager.
• Followed Informatica recommendations, methodologies and best practices.

Environment: Informatica Power Center 7.1, SQL Server 2000, PL/SQL, TOAD, UNIX.

Confidential, Foothill Ranch CA

ETL/Informatica Developer

Responsibilities:

• Analyzed business process and gathered core business requirements.Interacted, with business analysts and end users.
• Analyzed business requirements and worked closely with the various application teams and business teams to develop ETL procedures that are consistent across all application and systems.
• Used Informatica designer for designing mappings and mapplets to extract data from SQL Server, Sybase and Oracle sources.
• Created different parameter files and changed Session parameters, mapping parameters and variables at run time.
• Extensively used Source Qualifier Transformation to filter data at Source level rather than at Transformation level.
• Created different transformations such as Source Qualifier, Joiner, Expression, Aggregator, Rank, Lookups, Filters, Stored Procedures, Update Strategy and Sequence Generator.
• Used Debugger to test the data flow and fix the mappings.
• Created and monitored workflows and task using Informatica Power Center Workflow Manager.
• Partitioned Sessions for concurrent loading of data into the target tables.
• Tuned the workflows and mappings.
• Involved in identifying the bottle necks and tuning to improve the Performance.
• Created workflows using Workflow manager for different tasks like sending email notifications, timer that triggers when an event occurs, and sessions to run a mapping.
• Executed Workflows and Sessions using Workflow Monitor.
• Dealt with data issues in the staging flat files and after it was cleaned up it is sent to the targets.
• Actively coordinated with testing team in the testing phase and helped the team to understand the SQL*Plus dependency chain of the whole project.
• Executed the workflow using pmcmd command in UNIX.
• Interaction with the offshore team on a daily basis on the development activities.

Environment: Informatica Power Center 8.6, Oracle 10g/9i/8i, SQL Server 2000, PL/SQL,TOAD, SQL*Plus,Windows, Unix.

Confidential

ETL Informatica Developer

Responsibilities:

• Created mappings and sessions to implement technical enhancements for data warehouse by extracting data from sources like Oracle and Delimited Flat files.
• Applied slowly changing dimensions like Type 1 effectively to handle the delta Loads.
• Used various transformations like Source Qualifier, Expression, Aggregator, Joiner, Filter, Lookup, Update Strategy Designing and optimizing the Mapping.
• Developed Workflows using task developer, worklet designer, and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Created various tasks like Session, Command, Timer and Event wait.
• Modified several of the existing mappings based on the user requirements and maintained existing mappings, sessions and workflows.
• Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.
• Prepared SQL Queries to validate the data in both source and target databases.
• Worked on TOAD and Oracle SQL Developer to develop queries and create procedures and packages in Oracle.
• Worked extensively on PL/SQL as part of the process to develop several scripts to handle different scenarios.
• Created Test cases for the mappings developed and then created integration Testing Document.
• Prepared the error handling document to maintain the error handling process.
• Automated the Informatica jobs using UNIX shell scripting.
• Closely worked with the reporting team to ensure that correct data is presented in the reports.

Environment: Informatica 7.1, Oracle 9i, PL/SQL, SQL Server, DB2, MS Excel, UNIX Shell Scripting, TOAD.