OBJECTIVE

• Seeking for a position as Informatica developer/consultant in Silicon valley area.

SUMMARY

• 5+ years of ETL experience with Informatica PowerCenter (9.1/8.5/8.1.1 ) and in developing & Administering ETL mappings with Designer (Source Analyzer, Target Designer, Transformation Developer, Mapping Designer, Mapplet Designer), Repository Manager, Workflow Manager, Workflow Monitor& Admin console.
• 4+ years of experience in Database front using Oracle9i/8i/8.0, MS SQL Server 2005/2008, MS Access and PL/SQL.
• Data Analysis: 3+ years of strong experience on Data Design/Analysis, Business Analysis, User Requirement Gathering, User Requirement Analysis, Gap Analysis, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis.
• 3+ years of experience in data warehouse design and development.
• Strong knowledge of software development life cycle (SDLC).
• Experienced in automating the Informatica jobs, also experienced in Informatica Scheduler, Autosys, UNIX scripts for automation
• Experienced in integrating from various data sources like Flat Files, XML files, databases (Oracle, SQL Server, MS Access) and handling large volumes of data.
• Experienced in writing, testing and implementation of the triggers, stored procedures, functions, packages at database level using SQL, PL/SQL.
• Experienced in preparing Technical design document, mapping documents, data definition documents, Detail design document for the Source/Target mapping.
• Excellent problem solving skills with a strong technical background andgood interpersonal skills

TECHNICAL SKILLS

Data Warehousing: Informatica Power Center 9.1/8.5/8.1.1/7.1.2 , Informatica Designer, Workflow Manager, Work flow Monitor, Datamart,Mapplet, Transformations, Autosys, SQL*Plus, SQL*Loader. Familiar with Microsoft SSIS ETL tool.

Data Analysis: Requirement Analysis, Business Analysis, detail design, data flow diagrams, data definition table, Business Rules, data modeling, Data Warehousing, system integration.

Data Modeling: Experienced in Dimensional Data Modeling (Star Schema, Snow - Flake, FACT-Dimensions), Conceptual Physical and Logical Data Modeling, ER Models, Visio, OLAP, OLTP concepts

Databases: Oracle 10g/9i/8i, MS SQL Server 2005/ 2000/7.0/6.0 , MS Access.

Programming GUI: SQL, PL/SQL, SQL Plus, Unix Shell Scripting, C

Environment: Win 9x/NT/2000/ XP, Red Hat Linux, HP-UX

PROFESSIONAL EXPERIENCE

Confidential, Wichita, Kansas

ETL/Informatica Consultant

Responsibilities:

• Experience in developing sales and marketing datamart using Informatica Power Center 8.1.1(Designer, Repository Manager,Workflow Manager, and Workflow Monitor).
• Worked with Informatica - Source Analyzer, Warehouse Designer, Transformation developer, Mapplet Designer, Mapping Designer, Repository manager, Workflow Manager, Workflow Monitor, Repository server and Informatica server to load data from flat files, legacy data.
• Extensively used transformations such as Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Joiner, Transaction Control and Stored Procedure.
• Developed Informatica mappings and mapplets and also tuned them for Optimum performance, Dependencies and Batch Design.
• Tuned sources, targets, mappings and sessions to improve the performance of data load.
• Implemented Slowly ChangingDimension methodology.
• Designed and Developed Oracle PL/SQL Procedures and UNIX Shell Scripts, Data Import/Export and Data Conversions.
• Involved in Unit testing and documentation.
• Provided production support for Business Users.

Environment: Informatica 8.1.1/8.5, SQL, PL/SQL, Oracle 10g, Unix HP-UX.

Confidential

Informatica Developer

Responsibilities:

• Prepared document for data flow process from different source systems to target system.
• Worked with development team to write Informatica mappings based on the business and technical requirements incorporating the best practices.
• Developed mappings/Reusable Objects/Transformation/Mapplets by using mapping designer, transformation developer and Mapplet designer in Informatica PowerCenter 7.1.4/8.1.1.
• Designed and developed audit control process for Informatica jobs to keep track of all the job execution along with balance and reconciliation reports.
• Implemented populate slowly changing dimension to maintain current information and history information in dimension tables.
• Integrated with different data sources such as Oracle, SQL, Flat files etc.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML, Source Qualifier and Stored procedure transformations adhering to client standards.
• Wrote SQL, PL/SQL, stored proceduresfor implementing business rules and transformations.
• Responsible for writing SQL queries, stored procedures, views, triggers.
• Developed PL/SQL and UNIX Shell Scripts for scheduling the sessions in Informatica.
• Prepared functional and technical documentation of the reports created for future references.
• Created deployment groups, migrated the code into different environments.
• Involved in development of the entire warehouse architecture and plan the ETL process

Environment: Informatica Power Center/ Power Mart 8.1.1/7.1.4 , Oracle 10g/9i, SQL, PL/SQL, XML, Windows XP, UNIX.