SUMMARY

• Around 8 Years of IT experience as Software Engineer in Development, Maintenance, Testing of various projects using Data Warehousing tools and having good knowledge in Oracle 10G databases.
• Strong experience in Development of Data Warehouses with ETL tools Informatica Power Center 9.6/9.5/9.1/9.0.1/8.6/8.1.1/7. x/6.x/5.x
• Extensively worked with Informatica Tools - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Task Developer and Workflow&Worklet Designer.
• Hands on experience with creation of mappings from varied transformation logics.
• Extensive experience in creation of ETL mappings and Transformation to reflect business rules using InformaticaPowerCenter to move data from multiple sources into target area.
• Configured the mappings to handle the updates to preserve the existing records using Update Strategy Transformation.
• Strong Experience in developing Sessions/Tasks, Worklets and Workflows using Workflow Manager tools -Task Developer, Workflow & Worklet Designer.
• Worked extensively with complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups, Aggregators, and Re-usable transformations.
• Having very good knowledge in UNIX commands, shellscripting and Awk programming.
• Experienced in using parameter files, mapping parameters, session Parameters in mappings.
• Good Knowledge on Data warehousing techniques using different Data Warehouse Schemas, SCD Dimensions and Fact tables etc.
• Performing data cleansing and validating the data before loading the data into Data warehouse.
• Extensive experience in extraction, transformation and loading of data from heterogeneous source systems like flat files, Excel, Oracle.
• Good Knowledge in SQL, PL/SQL.

TECHNICAL SKILLS

Data Warehousing: Informatica Power Center 9.x/8.x/7.x/6.x/5.x

Databases: Oracle,MS SQL Server.

Programming Languages: SQL,PLSQL,SQL Loader,HTML.

Operating Systems: UNIX and MS Windows 2003/XP

PROFESSIONAL EXPERIENCE

Confidential, AL

ETL Informatica Developer

Environment: SQL, PL/SQL, Informatica, Web Intelligence

Responsibilities:

• Understanding of client business requirement and documentation of same.
• Preparation of mapping documents based on client requirement specifications.
• Preparation of ETL Design documents and Functional & Technical specifications
• Created Informatica Mappings, usage of Lookups, Aggregator, Ranking, Mapplets, connected and unconnected and source filter usage in Source qualifiers and data flow management into multiple targets using Routers was extensively done.
• Created Data Marts and loaded the data using Informatica Tool.
• Created Physical schema (Data Mart) and load the data into schema using NSI Scheduling tool
• Extensively worked with Source Analyzer, Warehouse Designer, Transformation Designer, Mapping Designer and Mapplet Designer.
• Worked on Performance Testing, Works within an Oracle environment performing PL/SQL code development, building high performing Oracle queries, and tuning existing queries
• Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Reviewed and analyzed functional requirements, mapping documents, problem solving and trouble shooting.

Confidential, IA

Oracle and informatica developer

Environment: InformaticaPowerCenter8.6.1, Oracle 10g, SQL*Loader, TOAD 9.6.1.

Responsibilities:

• Analyzed, Designed and implemented in Informatica, PL/SQL stored procedures to Extract, Transform and Load data from external and Visilogplus internal application systems to GL and ftped to different downstream legacy systems.
• Developed various mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.
• Work with Data modeler to understand the architecture of Data warehouse
• Transformed business requirements into technical specification and then source-to-target mapping documents.
• Designed and Developed Complex Informatica Mappings, Mapplets, reusable Transformations, tasks, sessions and Workflows for Daily, Weekly and Monthly process to load heterogeneous data into the Oracle Data warehouse or external vendors and to Data marts and then to downstream systems..
• Extensively Designed, Developedand Tested complex Informatica mappings and mapplets to load data from external flat files and other databases to Oracle Data Warehouse and various Data Marts.
• Extensively worked on workflow manager and workflow monitor to create, schedule, monitor workflows, worklets, sessions, tasks etc.
• Execute and Process (Migration) Informatica change control code from Development to QA and then to Production environments.
• Created, Updated and Scheduled Autosys jobs based on user requirements in UAT and Production environments.
• Created UAT scripts for Informatica, Oracle stored procedures, Different kind of Oracle feeds and done unit testing.
• Done the production support and fixing the issues raised by the UAT teams, visilogplus users and external users for Informatica GLIG applications.

Confidential

ETL informatica developer

Environment: InformaticaPowerCenter8.6.1, Oracle 10g, SQL*Loader, TOAD 9.6.1

Responsibilities:

• Designed ETL's using Informatica Power Center 9.1.0 to extract data from the functional Data Marts and aggregate the metrics into the SQL Server Database which would be later used to generate Executive dashboards.
• Work with Data modeler to understand the architecture of Data warehouse and mapping documents
• Extraction from various Source databases such as Flat Files and Oracle stage tables using Informatica mappings.
• Worked extensively on different types of transformations like Source Qualifier, Expression, Filter, Aggregator, Joiner, Rank, Update Strategy and Lookup.
• Used Informatica features to implement Type II changes in slowly changing dimension tables.
• ETL processes using Informatica to load data from heterogeneous sources to target Oracle Data Ware house database.
• Created Documentation, Functional Overview for Documentation of Understanding Purpose.
• Involved in developing SQL overrides in source Qualifier according to business requirements.
• Performed data analysis finding out the data issues and reporting it to clients.
• Preparing and Working on some unit test cases for testing the data.
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes.
• Resolved if any issues in Transformations and Mappings.
• Involved in the preparation of Test Scenarios, Test cases.

Confidential

Informatica Developer

Responsibilities:

• Troubleshoot and diagnose complex technical work, resolve end User issues.
• Taking responsibility in fixing the defects.
• Loading of history data (around 450 million records) and addressing the issues if found.
• Checking the daily run jobs in Control-M and analyzing the failures.
• Helping in deploying the code from Development environment to Test and Production environment
• Helping team members in resolving their problems and make sure the defects are closed on time.
• Participated in giving estimates for the project.