SUMMARY:

• About 8+ years of experience in Information Technology with a strong background in Database development and Data warehousing and nearly 8 years of experience in ETL process using Informatica Power Center Good knowledge of Data warehouse concepts and principles (Kimball/Inman) - Star Schema, Snowflake, SCD, Surrogate keys, Normalization/De normalization.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server and Worked on integrating data from flat files like fixed width and delimited.
• Have extensively worked in developing ETL for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Well acquainted with Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer.
• Worked extensively with complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups and Aggregators.
• Strong Experience in developing Sessions/tasks, Worklets, Workflows using Workflow Manager Tools - Task Developer, Workflow & Worklet Designer.
• Experience in using the Informatica command line utilities like pmcmd to execute workflows in non-windows environments.
• Extensively used Informatica Repository Manager and Workflow Monitor.
• Experience in debugging mappings. Identified bugs in existing mappings by analyzing the data flow and evaluating transformations.
• Hands on experience in Performance Tuning of sources, targets, transformations and sessions.
• Good experience in documenting the ETL process flow for better maintenance and analyzing the process flow.
• Worked with Stored Procedures, Triggers, Cursors, Indexes and Functions.
• Strong Knowledge in optimizing database performance.
• Experience in UNIX shell scripting, CRON, FTP and file management in various UNIX environments.
• Highly motivated to take independent responsibility as well as ability to contribute and be a productive team member.

TECHNICAL SKILLS:

ETL Tools: Informatica (Power Center/Power Mart ) (Designer, Workflow Manager, Workflow Monitor, Server Manager, Power Connect)

Data Modeling: Erwin, Star Schema Modelling, Snow Flake Modelling

Databases: Oracle, MS SQL Server, DB2

OLAP Tools: Cognos

Languages: SQL, PL/SQL, Unix Shell Script, Visual Basic

Tools: Toad, SQL* Loader

Operating Systems: Windows, AIX, Sun Solaris, Linux

PROFESSIONAL EXPERIENCE:

Confidential, PROVIDANCE, RI

Senior Informatica Developer

Responsibilities:

• Worked closely with the Business Analysts team to understand the User Stories.
• Documented STM (Source to Target Mapping document)
• Developed mappings, sessions and workflows in Informatica Power Center for Universal Extract data load (Claims and Members data)
• Developed Pre session and Post session Command scripts to capture the record counts from SQL Server to WRK and WRK to STG layers.
• Developed Insert Scripts to Insert the Batch Ref Code and Subject Ref Code for each Table to capture the record counts in BATCH AUDIT DTL table
• Created tags and documented Implementation plan and System Support document for each release.
• Involved in migration of code from Dev to Upper environments.
• Worked with the SQA team for defect resolutions.

Environment: Informatica Power Center, Teradata, SQL Server, TIDAL

Confidential, Houston, TX

Senior Informatica Developer

Responsibilities:

• Responsible for understanding the business requirements and Functional Specifications document and prepared the Source to Target Mapping document.
• Worked closely with Business Analyst and involved in Data Analysis to identify the business rules.
• Developed mappings/reusable objects/ transformations by using mapping designer and transformation developer in Informatica Power Center.
• Created a mapping to load the data from DB2 Transactions table in to SQL Server 2008 Pricing Txns table
• Created variable ports and output ports in expression transformations and developed the logic as per the Case statement in the Functional document.
• Validated all the business rules in the Case statement.
• Created Connected and Unconnected Lookup transformations, Expression Transformation, Sequence Generator Transformation, Filter and Aggregator Transformations in the mappings as per the business rules.
• Generated the request file with the Bloomberg Market data key and FTP the file to the Bloomberg site.
• Created another mapping to update the Pricing Txns table with the reply file from the Bloomberg site with the ALT Previous Price, PX Yesterday Close, PX Yesterday High, PX Yesterday Mid Prices.

Environment: Informatica Power Center, DB2, Oracle, SQL, PL/SQL, TOAD, Erwin, SQL SERVER 2008 R2, T-SQL, SQL Navigator, Autosys, Sybase, Service Now

Confidential, Muscatine, IA

ETL/ Informatica Developer

Responsibilities:

• Responsible for gathering business requirements, prepare Source to Target Mapping specifications and Transformation rules.
• Worked closely with Business Analyst and involved in Data Analysis to identify the business rules.
• Data in the target files involves Org Id, Supplier Id, Commodity Code, Parts description and Site Address.
• Developed mappings/reusable objects/ transformations by using mapping designer and transformation developer in Informatica Power Center.
• Created 3 different mappings to load the Direct and Indirect Spend data in to target files.
• Created Connected and Unconnected Lookup transformations, Expression Transformation, Sequence Generator Transformation, Filter and Aggregator Transformations in the mappings as per the business rules.
• Created 3 different sessions for this mappings in a single work flow to load the monthly data.
• Migrated data from Oracle and SQL Server databases.
• Target files have been uploaded in the Co-Experise application to generate reports for Direct and Indirect Spending.
• Created Promote requests to move the objects from Development folder to Volume and Test Repositories.
• Created Unit Test documents for the mappings to test the data load.
• Involved in data validation from Source to staging to Target.
• Conducted UAT with the end users before production release.
• Resolved Defects logged in the Mercury Quality Center during UAT.

Environment: Informatica Power Center, Oracle, SQL, PL/SQL, TOAD, Erwin, SQL SERVER, T-SQL,SQL Navigator, Appworx, JD Edwards

Confidential, Ann Arbor, Michigan

ETL/ Informatica Developer

Responsibilities:

• Worked closely with the end users in writing the functional specifications based on the business needs.
• Responsible for gathering suit of business requirements, prepare Source to Target Mapping specifications and Transformation rules.
• Created Source to Target Mapping Specification Document.
• Involved in system study, analyze the requirements by meeting the client and designing the system.
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Warehouse.
• Extracted data from different sources like SQL Server, Oracle, Flat files and loaded into ODS.
• Designed and developed complex aggregate, join, lookup transformation rules (business rules) to generate consolidated (fact summary) data identified by dimensions using Informatica ETL tool.
• Involved in Performance tuning for sources, targets, mappings, sessions and server.
• Created test cases and completed unit, integration and system tests for Data Warehouse.
• .Generated Reports using Business Objects 6.0 and Crystal Reports.
• Wrote test cases, test conditions for various derivatives and subject areas.

Environment: Informatica Power Center 9.1, DB2, Oracle 11g, SQL, PL/SQL, TOAD, Erwin, SQL SERVER 2008, T-SQL,SQL Navigator, Mercury Quality Center

Confidential

ETL/Informatica Developer

Responsibilities:

• Worked closely with the end users in writing the functional specifications based on the business needs.
• Developed standards and procedures for transformation of data as it moves from source systems to the data warehouse.
• Created Technical design specification documents based on the functional design documents and the physical data model.
• Developed mappings to extract data from Oracle, Flat files, XML files and load into Data warehouse using the Mapping Designer.
• Used Source Analyzer and Warehouse designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target.
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Warehouse.
• Worked on Informatica Power Center 8.6 tool - Source Analyzer, warehouse designer, Mapping Designer, Workflow Manager, Mapplets, and Reusable Transformations.
• Using Informatica Designer designed Mappings, which populated the Data into the Target Star Schema on Oracle 8i Instance.
• Optimized Query Performance, Session Performance and Reliability.
• Extensively used Normalizer, Router, Lookup, Aggregator, Expression and Update Strategy Transformations.
• Involved in the Migration process from Development, Test and Production Environments.
• Debugging invalid mappings using break points, testing of stored procedures and functions, testing of Informatica sessions, batches and the target Data.
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows.
• Identified sources, targets, mappings and sessions and tuned them to improve performance.
• Used Debugger in troubleshooting the existing mappings
• Developed UNIX shell scripts to control the process flow for Informatica workflows to handle high volume data.
• Tuning the Mappings for Optimum Performance, Dependencies and Batch Design.
• Schedule and Run Extraction and Load process and monitor sessions using Informatica Workflow Manager.
• Scheduled the batches to be run using the Workflow Manager.

Environment: Informatica Power Center, DB2, Oracle, SQL, PL/SQL, TOAD, Erwin, SQL SERVER, T-SQL,SQL Navigator, Mercury Quality Center