SUMMARY

• Over 7+ years of combined Industry Experience as a Data Warehousing professional and ETL Developer in designing, developing and implementing ETL processes for business applications.
• Experience in data warehousing development using various ETL tools (Informatica 8x/9.5) and Oracle warehouse builder
• Experience in working with data warehouses and data marts using Informatica Power center (Designer, Repository Manager, Workflow Manager, and Workflow Monitor)
• Extensive experience in analyzing application/system issues to determine the cause of the problem and then collaborates with others to resolve the issue in a timely manner
• Expertise in BI / Data warehouse projects involving Informatica
• Understanding & Working knowledge of Informatica CDC (Change Data Capture)
• Developed Strategies for Extraction Transformation Loading (ETL) mechanism
• Extensive knowledge with Dimensional Data modeling, Star Schema/snowflakes schema, Fact and Dimension tables
• Worked with Type 1 and 2 dimensions, Fact Tables, Star Schema and Snow flake design, Operational Data Store (ODS), leveling and other Data Warehouse concepts.
• Re - engineer some of the current ETL processes to streamline the data acquisition and integration process using Informatics Power Center and UNIX scripts
• Work with business partners to define analysis requirements. Guide them through the BI delivery process and layout the business and application architecture road map.
• Extensive work with Informatica Pushdown Optimization and Message Queue.
• Basic Knowledge on Unix Shell Scripting
• Hand-on experience in failure Investigation, error tracking, creating bug fix plan, coordinating with all the teams involved, communicating with the client management for all the Production related issues
• Experience in coordinating with onsite/Offshore on development / maintenance projects
• Have used third party schedulers which include Autosys
• Reliable, responsible, hard-working and good team player.
• Strong interpersonal and communication skills.

TECHNICAL SKILLS

ETL Tools: Informatica 8x, 9.5, Oracle Warehouse Builder10g

RDBMS: DB2v9x, Netezza, SQL Server, Oracle 10

Languages: SQL, UNIX

OS: UNIX, Windows

Tools: Autosys, SharePoint, Quality Center11.0

PROFESSIONAL EXPERIENCE

Confidential, IL

Technical Lead

Responsibilities:

• Involved in gathering business requirements, analysis, development and testing and production support of client application.
• Involved in creating high level design documents, functional specification documents and change requirement documents.
• Worked on extracting data from various heterogeneous sources like Netezza, files.
• Extensively worked with Slowly Changing Dimensions Type1 and Type2 for Data Loads
• Tracked production issues and provided application support in case of job failures.
• Involved in handling the production tickets and resolve them in timely manner.
• Responsible for Performance Tuning at the Mapping Level, Session Level, Source Level, and the Target Level.
• Extensively worked with Source Qualifier Transformation to join the homogeneous sources.
• Extensively worked with Joiner Transformation to join the heterogeneous sources.
• Extensively worked with both Connected and Un-Connected Lookups.
• Extensively worked with Look up Caches like Shared Cache, Persistent Cache, Static Cache, and Dynamic Cache to improve the performance of the lookup transformations.
• Worked with re usable objects like Re-Usable Transformation and Mapplets.
• Extensively worked with aggregate functions like Avg, Min, Max, First, Last in the Aggregator Transformation
• Extensively used SQL Override function in Source Qualifier Transformation
• Extensively used Normal Join, Full Outer Join, Detail Outer Join, and master Outer Join in the Joiner Transformation.
• Responsible for migrate the workflows from development to production environment.
• Extensively worked with Incremental Loading using Parameter Files, Mapping Variables, and Mapping Parameters.
• Involved in maintaining the share point portal to upload the documents regularly and store them on share point site.
• Coordinate deployment process and issues across various development and infrastructure teams and environments.
• Responsible for Performance in Informatica PowerCenter at the Target Level, Source level, Mapping Level, Session Level, and System Level.
• Responsible for offshore and onsite coordination
• Extensively worked salesforce targets.

Environment: Informatica Power Center 9.5.1, Netezza, UNIX, Autosys, Window XP

Confidential

Technical Lead

Responsibilities:

• Involved in gathering business requirements, analysis, development and testing and production support of client application.
• Involved in creating high level design documents, functional specification documents and change requirement documents.
• Worked on extracting data from various heterogeneous sources like db2, message queue
• Extensively used SQL Override function in Source Qualifier Transformation
• Extensively used Normal Join, Full Outer Join, Detail Outer Join, and master Outer Join in the Joiner Transformation.
• Mentoring other developers in technical and business aspects.
• Responsible for migrate the workflows from development to production environment.
• Extensively worked with Incremental Loading using Parameter Files, Mapping Variables, and Mapping Parameters.
• Involved in maintaining the share point portal to upload the documents regularly and store them on share point site.
• Coordinate deployment process and issues across various development and infrastructure teams and environments.
• Used Post and Pre session commands to call scripts which Drop, recreate indexes and run stats on the warehouse table which was loaded.
• Responsible for Performance in Informatica Power Center at the Target Level, Source level, Mapping Level, Session Level, and System Level.

Environment: Informatica Power Center9.5.1, DB2, Netezza, UNIX, Autosys, Window XP

Confidential

Senior Informatica Developer

Responsibilities:

• Involved in creating high level design documents and low design document.
• Worked on extracting data from various heterogeneous sources like DB2 and Flat files.
• Extensively worked with Slowly Changing Dimensions Type1, Type2 for Data Loads
• Tracked production issues and provided application support in case of job failures.
• Involved in handling the production tickets and resolve them in timely manner.
• Responsible for Performance Tuning at the Mapping Level, Session Level, Source Level, and the Target Level.
• Extensively worked with Source Qualifier Transformation to join the homogeneous sources.
• Extensively worked with Joiner Transformation to join the heterogeneous sources.
• Extensively worked with both Connected and Un-Connected Lookups.
• Extensively worked with Look up Caches like Shared Cache, Persistent Cache, Static Cache, and Dynamic Cache to improve the performance of the lookup transformations.
• Worked with re usable objects like Re-Usable Transformation and Mapplets.
• Extensively worked with aggregate functions like Avg, Min, Max, First, Last in the Aggregator Transformation
• Extensively used SQL Override function in Source Qualifier Transformation
• Extensively used Normal Join, Full Outer Join, Detail Outer Join, and master Outer Join in the Joiner Transformation.
• Responsible for migrate the workflows from development to production environment.
• Extensively worked with Incremental Loading using Parameter Files, Mapping Variables, and Mapping Parameters.
• Involved in maintaining the share point portal to upload the documents regularly and store them on share point site.
• Coordinate deployment process and issues across various development and infrastructure teams and environments.
• Responsible for Performance in Informatica Power Center at the Target Level, Source level, Mapping Level, Session Level, and System Level.

Environment: Informatica Power Center8.x, db2, UNIX, Window XP

Confidential

Senior Informatica Developer

Responsibilities:

• 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 data.
• Extensively worked on performance tuning of mappings, sessions, Target, Source and various ETL processes.
• 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.

Environment: Informatica Power Center8.x, SQL Server, Window XP

Confidential

Informatica Developer

Responsibilities:

• Extensively Involved in creating the mappings, sessions and Workflows
• 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 data.
• Extensively worked on performance tuning of mappings, sessions, Target, Source and various ETL processes.
• Extensively involved in troubleshooting the issues in UAT.
• Extensively involved in unit testing and unit test case creation
• Responsible for troubleshooting the informatica tasks and performance related issues and data issues using the session logs, debugger and performance indicators provided by informatica.

Environment: Informatica Power Center8.x, SQL Server, Window XP

Confidential

Informatica Developer

Responsibilities:

• Extensively Involved in creating the mappings, sessions and Workflows
• 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.
• Extensively worked on performance tuning of mappings, sessions, Target, Source and various ETL processes.
• Extensively involved in troubleshooting the issues in UAT.
• Extensively involved in unit testing and unit test case creation
• Responsible for troubleshooting the informatica tasks and performance related issues and data issues using the session logs, debugger and performance indicators provided by informatica.

Environment: Informatica Power Center8.x, SQL Server, Window XP

Confidential

Oracle Warehouse Builder developer

Responsibilities:

• Extensively Involved in creating the mappings, sessions and Workflows
• Extensively involved in unit testing and unit test case preparation.
• Fixing the defects and monitoring the status till the defect is closed.

Environment: Oracle warehouse builder10g, Oracle, Windows