Professional Summary:

• Over 6 years of professional IT experience in System Analysis, Design, Development, Datawarehouse/Data Mart Design, Development and Implementation of Client Server applications.
• Experience in ETL methodology for supporting Data Extraction, Transformations and Loading Process in a corporate-wide-ETL solution using Informatica PowerCenter 9.x/8.x/7.x/6.x
• Experience in source systems analysis and data extraction from various sources like Flat files, Oracle 11g/10g/9i/8i, MSSQL Server, IBM DB2 .
• Experience in optimizing very large data loads, Performance Tuning for ETL processes Client, Database, and Server side tuning .
• Proficient in using Informatica designer, workflow manager and workflow monitor
• Hands on experience in design of Data Warehouse/Data Mart, Star Schema, Snowflake Schema, ETL process, Data Requirement Analysis, Data modelling, Development, Testing, Documentation and Implementation of Business Applications.
• Excellent communication skills, team player, ability to work individually and meet tight deadlines.

Technical Skills:

• ETL Tools: Informatica 9.x/8.x/7.x PowerCenter, WorkFlow Manager, WorkFlow Monitor, Designer, Serve, Repository Manager.
• Databases: Oracle 11g/10g/9i, MS-SQL Server, IBM DB2.
• Languages: SQL
• Tools: TOAD 10/9/8.x/7.x
• Operating Systems:Windows NT 4.0/XP/2000/7

Professional Experience:

Confidential

Informatica ETL Developer/Consultant

Responsibilities:

• Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translated business rules and functionality requirements into ETL procedures.
• Used Informatica Workflow Manager Informatica 9.1 to create, Schedule, execute and Monitor Sessions, Worklets and Workflows.
• Extensively used Source, Target and Transformation shortcuts.
• Extensively used Worklets and Mapplets which were reused across different releases.
• Involved in designing the procedures for getting the data from all systems to Data Warehousing system.
• Involved in fixing invalid Mappings, testiand Functions, Unit and Integration Testing of Informatica Sessions, Batches and the Target Data.
• Involved in developing the mappings for moving data from Flat Files to Staging STG and then to Data Warehouse DWH and then to Data Mart.
• Created test cases and completed unit, integration and system tests for mappings developed. It involved documenting the test cases and the output for the given input.
• Created Connected and Unconnected lookup transformations to look up the data from the source and target tables.
• Improved the performance of the mappings by moving the filter transformations early into the transformation pipeline, performing the filtering at Source Qualifier for relational databases
• Designed and developed complex Aggregator, Joiner, Router, Lookup and Update Strategy transformation rules business rules .
• Created ETL scripts for data conversion, migration and transformation of legacy data.
• Created scripts, which were part of the mapping's session properties. Used sessions to move files from one directory to another and also to compare files.
• Documented all Test Plans, Performance statistics

Environment: Informatica PowerCenter 9.1 Designer, Repository Manager, Workflow Manager and Workflow Monitor , Oracle 11g/10g, TOAD 10.1, MSSQL Server 2008, and Windows 7.

Confidential

ETL Developer/Analyst

Responsibilities

• Involved in requirement analysis, ETL design and development for extracting data from the source systems like Oracle, flat files, XML files and loading into datamart.
• Developed complex mapping logic using various transformations like Expression, Lookups Connected and Unconnected , Joiner, Filter, Sorter, Router, Update strategy and Sequence generator.
• Converted functional specifications into technical specifications design of mapping documents .
• Developed complex mappings to load data from multiple source systems like Oracle, flat files and XML files to datamart in Oracle database.
• Worked with team to create scripts to ensure e-mails sent to respective people on Failure/Success, error handling, control /auditing of different processes.
• Involved in Performance Tuning of existing mappings as well as new ones.
• Wrote complex SQL scripts to avoid Informatica joiners and Look-ups to improve the performance as the volume of the data was heavy.
• Used the Rational Clearcase for versioning the various objects like the mappings, workflows, SQL scripts.
• Involved in Unit and Sub System Testing.

Environment: Informatica Power Center 8.X/7.x, Oracle 9i, TOAD, Workflow scheduler

Confidential

Data Warehouse Developer

Responsibilities:

• Worked with business analysts, data architects and database administrators to gather requirements and build the infrastructure of the data flow
• Designed and developed Informatica mappings for data loads and data cleansing.
• Worked with different kind of source like flat files, xml files, Access, People Soft, Oracle
• Extensively worked with all the transformations of Informatica Source Analyzer, Data warehousing designer, Mapping Designer, Mapplets, Transformations including complex Lookups, Filters, Router, Rank, Aggregator, Expression, Joiner, Update Strategy, Source Qualifier and others.
• Workflow manager was used for creating sessions, batches and scheduling
• Configured Informatica Power Center Server and Client components.
• Responsible for identifying the missed records in different stages from source to target and resolving the issue
• For better performance tuned Informatica mappings and Optimized Query Performance, Session Performance and Readability.
• Tuned database and applications performance by enabling session level trace and also used various tools like explain plan etc
• Used parameters and variables sessions/mappings extensively for incremental loads

Environment: Informatica PowerCenter 7.5, Oracle 8i, Toad, SQL, Windows XP

Confidential

ETL/DW Developer

Responsibilities:

• Worked with the Business analysts and the DBA for requirements gathering, business analysis, testing, and metrics and project coordination.
• Involved in Dimensional modelling of the Data warehouse
• Configured Informatica 6.2 Power Center Server and Client components on local systems.
• Created multiple repositories, users and privileges in Informatica repository manager
• Created mappings and complex mapplets using Informatica power center designer 7.1.2.
• Involved in massive data cleansing and data profiling of the production data load.
• Created synonyms for copies of time dimensions, used the sequence generator transformation type to create sequences for generalized dimension keys, stored procedure transformation type for encoding and decoding functions and Lookup transformation to identify slowly changing dimensions.
• Used Power Center server manager/Workflow manager for polling, session management, database connection management and scheduling of jobs to be run in the batch process

Environment: Informatica Power Center 7.1.2, Oracle 9i, SQL Server 2000, SQL, Windows NT.