PROFESSIONAL SUMMARY:

• 7 years of total IT experience in Application Design, Data Modeling, Development, Implementation Testing of Data warehousing and Database business systems.
• Experience in the Data Analysis, Design, Development, Implementation and Testing of
• Data Warehousing using Data Extraction, Data Transformation, Data Validation and Data Loading ETL .
• Extensive Data Warehouse experience using Informatica Power Mart/ Power Center 7.x/8.x/9 Source Analyzer, Repository Manager, Server Manager, Mapping Designer, Mapplet Designer, Transformations Designer, Warehouse Designer as ETL tool on Oracle, SQL Server and DB2 Databases.
• Extensively worked on transformations such as Source Qualifier, Joiner, Filter, Router, Expression, Lookup, Aggregator, Sorter, Normalizer, Update Strategy, Sequence Generator and Stored Procedure transformations.
• Comprehensive Knowledge of Data Modeling Concepts including Dimensional Data Modeling, Star/ Snowflake Schema Modeling.
• Strong knowledge and experience in interacting with Oracle, SQL Server, DB2 databases with SQL/PL SQL programming.
• Experience in integration of various data sources like Oracle, SQL Server, Flat Files, and XML into staging area.
• Experience in writing UNIX shell scripts.
• Hands on experience in all aspects of Software Development Life Cycle SDLC .
• Experienced in overall data warehouse, database, ETL and OLAP tuning for better performance.
• Experience of preparing FSD/TSD Functional/Technical Specification Document documents from BRD Business Requirement Document / Customer Requirements.
• Excellent communication and demonstrational skills for analyzing user requirements.
• Team player with good interpersonal and problem solving skills, ability to work in team and also work individually.

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE:

Confidential

Sr.Informatica / ETL Developer

Petsmart is one of the largest in retail chain operations in the United States, Canada, and Puerto Rico engaged in the sale of specialty pet supplies and services companies. Petsmart is a specialty provider of products, services and solutions for the lifetime needs of pets. The Company has identified a group of pet owners that the Company calls pet parents which offers a variety of plans. The project is to extract the data from SAP, SQL database and flat files systems for TRANSPORTATION and to build a data mart using DB2 database. The data in data mart is used by the business users for analyzing and for reporting purposes.

Responsibilities:

• Collected the requirements from Business people.
• Designed and developed the required tables in Netezza and Sql Server Databases.
• Designed and developed Informatica Mappings based on the business requirements.
• Validate the data in the target tables once it was loaded.
• Fine-tuned existing mappings for performance optimization.
• Unit and integration testing in both DEV and QA Environments.
• Worked on bug fixes on existing mappings to produce correct output.
• Developed workflows and sessions associated with the mappings using Workflow Manager.
• Running the workflows daily, quarterly and scheduling the workflows using tidal and monitoring them.
• Involved in writing complex queries for generating different reports as per client needs.
• Worked with all phases of the Software Development Life Cycle SDLC .
• Extracted the data from Flat files, Tables, Sap system and loaded the data into Data warehouse using Informatica Power center.
• Coordinating with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema Design Star Schema and maintenance.
• Created shortcuts for source and target.
• Created Reusable Transformations in Shared folder.
• Worked on Informatica Power Center - Source Analyzer, Data warehousing designer, Mapping Designer Mapplets, and Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
• Various kinds of the transformations were used to implement simple and complex business logic. Transformations used are: Procedure, connected unconnected lookups, Router, Expressions, source qualifier, aggregators, filters, sequence Generator, etc.
• Developed application support documentation accepted by systems changes into production.
• Designed and developed a custom database Tables, Views, Functions, Procedures, and Packages .
• Working with Business Analyst, translating business requirements into functional requirements.

Environment: Informatica Power center 9.x , Workflow Manager, Informatica Designer, DB2, SQL, Netezza, Unix, Tidal for scheduling DB2 Connect, BO, Windows XP.

Confidential

Sr.Informatica / ETL Developer

Confidential Insurance is one of the largest insurance companies in U.S., which offers a variety of Auto insurance plans. Foremost Insurance Company, one of the groups of Farmers Insurance provides specialty insurance including mobile homes, motor homes, travel trailers and specialty dwellings. The project is to extract the data from mainframe systems for mobile homes and to build a data mart using DB2 database.

The data in data mart is used by the business users for analyzing and for reporting purposes.

Responsibilities:

• Designed and developed Informatica Mappings based on the business requirements
• Validate the data in the target tables once it was loaded.
• Fine-tuned existing mappings for performance optimization.
• Worked on bug fixes on existing mappings to produce correct output.
• Running the workflows quarterly and scheduling the workflows and monitoring them.
• Developed workflows and sessions associated with the mappings using Workflow Manager.
• Involved in writing complex queries for generating different reports as per client needs.
• Worked with all phases of the Software Development Life Cycle SDLC .
• Extracted the data from Flat files and loaded the data into Data warehouse using Informatica
• Power center.
• Coordinating with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema Design Star Schema and maintenance.
• Created shortcuts for source and target.
• Created Reusable Transformations in Shared folder.
• Worked on Informatica Power Center - Source Analyzer, Data warehousing designer, Mapping Designer Mapplets, and Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
• Various kinds of the transformations were used to implement simple and complex business logic.
• Transformations used are: Procedure, connected unconnected lookups, Router, Expressions, source qualifier, aggregators, filters, sequence Generator, etc.
• Developed application support documentation accepted by systems changes into production.
• Designed and developed a custom database Tables, Views, Functions, Procedures, and
• Packages .
• Working with Business Analyst, translating business requirements into functional requirements.

Environment: Informatica Power center 8.6.1/9.0.1, , Workflow Manager, Informatica Designer, DB2,

SQL, DB2 Connect, BO, Windows XP.

Confidential

Informatica Developer

Description:

State Farm Insurance is a group of insurance and financial services companies in the United States. The company also has operations in Canada and one of the largest financial institutions in the world. The group's offers Automobile, Life, Fire, and Health Insurance. State Farm is also the world's largest mutual P C property casualty insurance firm. The project is to extract the data from mainframe systems for Home owners, Renters, condominium and Manufactured Home and to build a data mart using DB2 database. The data in data mart is used by the business users for analyzing and for reporting purposes.

Responsibilities:

• Extensively worked on Informatica Power Center tools- Mapping Designer, Workflow Manager, Workflow Monitor and Repository Manager and Informatica Power Exchange to develop the marketing data mart.
• Designed and developed Informatica Mappings based on the business requirements.
• Validate the data in the target tables once it was loaded.
• Fine-tuned existing mappings for performance optimization.
• Worked on bug fixes on existing mappings to produce correct output.
• Running the workflows quarterly and scheduling the workflows and monitoring them.
• Developed workflows and sessions associated with the mappings using Workflow Manager.
• Involved in writing complex queries for generating different reports as per client needs.
• Worked with Data modeler to restructure the data mart according to changes in the model worked on changes in the Informatica.
• Extensively worked with Source Analyzer, Target Designer, Transformation Developer, Mapping Designer and Mapplet Designer.
• Developed mappings in Informatica PowerCenter to load the data from various sources using transformations
• Extracted data from fixed width flat files to load into the DB2 staging area and then to the data mart.
• Strong understanding in analyzing insurance services and meet OLAP requirements through necessary architecture.
• Created views, triggers, stored procedures and functions for analyzing data.
• Created and configured the sessions for work flow. Created and maintained parameter files for workflows in UNIX.
• Worked on Joiner, Aggregator, Update Strategy, Router, Lookup, Stored Procedure, Sequence Generator, Filter, Sorter, and Source Qualifier.
• Implemented slowly changing dimensions - Type I, II in different mappings as per the requirements.
• Created connections for relational, Non-relational and applications in the workflow manager.
• Created mappings using Reusable Transformations.
• Migrating mappings, workflows and parameter files from development to production.
• Developed PL/SQL scripts and conducted data masking on testing environment to protect sensitive data.

Environment: Informatica Power Center 9.1, Oracle 11g, DB2, Flat files, UNIX, Shell scripting, SQL Developer, BO, Teradata 13, Windows.

Confidential

Informatica / ETL Developer

Confidential Corporation is an international transportation company offering a variety of rail, container shipping, intermodal, trucking and contract logistics. It takes advanced technologies, state-of-the-art facilities, and the people to support them. This project aimed at making a data warehousing system of customers. The objective during this service phase is to maintain the application availability to the business users, provide fixes to production issues within the service levels defined and agreed upon.

Responsibilities:

• Involved in extraction of data from various sources like flat files, Oracle and SQL Server.
• Created Star Schema design using Data warehouse concepts like Fact Table and Dimension Tables.
• Studied the existing OLTP system s and Created facts, dimensions and star schema representation for the data mart.
• Created Entity relationship diagrams, function relationship diagrams, data flow diagrams and enforced all referential integrity constraints.
• Created SQL tables with referential integrity and developed queries using SQL.
• Created complex mappings involving Filter, Router, Expression, Lookup, Update Strategy, Sequence generator, Joiner and Aggregator transformations.
• Used Lookup Transformation to access data from tables, which are not the source for mapping and also used Unconnected Lookup to improve performance.
• Designed and developed Informatica Mappings based on the business requirements.
• Validate the data in the target tables once it was loaded.
• Fine-tuned existing mappings for performance optimization.
• Worked on bug fixes on existing mappings to produce correct output.
• Running the workflows quarterly and scheduling the workflows and monitoring them.
• Developed workflows and sessions associated with the mappings using Workflow Manager.
• Involved in writing complex queries for generating different reports as per client needs.
• Extensively used all the features of Informatica 8.6 including Designer, Workflow manager and Repository Manager, Workflow monitor.
• Implemented various workflows using transformations such as Filters, update strategy, look up, aggregator, stored procedure and scheduled jobs for different sessions.
• Designed and developed several ETL scripts using Informatica, UNIX shell scripts.
• Involved in Performance Tuning at various levels including Target, Source, Mapping and Session for large data files.
• Used PMCMD command to automate the PowerCenter sessions and workflows through UNIX.
• Documented ETL development standards as per client requirement.
• Involved in review of the mappings and enhancements for better optimization of the Informatica mappings, sessions and workflows.

Environment: Informatica Power Center 8.3, Teradata, DB2, Oracle 10g, SQL, PL/SQL, TOAD,

Shell Scripts, UNIX AIX , Erwin.

Confidential

Software Engineer

Confidential Ltd specializes in the manufacture of Soya products and exports to more than 32 countries. Sonic Biochem uses two manufacturing plants equipped with the latest testing equipment to ensure its products comply with quality assurance standards.

Responsibilities:

• Created the mappings according to the design documents.
• Worked on Informatica Power Center tool - Source Analyzer, warehouse designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Extensively used various types of transformations such as Expression, Joiner, Update strategy, Look up, filter for developing mappings.
• Created workflows.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Implemented Error handling logic to capture the invalid data.
• Designed and developed Oracle PL/SQL Procedures.
• Designed and Developed Oracle PL/SQL and Shell Scripts, Data Import/Export, Data Conversions and Data Cleansing.
• Performance tuning of Oracle PL/SQL Scripts.
• Designed and developed UNIX shell scripts.

Environment: Informatica Power Center 8.3, flat files, DB2, Oracle 10g, SQL, PL/SQL, TOAD.

Confidential

Database / Informatica Developer

Confidential is a Business Intelligence Services Company uniquely focused on the SMB sector in India. Our services include BI strategy assessment roadmap definition, BI architecture design, BI end to end implementation, BI Governance and BI Support.

Responsibilities:

• Involved in gathering Business requirements and technical aspects for development.
• Involved in deciding the architecture strategy, design of the physical and logical models of the data warehouse as well as two dependent data marts.
• Scheduling, monitoring, coding and testing of custom PL SQL modules to load data into the data warehouse from the legacy systems.
• Extensively used all the features of Informatica Versions 6.x and 7.x including Designer, Workflow manager and Repository Manager, Workflow monitor.
• Interpreted logical and physical data models for Business users to determine common data definitions and establish referential integrity of the system.
• Worked with mappings using expressions, aggregators, filters, lookup, update strategy and stored procedures transformations.
• Partitioned sources to improve session performance.
• Created users in Informatica, assigned them various permissions.
• Backup/Restoration of repositories.

Environment: Informatica Power Center 6.1, Oracle7.0, SQL, PL/SQL, TOAD, Oracle, Designer, Business Objects.