SUMMARY

• Over 8 years of total IT experience and technical proficiency in ETL Processes for clients in major industry sectors like Finance and Health.
• Data Warehousing experience in using Informatica 9.5/9.1/8.6/8.1/7.1 PowerCenter Client tools - Designer, Repository manager, Workflow manager/monitor and Server tools - Informatica Server, Repository Server manager.
• Implemented various Data warehouse projects and supported them by using Ralph Kimball and Bill Inmon methodologies.
• Experience in Data warehousing concepts like Star Schema and Snowflake schema.
• Extensive experience in Extraction, Transformation and Loading (ETL) of Data into Data Warehouse using Informatica Power Center 9.5,9.1, 8.6, 8.5x, 7.x and 6.x versions.
• Experience in Designing and developing the complex mappings from various Transformations like Source Qualifier, Joiner, Aggregator, Router, Filter, Expression, Lookup, Sequence Generator, Update Strategy, Sorter Transformation etc.,
• Strong experience in developing the Mappings, Mapplets, Sessions and Workflows.
• Experience in Debugging sessions and mappings; Performance Tuning of the Sessions and mappings, implementing the complex business rules, optimizing the mappings.
• Knowledge of Entity relationship concepts, Facts and Dimensions tables, slowly changing dimensions and Dimensional modeling (Star Schema and Snow Flake Schema).
• Strong knowledge of RDBMS like DB2 UDB / SQL Server/Oracle / Teradata.
• Solid Experience with SQL Query Tuning on DB2 UDB / SQL Server/Oracle.
• Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Experience in using Automation Scheduling tool like, Control-M.
• Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.
• Strong analytical, problem-solving and organizational skills.

TECHNICAL SKILLS

Operating Systems: Windows 200X/XP/95/NT Server. UNIX (Sun-solaris, AIX, HP/UX), Linux.

ETL Tools: Informatica PowerCenter 7.X/ 8.6.1/9.1/9.5

Databases: Oracle 8i/9i/10g/11i, DB2, DB2 UDB, MS-SQL Server 2000/2005/2008 Sybase 10, My SQL and MS-Access, Teradata.

Languages: C, Java 1.5, UNIX Shell Scripting, SQL, PL/SQLReporting Tools

OBIEE 11g/10.1.3.XTools: TOAD, MS VISUAL STUDIO, MS VISIO, MS PROJECTSQL *PLUS, SQL Loader, AUTOSYS, Control-M

Modeling: Star-Schema Modeling, Snowflake Modeling, FACT and Dimension Tables, ERWIN 4.1/4.0/3.5.2, Logical & Physical Data Modeling

PROFESSIONAL EXPERIENCE

Confidential, Schaumburg, IL

ETL/Informatica Developer

Responsibilities:

• Analyzed business requirements and worked closely with the various application teams and business teams to develop ETL code.
• Created mappings using the transformations like Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update Strategy and Joiner transformations.
• Created reusable transformations and Mapplets and used them in mappings.
• Used the XML Parser transformation to parse the source xml message queue.
• Used the web service consumer transformation to call the MDM web service.
• Used the upsert operation to insert and update data in sales force target.
• Created and monitored workflows and taskusing Informatica PowerCenter Workflow Manager.
• Created Autosys jobs using command interface to run the informatica workflows.
• Created various Documents such as Source-To-Target Data mapping Document and Unit Test Cases.
• Involved inUnit testing, Iterative testingto check whether the data loads into sales force target are accurate, which was extracted from message queue.
• Created error processing to handle the error records according to the business requirement.
• Activelycoordinated with testing team in the testing phaseand helped the team to understand the dependency chain of the whole project.

Environment: Informatica Powercenter 9.5/9.1, UNIX, Oracle 11g/10g, SQL, MQ, Salesforce, DB2, SQL Developer, Toad and Windows 2000 / XP, AQT.

Confidential, Dallas, TX

ETL/Informatica Developer

Responsibilities:

• Worked on Informatica Power Center 9.5/9.1 - Source Analyzer, Data warehouse designer, Mapping Designer & Mapplet, Transformations, Work Flow Manager (Task Developer, Worklets, and Work Flow Designer) and Work Flow Monitor.
• Responsible for developing, Testing, support and maintenance for the ETL processes using Informatica Power Center.
• Created mappings using the transformations like Source Qualifier, Aggregator, Expression, Lookup, Router, Normalizer, Filter, Update Strategy and Joiner transformations.
• Created reusable transformations and Mapplets and used them in mappings.
• Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Used Informatica Power center workflow manager to create sessions, workflows and Worklets to run with the logic embedded in the mappings.
• Used the Informatica Server Manager to embed sessions with pre- and post-session shell scripts and also, wrapped session PMCMD commands in shell scripts for batch processing using Control M Scheduler.
• Designed and developed UNIX shell scripts to schedule jobs. Also wrote pre-session and post-session shell scripts.
• Unit tested and tuned SQLs and ETL Code for better performance.
• Created various Documents such as Source-To-Target Data mapping Document, Unit Test Cases and Data Migration Document.
• Actively involved in building the system test environment and migrated mappings from Development to System Test environment and executed code in QA environment.
• Involved in. Monitored the performance and identified performance bottlenecks in ETL code.

Environment: Informatica Powercenter 9.5/9.1, UNIX, Oracle 11g/10g, SQL, Teradata, PL/SQL, SQL Developer, Toad and Windows 2000 / XP, WinSQL.

Confidential, Baltimore, MD

ETL/Informatica Developer

Responsibilities:

• Interaction with business users and team leads for better understanding of business specifications and requirements, Identifying data sources and Development strategies.
• Extracted data from different sources such as Oracle, SQL Server, Teradata, DB2, Flat Files and Fixed width files to load into Operational Data Store (staging area).
• Developed mappings in Informatica to load the data from various sources using transformations like Source Qualifier, Expression, Lookup (connected and unconnected), Aggregator, Update Strategy, Filter, Router, Joiner, Union, Normalizer, Sorter etc.
• Developed complex mappings by extensively using the Informatica transformations and flagging the records using the update strategy for populating the desired slowly changing dimension (Type 1, Type 2, and Type 3) tables.
• Developed Mapplets and Reusable Transformations used to prevent redundancy of transformation Usage and Maintainability.
• Used Workflow manager and Workflow monitor for Workflow, sessions and database connection management and workflow monitoring.
• Identified performance bottlenecks and fine-tuning ETL mappings and workflows for performance. Performed Data Cleansing and Data profiling for Data consistency.
• Designed SQL queries with multiple joins to pull relative data during import state.
• Designed and modified PL/SQL Stored Procedures to modify data flow. Used Informatica workflow manager for creating, running the batches and sessions and scheduling them with UNIX shell scripting to run at specified time.
• Tuning and performance improvement of the jobs in Informatica. Involved in Unit testing of mappings.
• Designed and documented validation rules, error handling routines and testing strategy for the mappings.

Environment: Informatica Powercenter 9.5/9.1, UNIX, Oracle 11g/10g, SQL, PL/SQL, SQL Developer, Toad and Windows 2000 / XP,WinSQL.

Confidential, NY

ETL/Informatica Developer

Responsibilities:

• Coordinated with Business Users to understand business needs and involved in gathering of business scope and technical requirements and created technical specifications.
• Designed and developed various Informatica mappings using transformations like Expression, Aggregator, External Procedure, Stored Procedure, Lookup, Filter, Joiner, Rank, Router, Update Strategy and XML.
• Developed complex mappings and SCD type-I, Type-II and Type III mappings in Informatica to load the data from various sources using different transformations.
• Involved in design and development complex ETL mappings and stored procedures in an optimized manner.
• Used Informatica Workflow Manager and Workflow Monitor to schedule and monitor session status and have implemented decision task and email task for tracking the successful completion.
• Developed and tested all the backend programs, Error Handling Strategies and update processes.Worked on bug fixes on existing Informatica Mappings to produce correct output.
• Performed data validation in the target tables using complex SQLs to make sure all the modules are integrated properly.
• Design and development of UNIX Shell Scripts to handle pre and post session processes.
• Implemented performance tuning logic on Targets, Sources, mappings, sessions to provide maximum efficiency and performance.
• Created Stored Procedures to transform the data. Worked extensively on SQL, PL/SQL for various needs of the transformations.

Environment: Informatica Powercenter 9.1/8.6.1, UNIX, SQL Server 2000/2008, DB2, SQL, PL/SQL, SQL Developer, Sybase, Toad and Windows 2000 / XP,WinSQL.

Confidential, CA

ETL /Informatica Developer

Responsibilities:

• Worked with the business analysts to gather business requirements and extracted data according to the business rules and technical specifications.
• Analyzed the source data coming from Oracle, DB2 and flat files etc.
• Used Informatica Designer to create mappings using different transformations to move data to a Data Warehouse.
• Developed complex mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Source Qualifier, Expression, Lookup, Aggregator, Update Strategy, Joiner, and Rank.
• Used task developer in the Workflow manager to define sessions. Created reusable worklets and mapplets. Involved in data cleansing and data profiling.
• Involved in writing UNIX shell scripting for Informatica ETL tool to run the sessions.
• Developed schedules to automate the update process and Informatica Batches/Sessions.
• Monitored sessions that were scheduled, running, completed or failed and debugged mappings for failed sessions.
• Worked on database connections, SQL joins, loops, aliases, views, aggregate conditions.
• Implemented data integrity constraints like referential integrity using primary-key and foreign-keys relationships.
• Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system.
• Documented processing times, developed test cases and used them to run through each process.

Environment: Informatica Power Center 8.6/8.1 (Power Center Designer, workflow manager, workflow monitor), SQL*Loader, Oracle 10g/9i, DB2, Windows XP, TOAD, UNIX.

Confidential, Charlotte,NC

Informatica Developer

Responsibilities:

• Analyzed the requirements and framed the business logic for the ETL process.
• Designed and developed Informatica’s Mappings and Sessions based on business user requirements and business rules to load data from source flat files and oracle tables to target tables.
• Used Informatica Designer to create mappings using different transformations to move data to a Data Warehouse from SQL server and Sybase.
• Extensively used several transformations such as Source Qualifier, Router, Lookup (connected & unconnected), Update Strategy, Joiner, Expression, Aggregator and Sequence generator transformations.
• Identified and tracked the slowly changing dimensions, heterogeneous Sources and determined the hierarchies in dimensions.
• Used debugger to debug mappings to gain troubleshooting information about data and error conditions. Involved in monitoring the workflows and in optimizing the load times.
• Involved in fixing invalid Mappings, testing of Stored Procedures and Functions, Testing of Informatica Sessions, and the Target Data.
• Created reusable transformations and Mapplets and used them in mappings.
• Used Informatica Repository Manager to maintain all the repositories of various applications.
• Worked on SQL tools like TOAD to run SQL queries to validate the data.
• Design and Development of pre-session, post-session and batch execution routines to run Informatica sessions using Informatica Server.
• Created and Scheduled sessions & Worklets using workflow Manager to load the data into the Target Database..

Environment: Informatica PowerCenter 8.1.1/7.1.3, DB2, Oracle9i, SQL, MS SQL Server 2000, MS Query Analyzer, Flat file,, UNIX, Toad, Windows NT.

Confidential

ETL Developer

Responsibilities:

• Involved in the requirement definition and analysis in support of Data Warehousing efforts.
• Designed and developed mappings that included Source Qualifier, Aggregator, Joiner, Lookup, Filter, Router, Update Strategy, Expression, Stored Procedure, Rank and Sequence Generator transformations.
• Involved in the creation of jobs using Informatica workflow manager to validate schedule run and monitor jobs using Workflow Monitor.
• Extensively used ETL to load data from Flat files which involved both fixed width as well as Delimited files and also from the relational database, which was Oracle 9i.
• Developed and tested all informatica mappings involving Advanced External Procedure, complex lookups and update strategies.
• Created shell scripts for moving the Flat files from one directory to another once the session is done. Configured sessions with email when failure, command task and decision task.
• Involved in partitioning of the sessions and performance tuning of database and informatica.
• Worked on Dimension as well as Fact tables, developed mappings and loaded data on to the relational database.
• Analyzed the session, event and error logs for troubleshooting mappings and sessions.
• Created dimensions, dimension hierarchies, levels, level based measures and defined level, attributes level keys and report development.

Environment: Informatica Power Center 7.1, Erwin 4.2, Oracle 9i, SQL, PL/SQL, Toad 7.6.0.1.1, Windows XP Professional 2002, UNIX.