SUMMARY

• 8 years of experience in using Informatica PowerCenter(9.x/8.x/7.x/6.x).
• Experience in Data Cleansing Dimensional Modeling (Star schema, Snow - flake schema), Logical and Physical design while implementing Industry accepted methodologies Bill Inmon and/or Ralph Kimball.
• Extensive experience in Debugging and Resolving data issues in Identifying System Bottlenecks, performance tuning, Data Cleansing, bug fixing, and source to target data flow.
• Extensive experience using Oracle 11g/10g/9i, MS SQL Server 2005/2000, SQL.
• Experience in Installation, Configuration, and Administration of Informatica Power Center 9.x/8. x.
• Developed ETL (Informatica) jobs using various transformations like Join, union, Lookup, Surrogate key, Sort, Remove Duplicate, Filter and Aggregator.
• Good knowledge of Data Warehousing Principles (OLTP and OLAP concepts) and architectural methodologies (Normalization, Dimensional Modeling).
• Preparation of test data, Resolution of defects across all phases of Testing (Unit/System/Regression/UAT).
• Experienced in performing gap analysis to identify system modifications and providing ETL solutions.
• Extensively worked with production support team to resolve issues and worked in extracting data from Oracle, Mainframe files and flat files.
• Competent in all aspects of Data Warehousing including project planning, requirement gathering, data modeling, development, deployment, maintenance, and enhancements.
• Hands on experience in ETL process using Informatica Power Center for loading data from various data sources.
• Hands on strong experience in Informatica installation, configuration and administration.
• Excellent communication and interpersonal skills and ability to work in a team as well as individually.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9x/8x/7x/6x.

RDBMS: Oracle11g/10g/9i/8.x, DB2, SQL Server 2005/2000

Other Tools & Utilities: TOAD, MS -Visio, CONTROL-M

Languages: SQL, C, C++

Scripting Languages: Java Script, Shell Scripting

PROFESSIONAL EXPERIENCE

Confidential

System Analyst

Responsibilities:

• Attended client meetings and assist with determination of project requirement.
• Assisted the PM in the drafting and issuance of project preliminary schedules, estimates.
• Chair site meetings and distributed minutes to all project team members.
• Tracked the progress and quality of work being performed by design disciplines/trades.
• Effectively and accurately communicated relevant project information to the client and project team.
• Communicated the Project Manager and others about project status and issues that may impact project schedule.
• Communicated ideas for improving company processes with a positive and constructive attitude.
• As a technical responsibility, Extracted Data from Oracle and Flat files using Informatica.
• Design of ETL processes using Informatica tool to transform data from source system to target database.
• Designed and developed various Mappings using transformations like aggregator, joiner, Lookup, Filter, Router and Update Strategy.
• Writing Various SQL queries for Testing the Mappings.
• Used Debugger for debugging Mappings.
• Performed tasks of executing, scheduling and validating the sessions in Informatica workflow manager

Confidential

Informatica Developer

Responsibilities:

• Extensively worked in data Extraction, Transformation and Loading from Source to target System using Power Center of Informatica.
• Importing Source/Target tables from the respective databases and created.
• Reusable transformations and mappings using Designer Tool set of Informatica.
• Created Transformations and Mappings using Designer Tools set of Informatica.
• Scheduled Workflows Using Workflow Manager.
• Extensively Involved in Preparation of Technical Specifications. Prepared Unit Test Specification Requirements

Confidential

Informatica Developer

Responsibilities:

• Extensively Involved in Business requirements gathering and analysis of the source data.
• Completed documentation in relation to detailed work plans, mapping documents and high-level data models.
• Developed conceptual design to meet the requirements, followed by the logical process flow.
• Creating the Tasks like Command, Sessions, and Workflows using Workflow Manager Component.
• Done the Unit testing on newly and modified Mappings, Sessions and Workflows.
• Created the Repositories in Test and Production environment and created folders, users.
• Configure the Repository and Informatica Servers in Dev, Test, Prod environments.

Confidential

Informatica Developer

Responsibilities:

• Created and Imported/Exported various Sources, Targets, and Transformations using Informatica Power Center Designer.
• Developed number of Complex Informatica Mappings, Mapplets and Reusable Transformations for the Sales and Marketing Systems to facilitate one time, Daily, Monthly and Yearly Loading of Data.
• Involved in fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and the Target Data.
• Developed Mappings for the Category, Specification, Code, Type areas.
• Responsible to design, develop and test the software (Informatica, PL SQL, UNIX shell scripts) to maintain the data marts (Extract data, Transform data, Load data
• Involved in the development and testing of programs, Informatica mappings and update processes.
• Designed and developed complex Aggregate, Join, Router, Look up and Update transformation rules (business rules).
• Developed schedules to automate the update processes and Informatica Sessions/Batches.

Confidential

Informatica Developer

Responsibilities:

• Designed data models for Data warehouse supporting data from multiple sources with Informatica Power center.
• Extensively worked with Informatica to load data from Oracle Applications, namely Oracle Financials to the target database.
• Responsible to design, develop and test the software (Informatica, PL SQL, UNIX shell scripts) to maintain the data marts (Extract data, Transform data, Load data
• Involved in the development and testing of programs, Informatica mappings and update processes.
• Designed and developed complex Aggregate, Join, Router, Look up and Update transformation rules (business rules).
• Developed schedules to automate the update processes and Informatica Sessions/Batches.

Confidential

Developer

Responsibilities:

• Responsible to design, develop and test the software (Informatica, PL SQL, UNIX shell scripts) to maintain the data marts (Extract data, Transform data, Load data
• Involved in the development and testing of programs, Informatica mappings and update processes.
• Designed and developed complex Aggregate, Join, Router, Look up and Update transformation rules (business rules).
• Developed schedules to automate the update processes and Informatica Sessions/Batches.
• Designed data models for Data warehouse supporting data from multiple sources with Informatica Power center.