SUMMARY

• Around 8.6 Years of solid IT industry experience with 8 years of extensive experience as a LEAD in Informatica, Data Warehousing and Data integration projects.
• Informatica Certified Specialist Developer.
• Having in depth Informatica development knowledge and also worked in support.
• Strong Hands - on experience with Power enter Informatica Designer, Workflow manager, Workflow Monitor and Repository Manager.
• Well versed with Data Warehousing concepts and ETL designs for loading Star Schemas/ Snowflake schemas.
• Sound knowledge in Informatica transformations and its several components like Workflow manager, Repository manager, Workflow Monitor.
• Good understanding and hands on Performance tuning of mappings / sessions in Informatica.
• Strong hands-on in Oracle 9i, 10g, 11g and on PL/SQL, Functions, Procedures, Triggers and Cursors.
• Advanced development and implementation knowledge in informatica mapplets, SQL overrides, load types, session partitioning.
• Transformations knowledge on Lookup, Joiner, Aggregator, Sorter, Rank, Expression, Union, SQL transformation, Source Qualifier, Filter, Router, Stored procedure, XML, Normalizer, Sequence Generator, Transaction Control, Update Strategy.
• Good experience in developing re-usable and non-re-usable tasks.
• Sound knowledge in SQL queries and Informatica integration with other databases.
• Very good Debugging skills in issues pertaining to Oracle and Informatica.
• Very well experienced in client communication.
• Exceeded Client’s expectation in resolving critical issues in Informatica transformations.
• Knowledge on SDLC Processes and Change Management processes.
• Sound experience in adhering to ETL standards and designing ETL process and frameworks to help reusability.
• Well known skill for issue resolution till the closure.
• Good Team management capability.

• Power enter 9.x/8/x expert
• Oracle 9i / 10g / 11g proficiency
• Proficient in ETL
• Requirement Analysis and Design phase experience
• Well experienced in every phase of SDLC
• Shell scripting and UNIX commands experience
• Informatica Certified Specialist
• Analytical Problem Solving Capabilities
• Team player / Motivator
• Customer Oriented approach
• Experienced in Waterfall model and Agile Development methodology as well
• Basics of Python scripting
• Change Data Capture (CDC)

PROFESSIONAL EXPERIENCE

Confidential, Portland, OR

Lead Informatica Consultant

Responsibilities:

• As a senior developer, responsibilities include discussion with business managers and take the required inputs as per the requirement.
• Assigning tasks to the respective individual team members based on the required deliverables to satisfy a lead responsibility.
• Extensively involved in developing the ETL logic to do the Auditing and Error Handling for the loads happening across different projects using Informatica.
• Passionately drive the development and give the top notch delivery.
• Developed the ETL code in Informatica and also have done unit testing.
• Test results to be captured and documented thoroughly.
• To contribute to daily work by understanding new requirements and change the ETL accordingly.
• Review the code developed by other team members.
• Suggest any performance oriented approaches as applicable.
• Always deliver and stay on top of Informatica development and support related issues.

Environment: Windows 7, Informatica 9.5, UNIX, SQL.

Tools: HP Quality Centre for bug tracking and issue resolution.

Confidential, Denver, CO

Sr. Informatica Developer

Responsibilities:

• To interact with Client directly and discuss any on-going issues and provide guaranteed solutions that are destined to work.
• Discuss with team and get the doubts clarified before going to start their daily activities.
• Assigning tasks to the respective individual team members based on the required deliverables.

Environment: Windows XP, Informatica 9.1, UNIX, SQL.

Tools: CA Harvest SCM Workbench (for source code control)

Confidential, Louisville, KY

Sr.Informatica Developer

Responsibilities:

• Understanding the business requirement and the functional requirements.
• Extensively worked in data Extraction, Transformations and Loading from different source system and manipulated ETL-logic to Target system tables
• Developed PL/SQL Procedures and packages and using in informatica pre/post session routines SQL for metrics calculation.
• Created command tasks using informatica workflow-designer and execute the corresponding Shell-script.
• Used Informatica Power enter for Extraction, Loading and Transformation(ETL) of data in the data warehouse.

Environment: Windows XP, Informatica 8.6, SQL, UNIX, $Universe Scheduler, Enterprise Turn Point.

Tools: Tortoise SVN (for source code control)

Confidential

Informatica Developer

Responsibilities:

• Preparing Data builds for new change requirements.
• Handling ORT calls with customers.
• Resolving issues related to Calls.
• Issue resolution regarding the provisioning of a Service, Customer detail, Number detail.

Environment: Windows XP, Vista, SQL, UNIX, Informatica

Tools: Tortoise SVN (for source code control)

Confidential

Informatica Developer

Responsibilities:

• Used Informatica Power enter for Extraction, Loading and Transformation (ETL) of data in the data warehouse.
• Used most of the Transformations such as Source Qualifier, Aggregator, lookup, Filter, Joiner, Sequence generator, Router, update strategy etc.
• Used session parameters, Mapping variable/parameters and created parameter files for flexible runs of workflows based on changing variable values.
• Involved in Optimizing and performance tuning logic on targets, sources, mappings, and sessions to increase the efficiency of session.
• Reloading data for failed informatica workflows and finding out RCA.

Environment: Windows XP, Vista, Informatica 8.6, PL/SQL, UNIX basics

Tools: Microsoft Visual Source Safe (for source code control)

Confidential

Informatica Developer

Responsibilities:

• Involved in execution of the Cmo to Walky10 migration for different circles.
• Involved in Cmo to VDATA migration activity.

Environment: Oracle 9i SQL, PL/SQL, UNIX, Informatica Basic transformations.

Tools: Rational ClearCase Explorer (for source code control)