SUMMARY

• Informatica ETL consultant with over 7 years of extensive experience with Informatica Power Center in all phases of Analysis, Design, Development, Implementation and Support of Data Warehousing applications.
• Hands on experience in all aspects of AGILE and Software Development Life Cycle (SDLC) projects. Experience managing off - shore development teams during development and testing phase to report and resolve defects and change requests using HP Quality Center.
• Strong business understanding of Hospitality, Banking, Retail, Pharmaceuticals-Healthcare sectors.
• Expert in data extraction, transformation and load using Informatica PowerCenter 9. 1, 8.6, 7 .1 and Power Exchange and knowledge of Informatica Data Quality(IDQ), Metadata Manager, Informatica MDM, SSIS, OBIEE etc.
• Experienced in integration of various data sources like Oracle 11g/10g/9i/8i, Teradata, Netezza, SQL Server 2005/2008, MS Access, XML source and target files and flat files sources into staging area and different target databases.
• Expert in Entity relationship modeling and Dimensional modeling for data warehouse and data marts. Experience using Visio and ERWin design tools to create Star and Snowflake schemas.
• Hands on experience on tools like Toad, SQL assistant and SQL Developer and utilities like SQL*Loader.
• Experienced in Performance Tuning of Mapping, Session and database level, identifying and resolving performance bottlenecks at various levels in Business Intelligence applications. Applied Informatica session partitions to remove source bottlenecks.
• Advanced Knowledge of Oracle PL/SQL programming, stored procedures & functions, indexes, triggers, anonymous blocks, etc.
• Experienced in automating and triggering workflows through UNIX scripts.
• Excellent analytical and logical programming skills with a good understanding at the conceptual level
• Excellent presentation, interpersonal skills and written and verbal communication skills including problem-solving skills.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 9.1/8.6/8.1/7.1 , IDQ, MDM, etc.

Databases: Oracle 11i/10g/9i/8i, SQL Server 2000/2005, Teradata V12, Netezza, ERP databases such as Oracle eBusiness Suite, JD Edwards, SalesForce, etc.

Database Tools: TOAD, SQL Developer, SQL plus, SQL assistant

Data Modeling tools: ERWin 4.0, MS Visio

Scheduling tools: Tidal, AutoSys

MS Products: MS Visio, MS Project, MS office Suite, MS SharePoint

Programming Languages: PL/SQL, Java, C, C++, UNIX Shell scripting

IDE/ Tools: Putty, Toad, SQL Developer, SQL Loader

Operating Systems: Windows 7, Windows NT, Windows 2000/XP

Bug tracking tools: HP Quality Center, HP Service Manager (Peregrine)

PROFESSIONAL EXPERIENCE

Confidential, Pheonix, AZ

Sr. informatica DEVELOPER

Responsibilities:

• Designed the ETL Architecture for the process flow from the source to target along with automation in writing wrapper shell scripts.
• Using Informatica Power Center 9.1.0 extracting the data from the externally received files and loading the data into the data mart.
• Managed offshore team and do code review once development is completed.
• Involved in Performance Tuning at various levels including Target, Source, Mapping, and Session for large data files.
• Did Informatica mapping specification documents for the mappings developed and documented them according to Business standards.
• Handling the data with the Change Data Capture Slowly Changing dimension type I & Type II.
• Worked with Business Users in understanding the requirements.
• Worked on Salesforce Transformation in the mappings, to load data into the salesforce & also used salesforce as a source.
• Documented the requirement specifications and created source to target mapping documents.
• Created mappings using the Transformations like Source qualifier, Aggregator, Expression, lookup, Router, Filter, Rank, Sequence Generator, and Update Strategy.
• Created Mapplets, reusable transformations and used them in different mappings.
• Used Debugger wizard to remove bottlenecks at source level, transformation level, and target level for the optimum usage of sources, transformations and target loads.
• Used database objects like Views and Stored Procedures for accomplishing Complex logical situations.
• Involved in Unit testing, System testing to check whether the data loading into target are accurate, which was extracted from different source systems according to the user requirements.
• Involved in performance tuning and optimization of Informatica mappings and sessions using features like Session Partitioning, setting DTM Buffer Size and Cache Calculation (Data/Index cache) to manage very large volume of data.
• Worked with DBA’s in tuning SQL queries using Execution Plan, Partitioned tables, compressed tables and Purged the data periodically.
• Documented the code for better understanding for production support team in the event of production failure also for better maintenance and analyzing the process flow.
• Actively participated in Design Reviews and Code Reviews to follow Standards and Best Practices.

Environment: Informatica PowerCenter 9.1.0, IDQ, Oracle 11g, DB2, Neteeza, Toad, Putty 0.58, Toad for SQL Server, Win 7.

Confidential, COLUMBUS, OH

Informatica DEVELOPER

Responsibilities:

• Worked with Business Users in understanding the requirements.
• Documented the requirement specifications and created source to target mapping documents.
• Created mappings using the Transformations like Source qualifier, Aggregator, Expression, lookup, Router, Filter, Rank, Sequence Generator, and Update Strategy.
• Created Mapplets, reusable transformations and used them in different mappings.
• Used Debugger wizard to remove bottlenecks at source level, transformation level, and target level for the optimum usage of sources, transformations and target loads.
• Used database objects like Views and Stored Procedures for accomplishing Complex logical situations.
• Involved in Unit testing, System testing to check whether the data loading into target are accurate, which was extracted from different source systems according to the user requirements.
• Involved in performance tuning and optimization of Informatica mappings and sessions using features like Session Partitioning, setting DTM Buffer Size and Cache Calculation (Data/Index cache) to manage very large volume of data.
• Worked with DBA’s in tuning SQL queries using Execution Plan, Partitioned tables, compressed tables and Purged the data periodically.
• Documented the code for better understanding for production support team in the event of production failure also for better maintenance and analyzing the process flow.
• Actively participated in Design Reviews and Code Reviews to follow Standards and Best Practices.
• Used Autosys scheduling and Informatica Scheduler to schedule the workflows.

Environment: Informatica PowerCenter 8.6, Oracle 10g, Toad, Putty 0.58, HP Service Manager (Peregrine), Win XP

United Health care, SAN DIEGO, ca

Role: INFORMATICA DEVELOPER

United Healthcare is an operating division of UnitedHealth Group, the largest single health carrier in the United States.It is considered as a recognized leader in the health and well-being industry in striving for improved health care for all Americans by creating products and services that make health care more affordable and use technology to make the health care system easier to navigate

Responsibilities:

• Working in an AGILE environment, I am heavily involved in resolving priority issues, Requirement Analysis, Schema and ETL Design, and Development using Informatica 9.1.
• Design and develop logic for creating conformed dimensions to enable consolidated reporting, taking into consideration requirements from end report, dependencies between tables, (high) volume of transactional data.
• Use Incremental Loading concept by pulling transactional data that has a Source Update Date greater than the workflow’s last run date. Workflow’s last run date is captured in a custom table and updated in Post SQL of the workflow. Parameter files are created dynamically at the start of the workflow.
• Create complex mappings which involved Slowly Changing Dimensions (SCD Type 2 with date range), lookups on multiple tables, mapping and workflow parameters, User defined functions, mapplets and dynamic lookups
• Developed PL SQL procedure to enable a workflow to trigger only after certain fields are set in an external table
• Extensively used PL SQL/ SQL developer to test and replicate cubes to check if sum of measures for individual dimensions and conformed dimensions is exactly the same.
• Quickly resolved defects by reviewing Session logs and debugging mappings to gain troubleshooting information about data and error conditions using Informatica Debugger.
• Build mappings to sync data between SalesForce and Oracle EBS.

Environment: Informatica PowerCenter 9.1, Oracle e-Business Suite, JD Edwards, Sales Force, Oracle 11g, SQL Developer, SQL plus, Win 7

Omni Engineering Services,Minneapolis, MN

Role: INFORMATICA DEVELOPER

OMNI provides system testing products - electronic product design solutions, test systems, research and development, and prototyping - and product design services to Agricultural, Automotive, Commercial, HVAC, Medical, and Military clients.

The project involves integrating Retail transaction files from daily transaction from distributed systems. XML and flat files are received and are loaded into the ODS system initially using the Informatica interface. The four transaction Retail, Tender, Inventory and Batch data from all the system are stored in the ODS system. The data is then loaded from ODS database into Oracle Datawarehouse.

Responsibilities:

• Worked closely with the Business analyst to understand the various data sources and requirements.
• Heavily involved in Requirement Analysis, ETL Design and Development for extracting from the source systems and loading it into the Data mart, and creating documents according to project standards.
• Used Informatica Power Center Workflow manager to create sessions and workflows to run the logic embedded in the mappings.
• Worked in on-site offshore model. Managed offshore team of 4 developers during testing phase to register and resolve defects and change requests using HP quality center.
• Created complex mappings which involved Slowly Changing Dimensions, implementation of Business Logic and capturing the deleted records in the source systems
• Performed Informatica administrative tasks such as stopping/starting Informatica Repository and Server processes.
• Involved in administration using Admin Console and Repository Manager to install Informatica, Creation of folders/Permission and upgrade Informatica from 8.6 to 9.1, upgrading and migration of the repository from 8.6 to 9.1.
• Provided Production Support for business users and documented problems and solutions for running the workflow.
• Used Workflow Monitor to monitor the progress of workflow and session and also used the workflow log and session log for trouble shooting purposes.
• Debug mappings to gain troubleshooting information about data and error conditions using Informatica Debugger.
• Worked with the DBA to improve Informatica session performance and query performance by collecting statistics and defining relevant indexes on target tables
• Understanding the specification and analyzed data according to client requirement.
• Did statistical analysis of the data and Involved in creating Reports, Dashboard KPI’s and ad hoc reports.
• Performed unit testing to test load time and documented the Unit Test Results and Unit Test Cases.
• Involved in unit testing and preparing test cases and Involved in peer-to-peer reviews. Used HP Quality Center for defect logging and resolution.

Environment: Informatica PowerCenter 9.1, Oracle e-Business Suite, XML, Oracle 11g, TOAD 8.6, SQL plus, Win XP, HP Quality Center, Teradata, SQL assistant, SQL Server 2005/2008

BAYER PHARMA, EDISON, NJ

Role: Informatica CONSULTANT

Involved in the ABBI Project. The project is mainly about the loading the data from different files into ABBI systems and providing the outbound feeds to different external users. Receives the calls, product, Territory, Account, User, Address information from external Veeva system and used to analyze the data for reporting purpose.

Responsibilities:

• Actively involved in all the phases of project (Client Interaction, gathering requirements from Business users, Preparation of detail design, Development, Unit Testing and Production support)
• Used Informatica Power Center 8.6 for migrating data from various OLTP databases to the data mart
• Sourced Teradata and DB2 data to staging table before loading to EDW. Used PowerExchange utility to read DB2 files in order to load customer table.
• Extracted data from Sales department to flat files and load the data to the target Oracle database
• Extracted data from sources like fixed width and Delimited Flat files transformed the data according the business requirement and then loaded into Target Data mart
• Created various Informatica mappings and mapplets to load the data mart. The mappings involved extensive use of transformations like Aggregator, Filter, Router, Expression, Joiner, Sequence generator
• Monitored and cleansed prescription and sales data using Informatica Data Quality (IDQ) - source data profiling using Informatica Analyst, and creating mappings in Informatica Developer to apply cleansing and business rules.
• Utilized name matching transformation to cleanse drug names based on results of data profiling. Created and scheduled application to run the mapping using Infacmd commands.
• Configured the mappings to handle the updates to preserve the existing records (Slowly changing dimensions) using Update Strategy Transformation (SCD Type-2)
• Used Debugger to identify the errors in the mappings and fix them
• Performed unit testing to validate mappings and populate the database
• Used TOAD and SQL Plus to write queries and interact with Oracle database
• Implemented several different tasks (Session, Assignment, Command, Decision, Timer, Email, Event-Raise, Event-Wait, Control) in the workflow

Environment: Informatica Power Center 8.6, Teradata V2R5, SQL assistant, DB2, UNIX (Shell Scripting), IDQ, Informatica Data Explorer (IDE), Oracle 10g, SQL Server 2005, SSIS, SSRS, PL/SQL, Flat files, SQL Developer, XML, Win XP, Tidal Scheduler. OBIEE, Qlikview, Netezza.

HDFC, India

Role: database Developer

Responsibilities:

• Involved in initial study, design of Data Warehouse for better Reporting for Inventory and Procurement Systems.
• Developed Application programs using Oracle PL/SQL.
• Attended in-house Training in Informatica and Dimensional Data Modeling.
• Involved in complete system development life cycle study, analysis and Design for creating a robust MIS Reporting System.
• Created indexes, sequences and constraints.
• Tracked various defects and worked to resolve the production defects.
• Used Informatica PowerCenter 6.1 to create data mappings.
• Created test plan, test scripts. Documented actual results and compared them with expected results.
• Created various mapping like Joiner, Lookup, Update Strategy.
• Used SQL*Loader to load flat files data to various tables.
• Wrote Packages, Procedures, Functions and Database Triggers.
• Involved in Unit Testing / System Integration Testing. Assisted QA Team members to create test scenarios.
• Verified the source data and executed various SQL queries to verify data in TOAD.

Environment: Oracle Database 9.2/8.1.7, SQL, PL/SQL, Windows 2000, Toad, Informatica Power Center 6.2