SUMMARY

• Over 8+ years of combined Industry Experience as a Data Warehousing professional and ETL Developer in designing, developing and implementing ETL processes for business applications.
• Extensive experience in implementing the ETL processes which include developing the data model, designing the change capture and disaster recovery strategies.
• Have a clear understanding of Data Warehousing concepts with emphasis on ETL and Life Cycle Development including requirement analysis, design, development, testing and implementation.
• Experience in Data Warehouse development working with Data Conversion, and Extraction/Transformation/Loading using Informatica PowerMart/PowerCenter with Oracle, SQL Server, Teradata and DB2 databases.
• Worked with various Power Center/Power Mart components like Informatica Server and Client tools like Designer, Workflow Manager, and Repository Manager & Workflow Monitor.
• Knowledge in power center features partitioning, Recovery for concurrent sessions, version controlling of the ETL process.
• Experience in integration of various data sources like Oracle, SQL Server and DB2 into the Staging Area.
• Experience in optimization techniques such as concurrent caching and using push down optimization.
• Worked on loading data into Data Warehouse/Data Marts using Informatica, Import Utilities, SQL*Loader.
• Good experience with star schema, dimensional data modeling, Fact and dimensional tables, slowly changing dimensions.
• Involved in Informatica Performance tuning of the ETL process.
• Extensive experience in designing the architecture for Extract, Transform, Load environment and development of mappings and process using Informatica Power Center.
• Extensive experience in formulating error handling mechanism.
• Have knowledge in automating the ETL processes for migration and patching Informatica objects
• Have used third party schedulers which include Control - M, AutoSys and Dollar-U
• Excellent communication skills, Good organizational skills, outgoing personality, Self-motivated, hardworking, ability to work independently or cooperatively in a team, eager to learn, ability to grasp quickly.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 6.x/7.x/8.x/9.x

Databases: Oracle 8.i/9.i/10g/11g, SQL Server, DB2 UDB 8.1 Teradata V8.

Data Modeling Tools: Erwin 4.1, ER Studio

Languages: SQL, PL/SQL, C, C++, Java

Scripting Languages: Korn Shell, Bash shell scripting

Business Intelligence Tools: OBIEE 11.x, Cognos 7.x

Operating Systems: Windows, Red Hat Linux, Sun Solaris, IBM AIX

PROFESSIONAL EXPERIENCE

Confidential, VA

Sr. ETL / Informatica Developer

Responsibilities:

• Involved in the design, development and implementation of the Enterprise Data Warehousing (EDW) process and Data Mart.
• Used Informatica Power Center 9.0.3 for migrating data from various OLTP servers/databases to the data mart.
• Created complex Informatica mappings to load the data mart and monitored them.
• The mappings involved extensive use of transformations like Aggregator, Filter, Router, Expression, Joiner, Sequence generator.
• Used Lookup Transformation to access data from tables, which are not the source for mapping and also used Unconnected Lookup to improve performance.
• Expertise in developing SQL and Oracle PL/SQL code as procedures to implement the business logic.
• Worked on ETL design, development, source to target mappings, data warehouse transformations, on call support, troubleshooting, testing, and documentation.
• Used Informatica Power Center/Power Exchange to extract/transform and load data from different operational data sources like Oracle, Flat files into staging area (Oracle) and load into Oracle data warehouse.
• Performed data analysis for Advanced Commercial Banking System (ACBS) data.
• Implemented Slowly Changing Dimensions for accessing the full history of accounts and transaction information.
• Extensively worked with performance tuning at mapping levels. For example, implementing active transformation like filter as early as possible in the mapping.
• Created and configured workflows, and sessions using Informatica Workflow Manager.
• Performed unit test for Informatica mappings and workflows in both development and test environments.

Environment: Informatica Power Center 9.X, Toad Data Modeler, Oracle 10g/11g, Visio, Excel, Flat Files.

Confidential, San Francisco

ETL Consultant

Responsibilities:

• Involved in business analysis and technical design sessions with business and data architect to develop requirements document, data models and ETL specifications.
• Used reusable logic to create mappings for three regions Europe, America and AMEA.
• Developed error handling mechanism to load invalid records into error table with an appropriate status.
• The status of the record determines whether the record is to be reprocessed with the next day load.
• Extensively worked on performance tuning of mappings, sessions and various ETL Processes.
• Used Post and Pre session commands to call scripts which Drop, recreate indexes, run reorg and runstats on the warehouse table which was loaded.
• Worked on performance tuning of various mappings and session to identify and remove the bottle necks.
• Created PL/SQL stored procedures.
• Developed mappings for implementing type I and type II slowly changing dimensions and dimensional hierarchies.
• Mentoring other developers in technical and business aspects.
• As the project had a crunching timeline we had to spend we had to work overtime but were successful in meeting the deadline.

Environment: Informatica, Oracle, Linux, Windows NT/2000

Confidential, Chicago, IL

ETL Consultant

Responsibilities:

• Involved in business analysis and technical design sessions with business and data architect to develop requirements document, data models and ETL specifications.
• Developed error handling mechanism to load invalid records into error table with an appropriate status.
• The status of the record determines whether the record is to be reprocessed with the next day load.
• Developed notification mechanism to send out error reports to the required groups.
• Also developed notification mechanism to send out daily load status reports to the operations team.
• Developed type two mapping to load the Customer, Legal Entity hierarchy and Product master data.
• Developed type 1 mapping to load the sales transaction data.
• Extensively worked on performance tuning of mappings, sessions, Target, Source and various ETL processes.
• Created Informatica mappings with PL/SQL stored procedures to in corporate critical business functionality to load data.
• Extensively involved in troubleshooting the issues in UAT.
• Responsible for troubleshooting the informatica tasks and performance related issues and data issues using the session logs, debugger and performance indicators provided by informatica.
• Have knowledge to invoke the informatica workflows through command line using PMCMD

Environment: Informatica, Oracle, PL/SQL, Linux, TOAD and Windows NT/2000, FileZilla.

Confidential

ETL Consultant

Responsibilities:

• Involved in review and finalizing the technical specifications of source-target mapping documents
• Responsible for Data Extraction and Transformation from disparate sources like Oracle, SAP R/3 using Informatica Power Center.
• Addressed critical areas of impact in terms of performance, data integrity, runtime errors, user interface, application maintenance and development.
• Involved in designing Error Handling strategy using Error detection/Notification/Re-Processing processes
• Created source to target mappings according to business requirements.
• Worked on the transformations like Source Qualifier, Expression, External Procedure, Router, Sequence Generator, Aggregator, Filter, Joiner, and Lookup.
• Extensively used concurrent lookup caches for fine tuning the Informatica processes.
• Worked on performance tuning of various mappings and session to identify and remove the bottle necks.
• Involved in creating delta files, which involved comparing current data with previous day’s data and sending the delta records to third party called Inventive.
• Used Post and Pre session commands to call scripts which Drop, recreate indexes on the warehouse table which was loaded.
• Involved in fine-tuning the ETL mapping by studying the session logs and coming up with a better strategy to deal with bottlenecks such as time involved in building the cache.
• Developed mappings for implementing type I and type II slowly changing dimensions and dimensional hierarchies and aggregates
• Mentoring other developers in technical and business aspects.

Environment: Informatica, Oracle, PL/SQL, Sun Solaris, TOAD and Windows NT/2000.