SUMMARY:

• Over 7+ years of extensive experience with Informatica Power Center in all phases of Analysis, Design, Development, Implementation and support of Data Warehousing applications using Informatica Power Center 9.X/8.X, SQL, Oracle and Unix.

• Experience in full life cycle implementation of Data Warehouses.
• Involved in all the phases Analysis and Design, Data Modeling - ER Diagrams and Normalization, System Testing, Development, documentation and implementation.
• Troubleshooting and problem solving applications with Informatica Debugger and Performing code migration from Dev to Test.
• Experience in Slowly Changing Dimensions (Type 1, Type 2 and Type 3), OLAP, Data Reports and Surrogate keys, and Normalization/De normalization.
• Designed complex mappings using Source Qualifier, Filter, Normalizer, Aggregator, Router, Updated Strategy, Union, Lookup, Joiner, Sorter and Stored Procedure Transformations.
• Hands on experience in Performance Tuning of sources, targets, transformations and sessions.
• Knowledge of working with tools like Toad.
• Worked in Agile, Water Fall Development Methodology.
• Experience in UNIX and WINDOWS environment.
• Highly Proficient in Informatica Designer Components like Source Mapping Designer, Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor.
• Experience in building Enterprise Data Warehouses (EDW), Operational Data Store (ODS), Data Marts, and Decision Support Systems (DSS) using Data modeling tool ERWIN and Dimensional modeling techniques, Star and Snowflake schema addressing Slowly Changing Dimensions (SCDs).
• Strong experience in Extraction, Transformation and Loading of data from multiple sources into Data Warehouse.

TECHNICAL SKILLS:

ETL: Informatica Power Center 8.x/9.x

Scheduling Tool: Autosys

Databases: Oracle11g/10g, MS SQL Server 2005/2000, Oracle SQL * Loader

Operating Systems: Windows 95/98/2000/2003 Server/NT Server Workstation 4.0, UNIX

Other Tools: TOAD, MS Visio

Scripting Languages: UNIX Shell Scripting

Methodologies: E-R Modeling, Star Schema, Snowflake Schema

PROFESSIONAL EXPERIENCE:

Confidential, Franklin, TN

Informatica Developer

Responsibilities:

• Worked with business analysts for requirement gathering (BRD), business analysis, and translated the business requirements into technical specifications to build the Enterprise data warehouse.

• Interacted with both Technical, functional and business audiences across different phases of the project life cycle.
• Developed mappings for fact and dimension tables using the various transformations to extract data from different source databases Oracle, SQL Server.
• Designed and developed complex ETL mappings by making use of transformations like Source Qualifier, Joiner, Update Strategy, Connected Lookup and unconnected Lookup, Rank, Expression, Router, Filter, Aggregator and Sequence Generator transformations.
• Created Workflows using various tasks like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment and worked on scheduling of the workflows.
• Used mapping parameters and variables.
• Prepared mapping specification document, which gives the data flow and transformation logic for populating each column in the data warehouse table.
• Used debugger to analyze the data flow between source and target to fix the data issues.
• Implemented audit and reconcile process to ensure Data warehouse is matching with the source systems in all reporting perspectives.
• Followed Agile Scrum Development Methodology.
• Prepared the Standard Operating Procedure (Knowledge Transfer) document, which provides necessary information, required for the Maintenance and Operation of the application.
• Created the release requests for QA Builds to include all the release requirements and involved in the implementation of QA, UAT and Production releases.
• Provided data loading, monitoring, System support and worked on data issues raised by end user during its production support phase.

Environment: Informatica Power Center 9.5, Oracle 11g, Teradata 13, Flat Files, UNIX Shell Scripting, TOAD, ERWIN, Autosys, Linux.

Confidential, Nashville, TN

Informatica Developer

Responsibilities:

• Interacted with both Technical, functional and business audiences across different phases of the project life cycle.

• Designed and developed conceptual, logical and physical data model of the star schema using VISIO.
• Designed and developed complex ETL mappings by making use of transformations like Source Qualifier, Joiner, Update Strategy, Connected Lookup and unconnected Lookup, Rank, Expression, Router, Filter, Aggregator and Sequence Generator transformations.
• Developed Informatica mappings, sessions and workflows as per the business rules and loading requirements.
• Created Workflows using various tasks like sessions, events raise, event wait, decision, e-mail, command, Worklets, Assignment and worked on scheduling of the workflows.
• Used mapping parameters and variables.
• Prepared mapping specification document, which gives the data flow and transformation logic for populating each column in the data warehouse table.
• Used debugger to analyze the data flow between source and target to fix the data issues.
• Implemented audit and reconcile process to ensure Data warehouse is matching with the source systems in all reporting perspectives.
• Prepared the Standard Operating Procedure (Knowledge Transfer) document, which provides necessary information, required for the Maintenance and Operation of the application.
• Created the release requests for QA Builds to include all the release requirements and involved in the implementation of QA, UAT and Production releases.
• Provided data loading, monitoring, and system support and worked on data issues raised by end user during its production support phase.
• Used Connect: direct to get files from mainframe to UNIX server.
• End-to-end ETL development of the Marketing Data Warehouse.

Environment: Informatica Power Center 8.6.1, Oracle 11g, SQL Server 2008, Oracle SQL * Loader, DB2, XML, Flat files, Toad, UNIX.

Confidential, Nashville, TN

Informatica Developer / Data Analyst

Responsibilities:

• Worked with business analysts for requirement gathering (BRD), business analysis, and translated the business requirements into technical specifications to build the Enterprise data warehouse.

• Interacted with both Technical, functional and business audiences across different phases of the project life cycle.
• Developed mappings for fact and dimension tables using the various transformations to extract data from different source databases Oracle, SQL Server and XML Files.
• Designed and developed complex ETL mappings by making use of transformations like Source Qualifier, Joiner, Update Strategy, Connected Lookup and unconnected Lookup, Rank, Expression, Router, Filter, Aggregator and Sequence Generator transformations.
• Created Workflows using various tasks like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment and worked on scheduling of the workflows.
• Used mapping parameters and variables.
• Prepared mapping specification document, which gives the data flow and transformation logic for populating each column in the data warehouse table.
• Used debugger to analyze the data flow between source and target to fix the data issues.
• Developed PL/SQL procedures, functions to facilitate specific requirement.
• Optimized and Tuned SQL queries and PL/SQL blocks to eliminate Full Table scans to reduce Disk I/O and Sorts.
• Involved in DBMS developments include building data migration scripts using Oracle SQL*LOADER and UTL packages.
• Implemented audit and reconcile process to ensure Data warehouse is matching with the source systems in all reporting perspectives.
• Prepared the Standard Operating Procedure (Knowledge Transfer) document, which provides necessary information, required for the Maintenance and Operation of the application.
• Created the release requests for QA Builds to include all the release requirements and involved in the implementation of QA, UAT and Production releases.
• Developed UNIX Shell scripts, which will send the reports to client over the network by using file transfer protocol (FTP & SFTP) and generating the log file, which will keep the history for the FTP reports.
• Provided data loading, monitoring, System support and worked on data issues raised by end user during its production support phase.

Environment: Informatica Power Center 8.1/ 8.6, Teradata V2R6, Oracle SQL * Loader, Flat Files, UNIX Shell Scripting, TOAD, Appworx 6.0, ERWIN.