SUMMARY

• Over 10+ years of IT experience in Analysis, Design, Development and Maintenance of various software applications.
• Over 7+ years experience in using ETL methodologies for supporting Data Extraction, Data Migration, Data Transformation and loading using Informatica Power Center 9.x./8.x./7.x.
• Strong experience in Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Designer, Workflow Manager, Workflow Monitor, Metadata Manger).
• Extensively worked on Informatica Designer Tools (Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet/Mapping Designer) and Workflow Manager Tools (Task Developer, Worklet/Workflow Designer)
• Experience in Data Analysis, Data Mapping, Data Modeling, Data Profiling and Development of Databases for business applications in client/server applications and Data warehouse environments.
• Good knowledge of Data warehouse concepts and principles (Kimball / Inman), Dimensional modeling using Star Schema and Snowflake, Slowly Changing Dimension (SCD), Surrogate keys, Normalization and Denormalization.
• Good understanding of data warehousing techniques for Data Cleaning, Update Strategies, Incremental loads and CDC (Change Data Capture)
• Experience in integration of various data Sources such as Multiple Relational Databases (like Oracle, SQL Server), XML files, Flat files (fixed width and delimited)
• Maintained the data integrity during extraction, manipulation, processing, analysis and storage
• Worked extensively with complex Mappings using various Transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Aggregators, Updated Strategy and Lookups
• Good data analysis and data validation skills and experience in debugging the Mappings, Identifying bugs in existing Mappings by analyzing the data flow and evaluating Transformations
• Hands on experience in Performance Tuning of Sources, Targets, Transformations and Sessions
• Experience in writing, testing and implementation of the Functions, Procedures at Database level using SQL and PL/SQL
• Good experience in documenting the ETL process flow for better maintenance and analyzing the process flow.
• Exposure to plan and execute all phases of System Development Life Cycle (SDLC) including Requirement Analysis, Design, Development, Maintenance, Unit Testing, Integration Testing, Regression Testing, UAT, Implementation, Documentation and Production/Application Support
• Experience in using version - control tools like PVCS, TFS and SVN.
• Strong communication skills and ability to work in a team and individually.

TECHNICAL SKILLS

Operating System: Windows XP/7, Windows 2000 Server,Windows 2003 Server, UNIX,Linux

Databases: SQL server 2000/2005/2008 R2/2012, MS-AccessOracle 8i/9i/10g/11g, Teradata 12/V2R5

ETL Tools: Informatica Power Center 9.x./8.x./7.x, SSIS,DTS

Data Modeling Tools: Erwin r7/r4/3.5, Microsoft Visio 2007/2010, MicrosoftVisual SourceSafe 6.0

OLAP/Reporting Tools: SSAS, SSRS, Cognos, Crystal Reports 9.0/10/X1,OBIEE

Languages: C, C++, C#, JAVA, T-SQL, XHTML, JavaScript, VB,ASP, UNIX Shell Scripting, VB.Net, ASP.Net, PL/SQL

Other Tools: SQL Loader, ERWIN, Microsoft Visual Source Safe,Microsoft Office, Microsoft Visio, MS Visual Studio,SQL server Management Studio

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Senior Informatica Developer

Responsibilites:

• Involved in various design discussions and requirement discussions with the end users.
• Analyzed the Functional Specs provided by the Data Architect and created Technical Design Specs documents for all the Mappings
• Extracted data from various Sources such as Oracle 11g, XML files and Flat files with delimited.
• Created complex Mappings using different Transformations like Filter, Router, Joiner, Connected & Unconnected Lookups, Sorter, Aggregator and Sequence Generator to pipeline data to Data Warehouse.
• Developed Reusable Mapplets and Transformations for reusable business calculations.
• As per the requirement of the business users, managed changes in the data and implemented Slowly Changing Dimensions type I and type II.
• Created an Issue Log to identify the errors and used it for preventing any such errors in future development works.
• Used Exception handling logic in all Mappings to handle the null values or rejected rows.
• Implemented the best practices for the creation of Mappings, sessions and Workflows and performance optimization.
• Performed Data Quality Analysis to determine cleansing requirements
• Created scripts to update the parameter files to establish delta extraction
• Wrote various shell scripts for pre-processing of data and scheduling of jobs
• Responsible to troubleshoot the problems by monitoring all the Sessionsthat are scheduled, completed, running and also used Debugger for complex problem troubleshooting.
• Reviewed code, Design and Test plans as appropriated throughout projectLifecycle
• Worked in various testing environments (Unit Testing, System Testingand Integration Testing with different releases) and documented the results.
• Performed query overrides in Lookup Transformation as and when requiredto improve the performance of the Mappings
• Improved the performance of the ETL by indexing and caching
• Involved in performance tuning of the Mappings, Sessions and Workflows
• Prepared the code migration document and worked with release team in
• Migrating the code (Informatica Objects, Unix Scripts) from Development toTest and Production Environments.

Environment: Informatica PowerCenter 9.1, Oracle 11g, Flat Files, XML Files, SQL, PL/SQL, TOAD, Unix.

Confidential, West Chicago, IL

Sr. Informatica Developer / Production Support

Responsibilities:

• Understand the Requirements and Functionality of the application from specs
• Involved in the development of Informatica mappings and tuned existing mappings for better performance.
• Responsible for testing the mappings and ensure that the mappings do the transformation as proposed.
• Developed Mapplets and Worklets for reusability.
• Created mappings using different transformations like Source Qualifier, Joiner, Aggregator, Expression, Filter, Router, Lookup, Update Strategy, data masking and Sequence Generator etc.
• Involved in Unit Testing, create test cases to check whether the data loads into target.
• Prepared technical specifications for the development of Informatica (ETL) mappings to load data into various target tables and defining ETL standards.
• Scheduling daily, weekly and monthly loads for the managers according to the business specs.
• Develop workflows, sessions used command task in workflow manager.
• Configure the Driving tables according to the variation of data and maintain CSV documents as per that.
• Developed Informatica mappings for TYPE 2 Slowly Changing Dimensions.
• Creating sessions and work-flows for the Informatica mappings.
• Improved the Informatica Mappings and Session performance by eliminating extensive cache usage transformations, increasing commit interval and calculating the cache sizes appropriately.
• Configuring sessions for different situations including incremental aggregation, pipe-line partitioning etc.
• Migrated Informatica code from Dev to QA and QA to Production environments.
• Involved in writing Oracle stored procedures and functions for calling during the execution of Informatica mapping or as Pre or Post session execution.
• Performance Tuning, partitioning, Parallelism, Push-Down Optimization techniques were implemented to improve the through put.
• Documented Mappings, Transformations and Informatica sessions.
• Created effective Test Cases and involved in designing the ETL testing strategies for functional, integration and system testing for Data warehouse implementation.
• Worked with the End Users directly and performed user acceptance testing.
• Executed Test Driven Development (TDD) wherever possible as part of Agile sprints.
• Developed required Unix shell scripts to automate ETL processes.
• Analyzed Session Log files in case the session failed to resolve errors in mapping or session configurations.

Environment: Informatica Power Center 9.1, Oracle 11g, SQL Server 2008, SSIS, SSRS, Mainframes, Flat Files, UNIX, Erwin, PL/SQL, UNIX, Shell Scripting, Windows, TOAD 9.0, Agile, Autosys.

Confidential, Atlanta, GA

ETL Consultant

Responsibilites:

• Analyze business requirements, technical specification, source repositories and physical data models for ETL mapping and process flow.
• Created detailed Technical specifications for Data Warehouse and ETL processes.
• Worked on Informatica- Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet, and Transformation Developer.
• Experience using ERWIN 4.0 in Data modeling.
• Extracted/loaded data from/into diverse source/target systems like Oracle, XML and Flat Files.
• Used most of the transformations such as the Source Qualifier, Expression, Aggregator, Filter, Connected and Unconnected Lookups, Joiner, update strategy and stored procedure.
• Developed mappings to load Fact and Dimension tables, SCD Type I and SCD Type II dimensions and Incremental loading and unit tested the mappings.
• Worked in the Performance Tuning of SQL, ETL and other processes to optimize session performance.
• Involved in design phase of logical and physical data model using Erwin 4.0.
• Worked extensively with different Caches such as Index cache, Data cache, Lookup cache (Static, Dynamic and Persistence) and Join cache while developing the Mappings.
• Created Reusable transformations, Mapplets, Worklets using Transformation Developer, Mapplet Designer and Worklet Designer.
• Data quality checking and interacting with the business analysts.
• Created shell script for archiving files and trigger files.
• Responsible for Unit Testing and helped with User Acceptance Testing.
• Scheduling Informatica jobs and implementing dependencies if necessary.
• Provided 24/7 on call Prod support.

Environment: Informatica Power center 8.6/8.1, Oracle10g, PL/SQL, SQL Server 2008, Erwin 4.0, Unix scripting, OBIEE, Toad.

Confidential, Columbus, GA

Informatica Developer

Responsibilites:

• Coordinating with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema Design (Star Schema) and maintenance.
• Designed Informatica mappings by translating the business requirements.
• Worked with Business analysts and the DBA for requirements gathering, business analysis and designing of the data warehouse.
• Developed mappings for customers, Investments and Risk analysis.
• Widely used Informatica client tools Source Analyzer, Warehouse designer, Mapping designer, Transformation Developer and Informatica Work Flow Manager.
• Used look up, router, filter, joiner, stored procedure, source qualifier, aggregator and update strategy transformations extensively.
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• Done extensive bulk loading into the target using Oracle SQL Loader.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Assisted the team in the development of design standards and codes for effective ETL procedure development and implementation.
• Extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings and sessions.
• Involved in the design, development and testing of the PL/SQL stored procedures, packages for the ETL processes.
• Installed, and Documented the Informatica Power Center setup on multiple environments.

Environment: Informatica Power Center 8.6 (Power Center Repository Manager, Designer, Workflow Manager, and Workflow Monitor), SSIS, DTS, Oracle 9i, TOAD, PL/SQL.

Confidential, Atlanta, GA

ETL/Database Developer

Responsibilities:

• Involved in Requirement gathering, business Analysis, Design and Development, testing and implementation of business rules.
• Resolved Logical, Design Errors in mapping with the help of Debugger and different Log files.
• Effectively communicated with BAs on Informatica bugs & issues.
• Design and implement error Handling Strategy, Performance Monitoring and Tuning
• Used the Slowly Changing Dimensions - Type II in various mappings.
• Used debugger to test the data flow and fix the mappings.
• Create and secure a Data Warehouse environment to improve data quality and end user access controls
• Create Informatica Mappings, using transformations like Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Joiner, Union and Normalizer.
• Responsible for creating user groups, privileges to the users using repository manager.
• Developed mappings which load data mart data into SQL SERVER.
• Designing and creation of complex mappings using SCD type II involving transformations such as expression, joiner, aggregator, lookup, update strategy, and filter using CDC.
• Implemented Performance tuning in Mappings and Sessions by identifying the bottlenecks and Implemented effective transformation Logic.
• Maintain Development, Test and Production mapping migration using Repository Manager.
• Involved in enhancements and maintenance activities of the data warehouse including performance tuning.
• Experience in analyzing the reporting requirement.
• Created AutoSys schedules/jobs for automation of ETL load process.
• Involved in Unit Testing, data masking, User Acceptance Testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Preparing and using test data/cases to verify accuracy and completeness of ETL process.
• Actively involved in the Production support and also transferred knowledge to the other team members.
• Worked on performance tuning of various mappings and session to identify and remove the bottle necks.
• Logged the bugs in test directory and coordinated with other team member in resolving the issues.
• Validated all the applications and run the workflow using Workflow Manager.
• Created events and tasks in the workflows using work flow manager.
• Performed tunings of mappings, sessions for optimum performance
• Performed Unit Testing and Integration testing for the mappings created.
• Assisting Reporting team in designing Monthly and Daily Universes.

Environment: InformaticaPowerCenter8.1, Oracle8i, UNIX, Windows XP, Flat Files, Autosys, TOAD.

Confidential

Oracle developer

Responsibilities:

• Interacted with end users for gathering requirements.
• Perform database tuning, monitoring, loading and back up.
• Used SQL loader to load data from csv files into Oracle tables.
• Creating prototype reporting models, specifications, diagrams and charts to provide direction to system programmers.
• Developed procedures and functions using PL/SQL.
• Created number of database Triggers according to business rules using PL/SQL.
• Developed SQL for loading metadata from Excel spread sheet to the database using SQL Loader.
• Extensively used PL/SQL to implement cursors, triggers and packages.
• Developed SQL script for loading data from existing MS Access tables to Oracle.
• Create record groups for manipulation of data, Perform unit and system integrated testing.
• Involved in database design, development of database, tables and views.
• Involved in application testing, deployment and production support.

Environment: Oracle 8i, PL/SQL, TOAD, SQL*Loader, Oracle Forms, Oracle Reports, MS Access, Excel spread sheet, Windows NT.