SUMMARY

• 7.5 years of work experience in Information Technology as Informatica Developer with strong background in ETL Data warehousing experienced using Informatica PowerCenter 9.1/ 8.x/ 7.x.
• Extensive experience in developing complex mappings from varied transformations like Router, Filter, Sorter, Connected and Unconnected lookups, Normalizer, Expression, Aggregator, Joiner, Union, Update Strategy, Stored Procedure and Sequence Generator etc.
• Expertise in design and implementation of Slowly Changing Dimensions (SCD) type1, type2, type3.
• Experienced in loading data, troubleshooting, Debugging mappings, performance tuning of Informatica (Sources, Targets, Mappings and Sessions) and fine - tuned transformations to make them more efficient in terms of session performance.
• Database experience using Oracle 11g/10g/9i, MS SQL Server 2000 and MS Access.
• Strong experience using SQL, PL/SQL Procedures/Functions, Triggers and Packages.
• Experience in UNIX Operating System and Shell scripting.
• Working knowledge of data warehouse techniques and practices, experience including ETL processes, dimensional data modeling (Star Schema, Snow Flake Schema, FACT & Dimension Tables), OLTP and OLAP.
• Experienced in all data processing phases, from the Enterprise Model, Data Warehousing (ETL)
• Excellent skills in fine tuning the ETL mappings in Informatica.
• Extensive experience in extracting the data using facets database and using tool such as SQL *Plus, SQL * Loader
• Good knowledge of business intelligence tool Cognos.
• Excellent communication, presentation, project management skills, a very good team player and self-starter with ability to work independently and as part of a team.

TECHNICAL SKILLS

ETL Tools: Informatica 9.5/9.1//8.x/7.x (PowerCenter/PowerMart) (Designer, Workflow Manager, Workflow Monitor, Server Manager, Power Connect)

Data Modeling: Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake, Fact, Dimensions), Entities, Attributes, Cardinality, ER Diagrams.

Databases: Oracle 11g10g/9i, MS SQL Server 2008/2005, MS Access and DB2

Languages: SQL, PL/SQL, C, Data Structures, Facets, Unix Shell Script, Visual Basic

Web Technologies: HTML, XML,Web application, SOAP, Java Script

Tools: SQL plus, PL/SQL Developer, Toad, SQL* Loader, Active Batch

Operating systems: Windows NT/2000/2003/XP/VISTA/7,UNIX,MSDOS and LINUX

PROFESSIONAL EXPERIENCE

Confidential, Norfolk, VA

Sr. ETL/Informatica Developer

Responsibilities:

• Gathered user Requirements and designed Source to Target data load specifications based on Bussiness rules.
• Used Informatica Power Center 9.5 for extraction, loading and transformation (ETL) of data in the datamart.
• Designed and developed ETL Mappingsto extract data from flat files, MS Excel and Oracle to load the data into the target database.
• Developing several complex mappings in Informatica a variety of PowerCenter transformations, Mapping Parameters, Mapping Variables, Mapplets & Parameter files in Mapping Designer using Informatica PowerCenter.
• Extensively used ETL processes to load data from various source systems such as DB2, SQL Server, SQL Tunning and Flat Files, facets, XML files into target system applying business logic on transformation mapping for inserting and updating records when loaded.
• Experience in migration Informatica objects from 9.1 to 9.5.
• Experience in Informatica upgrade testing, troubleshoot and resolve issues.
• Created complex mappings in the designer and monitored them. The mappings involved extensive use of Aggregator, Filter, Router, Expression, Joiner, Union, Normalizer and Sequence generator transformations.
• Ran the workflows on a daily and weekly basis using Active Batch Scheduling tool.
• Examined the workflow log files and assigning the ticket to the Informatica support based on the error.
• Experience in developing Unix Shell Scripts for automation of ETL process.
• Performed operational support and maintenance of ETL bug fixes and defects.
• Maintained the target database in the production and testing environments.
• Supported migration of ETL code from development to QA and QA to production environments.
• Migration of code between the Environments and maintaining the code backups.
• Designed and developed Unix Shell Scripts, FTP, sending files to source directory & managing session files
• Done extensive testing and wrote queries in SQL to ensure the loading of the data.
• Developed PL/SQL code at the database level for the new objects using SOAP

Environment: Informatica Power Center 9.5, Oracle 10g/9i, SOAP, PL/SQL, SQL Tunning, Flat files, Facets, XML, MS Access, SQL Server 2008, VSS, ER STUDIO, Active Batch

Confidential, Kansas City MO

Sr.ETL/Informatica Developer

Responsibilities:

• Gathered user Requirements and designed Source to Target data load specifications based on Bussiness rules.
• Used Informatica PowerCenter 9.1 for extraction, loading and transformation (ETL) of data.
• Designed and Implemented the ETL Process using Informatica power center.
• Involved in Data Extraction from Oracle, SOAP, Flat files using Informatica.
• Extracted data from FACETS.
• Experience in analysis members and providers data.
• Used Source Analyzer and Warehouse designer to import the source and target database schemas.
• Created mappings from source systems to target systems. Implemented Join, Expression, Aggregate, Sort, Rank, Lookup, Update Strategy, Filter and Router Transformations in Mappings.
• Worked on Designer tool - Source Analyzer, warehouse designer, Mapping Designer & Mapplet Designer and Transformation Developer.
• Involved in complete software development life cycle (SDLC) of the project.
• Mapplets and Reusable Transformations were used to prevent redundancy of transformation usage and maintainability.
• Creating Reusable Transformations and Mapplets in a mapping.
• Involved in Creating tasks, worklets, workflows and Schedule, Run, Monitor sessions by using workflow manager and workflow monitor.
• Worked on moving mappings from Development to Test and from Test to Production environments.
• Migrated Mappings, Sessions, and Workflows from Development to Test and then to Production environment.
• Identified and fixed the Bottle Necks and tuned the Mappings and Sessions for improving performance. Tuned both ETL process as well as Databases.
• Created and monitored sessions and batches to run the mappings.

Environment: Informatica PowerCenter 9.1, SQL Server 2008, Facets, Windows Xp, SOAP, Oracle 11g, VSS

Confidential, Milpitas, CA

ETL Informatica Developer

Responsibilities:

• Interacted with Business Analysts to understand the requirements and the impact of the ETL on the business.
• Worked with data modelers in preparing logical and physical data models and adding/deleting necessary fields using Erwin.
• Extracted data from flat files and oracle database, applied business logic to load them in the central oracle database.
• Developed mappings/Reusable Objects/Transformation/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica Power Center.
• Created reusable transformations and mapplets and used them in mappings.
• Implemented slowly changing dimensions to maintain current information and history information in dimension tables.
• Involved in creation of Folders, Users, Repositories, Deployment Group using Repository Manager.
• Worked on different data sources such as Oracle, SQL Server, SOAP, Flat files etc.
• Developed PL/SQL and UNIX Shell Scripts for scheduling the sessions in Informatica.
• Created E-mail notifications tasks using post-session scripts.
• Wrote SQL, PL/SQL, stored procedures & triggers, cursors for implementing business rules and transformations.
• Used Change Data Capture to implementincremental load.
• Created various reports in report studio and packages in framework manager.
• Generated various reports like List, Crosstab, Chart, Master detail, Drill through reports in report studio.
• Provided support to develop the entire warehouse architecture and plan the ETL process.

Environment: Informatica Power Center 9.1/ 8.6.1, Oracle 11g/10g, SQLServer2008, PL/SQL, XML, MS Access, SQL Aginity, UNIX, SOAP, UDB DB2 8.1, Autosys

Confidential, Pleasanton CA

ETL Informatica Developer

Responsibilities:

• Designed and Implemented the ETL Process using Informatica power center.
• ETL flows are developed from Source to Stage, Stage to Work tables and Stage to Target Tables.
• Worked in developing Mapplets and Re-usable Transformations for reusability and reducing effort.
• Created Work Flows with Command Tasks, Worklets, Decision, Event Wait and Monitored sessions by using workflow monitor.
• Migrated Informatica Folders from Development Environment to Test and System Test Environment and Worked with Admins to migrate the same to Production environments.
• Wrote PL/SQL procedures for reconciliation of financial data between source and target to automate testing phases and help business for preliminary validation.
• Wrote UNIX scripts, environment files for Informatica.
• Developed Metadata driven code for effective utilization and maintenance using SOAP & technical metadata, business metadata and process metadata.
• To externalize the business logic instead hardcoding in the mapping I have used Parameter file in Informatica.
• Generated Cognos reports to test standardized reports as per business requirements.
• Tuned Mappings and Mapplets for best Performance on ETL Side and Created Indexes and Analyzed tables periodically on Database side.
• Organized the data flow and developed many Control M jobs for Scheduling Jobs and moved to production.
• Primary resource in Production support team so, involved in emergency calls when application outage occurred and resolved defects when raised.

Environment: Informatica PowerCenter 8.6.0, SQL Server 2005, Oracle 10g, MS Excel, MS Access, Flat Files, Cognos 8.0, SQL Dev, Toad, Unix, Windows XP, SOAP, Erwin, Control M.

Confidential, Richmond, VA

Jr. Informatica Developer

Responsibilities:

• Designed and Implemented the ETL Process using Informatica power center.
• Involved in Data Extraction from Oracle, Flat files using Informatica.
• Worked on Designer tool - Source Analyzer, warehouse designer, Mapping Designer & Mapplet Designer and Transformation Developer.
• Involved in complete software development life cycle (SDLC) of the project.
• Mapplets and Reusable Transformations were used to prevent redundancy of transformation usage and maintainability.
• Creating Reusable Transformations and Mapplets in a mapping.
• Involved in Creating tasks, worklets, workflows and Schedule, Run, Monitor sessions by using workflow manager and workflow monitor.
• Worked on moving mappings from Development to Test and from Test to Production environments.
• Migrated Mappings, Sessions, and Workflows from Development to Test and then to Production environment.
• Identified and fixed the Bottle Necks and tuned the Mappings and Sessions for improving performance. Tuned both ETL process as well as Databases.
• Created and monitored sessions and batches to run the mappings.

Environment: Informatica PowerCenter 8.1, SQL Server 2005, Unix/AIX 5.3.8.0, Windows Xp, Oracle 10g, Erwin.

Confidential

Software Engineer

Responsibilities:

• Developed various mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure and Sequence Generator transformations.
• Implemented Slowly Changing Dimensions of type 1 & type 2 to store history according to business requirements.
• Used Parameter files to pass mapping and session parameters to the session.
• Tuned the Informatica mappings to reduce the session run time.
• Developed PL/SQL procedures to update the database and to perform calculations.
• Worked with SQL*Loader to load data into the warehouse.
• Developed reports in Cognos Reportnet.
• Contributed to the design and development of Cognos framework model.
• Wrote UNIX shell scripts to work with flat files, to define parameter files and to create pre and post session commands.
• Performed Unit testing and System testing of Informatica mappings.
• Involved in migrating the mappings and workflows from Development to Testing and then to Production environments.

Environment: Oracle8i, SQL, PL/SQL, SQL*PLUS, HP-UX 10.20, Informatica PowerCenter 7, DB2 Cognos Report net 1.1, Windows2000