Professional Summary:

• 7 years of focused experience in Information Technology with a strong background in Data warehousing and Business Intelligence.
• Extensive experience in the Extraction, Transformation and Loading ETL of the data into the Data Warehouse using Informatica Power Center 9.1.0/8.6/7.1.5/6.x, Power CenterDesigner, Workflow Manager, Workflow Monitor and Repository manager.
• Expertise in Performance tuning measures in mappings, transformations, sessions. Solid knowledge in Identifying source, target and mapping bottlenecks.
• Involved in identifying the business requirements and analyzing them in support of Data Warehousing ETL efforts.
• Good knowledge of Oracle RDBMS v11g/10g/9i with proficiency in writing SQL queries and PL/SQLStored Procedures, Triggers, Packages, Cursors.
• Experience in Dimensional Modeling Star schema, Snow-flake schema .
• Excellent knowledge in complete software development life cycle involving analysis, design, development, deployment, testing, documentation, implementation maintenance of application.
• Strong Understanding existing business model and customer requirements.
• Designed Mapping Specifications on the basis of Functional Requirements to create the ETL Mappings.
• Extensively used Source Qualifier, Lookup, Router, Filter, Expression, Aggregate, Stored Procedure, Mapplet, Joiner, Update strategy and Union transformations.
• Developed reusable Mapplets and Transformations.
• Experience in writing UNIX scripts.
• Team player, self-starter with excellent communication and interpersonal skills.

Technical Skills:

Project Details:

Confidential

ETL Senior Developer

Roles Responsibilities:

• Created complex mappings in Power Center Designer using Filter, Sequence Generator, Update Strategy, Joiner and Stored procedure transformations. Created connected and unconnected Lookup transformations to look up the data from the source and target tables.
• PerformingClient Liaison, Requirement Analysis, Data Quality Analysis, Gap Analysis, CODE Mapping, Functional/Technical Specifications, ETL Design Documents, ETL Development, Testing and Support Activities.
• Worked as an ETL developer.
• Responsible for design/development of Mappings Transformation objects using Informatica PowerCenter.
• Scheduling Informatica batches and sessions to transport the data.
• Worked with the DBA group to create Informatica scripts to extract the historical data from one Sybase database into a datamart built in another Sybase database
• Responsible for designing the data model star schema.
• Developed plan to load the dimensional and fact tables into the Data Mart.

Environment:

Informatica Power Center 9.5.1 Designer, Workflow Manager, Workflow Monitor, Repository Manager ,Flat Files, Sybase, Windows XP.

Confidential

Responsibilities:

• Responsible for definition, development and testing of processes/programs necessary to extract data from multiple databases, Transform and cleanse data, and Load it into data warehouse using Informatica Power center. Created the repository manager, users, user groups and their access profiles.
• Extensively involved in Data Extraction, Transformation and Loading ETL process from Source to target systems using Informatica.
• Performed data cleansing and transformation using Informatica.
• Worked extensively with Designer tools like Source Analyzer, Transformation Developer, Mapping and Mapplet Designers.
• Created data mappings to extract data from different source files, transform the data using Filter, Update Strategy, Aggregator, Expression, Joiner Transformations and then loaded into target.
• Developed various worklets as part of workflow design.
• Worked on optimization of mapping.

Environment:

Informatica Power Center 8.6 Designer, Workflow Manager, Workflow Monitor, Repository Manager , Sybase, Flat Files,Windows XP.

Confidential

ETL Developer

Roles Responsibilities:

• Implemented Slowly Changing Dimensions SCDs, Type 2 . Cleansed the source data, extracted and transformed data with business rules, and built reusable mappings, known as 'Mapplets' using Informatica Designer.
• Responsible for Data Extraction, Transformation and Loading ETL process from Source to target systems using Informatica.
• Worked extensively with Designer tools like Source Analyzer, Transformation Developer, Mapping and Mapplet Designers.
• Created data mappings to extract data from different source files, transform the data using Filter, Update Strategy, Aggregator, Expression, Joiner Transformations and then loaded into target.
• Used Update Strategy Transformation to update the Target Dimension tables, type2 updates where we insert the new record and update the old record in the target so we can track the changes in the future.
• Used Workflow Manager to read data from sources, and write data to target databases and manage sessions.

Environment:

Informatica Power Center 8.6 Designer, Workflow Manager, Monitor, Repository Manager , Oracle 11g,

Windows XP.

Confidential

InformaticaDeveloper

Responsibilities:

• Reviewed data models, system and designed Extracting architecture, Applications design, requirements documentation and program specifications.
• Involved in design and coding for various technical modules, building prototypes and integration of various modules of the software system.
• Created Informatica repositories in different stages of project, which supports multi-language data Unicode data and created users, user groups and connections. Designed the mappings and sessions to extract Real-Time data from different systems.
• Created Simulation mappings, sessions and workflows for processing error records while loading into Informatica.
• Developed the JAVA components for the application.
• Responsible for generating automated test cases using Quality Test Professional.

Environment:

Informatica Power Center 8.1.1 Designer, Workflow Manager, Monitor, Repository , Oracle 9i / 10g, Windows XP.

Confidential

InformaticaDeveloper

Responsibilities:

• Developed ETL mappings, transformations using Informatica power center. Implemented source and target definitions in workflow designer.
• Developed mappings using various transformations like update strategy, lookup, stored procedure, Router, Filter, sequence generator, joiner, aggregate transformation and expression. Mappings were designed to cater the slowly changing dimensions.
• Used various stored procedures in the mappings. Preparation of Test Plans, Test Cases/Scripts, SIT/UAT Testing, Reporting, Client Presentation and Post Production Support Activities. Development Reports using Business Objects reporting solutions.
• Data Modeling Design using Erwin, Developed several reusable transformations and mapplets that were used in other mappings. Worked on the server manager to run several sessions and batches concurrently and sequentially.
• Mappings were designed to the utmost performance by optimizing expressions in expression editor of transformation, filtering source data at the source qualifier, and applying transformation logic.

Environment: Informatica power center 7.1.4/8.1.1, Oracle 9i, UNIX, PL/SQL, STAR Schema, Flat files.