Professional Summary

• Informatica 8.x Certified Developer
• 7 years of experience in database development, including Data warehousing ETL using Informatica, Oracle, SQL Server, Windows server, UNIX and Solaris
• 2 years of experience in Data Analysis, Data profiling and Data cleansing using Informatica tools like Informatica Data Quality IDQ and Data Analysis
• Proficient in Informatica Administration, data extraction, transformation and loading data using Informatica PowerCenter 9.5/9.0.1/8.6/8.1.1/7.1.4/7.1.3 Admin Console, Repository Manager, Designer, Workflow Manager, and Workflow Monitor , Informatica Power Exchange
• Experienced in all phases of Software development life cycle SDLC of Data warehousing, including requirement gathering from business users, analysis, design, creation of business requirement documents, mapping documents, development, testing, and implementation
• Experienced in integration of data sources like Oracle 10g/9i/8i, MS SQL Server 2005/2000, XML files
• Extensively worked on developing and debugging Informatica mappings, mapplets, sessions and workflows
• Worked on non-relational sources like Flat files and used secure FTP, SSH
• Worked on Oracle PL/SQL programming, Stored procedures
• Worked on Performance Tuning Informatica Targets, Sources, mappings and sessions
• Dealt with Change Data Capture CDC using PowerExchange CDC option to distill updates from unchanged background data and to deliver them to multiple targets without intermediate queues or staging tables
• Worked on Incremental loading Target databases using SCD Type1/Type2 loads
• Outstanding communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high compliance to new technologies and tools

Skills Summary

ETL Tools: Informatica PowerCenter 9.5/9.0.1/8.6/8.1/7.x, Informatica PowerExchange

Databases: Oracle 11g/10g/9i/8i, DB2, MS-SQL Server 2000/5, MS Access

Database Tools: TOAD 8.6, SQL plus, SQL Developer, ERwin 4.0

Packages: MS Office, MS Visio, MS Project

Languages: SQL, PL/SQL, C

Operating System: WIN 95/98/NT/2000/XP, UNIX, HP-UX, RHEL, Susie Linux, Sun Solaris

Professional Experience

ETL Informatica Developer

Confidential

Job Responsibilities

• Involved in the migration of AT T accounts to Frontier systems
• Created ETL process to generate XML files from oracle tables using Informatica
• Extensively worked with XML files as the Source and Target, used transformations like XML Generator and XML Parser to transform XML files
• Created lot of mappings using various active and passive transformations like Source Qualifier, Lookup, java, Router, Aggregator, Filter, Joiner, and Expression
• Involved in the source data landing process, wrote scripts to load various source files like txt, csv, delimited and oracle dump Used Informatica Debugger to check the errors in the mapping and made appropriate changes in the mappings to generate the required results
• Prepared the Standard Operating Procedure Knowledge Transfer document, which provides necessary information, required for the Maintenance and Operation of the application
• Worked with tools like TOAD, SQL Developer, SQL Plus to connect to Oracle and DB2 databases to write queries and analyze data
• Worked with business users, testing team and application development teams on analyzing, resolving and documenting the defects using HP ALM tool

Environment: Informatica PowerCenter 9.5 Repository Manager, Designer, Workflow Manager, and Workflow Monitor , Linux, Oracle 11g, DB2, Flat files, XML Files, SQL Developer, WinSCP, PuTTY, TextPad

Informatica Consultant

Confidential

Job Responsibilities

• Collection of requirements from business users and analyzed based on the requirements
• Extensively used XML files for Designing and developing complex Informatica mappings using expressions, aggregators, filters, lookup and stored procedures to ensure movement of the data between various applications
• worked on Informatica Data Quality IDQ 8.5 option to distill XML Background data and to deliver then to multiple targets without any error.
• Involved in the design, development and implementation of POSXML - Informatica project
• Designed and developed complex mappings using various transformations in Designer to extract the data from sources like Oracle, SQL Server, XML files and flat files to perform mappings based on company requirements and load into Oracle tables
• Involved in gathering business requirement from the users and creating the business requirement documents, mapping documents
• Extensively worked on XML files with both direct and indirect loading and implemented mappings and workflows with parameters and variables
• Worked on creating and altering tables and other DDL, DML and DCL utilities of Oracle 10g
• Created mappings involving various transformations like joiner, aggregator, lookup, sequence generator, stored procedure, update strategy, filter and router transformations to implement business logic
• Extensively used mapplets and worklets to prevent redundancy of transformation usage and maintainability
• Used different tasks Session, Command, Decision, Timer, Email, Event-Raise, Event-Wait, Control in the workflow
• Performed unit and regression testing, troubleshooting and bug fixing in development and QA environments
• Worked on Informatica Debugger to debug the mapping
• Well versed in using Mercury Quality Center to document defects
• Involved in Change control Management
• Involved in knowledge transfer to the offshore team on the process flow

Environment: Informatica PowerCenter 8.6 Admin Console, Repository Manager, Designer, Workflow Manager, and Workflow Monitor , Linux, Oracle 10g, Flat files, XML Files, TOAD 10, SQL Developer, WinSCP, PuTTY, Winmerge, TextPad, EditPlus

ETL Consultant

Confidential

Job Responsibilities:

• Worked as a Informatica lead to design and develop Informatica mapping. To perform the Extraction, Transform and Load process by studying the business requirement from the users and the mapping documents
• Extensively used COBOL copy book to import the VSAM files from the Mainframe Source. The Mainframe flat file lists were indirectly accessed and implemented mapping with parameters and variables
• Developed mappings using various transformations in Designer to extract the data from relational sources like Oracle and non relational source like flat files to perform mappings based on company requirements and load into BI system
• Worked on Informatica PowerCenter tools- Admin Console, Repository Manager, Designer, Workflow Manager, Workflow Monitor
• Worked on migration of Informatica objects across Dev, Test and Prod environments using export and import of objects
• Involved in Informatica administration to take Repository backup, restore across different Informatica environments
• Worked on complete Extract, transformation and load process ETL using Informatica 8.1
• Designed and developed complex mappings using various transformations in Designer to extract the data from sources like Oracle, SQL Server, XML files and flat files to perform mappings based on company requirements and load into Oracle tables
• Created shortcuts in individually assigned folders for the sources and Targets which are imported into a Centralized shared folder
• Created XSD for XML files, imported into Designer as XML source qualifier
• Created slowly changing dimension tables - SCD type 1 type 2 mappings using lookup, Joiner, aggregator, Filter, Update Strategy and Router Transformations
• Used different tasks Session, Command, Decision, Timer, Email, Event-Raise, Event-Wait, Control in the workflow
• Worked on performance tuning of Informatica Targets, Sources, mappings and sessions for large data files
• Used Informatica Debugger to check the errors in the mapping and made appropriate changes in the mappings to generate the required results
• Worked with tools like TOAD, SQL Developer to write queries and generate the result
• Performed unit and regression testing, troubleshooting and bug fixing in development and QA environment
• Managed Change control implementation
• Involved in knowledge transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the Informatica mappings

Environment: Informatica PowerCenter 8.1.1 Informatica Services, Repository Manager, Designer, Workflow Manager, and Workflow Monitor , Solaris, Oracle 10g, Informatica PowerExchange, Flat files, XML Files, ERwin 4.0, TOAD 8.6, FileZilla

Informatica Developer

Confidential

Job Responsibilities:

• Worked with various business users for requirement gathering and analysis
• Designed ETL mapping document to map source data elements to the target based in Star-Schema dimensional model
• Involved in designing of star schema based data model with dimensions and facts
• Designed and developed complex mappings using various transformations in Designer to extract the data from relational sources like Oracle, SQL Server, and non relational source like flat files to perform mappings based on company requirements and load into Oracle tables
• Worked extensively on Informatica Designer, workflow manager to create, sessions, workflows and monitor the results and validate them according to the requirement
• Worked on Informatica repository manager for creating users, groups, assigning Read, write, execute privileges for Users by assigning users to groups, creating folders
• Created SCD type 1 type 2 mappings using lookup, Joiner, aggregator, Filter, Update Strategy and Router Transformations
• Worked on PowerExchange CDC option to distill updates from unchanged background data and to deliver them to multiple targets without intermediate queues or staging tables
• Used different tasks Session, Command, Decision, Timer, Email, Event-Raise, Event-Wait, Control in the workflow
• Performance Tuned Informatica Targets, Sources, mappings and sessions for large data files by increasing data cache size, sequence buffer length and target based commit interval
• Created pre-session and post-session shell scripts and mail-notifications
• Used debugger to check the errors in the mappings
• Worked with tools like TOAD to write queries and generate the result
• Managed Change control implementation
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the Informatica mappings

Environment: Informatica PowerCenter 8.1.1 Designer, Workflow Manager, and Workflow Monitor , Solaris, Oracle 9i, Informatica PowerExchange, SQL Server 2005, PL/SQL, Flat files, XML Files, ERwin, TOAD

ETL Developer

Confidential

Job Responsibilities:

• Involved in the design, development and implementation of the Enterprise Data Warehouse EDW
• Worked on ETL Migration process from legacy scripts to Informatica PowerCenter 7.1.1
• Worked on Informatica PowerCenter tools-Source analyzer, Warehouse Designer, Mapping Designer and Transformation developer
• Used various Informatica transformations to recreate data in the data warehouse
• Involved in Data cleansing before loading it on Oracle data warehouse
• Designed and developed Aggregate, Joiner, Lookup transformation rules business rules to generate consolidated fact/summary data identified by dimensions using Informatica ETL tool
• Used Update Strategy and Lookup transformation for insert, delete, update or reject the records based on business requirements
• Worked on change data capture for slowly changing dimensions SCD-2 to update a target table to keep full history
• Extensively used Mapplets and Reusable Transformations to prevent redundancy of transformation usage and maintainability
• Used the repository manager to give permissions to users, created new users and repositories
• Well versed with Trizetto Facets core administration software that help with the bill processing, claims information and customer service.
• Setting up automated scheduling of sessions at regular intervals using Informatica Scheduler
• Worked on identifying mapping bottlenecks in Source, Target and Mappings to Improve performance
• Extensively used debugger to troubleshoot logical errors
• Used workflow manager for session management, database connection management and scheduling of jobs
• Monitored workflows and session using PowerCenter workflows monitor
• Worked with TOAD to write SQL queries and generate the results

Environment: Informatica PowerCenter 7.1.1 Informatica Server, Repository Server, Repository Manager, Designer, Workflow Manager and Workflow Monitor , Windows XP, UNIX, Solaris, Oracle 8i, MS SQL Server 2000, Flat files

Informatica Developer

Confidential

Job Responsibilities:

• Worked closely with the Business analyst to understand the various source data
• Used Informatica PowerCenter for migrating data from various OLTP databases to the data mart
• Developed mappings using various transformations in Designer to extract the data from relational sources like Oracle, SQL Server, and non relational source like flat files to perform mappings based on company requirements
• Created several mappings involving transformations like lookup, joiner, aggregator, filter, sequence generator, Router, Update Strategy
• Created slowly changing dimensions SCD-2 to update a target table to keep full history
• Involved in performance tuning of mappings, targets, sources and session
• Used Debugger to identify the errors in the mappings and fix them
• Used TOAD and SQL Plus to write queries and interact with Oracle database
• Involved in writing UNIX scripts and used them to automate the scheduling process

Environment: Informatica PowerCenter 7.0 Informatica Server, Repository Server, Repository Manager, Designer, Workflow Manager and Workflow Monitor , Oracle 9i, MS SQL Server 2000, TOAD, UNIX, PL/SQL, Windows 2000/XP

Software Engineer

Confidential

Job Responsibilities:

• Prepared the different test scenarios and tested the SQL queries and stored procedures
• Conducted the Weekly Status meetings to Review/generate reports on the development of the software

Environment: SQL, PL/SQL, Oracle Forms, Oracle 8i, MS Access, Windows NT, UNIX