SUMMARY

• 7 years of experience in Analysis, Design, Development of various business applications in different platforms InformaticaPower Center 9.1/8.x, Informatica, InformaticaPower Exchange for DB2, Informatica Mapping Architect for Visio, Oracle11g and Microsoft SQL Server 2008 R2.
• Experience in Application Design, Data Extraction, Data Acquisition, and Implementations and Testing of Data warehousing.
• Expertise in using Informatica 9.1, 8.6x/8.1 (Repository Manager, Server Manager, Mapping Designer, Workflow Manager, Workflow Monitor, Transformation Developer, Source Analyzer).
• Good working knowledge of OLTP systems, Analysis E - R Modeling, Data Modeling using data modelers, Star schema, Snowflake schema, Fact and dimensions table using ERWIN.
• Extensively used Source Qualifier, Application Source Qualifier, Connected and Unconnected Lookup, Normalizer, Router, Filter, Expression, Aggregator, Stored Procedure, Sequence Generator, Sorter, Joiner, Update Strategy, Union Transformations, Mapplets.
• Experience in Mappings, Mapplets, Worklets, Reusable Transformations, Sessions/Tasks, Workflows and Batch Processes in Informatica Server.
• Extracted data from multiple operational sources for loading staging area, Data warehouse, Data Marts using SCDs (Type 1/Type 2/ Type 3) loads.
• Involved in PL/SQL Programming (Stored Procedures, Triggers, and Packages) Using Oracle.
• Also have good knowledge in Performance Tuning at both Database Level and Informatica.
• Good Experience in UNIX Shell Scripting and ETL Process Automation Using Shell Programming.
• Strong logical and Analytical Reasoning Skills, Excellent Communication with Good Listening Presentation and Intrapersonal Skills.
• Strong business understanding of verticals like Banking, Insurance, Mutual funds and Pharmaceuticals.
• Excellent problem solving skills with a strong technical background and good interpersonal skills.
• Quick learner and excellent team player, ability to meet tight deadlines and work under pressure
• Experience in development of Client/Server applications, Oracle, SQL Server, and MS Access.
• Excellent documentation and presentation skills using tools like Visio and PowerPoint.

TECHNICAL SKILLS

ETL Tools: Informatica 9.1/8.x Power Center/Power Mart/Power Exchange for SAP and PowerExchange

Data Modeling: Star Schema, Snow Flake Schema, MS Visio

Databases: Oracle 11g/10g MS SQL Server 2005/2008, DB2, Sybase

Languages: T-SQL, PL/SQL, Unix Shell Script.

DB Tools: Toad, SQL* Loader, DB Visualizer, SQL Navigator

Scheduling Tools: TWS, Informatica Scheduler

Operating Systems: Windows 2003/2000/NT, AIX, Sun Solaris, UNIX, Linux.

PROFESSIONAL EXPERIENCE

Confidential, Boise, ID

ETL Developer

Responsibilities:

• Identified the sources, targets and developed ETL mappings using Informatica 9.1.
• Attended multiple requirement gathering discussions and created Source to Target Detailed Design Documents and also developed Mapping Architect Diagrams using Informatica Visio.
• Performance Tuning at both Database Level and Informatica.
• Worked with Offshore Development team in guiding them and also participated in Daily Scrum meetings with the Manager to keep updated on the status.
• Incorporated various transformations, Lookups, Expressions, Routers, Sequence generators, Mapplets, dynamic lookups and reusable transformations, Mapplets, Mapping Parameters in ETL maps.
• Worked extensively with complex mappings using expressions, aggregators, filters, lookup and procedures to develop and feed in Data Warehouse.
• Created One - time Load workflows as well as Delta Daily workflows to load into the EDW, by using the MD5 checksum logic.
• Developed complex Stored Procedures, Packages, Triggers, Cursors and Shell Scripting in Informatica.
• Performed Unit Testing the mappings and workflows and created Unit Test Results and also conducted self review and peer review of the code and test results.
• Developed sessions, workflows which involve command tasks to invoke the ETL.
• Successfully completed Phase1 of the project.

Environment: Informatica Power Center 9.1, Informatica Mapping Architect for Visio, Microsoft SQL Server 2008 R2, Oracle 11g/10g, IBM Db2 V9.5, Microsoft Visio, Toad 9.0, Power Exchang

Confidential, Wilmington, DE

ETL Developer

Responsibilities:

• Worked since the Requirement Phase and played a major role in gathering the documents from the business users as per the ETL needs.
• Played a vital role in Data analysis of the Legacy data structures and ODS data structures.
• Played a vital role in organizing the team meetings.
• Developed complex ETL mappings like slowly changing dimensions, Fact tables and aggregated tables with Dynamic Lookups using various stages like Expressions, Routers, Update Strategies, Sequence Generator and Mapping parameters/variables global to that mapping.
• Implemented Archival Strategy to hold data up to 13 months.
• Developed Control Files and Data files using SQL loader and successfully loaded the data from the flat files into the main tables.
• Responsible for creating and maintaining the stored procedures. Creating data base objects like tables, indexes, Views and Sequences.
• Created several complex PL/SQL Packages, Procedures, Triggers and Functions to implement business logic at front end and also perform validations on the imported data from legacy system.
• Improved Performance of database queries and ETL maps using various Optimization Techniques like Query Tuning, avoiding unnecessary/repetitive database calls, persistent cache, and Modifying Buffer size at session level.
• Responsible for Backup recovery to all the mappings, sessions and workflows at the repository server.
• Worked on PL/SQL code optimization techniques and error handling mechanisms.
• Worked on SQL Tuning using Explain Plan and TKPROF.

Environment: Informatica Power Center 9.1/8.6.1, SQL server, Oracle10g, PL/SQL, Shell Scripting, Toad, UNIX, Windows XP.

Confidential, Cleveland, OH

ETL Developer

Responsibilities:

• Interacted with Business Users and understood the design requirements of the users.
• Used different kinds of transformations like Router, Sorter, Source Qualifier, Joiner, Aggregator, Lookups both Connected and Unconnected Lookups, Expression, Expression, Sequence Generator, Union, Update Strategy to load data into target tables.
• Extensively used Power exchangeto import source files from Mainframe systems
• Extensively used ETL to load data from wide range of source such as flat files, Mainframes to DB2.
• Used Debugger in troubleshooting the existing mappings.
• Extensively used Toad for DB2 for executing the queries.
• Used IBM Rational Clear Quest to track the Incidents.
• Implemented both SCD s (Slowly Changing Dimensions) TYPE - 1 and TYPE-2.
• Used Mapping Parameters and Variables, Dynamic parameter files, Shortcuts, Reusable Transformations.
• Involved in migrating folders from Development to Testing and from Testing to Production Environments, creating Connect Strings and synchronizing the Connect Strings and Connection Objects in Dev, Test and Prod environments.
• Involved in Unit Testing and created Test Cases for those mappings.
• Worked with QA Team and helped in Testing at Integration Level.
• Extensively used various tasks like Session task, Event Wait task, Decision task, Email task, Command task.
• Created UNIX shell scripts to run session workflows for Informatica mappings.

Environment: Informatica Power Center 8.6.1, Informatica Power Center, Power Exchange, DB2, Oracle 10g, SQL, PL/SQL,, UNIX, Toad, Windows XP.

Confidential, Richmond, VA

Informatica Developer

Responsibilities:

• Involved in the development of system requirements and design specifications.
• Interacted with the users to evolve the Security matrix for the system based on role - based-access.
• Rational Unified Processing approach was used for the Object Modeling.
• Verified the functional aspect as per the Business Process and validated the user interfaces.
• Developed complex mappings in Informatica to load the data from source tables using different transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Joiner, Filter, Stored Procedure and Router.
• Involved in snowflake and star schema using data modeling tool Erwin 3.0.
• Developed Mapplets to implement business rules that involved complex logic.
• Created and scheduled Sessions and Workflows through the Informatica Workflow Manager.
• Setup folders, groups, users,and permissions, performed Repository administration using Repository Manager
• Designed and documented the validation rules, error handling and test strategy of the mappings.
• Tuned the mappings and sessions for better performance by eliminating various performance bottlenecks.
• Maintained effective communication with non-technical client personal and handled the change requests.
• Worked with mapping variables, Mapping parameters and variable functions like Set Variable, SetCountVariable, SetMinVariable and SetMaxVariable.
• Developed Re-usable transformations, Mapplets to use them for data load to data warehouse and database (Oracle).
• Developed and tested all the mappings that have complex lookups and update strategies.

Environment: Informatica Power Center 8.1.1,Oracle 10g, SQL,PL/SQL, Linux, Unix, Toad, Shell Scripting, Window XP.

Confidential

DB Developer

Responsibilities:

• Involved in End to End development of OLTP (Online Transactional Processing).
• Resolved many database bottlenecks like deadlocks at database due to circular references among entities, the performance issues with de - normalization and resolved many to many and self recursive issues with complex business data flow.
• Developed ETL design spec based on business requirement specifications.
• Documentation at every stage of the software development life cycle.
• Coordinated with DBAs and UNIX administrators in setting up the physical databases.
• Using Oracle 10g and Informatica 7.1.3 for data based needs and ETL.
• Incorporated various transformations, Lookups, Expressions, Routers, Sequence generators, Mapplets, dynamic lookups and reusable transformations in ETL maps
• Developed various Stored Procedures, Functions, Packages and Materialized views for ETL needs.
• Performed Database/ETL migrations from Dev environment to Test/Training/ UAT/Staging and PROD environments.

Environment: Informatica Power Center 8.1,SQl Server, Oracle 9i, SQL, DB2.