SUMMARY:

• Nearly 7 years of IT experience with 5 years of professional work experience in Data Warehouse/Data Mart design, System analysis, design, development, Database design, SQL, PL/SQL programming.
• Extensive experience on Informatica PowerCenter 10.x,9.x,8.x,7.x,6.x/5.x with strong business understanding in power utility and insurance sectors.
• Expertise in implementing complex Business rules by creating robust mappings, mapplets, and reusable transformations using Informatica Power Center and Power Mart.
• Working experience in using Informatica Workflow Manager to create and schedule workflows and Worklets.
• Experience in using the Informatica command line utility to schedule and control sessions and batches.
• Extensive Knowledge in architecture design of Extract, Transform, Load environment using Informatica Power Mart and Power Center.
• Experience in identifying and resolving the bottlenecks in Source, Target, Transformations, Mappings and Sessions for better performance
• Experience in optimizing query performance, session performance and fine tuning the mappings for optimum performance
• Worked on integrating data from heterogeneous sources like Oracle, flat files, DB2, COBOL and XML files.
• Experience with pre - session and post-session SQL commands to drop indexes on the target before session runs, and then recreate them when the session completes.
• Used Debugger to validate the mappings and gain troubleshooting information about data and error conditions.
• Knowledge of full life cycle development for building a Data Warehouse.
• Excellent problem solving skills with a strong technical background and good interpersonal skills. Quick learner and excellent team player, ability to meet tight deadlines and work under pressure.

TECHNICAL SKILLS:

ETL Tools: Informatica (Power Center 8.X/ 7.1.2/6.2/5.1 ), Data stage

Operating Systems: Windows 2000/NT/98/95, Sun Solaris 2.x, HP-Unix, Red Hat Linux 7.2/7.3

RDBMS: Oracle7/ 8i/9i /10g(SQL, PL/SQL, Stored Procedures, Functions), MS-Access 2002/2003, Teradata V2R4.1/V2R5, SQL Server 2000/7, DB2

Data Base Tools: Toad, SQL Navigator 4.0, SQL Loader

Data Modeling: Erwin

Reporting tools: Business objects, Cognos, Cognos Report net, Crystal Reports

Scripting: Unix Shell Scripting.

Web Technology: HTML, Dream weaver Ultra Dev4.0, CSS, Java Script

Languages: Java, HTML, PL/SQL

PROFESSIONAL EXPERIENCE:

Confidential, DALLAS, TEXAS

ETL Developer

• Analyzed the data from various sources such as Peoplesoft, AVR, etc... to maintain consistency and performed validation.
• Identified the facts and dimensions and designed the relevant dim and fact tables.
• Extensively used Informatica Client tools - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Informatica Repository Manager and Informatica Workflow Manager.
• Developed various mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.
• Created Complex Mappings which involved Slowly Changing Dimensions to implement Business Logic and capturing the deleted records in the source systems.
• Developed PL/SQL stored procedures for database updates and to create the necessary indexes in the target tables.
• Created PL/SQL packages and stored procedures to load data from various sources to staging area.
• Worked with SQL*Loader to load the data into the warehouse and flat files.
• Created dynamic PL/SQL procedures to load data from staging area to the data marts.
• Created and scheduled Sessions, Jobs based on demand, run on time and run only once using Workflow Manager.
• Monitored Workflows and Sessions using Workflow Monitor.
• Performed Unit testing, Integration testing and System testing of Informatica mappings.
• Worked with SQL*Loader to load the data into the warehouse and flat files respectively.
• Wrote UNIX shell scripts to work with flat files, to define parameter files and to create pre and post session commands.
• Precise Documentation was done for all mappings and workflows.
• Used Debugger in troubleshooting the existing mappings.

Environment: Windows 2012,Oracle 10g/9i, SQL*Loader, Informatica Power Center 9.X

Confidential

ETL Developer

• Involved in identification of facts, measures, dimensions and hierarchies for OLAP models.
• Analyzed Source System data. Worked on Informatica Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet and Transformation designer.
• Responsible for developing Source to Target Mappings.
• Used most of the Transformations such as Source Qualifier, Aggregator, Lookups, Filters, Sequence generator, Expressions, Update Strategy, Router etc.
• Used pre-defined workflow variables and created persistent workflow variables to reference values and record information in a workflow.
• Used ETL to load data from Oracle, COBOL files to the Data Warehouse.
• Worked with SQL*Loader to load the data into the warehouse and flat files.
• Created reusable Mapplets/transformations embedding business logic.
• Created Stored Procedures to transform the Data and worked extensively on PL/SQL for various needs of the transformations while loading the data.
• Configured sessions and batches using Informatica Power Center Work Flow Manager and monitored them in the Work Flow Monitor.
• Performed Unit testing, Integration testing and System testing of Informatica mappings
• Tuned mappings, transformations and recommended tuning options of source/target database to DBA team for obtaining optimum performance.
• Precise Documentation was done for all mappings, workflows.
• Worked extensively with the major functionality of Business Objects, created the Universes with Default& Custom Hierarchies for multidimensional analysis and created reports with Multi-Level Scope of Analysis using Drill down, drill across, drill up, and slice and dice.
• Generated the Business Objects Reports using the universe as the main Data provider and writing the complex queries including Sub queries, Unions, Intersect and Aliases.
• Created User Objects including Dimensions, Details and Measures.
• Reports were formatted to the users according to the user requirements using Business Objects features like Slice and Dice, Drill Down

Environment: Windows 2012,Oracle 10g/9i, SQL*Loader, Informatica Power Center 9.X