SUMMARY:

• Around 7 years of IT experience as Technical consultant for Data Warehouse ETL, experienced in requirement analysis, data analysis, application design, modeling, development, testing and support life cycle of Data Warehouse applications using Informatica 9.x, 8.x.
• Experience in Full Life Cycle Development of building a Data Warehouse.
• Prominent experience in Data Integration, Extraction, Transformation and Loading data from multiple heterogeneous data source systems like Oracle, SQL Server and Flat files into Data warehouse by using Informatica tool.
• Expertise in working with Informatica tools - Power Center Client tools - Designer, Repository manager, Workflow Manager, Workflow Monitor and Server tools - Informatica Server, Repository Server manager.
• Proficient in creating Transformations and Mappings using Informatica Designer to implement business rules and processing tasks using Workflow Manager to move data from sources to targets.
• Worked extensively on various data transformations such as Source Qualifier, Joiner, Filter, Router, Expression, Lookup, Aggregator, Sorter, Normalizer, Update Strategy, Sequence Generator and Stored Procedure transformations in Informatica Power Center Designer.
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings and sessions.
• Proficiency in data warehousing techniques for Data Cleansing, Data Modelling, Slowly Changing Dimension Phenomenon.
• Extensively worked on data warehousing and decision support systems with relational databases such as Oracle design and database development using SQL, PL/SQL, SQL PLUS and TOAD.
• Experienced in Database programming for Data Warehouses (Schemas), efficient in designing dimensional modeling (Star Schema modeling, and Snowflake modeling).
• Ensure that user requirements are effectively and accurately communicated to the other members of the development team and facilitate communications between business users, developers and testing teams.
• Played significant role in various phases of project life cycle, such as requirements analysis, functional & technical design, testing, Production Support, implementation and scheduling.
• Coordinate ETL and database development work with developers and conduct code reviews.
• Excellent problem-solving and trouble-shooting capabilities. Quick learner, highly motivated, result oriented and an enthusiastic team player.
• Good interpersonal skills, experience in handling communication and interactions between different teams.

TECHNICAL SKILLS:

Data Warehousing/ETL: Informatica Power Center 9.5.1/8.x using Designer (Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer), Repository Manager, Workflow Manager & Workflow Monitor, SQL*PLUS, SQL*Loader

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2005/2000, Sybase 12.x/11.x

Reporting Tools: Cognos 10/8x, MS Access Reports

Programming: SQL, PL/SQL, SQL*Plus 8.1.5, Unix Shell Scripting

Environment: HP-UX 10.20/9.0, IBM AIX 4.2/4.3, MS DOS 6.22, Win 3.x/95/98, Win NT, Win 2000, Win XP.

PROFESSIONAL EXPERIENCE:

Confidential, Peapack, N.J

Informatica Developer

Responsibilities:

• Interacted with Business users to understand the Business requirements and prepared technical documents for implementing the solutions as per business needs.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes.
• Involved in logical and physical data modeling and analyzed and designed the ETL processes.
• Identified all the conformed dimensions to be included in the target warehouse design and confirmed the granularity of the facts in the fact tables.
• Extensively used Informatica client tools to extract data from different sources like flat files and oracle.
• Developed several complex Mappings, Mapplets and Reusable Transformations to facilitate one time, Daily, Monthly and Yearly Loading of Data.
• Configured the mappings to handle the updates to preserve the existing records using Update Strategy Transformation.
• Used Informatica Workflow Manager for Creating, running the Batches and Sessions and scheduling them to run at specified time.
• Involved in Debugging, Troubleshooting, Testing, and Documentation of Data Warehouse.
• Created new Tables, Indexes, and Sequences where needed.
• Creating solution documents for developed mappings.
• Involved in solving day-to-day problems, giving support to the users.
• Communicated issues and progress to project manager.

Environment: Informatica Power Center 9.5, Oracle 11g/10g, SQL, PL/SQL, TOAD 9.6, Windows XP.

Confidential, Georgetown, KY

Informatica Developer

Responsibilities:

• Involved in design and development of complex ETL mappings and stored procedures in an optimized manner.
• Implemented partitioning and bulk loads for loading large volume of data.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Involved in analysis, requirements gathering, designing functional/technical specifications, development, deploying and testing.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Extensive experience in full cycle implementation of Informatica.
• Involved Migration activities from development and pre-production environments.
• Created mapplets in place of mappings which were repeatedly used like formatting date or data type conversion.
• Worked extensively on Source Analyzer, Mapping Designer, Mapplet designer and Transformation Developer.
• Performed scrubbing and cleaning of the data.
• Performed Unit Test and Integration Test for the ETL Processes.

Environment: Oracle 10g, SQL, PL/SQL, TOAD, HP UNIX Shell Scripting, Informatica Power Centre 9.1, Sybase.

Confidential, Palo Alto, CA

Informatica Developer

Responsibilities:

• Designed and Implemented the ETL Process using Informatica power center.
• Involved in Data Extraction from Oracle, Flat files using Informatica.
• Prepared ETL flow of data from Staging to Data Mart.
• Worked with Power Center- Designer tool in developing mappings and mapplets to extract and load the data from various sources.
• Developed various transformations for loading the data into target warehouse.
• Usage of Aggregator, SQL Overrides usage in Lookups and Source qualifiers and data flow management into multiple targets using Routers was extensive.
• Developed various reusable transformations using the Transformation Developer in the Informatica Power Center Designer.
• Implemented the Slowly Changing Dimensions for the purpose of incremental loading of the target database.
• Responsible for Debugging & Performance Tuning of the Informatica mappings and sessions.
• Used Session Parameters to increase the efficiency of the sessions in the Workflow Manager.
• Extensive use of SQL commandswithTOADenvironment to create Target tables.
• Tuned Performance of Informatica session for large Data Files by increasing block size, data cache size, Sequence buffer length and target based commit interval.

Environment: Informatica Power Center 8.6, Oracle 10g, DB2, Sybase, TOAD, SQL, windows NT/XP.

Confidential, Lynchburg, VA

Informatica Developer

Responsibilities:

• Interacted with business users and source system (OLTP) IT teams to define, agree and document incoming data mapping specifications.
• Involved in leading onsite and offshore resources.
• Provided project estimations to client and upon agreement with client delivered project accordingly.
• The objective was to extract data from Flat Files and Oracle database and to initially load it into a single data warehouse repository, which was in Oracle.
• Worked with Informatica Power Center to move data from multiple sources into a common target area such as Data Warehouse.
• Used different transformations in Informatica PowerCenter to develop Mappings.
• Extensively worked on developing Informatica Mappings, Mapplets, Sessions, Workflows and Worklets for data loads.
• Extensively used ETL to load data from wide range of sources such as flat files, XML files, Oracle, Sybase.
• Responsibilities included designing and developing complex Informatica mappings including Type-I slowly changing dimensions.
• Involved in writing shell scripts in UNIX for Informatica ETL tool to run the sessions.
• Wrote complex SQL queries using joins, sub queries and inline views to retrieve data from the database.
• Responsible for to analyze and apply new requirements to existing reports.
• Continuously monitor the accuracy of the data and the content of the delivered reports.
• Responsible for to provide production support and resolve issues.

Environment: Informatica Power Center 8.6, Oracle 10g, SQL, PL/SQL, TOAD, Unix shell scripting, SQL Server, Erwin.

Confidential

Informatica/Oracle Developer

Responsibilities:

• Involved in gathering requirements to understand the business requirements.
• Created Data Structures. I.e. Tables & views and applying the referential integrity using SQL.
• Responsible for creating and modifying the PL/SQL procedure, function, triggers according to the business requirement.
• Worked closely with users, decision makers to develop the transformation logic to be used in Informatica Power Center.
• Converted the business rules into technical specifications for ETL process for populating fact and dimension table of data warehouse.
• Created mappings, transformations using Designer, and created sessions using Server Manager.
• Created mappings with Slowly Changing Dimensions as the load was monthly load.
• Created staging tables to do validations against data before loading data into original fact and dimension tables.

Environment: Informatica Power Center 8.4, Oracle 9i/8i, SQL Server, UNIX, Windows NT

Confidential

Informatica Developer

Responsibilities:

• Used Informatica Power Center for ETL extraction, Transformation and loading data from heterogeneous source systems to Staging area.
• Developed various mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations, maintaining Informatica workflows.
• Created Worklets to run several sessions sequentially and Developed schedules to automate the updated process and Informatica Sessions/Worklets.
• Extensively worked on Performance Tuning and there by decreased the load time.
• Extensively worked with Slowly Changing Dimensions Type1 and Type2 for Data Loads.
• Extensively worked with Lookup Caches like Persistent Cache, Static Cache, and Dynamic Cache to improve the performance of the lookup transformations.
• Extensively worked on UNIX Shell scripts and invoked oracle procedures and Informatica workflows via shell scripts.
• Responsible for error handling using Session Logs, Reject Files and Workflow Logs in the Workflow Monitor.
• Extensively worked with the Debugger for handling the data errors in the mapping designer.
• Involved in all the testing phases of the project to check whether the data is being processed accurately according to the user requirements and performance monitoring.

Environment: Informatica Power Center 8.1, Informatica Power Connect, (Repository Manger, Designer, Workflow Monitor, Workflow Manager), ETL, Flat files, Erwin, Oracle 9i/8i, PL/SQL, Unix shell.