SUMMARY

• Around 6 years of work experience in designing and developing Data warehouse applications with special emphasis on Design and Development of Data Warehousing using Informatica Power Center.
• Strong expertise in Relational data base systems like Oracle, SQL Server, MS Access.
• Have extensively worked in developing for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Well acquainted with Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplets and Mapping Designer.
• Worked extensively with complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups, Aggregators, and Re-usable transformations.
• Expertise in using Informatica client tools - Designer, Repository, Manager, Repository Server, Administration Console, Workflow Manager, and Workflow Monitor. Knowledge of Informatica administration in windows and Linux environment
• Extensive experience in ETL processes in extracting data from operational and legacy systems to data warehouse using Informatica.
• Expertise in Dimensional data modeling, Star schema modeling, Snowflake modeling, Data Normalization.
• Experience in working with Erwin and TOAD.
• Highly proficient in processing tasks, scheduling sessions, import/export repositories, manage users, groups, associated privileges and folders.
• Proficient in the use of ORACLE (PL/SQL) SQL Loader, ETL Design and programming, Shell Scripting, TERADATA.
• Extensively used SQL and PL/SQL to write Stored Procedures, Functions, Packages and Triggers.
• Identifying Facts and Dimensions, Physical and logical data modeling using Erwin and ER-Studio.
• Expertise inPerformance Tuningof overall data warehouse, database, ETL and OLAP tuning coordinating with DBAs and UNIX Administrator for better performance.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.6/9.5/9.1/8.6/8.1 , Informatica Power Exchange 9.1/8.6, IDQ 9.1/9.5.1

Databases: Oracle 12c/11g/10g/9i, DB 2 8.0/7.0/6.0 , MS SQL Server 2000/7.0/6.5 , MS Access 7.0/97/2000, Teradata 14.0

Other Tools: Oracle Report Writer, TOAD, MLOAD, TPUMP, Erwin 4.x/3.5/3.x, SQL, XML, XSL, PL/SQL, SQL*Plus, SQL*Loader and Developer

Languages: SQL, UNIX Shell Scripting, Java, Unix Commands

Scheduling tools: Autosys, Control-M

Operating Systems: Windows Server 2008/2003, UNIX, OS, Sun Solaris 2.x.

PROFESSIONAL EXPERIENCE

Confidential - Chicago, IL

Sr. Informatica ETL Production Support & Developer

Responsibilities:

• Performed fine tuning of existing mappings in order to increase the performance of the mappings.
• Developed Claims processing data mappings to provide more feasibility to end users from the downstream applications.
• Implemented Type II slowly changing dimension to keep full history of dimensional data in the table.
• Managed and compile documentation for allETLprocesses.
• Performed maintenance of SQLs, Views, and Informatica objects.
• Monitored data warehouse month-end loads to ensure successful completion.
• Provideproductiondatabasesupport, enhance existing system and design and develop new systems.
• Monitor the usage of database space and performance.Performance optimization of the database and applications.Resolve on-call issues for hundreds ofproductiondatabases.
• Developed Conceptual, normalized Logical and Physical data models to design OTLP and Data warehouse environments.
• Used ETL process to load data from multiple sources to staging area (Oracle) using InformaticaPower Center 9.5.1.
• Worked with pre and post sessions and extracted data from transaction system into staging area along with knowledge of identifying fact and dimension tables.
• Tuned sources, targets, mappings and sessions to improve the performance of data load.Worked on dimensional models like Star schema and Snowflake schema.
• Extensively usedInformaticaWorkflow Manager to run the workflows/mappings and monitored the session logs inInformaticaWorkflow Monitor.
• Extensively used Data Stage for extracting, transforming and loading databases from sources includingOracle,DB2and Flat files.
• Experience in 24X7 productionsupport, ETL executions and resolving root causes.
• Extensively used ETL ToolInformaticato load data from Flat Files, Oracle and XML sources.
• Worked on requirements to implement the Change Data Capture (CDC) to record the latest changes in data from the source system.
• Involved in the development ofInformaticamappings and sessions and also tuned their performance for Optimum performance.
• Written complex SQL queries for data validation by querying data from different database tables as per the requirement.
• Extensively used UNIX commands for fetching and checking the Log files.

Environment: Informatica Power Center 9.5.1, TOAD DB2, Teradata, Oracle SQL Developer, UNIX, Tivoli (TWS), Microsoft SharePoint, HP Service Manager, Mainframe.

Confidential, Windsor, CT

Sr. ETL Informatica Developer

Responsibilities:

• Gathered requirements and developed mappings to maintain metadata in Repository to load data from Oracle, SQL Server, flat files into Oracle targets.
• Extensively used joins and sub-queries for complex queries involving multiple tables from different databases.
• Handled Data Conversion functions and defined constraints, indexes and views based on requirements.
• Involved in people soft migration project.
• Worked on mapplets and created parameter files wherever necessary to facilitate reusability.
• Extracted the data from Flat files (Delimited and fixed width) like CSV files or text files, XML files, Oracle 11g, SQL server, IBM mainframe, Sybase and load into Oracle data warehouse.
• Worked on identifying Mapping Bottlenecks and improved session performance through error handling.
• Used Error Handling to capture data errors in error tables to correct and reprocess them by analysis and error remediation Process.
• Implemented CDC by tracking the changes for critical inserts/updates by user.
• Worked on Pre-Session and Post session UNIX commands for file connections through Informatica server.
• Jobs are executed from UNIX wrapper scripts which are scheduled in TWS (Tivoli Work Load System)
• Modified the existing mappings for the updated logic and better performance.
• Avoided Duplicate issues through SQL override using look up, Joiner transformations.
• Created workflows using Workflow manager for different tasks like sending email notifications, timer that triggers when an event occurs, and sessions to run a mapping and handled process errors through emails.
• Actively participated in resolving Email tasks working on priority and non-priority issues.
• Developed and Scheduled jobs for daily loads that invoked Informatica workflows & sessions associated with the mappings, SQL scripts to drop & recreate the indexes on source and target tables for batch process.
• Handled running logs through UNIX scripts and edited files through VI editor.

Environment: Informatica Power Center 8.6.1, Oracle 10g/9i, MS SQL Server 7.0/2000, Flat files, SQL*Loader, Erwin 3.5, Toad 7.0, windows 2003, UNIX.

Confidential

Informatica Developer

Responsibilities:

• Involved in full life cycle design and development of Data warehouse.
• Interacted with business analysts, Source data architects and Source application developer to develop a data model.
• Prepared the required application design documents based on functionality required.
• Worked on PPM related requirements & providing solutions for issues related with same which covers activities like: requirement analysis, ETL designing, Scheduling workflows and providing Maintenance, Enhancement & Support to the Client
• Designed and developed the logic for handling slowly changing dimension table’s load by flagging the record using update strategy for populating the desired.
• Create ETL processes to extract data from Mainframe DB2 tables for loading into various oracle staging tables.
• Designed and Developed ETL logic for implementing CDC by tracking the changes in critical fields required by the user.
• Documented and maintained technical documentation regarding the extract, transformation and load process.
• Member of On-call team for providing support for daily and weekly batch loads.
• Involved in Unit testing, User Acceptance Testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.
• Involved in conversion of data using ETL mappings during Oracle upgrade from Oracle 10g to 11g.
• Involved in production support working with various mitigation tickets created while the users working to retrieve the database.
• Investigated and fixed problems encountered in the production environment on a day to day basis.

Environment: Informatica Power Center 8.6.1, Toad for DB2, Oracle 11g/10g/9i, Windows XP, BI Tools, UNIX

Confidential, NJ

ETL Developer

Responsibilities:

• Extensively used Informatica client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Informatica Repository Manager and Workflow Manager.
• Involved in extracting the data from various source systems like Sybase, DB2, Oracle and flat files and loaded to a relational data warehouse and flat files.
• Developed complex ETL mappings using various transformations like Source Qualifier, Joiner, Update Strategy, Connected and unconnected Lookup, Expression, Router, Filter, Normalizer, Aggregator and Sequence Generator transformations.
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time.
• Filtered Changed data using Power exchange CDC and loaded to the oracle target.
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Created mapping documents to outline data flow from sources to targets.
• Extensively optimized all the Informatica sources, targets, mappings and sessions by finding the bottlenecks in different areas and also debugged some existing mappings using the Debugger to test and fix the mappings.
• Extensively worked on Mapping Variables and Parameters, Workflow Variables and Session Parameters.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Sessions and scheduling them to run at specified time.
• Migrated mappings, sessions, and workflows from Development to Testing environments
• Extensively worked with the QA team to get the system and Integration testing done successfully and involved in ETL testing.

Environment: Informatica Power Center v 8.6, Teradata, Oracle 9i/10g, XML Files, Excel files, SQL, PL/SQL, Unix Shell scripting, Windows XP and, SQ Developer, Toad.