SUMMARY

• 6+ years Extensive experience in using ETL methodologies for supporting Data Extraction, Data Migration, Data Transformation and loading using Informatica Powercenter 8.x/ 9.1
• Expertise in Analysis, Design, Development, Implementation, Modeling, Testing, and support for Data warehousing applications.
• Strong knowledge in Dimensional Data Modeling Techniques, E - R modeling, Multi Dimensional Database Schemas like Star schema and Snowflake schema (Fact Tables, Dimension Tables), Ralph Kimball Methodology, Normalization forms and handling Slowly Changing Dimensions
• Experience in SQL, PL/SQL and UNIX shell scripting.
• Experience in UNIX working environment, writing UNIX shell scripts for Informatica pre & post session operations.
• Worked with Full Software Development Life Cycle (SDLC) involving Application Development and ETL/OLAP Processes.
• Excellent in designing ETL procedures and strategies to extract data from different heterogeneous source systems like oracle 11g/10g, SQL Server 2008/2005, DB2 10, Flat files, XML etc.
• Strong working experience in Informatica PowerCenter including designer, workflow manager, workflow monitor, repository manager, repository server admin console.
• Proficient in using Informatica server manager, PMCMD (Informatica command line utility) to create, schedule and control workflows, tasks, and sessions.
• Expertise in implementing change data capture and slowly changing dimensions Type 1 and Type 2 in informatica.
• Actively involved in Performance Tuning, Error handling Product support on various Platforms.
• Extensively worked on session partitioning using Informatica partitioning techniques to optimize the session load times.
• Expertise in implementing Incremental data loading from relational sources using mapping parameters and mapping variables.
• Experience in debugging mappings using informatica debugger. Identified bugs in existing mappings by analyzing the data flow and evaluating transformations.
• Experience in using scheduling tools control M, AutoSys to automate running of Informatica Workflows on a daily Batch Jobs.
• Have also worked on Onsite - Offshore model, carried out the different phases of the projects effectively by excellent co-ordination.
• Excellent communication and interpersonal skills. Ability to work effectively as a team member as well as an individual.

TECHNICAL SKILLS

ETL Tools: Informatica Power center 9.1/ 8.x/7.x

Operating Systems: UNIX, Windows 98/ NT/2000/XP, Solaris

Database Modeling Tool: ERWIN

Database: Oracle 11g/10g/9i, SQL Server 2008/2005,DB2

Database GUI Tools: TOAD

Web Development: HTML,XML

Microsoft Tools: MS office Tool set( Word,Excel,Visio,Power point,outlook)

Programming Languages: Oracle SQL, PL/SQL, UNIX Shell Script, C, C++,Java

Scheduling Tools: Autosys, Control M

Reporting Tools: SSRS,Crystal Report XI/10/9, Cognos 8

PROFESSIONAL EXPERIENCE

Confidential, Malvern, PA

Sr. Informatica Developer

Responsibilities:

• Involved in Analysis, Requirements gathering and documenting Functional and Technical specifications.
• Involved inDimensional modelingto Design and developSTARSchemas usingERWIN 4.0.
• Identified and tracked theslowly changing dimensions, heterogeneousSourcesand determined the hierarchies in dimensions.
• Developed Source to Target Mappings usingInformatica PowerCenter 9.1designer to load data from various source systems likeORACLE,MsSQL Server,XMLandFlat filesto the EMD (Oracle) Data mart.
• Designed and created complex source to target mapping using various transformations inclusive of but not limited to Sorter, Aggregator, Joiner, Filter, Source Qualifier, Expression and Router Transformations, and also involving target load order and constraint based loading.
• Extensively used Lookup Transformation and Update Strategy Transformation while working with Slowly Changing Dimensions.
• Used Mapping Parameters and Mapping Variables based on business rules provided.
• Tuned performanceof Informatica session for large data files bypartitioningand changing appropriate properties like increasing block size, data cache size, sequence buffer length and target based commit interval.
• Involved in usingSQL Loaderto bulk load data in Oracle database.
• Involved in fixing invalid Mappings, Testing of Informatica Sessions, Workflow and the Target Data.
• Scheduled the sessions and workflows to run at specified intervals by usingCrontab.
• Created unit test plans and test scenarios. Extensively used theInformatica Debuggerfor debugging the mappings associated with failed sessions.
• Designed and developed UNIX shell scripts as part of the ETL process to automate the data load processes to target.
• Usedpmcmdcommand to run workflows though shell scripts and command line
• Involved in preparingdetailed ETL design documents.
• Analyzed Source Data to resolve post-production issues. Used MS Access to analyze source data from flat files.

Environment: Informatica PowerCenter 9.1, UNIX (Sun Solaris 2.6), Windows NT, Oracle 11g, MS SQL Server 2008, PL/SQL, Toad, Business Object 5.1.

Confidential, Round Rock, TX

Sr. Informatica Developer

Responsibilities:

• Interacted with Business users for collecting the user's requirements.
• Closely associated with data architect in resolving the data issues.
• Worked with Data modelers to create E R Model schemas at warehouse level.
• Loaded data into the Enterprise Data Warehouse from various sources like flat files, and Oracle db.
• Extensively used all the transformations, which includes (Sequence Generator,Expression, Filter, Router, Sorter, Rank, Aggregator, LOOK UP (Static and Dynamic), Update Strategy, Source Qualifier, Joiner).
• Created mapplets, and reusable transformations to implement the business logic in the pipeline.
• Worked on Slowly Changing Dimensions (SCD’s) and its implementation to keep track of historical data.
• CreatedIncremental data loadinglogic using mapping variables.
• Implementedconstraint based load ordering of target datawithin the pipeline.
• Used differenttasks like Email, Command task, decision task, event raise and event wait tasks.
• Created the reusable transformations for better performance.
• Performedunittestingon the Informatica code by running it in theDebugger.
• A part of the testing team, Involved in conducting System tests and UAT.
• Involved in documenting the Deployment plan and created Test Scripts for the Unit test plan.
• Optimizing SQL queries to improve the Lookup query performance.
• ScheduledInformaticaworkflows and sessions using Control- M Tool
• Maintained documents for developed data mappings.

Environment: InformaticaPowerCenter 9.0.1, Oracle 11g/10g, Sql, Sql server,PL/SQL, Flat files, XML, Sql Assistant, Toad, Control -M, NT Server, UNIX, Shell scripts, FTP.

Confidential, Jersey city, NJ

Informatica Consultant

Responsibilities:

• Analyzed the requirements to identify the necessary tables that need to be populated into the staging database.
• Developed star schema and snow schema for multi dimensional data modeling.
• Developed ETL mappings, transformations and loading using Informatica PowerCenter 8.6.
• Worked on Informatica PowerCenter tools - source analyzer, warehouse designer, mapping & mapplet designer, and transformation developer.
• Developed mappings and workflows as per business logic, quality and coding standards prescribed for the module.
• Created mappings using transformations like source qualifier, aggregator, expression, lookup, router, filter, update strategy, joiner, union, and stored procedure, and XML transformations.
• Implemented aggregation logic using expression transformation with in the pipeline to implement the business logic.
• Used workflow manager for creating workflows, work lets, email and command tasks.
• Implemented Type I, Type II changes in slowly changing dimension tables.
• Used error handling strategy for trapping errors in a mapping and sending errors to an error table.
• Involved in performance tuning at various levels including Target, Source, Mapping, and Session for large data files.
• Wrote UNIX Shell scripts to automate workflows.
• Schedule and run extraction and load process, monitor task and workflow using the workflow manager and workflow monitor.
• Used FTP connection objects to retrieve flat files from the external sources.
• Worked on Migration Strategies between development, test and production repositories.
• Developed mapping document indicating the source tables, columns, data types, transformation required, bulk loading routines, business rules, target tables, columns and data types.
• Resolved issues and bugs raised by QA team.

Environment: Informatica PowerCenter 8.6, Oracle10g, Business Objects XI,TOAD,SOLARIS.

Confidential

Informatica Developer

Responsibilities:

• Analyzed functional requirements provided by Business Analysts for the code changes.
• Mainly involved in Preparation of Low level Designs (Mapping Documents) by understanding the system CPMS.
• Extensively used Informatica 8.6 to extract, transform and load data from multiple data sources.
• Mainly involved in ETL design & development.
• Responsible in developing the ETL logics and the data maps for loading the tables.
• Designed for populating Tables for one time load and Incremental loads.
• Designed and developed mappings, defined workflows and tasks, monitored sessions, exported and imported mappings and workflows, backups, and recovery.
• Power Exchange Change Data Capture has been done for data updates.
• Create workflows based on Dependencies in Informatica for the code changes.
• Unit test the data mappings and workflows.
• Validate the data loaded into database.
• Execute the Test cases for the code changes.
• Monitoring and tracking the applications as per the schedule run.
• Handling the user queries and tickets for Informatica applications.
• Provide the status report for all the application monitoring, tracking status.
• Responsible formigrating from Development to staging and to Production (deployments).
• Reloading of applications run and need to make sure reloading process is completed.
• Restarting of applications run and need to make sure restart process is completed.
• Provided extensive support in UAT (user acceptance testing) and deployment of mappings.

Environment: Informatica Power Center 8.6, UDB, UNIX, Oracle 10g, Mainframes (DB2, VSAM Files, Sequential Files).

Confidential

Jr. ETL Developer

Responsibilities:

• Involved in full life cycle development including Design, ETL strategy, troubleshooting Reporting, and Identifying facts and dimensions.
• Involved in Physical schema implementation, objects like table-space, table rollback segments, Created database structures, objects and their modification as and when needed.
• Coded database triggers, functions and stored procedures and written many SQL Queries.
• Developed and wrote procedures for getting the data from the Source systems to the Staging and to Data Warehouse system.
• Developed Informatica mappings, reusable transformations.
• Extensively used transformations to implement the business logic such as Sequence Generator, Normalizer, Expression, Filter, Router, Rank, Aggregator, Look Up (Target as well as Source), Update Strategy, Source Qualifier and Joiner, Designed complex mappings involving target load order and constraint based loading.
• Create/build and run/schedule workflows and worklets using the Workflow Manager.
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes.
• Helped coding shell scripts for various administration activities for daily backup.
• Responsible to tune ETL procedures and STAR schemas to optimize load and query Performance.
• Optimizing/Tuning mappings for better performance and efficiency, Creating and Running Batches and Sessions using the Workflow Manager, Extensively used UNIX Shell scripts for conditional execution of the workflows. Optimized the performance of Mappings, Workflows and Sessions by identifying and eliminating bottlenecks.
• Performed Unit Testing at development level, Source code migration and documentation
• Managed users & roles for database security, Maintained system security, control and monitor user access to database.
• Managed the Metadata associated with the ETL processes used to populate the data warehouse.
• Assigned predefined profiles and roles to the users to maintain database security, CPU activity, idle time and quota management on table-spaces.

Environment: Informatica Power Center 6.1, Oracle 8i, PL/SQL, Erwin and Toad.

Confidential

Database Developer

Responsibilities:

• Designed the database schema for the metadata for storing the informative queries that are generated dynamically.
• Created schema objects like indexes, views, stored procedures and synonyms.
• Involved in writing triggers which internally call procedures and functions.
• Testing and querying the database and handled the performance issues effectively.
• Extensively involved in documenting the technical procedures and process.

Environment: Oracle 9i, Unix, Windows NT