SUMMARY

• Over 6 years of hands - on experience in development and design of ETL methodology for supporting data transformations & using Informatica Power Center
• Over 5 Yrs of experience in diversified fields in Data Warehousing.
• Worked on various projects involving Data warehousing using Informatica Power Center 8.6/8.0/7.1 (Workflow Manager, Workflow Monitor, Server Manager, Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer & Transformation Developer)
• Expertise in designing and developing mappings from varied transformation logic using filter, expression, rank, router, aggregator, joiner, lookup, and update strategy.
• Involved in the data analysis for source and target systems and good understanding of Data Warehousing concepts, Data Modeling, staging tables, Dimensions, Facts and Star/Snowflake Schema.
• Expertise in Developing Mappings, Define Workflows &Tasks, Monitoring Sessions, Export & Import Mappings and Workflows.
• Experience in performance tuning of Informatica Sources, Targets, Mappings, Transformations and Sessions.
• Extensive experience Trouble shooting and Tuningperformances in mappings, targets, sources and sessions.
• Understanding in administration functions in repository manager
• Understanding in Informatica ILM and Data Masking concepts
• Experience in Oracle 11g/10g/9i/8i, Oracle SQL, PL/SQL Programming and TOAD.
• Knowledge of complete software development life cycle including Requirement Analysis, Requirement Gathering, Project Management, Design, Development, Implementation and Testing.
• Experience in working wif Unix shell scripting
• Highly analytic problem solver proficient in evaluating business and technical processes and issues, developed and implemented system enhancements to facilitate overall operations.
• Excellent analytical and communication skills
• Great learning skills to adapt the rapid changing technologies and implementing the same at work
• Good team player and also have ability to work independently in a time sensitive environment.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 6.0/7.0/8.0/8.6/9.1

Oracle Utilities/Tools: Oracle 11g/10g/9i/8i, SQL*Plus, Toad

Programming Languages: SQL and PL/SQL

Office Tools: MS PowerPoint, MS Word, MS Excel

Operating Systems: Windows NT/2000/XP, UNIX

PROFESSIONAL EXPERIENCE

Confidential

Informatica Developer

Responsibilities:

• Extensively used Informatica Power Center 9.1 as ETL tool for developing project.
• Worked wif various Informatica client tools like Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Workflow Manager.
• Developed various procedures to Extract, Transform and Load (ETL) the data into the system.
• Created complex mappings using various transformations like SQL filter, sorter, aggregator, expression, union, joiner, router, SQL and Look up.
• Coding and unit testing of Informatica mappings for various stages of ETL
• Designed and Developed data validation, load processes using PL/SQL, Stored Procedures, Functions, and Triggers using Oracle 11g.
• Wrote complex PL/SQL subprograms, packages, procedures, functions and DB triggers to implement the business logic.
• Integrated the Backup status reporting for the entire database in the enterprise to enable the web reporting using Oracle SQL, PL/SQL and Korn shells, Unix shell Scripting
• UNIX Shell scripting for backup and monitoring of databases.
• Responsible for the development, implementation and support of the database of the server.

Environment: Informatica Power Center 9.1, SQL, PL/SQL, Toad 9.7.2, Windows 7, UNIX Shell Scripting.

Confidential, Morrisville, NC

Informatica Developer

Responsibilities:

• Interacted wif business users, source system owners and Designed, implemented, documented ETL processes and projects completely based on best data warehousing practices and standards.
• Designed and developed Informatica Mappings and implemented business rules and Involved in testing of Informatica workflows and also the target data.
• Created Workflow, Worklets and Tasks to schedule the loads at required frequency using Workflow Manager
• Created Sessions, reusable Worklets and workflows in Workflow Manager and Scheduled workflows
• Provided production support and involved wif root cause analysis, bug fixing and promptly updating the business users on day-to-day production issues.
• Testing for the Data integrity and Consistency
• Prepared and maintained mapping specification documentation.

Environment: Informatica 9.1, Teradata, BTEQ, UNIX Shell Scripting, Windows 7

Confidential, Tampa, Florida

Informatica Developer

Responsibilities:

• Extensively used Informatica Power Center 8.6.1 as ETL tool for developing project.
• Worked wif various Informatica client tools like Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager, Workflow Manager and Workflow Monitor
• Worked on Star Schema modeling, Snowflake modeling to design Fact and Dimension tables.
• Data Loaded from different Flatfiles, Oracle and Sql Server wif different Transformations.
• Worked in developing various reusable transformation mappings
• Designed various workflows by using event raise and event wait to specify the path to target tables
• Implemented Type-1,Type-2 and Type-3 mappings depending on the requriments to populate the slowly changing dimension tables.
• Created Sessions, reusable Worklets and workflows in Workflow Manager and Scheduled workflows and sessions at specified frequency.
• Worked on Incremental Aggregation for Improving Performance in Mapping and Session level.
• Responsible for monitoring all the sessions that are scheduled, running, successful and failed.
• Involved in debugging the Mappings that failed.
• Moving the mappings and workflows to staging and then production environment and testing the process at every level.
• Redesigned some of the mappings in the system to meet new functionality
• Used SQL tools like TOAD to run SQL queries and validate the data in warehouse

Environment: Informatica 8.6.1, Oracle 11g/10g, SQL Navigator, PL/SQL, SQL*Plus,, UNIX Shell Scripting, windows XP

Confidential, Tampa, Florida

Informatica Developer

Responsibilities:

• Created workflows and tasks in Workflow Manager and linked the database through server setup and various other connections. Created users in Informatica, assigned them various permissions.
• Developed mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Joiner, Aggregator, Update Strategy, Rank, Router, Lookup, Sequence Generator, Filter, Sorter, Source Qualifier.
• Responsible in retrieving data by using data warehousing techniques like snowflake schema and star schema
• Handleslowly changing dimensionsof Type 2 to populate current and historical data to Dimensions and Fact tables in the data warehouse.
• Developed Informatica mappings, re-usable transformations, re-usable mappings and Mapplets for data load to data warehouse.
• Developed Mappings using Designer toextract, transformdata according to the requirements and loaded into database.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Created sequential/concurrent Sessions/ Batches for data loading process and used Pre & Post Session SQL Script to meet business logic.
• Configured workflows wif Email Task, which would send mail wif session, log for Failure of a sessions and for Target Failed Rows.
• Analyzed the session and error logs for troubleshooting Data mappings and sessions.
• Used the Debugger to run Debug sessions setting Breakpoints across instances to verify the accuracy of data.
• Responsible for monitoring all the sessions and debugged the mapping of the failed session to check the progress of data load.
• Co-ordinated wif the off-shore teams and mentored junior developers.

Environment: Informatica Power Center 7.1, TOAD, SQL Navigator, SQL*Plus, UNIX Shell Scripting, HTML, SQL Server 2000, windows XP

Confidential

Informatica Developer

Responsibilities:

• Worked wif Data Modeler to understand the Business Requirements and Business Rules Subjected to Business.
• Prepared ETL Specifications to help develop mapping.
• Extracted data from various sources (Flat files, SqlServer, 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. And Created source and target table definitions using Informatica Designer.
• Source data was extracted from Flat files, SqlServer and DB2 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.
• Modified the existing mappings for the updated logic and better performance.
• Developed Logical Data Flow Diagrams in Visio for every mapping that is developed.
• Assisted QA Team to fix and find solutions for the production issues.

Environment: Informatica Power Center, SQL, PL/SQL, Oracle 9i, SQL Developer, Linux Version 9.2, Windows XP, Sun Solaris, TOAD 9i, UNIX