SUMMARY

• Over Six years of Experience in IT Industry with Data warehousing tools using industry accepted methodologies and procedures.
• Extensive experience in Insurance, Pharmacy and Healthcare domains.
• Expert knowledge in working with Informatica Power Center 9.0/8.6/8.1/7.1/6.2 (Repository Administrator console, Designer, Workflow manager, workflow monitor)
• Knowledge in Dimensional Data Modeling (Star Schema, Snow - flake Schema, FACT and Dimension tables), Logical and Physical Data Modeling using Erwin.
• Experience in creating Transformations (Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank) and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Experience with data extraction, transformation and loading from different data sources into a Staging, Data Warehouse & Data Marts using Informatica.
• Well Experienced in doing Error Handling and Troubleshooting using various log files.
• Extensively worked on developing and debugging Informatica mappings, mapplets, sessions and workflows.
• Worked on Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Experience in Netezza, Oracle 8i/9i/10g, SQL server, PL/SQL, and UNIX & Windows operating system.
• Extensively used SQL and PL/SQL to write Stored Procedures, Functions, Packages and Triggers.
• Good exposure to Development, Testing, Debugging, Implementation, Documentation, End-user training and Production support.
• Ability to prioritize multi task, self-motivated and able to work independently and as a member of a team.
• Possess excellent written and verbal communication skills coupled with good inter-personal skills.
• Ability to work and communicate effectively with both Business and Technical audiences.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 8.x/7.x.

Data Modeling: ERWIN, Star-Schema Modeling, Snowflake Modeling, FACT & Dimension Tables

Reporting Tools: Business Objects, Crystal Reports

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

Operating Systems: Windows 2000/2003/XP/Vista/Windows7, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Chaddsford, PA

Informatica Developer

Responsibilities:

• Involved in the Development of logical and physical data model in Netezza using ERWIN based on the requirements and data sources.
• Created mapping specification document and Developed ETL data packages from Source to Stage tables and then from Stage to Target tables. These packages were used to manage internal financial data as well as outsourced Clinical data.
• Assisted in estimation and planning of all design and development activities.
• Created ETL mappings and transformations to reflect business rules to move data from multiple sources into target area. Source systems are mainly flat files and Excel files.
• Created and executed VB Scripts to define ranges for the excel sources.
• Developed various Mappings, Mapplets, and Transformations for Data warehouse.
• Worked with the reporting team to help understand them the user requirements on the reports and the measures on them.
• Performed data manipulation using basic functions and Informatica Transformations.
• Scheduled the Jobs using Tidal scheduler and monitored all the sessions that were running, scheduled, completed and failed. Trouble shooted the long running sessions and fixed the issues.
• Involved in data quality testing and Data validation.
• Migrated repository objects, services and scripts from development environment to test and production environment. Extensive experience in troubleshooting and solving migration issues and production issues.

ENVIRONMENT: Informatica Power center 9.0, Netezza, Tidal 5.3.x, Windows 7, Erwin, SQL Server.

Confidential, MA

ETL Developer

Responsibilities:

• Involved in analysis of BRD, FRD and Specs for the mappings
• Extensively used Informatica Power Center Designer, Workflow Manager, Workflow Monitor and Repository Manager on a daily basis
• Extensive knowledge and experience on various tools of designer that include Mapping Designer, Mapplet Designer, Source Analyzer, Target Designer and Transformation Developer
• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent sessions and scheduling them using Informatica Scheduler to run at specified time with required frequency.
• Used various Transformations like Lookup, Filter, Joiner, Aggregator, Expression, Router, Sequence generator, Normalize in the mappings.
• Used Mapping parameters and Variables in conjunction with various functions and also with Parameter files to produce desired results.
• Tuned the Mappings using different methods so as to improve session performance.
• Developed several Workflows, Tasks, Sessions, and Worklets in Workflow Manager and scheduled them to run according to Business Requirements.
• Used knowledge of Ralph Kimball’s methodology of SCD to store history.
• Extensively tested the mappings by running the queries against Source and Target tables and by using break points in the debugger.
• Created shortcuts, copies of Mappings, Workflows, various objects as per requirements and made use of shared folder objects.

Environment: Informatica Power Center 8.6, Windows 2000, Microsoft Excel, Erwin, Netezza.

Confidential, CA

ETL Developer

Responsibilities:

• Extensively used Informatica Power Center for Extracting, Transforming, and Loading into different databases.
• Created mappings using Informatica designer, sessions using workflow manager and tested the sessions using test data. Analyzing the data model and identification of heterogeneous data sources.
• Created necessary test plans and design documents for the mappings.
• Designing, developing of different mappings according to the requirements and tested the mappings using various test cases in the test plans.
• Wrote PL/SQL stored procedures for implementing business rules and transformations.
• Created post-session and pre-session shell scripts and mail-notifications.
• Used Informatica features to implement Type II changes in slowly changing dimension tables. Worked extensively on different types of transformations like Source Qualifier, Expression, Filter, Aggregator, Rank, Lookup, Update Strategy, Stored Procedure, Sequence Generator and Joiner.
• Wrote stored procedures using PL/SQL for incremental updates.
• Integrated various sources into the staging area in Data Warehouse.
• Development of Informatica mappings and Mapplets and also tuned them for Optimum performance, Dependencies.
• Extensively used ETL to load data from Flat Files to Staging area (Oracle 9i) using Informatica Power Center 7.1.
• Moving of mappings and sessions from development repository to production repository
• Involved and Extensive knowledge in full develop of Development Life Cycle

Environment: Informatica Power Center 7.x, PL/SQL, Oracle 8i, HP UNIX, Windows XP.

Confidential

ETL Developer

Responsibilities:

• Participated in requirement gathering, business analysis, user meetings, discussing the issues to be resolved and translating user inputs into ETL design documents
• Analyze Design, Develop, Test and implementation of Informatica Transformations and Workflows for extracting the data from the multiple sources
• Developed extraction mappings to load data from Source systems to ODS to Data Warehouse
• Developed complex mappings in Informatica to load the data from various sources using different transformations
• Documented the mappings used in ETL Code
• Designed and Developed the Informatica workflows/sessions to extract, transform and load the data into Target
• Wrote SQL scripts, PL/SQL stored procedures .
• Developed procedures to populate the customer data warehouse with transaction data, cycle and monthly summary data, and historical data
• Optimize SQL queries for better performance
• Worked with different Informatica tuning issues and fine-tuned the transformations to make them more efficient in terms of performance
• Worked on UNIX shell scripts Developed UNIX shell scripts to run the PMCMD functionality to start and stop sessions

Environment: Informatica Power Center 71, Oracle 9i, SQL, PL/SQL, TOAD, MS SQL Server, SQL*Plus, Windows 2000, UNIX, Shell Script.