SUMMARY

• 8+ Years of Total IT Experience in Analysis, Design, Development, Implementation, Testing and maintenance of Business Intelligence solutions using Data Warehousing/Data mart design, ETL, OLAP,OLTP client /server applications.
• Strong Data warehousing and ETL experience using Informatica Power Center 9.5/9.1.x/9.0.x/8.6.x/8.1.x/7.1.x,Metadata Manager, Warehouse Designer, Source Analyzer, mapping Designer, Transformation Developer, Mapplet Designer, Mapping Designer.
• Excellent knowledge upon RDBMS, OLAP, OLTP, Data Marts, ODS Systems.
• Mapping experiences using different transformations like Filter, Joiner, Router, Source Qualifier, Expression, Sequence Generator, Unconnected / Connected Lookup, Update Strategy, Aggregator, Sorter, Union, Transaction control and Normalizer.
• Efficiently handled the granularity, indexing and partitioning with data warehouses.
• Mapping experiences with SCD TYPES, Master, Transactional Subject areas & other dimensional models with respect to ETL Data warehouses.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Worked closely with the users to understand the current state of information availability in the enterprise and then identify future needs based on their analysis of business requirements, current state environments, gap analysis, and future state warehousing implementation.
• Performed gap analysis between the current state and future data warehouse environment identifying data gaps and quality issues plus recommending potential solutions.
• Worked closely with the data warehouse development team to ensure user requirements and issues being addressed while controlling scope.
• Data modeling experience using Star Schema/Snowflake modeling, FACT & Dimensions tables, Relational & Dimensional tables in perspective of Master and Transactional data.
• Good knowledge upon databases using Oracle 11g/10g/9.x/8.x/7.x, MS SQL Server 2000/2005, SQL, PL/SQL, SQL * Plus, SQL*Loader, Toad 7.3 / 8.x . 0/ 9.1/ 10.3.3.0/ 11.5.
• Experience in Informatica Power Center Administration in 7.1.x, 8.x,9.x including server setup, configuration, client installations, deployments, backups, repository management, server health and maintenance, performance monitoring and improvements, patching connectivity to connect to other databases., setting up ODBC.
• Experience in Performance tuning in Informatica Power Center.
• Experience in preparing, USE CASES, Activity Diagrams using Rational Rose.
• Good expertise in XML handling.
• Good expertise in migrating various Informatica sessions and mappings from one version to another.

TECHNICAL SKILLS

DATAWAREHOUSING ETL: Informatica Power Center 9.x, 8.x, 7.x, 6.x Informatica Power Exchange 8.x, IDQ, Data Mart, FACT & Dimensions tables, Physical & logical data modeling, Informatica Power Center, Data Management Express (DM Express).

DATABASES: Oracle 11g/10g/9i/8i, Teradata, SQL Server, DB2

PROGRAMMING LANGUAGES: C, C++, UNIX Shell Scripting.

ENVIRONMENT: UNIX, Windows2000/NT, Windows XP/Vista/7.

OFFICE PACKAGE: Ms Office - 97, 2000, 2003 and 2007.

PROFESSIONAL EXPERIENCE

Confidential, San Jose, CA

Informatica Developer

Responsibilities:

• Single handedly developed the module by dumping the data from source to a staging area, the staging data was then cleansed and validated against the specified business rules and loaded into Intermediate layer.
• The cleansed data from the Intermediate layer was then loaded into Data Repository after applying the required transformation rules.
• Created materialized views for the better performance in reporting.
• Responsible for Extraction, Transformation and Loading the data into Data warehouse by using Informatica Power center 9.5.
• Worked on several transformations such as Filter Transformations, Joiner Transformations, Rank Transformations, Sequence Generator Transformations, Stored Procedure Transformations, Lookup and Expression Transformations in Informatica.
• Created staging tables from the legacy database along with the auditing information.
• Involved in Analysis Phase to gather the requirement provided by user and prepare the functional document.
• Interacting with BA’s and downstream end users to understand the requirements clearly.
• Involved in creating the data model and specs for the ETL development.
• Developed Informatica mappings. Unit test ETL mapping codes and validated the result set data.
• Load the data from various File systems to the DWH and DM.
• Maintain the Versioning for the objects by using VSS.
• Analyzed the compatibility of the current code base and determined the impacts of new data mart (CDM) over the existing system.
• Designed and documented the technical and functional specification of the module.
• Documented validation rules, exception processing and test strategy of the mappings.
• Migrated ETL codes from Development to Test to Production.
• Supported and executed the job run cycles manually through the workflow process setup for each release.
• Performed unit testing for the developed mappings.
• Created Source to Target Mappings (STTMs) document.
• Validated and monitored daily job runs.
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations for populating target table in efficient manner.
• Studied and analyzed existing mappings/sessions and identified performance bottlenecks.
• Translate data transfer requirements into ETL solutions.
• Design, develop, test, and maintain ETL processes.
• Write complex DB2 joins and conditional DB2 logic.
• Create reusable objects.

Environment: Informatica 9.5.1, Share point, System navigator, TOAD, IBM DB2, AS400.

Confidential, Cleveland, OH

Informatica Developer

Responsibilities:

• Designed and developed the processes to extract, transform and load data into the Data Warehouse
• Used AGILE Methodology.
• Extensively used ETL to load data from Oracle 11g, XML files, Flat files data also used Power Exchange to load data in to Enterprise data ware house.
• Used Informatica PowerCenter 8.6 Source Analyzer, Target Designer, Mapping Designer, Workflow Manager, Mapplets, and Reusable Transformations.
• Extensively used almost all the Transformations like Lookup, Aggregator, Expression, Router, Filter, Update Strategy, Stored procedure and Sequence Generator.
• Designed Mapping document, which is a guideline for ETL Coding and implemented CDC, SCDI & SCDII Mappings.
• Actively understanding and following agile methodology principles.
• Designed and developed Informatica Mappings to load data from various Source systems like Files, Relational into the ODS (operational data store), DW and then to the Data Mart.
• Executed all the mappings and sessions in Development using workflow Manager.
• Implemented Slowly Changing Dimension(SCD) Type 1 and Type 2 for inserting and updating Target tables for maintaining the history.
• Used Mapplets and Reusable transformations were extensively wherever required.
• Worked withInformaticaData Quality 8.6.1 (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ 8.6.1.
• Created Process Control and worked with Metadata Manager .
• Developing Teradata utility scripts like fast load, multiload to load data from various source systems to Teradata.
• Creating basic Teradata query scripts to generate keys.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent batches and Sessions and scheduling those using Autosys at specified time.
• Organized data in the report Inserting Filters, Sorting, Ranking and highlighting data.
• Created reports in table, cross table, 2-D, 3-D Column, Line, Area and Pie charts.
• Developing Oracle PL/SQL stored procedures, Functions, Packages, SQL scripts to facilitate the functionality for various modules .
• Used Shell Scripts to interact with Informatica Server .
• Checked Sessions and error logs to troubleshoot problems and also used debugger for complex problem troubleshooting .
• Created and executed comprehensive unit test plans and assist with integrated system test.

Environment: Informatica PowerCenter 8.6 (Repository Server, Repository Manager, Designer, Workflow Manager and Workflow Monitor), IDQ(Informatica Data Quality) 8.6.1,Oracle 11g, Sybase, TOAD, UNIX, OBIEE, PL/SQL, Windows XP..

Confidential, Pittsburgh, PA

Informatica Developer

Responsibilities:

• Designing the source to target mappings that contain the Business rules and data cleansing during the extract, transform and load process.
• Efficiently worked upon Parameters and Variables.
• Identifying and tracking slowly changing dimensions and created complex mappings by using the SCD concepts.
• Acted as a liaison between various teams to connect to business users.
• Implemented Indirect file types for loading data with the same structures.
• Worked with Oracle BI Administration Tool, Presentation Services, Answers, & Interactive Dashboards and Security Implementation.
• Proficient in using SQL and PL/SQL for extract transform and load data into data warehouse.
• Data quality monitoring and profiling tool for the enterprise wide data elements.
• Development of Business Objects Reports.
• Target load order plans performed.
• Performed many sequential and parallel loadings.
• Created Event Task, Event wait and performed many successful loadings to targets.
• Preparing HLD, LLD, BRD, FRD, gathering complete requirements.
• Used the Slowly Changing Dimensions - Type II in various mappings.
• Handled Maintenance and Enhancement Requests as a team.
• Translated Business processes into Informatica Mappings for building Data marts.
• Importing various Sources, Targets, and Transformations using Informatica Power Center Server Manager, Repository Manager and Designer.
• Using Heterogeneous files from different sources and Importing stored procedures from Oracle for transformations.
• Team meetings and performance reviews .

Environment: Informatica Power Center 8.6, Oracle 10g, OBIEE, SQL SERVER 2008, MS-Access, Unix, Window 7, SQL, PL/SQL, MS-Visio, Microsoft tools, Putty.

Confidential

Informatica Developer

Responsibilities:

• Involved in requirement gathering, analysis and study of existing systems.
• Designed the logical model using star schema with all related entities, attributes and relationship with each entities based on the rules provided by the business manager using Erwin, along with the project manager.
• Extensively worked with Repository Manager, Designer, Workflow Manager and Workflow Monitor
• Extensively used Informatica Designer to create and manipulate source and target definitions, mappings, Mapplets, transformations, re-usable transformations, etc.
• Extracted data from Oracle, SQL Server and Flat Files and loaded them into Oracle.
• Involved in raw data validation and data integrity validation
• Used PL/SQL procedures to perform various tasks.
• Developed transformation logic and designed various Complex Mappings and Mapplets using Designer.
• Used various transformations like source qualifier, joiner, update strategy, lookup, aggregator etc.
• Used workflow monitor to monitor the jobs, reviewed error logs that were generated for each session.
• Implemented SCD methodology including Type 1, Type 2 changes to keep track of historical data.
• Tuned the mappings for optimal performance using the Informatica guidelines.
• Documented all the mapping details using Company’s document templates.
• Coordinated between the developments and testing teams for robust and timely development of fully integrated application.

Environment: Informatica Power Center 7.1.1, Oracle 9i, SQL Server, SQL Plus, PL/SQL, SQL, MS Visio, Toad, Unix.

Confidential

Informatica Developer

Responsibilities:

• Worked with Data Modeler to understand the Business Requirements and Business Rules Subjected to Business.
• Prepared ETL Specifications to help develop mapping.
• Extracted data from various sources (Flat files, SqlServer, DB2 Databases).
• Designed and developed Informatica Mappings and sessions based on business user requirements and business rules.
• Worked extensively on Source Analyzer, Mapping Designer, and Warehouse Designer.
• Source data was extracted from Flat files, SqlServer and DB2 Databases Analyzing the source data and deciding on appropriate extraction, transformation and loading strategy.
• Created mappings to read from Flat files, RDBMS and to load into RDBMS tables.
• Based on business Rules Debugged code, tested and validated data after processes are run in development.
• Modified the existing mappings for the updated logic and better performance.
• Developed Logical Data Flow Diagrams in Visio for every mapping that is developed.

Environment: Informatica Power Center, SQL, PL/SQL, Oracle 8i, SQL Developer, Windows XP, Sun Solaris, UNIX