SUMMARY

• Over 5+ years of work experience in developing large - scale Data warehouse projects, including Data Profiling, Data Modeling, Data Migration, Database Design and Development, Integration, Testing, SDLC, Project Management and Production Support.
• Core competency in Business Requirement Analysis, Modeling, Design, Development, Testing, Supporting and Documentation in the field of Data Warehouse.
• An expert in the ETL tool Informatica which includes components like Power Center, Power Exchange, Power Connect, Designer, Workflow Manager, Workflow Monitor.
• Worked on Star Schema, Snowflake modeling, FACT & Dimensions tables, Physical & logical data modeling.
• Experience in working with Oracle databases.
• Experience in integration of data sources like Oracle 11G and Flat Files.
• Experience in using Informatica Utilities like Pushdown optimization, Partition and implemented slowly changing dimensions Type1, Type2 methodology for accessing the full history of accounts and transaction information.
• Experience in testing mappings in Informatica Power center and reports in Cognos and have basic knowledge of Microstrategy reporting tool.
• Experience in SQL, PL/SQL, TOAD and Unix Shell Scripting and working knowledge of various platforms like Windows NT/XP/2000/98, Sun Solaris, HP-UX, and Unix-AIX & knowledge of SQL Server Integration services (SSIS).
• Good understanding of Software Development Life Cycle (SDLC), Data warehousing concepts and RDBMS concepts.
• Experience inAdministration activitieslike Creating and Managing Repositories, Users, User Groups, Folders, Working with administrator functions of Repository Manager.
• Strong Understanding ofData Warehouse concepts, ETL, OLAP, OLTP, Star Schema, Snowflake, AS-IS TO-BE models, KPI's, BPM, FACT & Dimensions tables, Conceptual, Physical & Logical Data Modeling. Providing ongoingtroubleshootandsupport for maintenanceandenhancingthe applications to meet the changing business requirements through a Change Management process.
• Experienced in Installation, Configuration, of Informatica PowerCenter on Client/Server environment. Experience in Debugging/Optimizing/Tuning Informatica 9.x, 8.x, 7.x mappings for better Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies.
• Experience in creatingReusable Transformations(Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank) and processing tasks usingWorkflow Managerto move data from multiple sources into targets.
• Performed system Analysis and QA testing and involved in Production Support.
• Experienced in QA Analysis by conducting Cross browser and Cross platform testing under QA Environment.
• Experienced in Integration Testing and User Acceptance Testing (UAT).
• Maintained clear, cohesive and complete documentation of QA Testing, inspection reports, configurations, test plans, test cases, bug reports, user manuals etc.
• Worked on PLSQL, Stored Procedures, Packages, Views, Synonyms, and Triggers.

TECHNICAL SKILLS

ETL Tools: Informatica 9.x/8.x(Power Center/Power Mart/Power Exchange) (Designer, Transformations, Workflow Manager, Workflow Monitor, Source Analyzer, Repository Manager, Mapping Designer, Mapplets) Power Analyzer, OLAP, OLTP.

Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling.

Databases: Oracle10g/9i, MS SQL Server, DB2, MS Access, SQL, PL/SQL, SQL*Plus.

Reporting Tool: Cognos, Microstrategy

Operating System: UNIX, Windows.

Programming: SQL, PL/SQL, SQL*Plus, HTML, C, C++, Java

PROFESSIONAL EXPERIENCE

Confidential, Tampa, FL

Sr.ETL Developer

Responsibilities:

• Worked with business and data analysts during requirements gathering to translate business requirements into technical specifications.
• Coordinated with Data modeling team and architect team to close the Mapping Spec and source to target mapping related queries.
• Understand and discuss the ETL requirements with the Business Unit and preparing the detail design documentation according to the standards.
• Prepare design document for the data flow from Extract team to the ADS or ODS tables.
• Responsible for developing Mappings for Membership and Medical Claims Subject Area.
• Responsible for developing Mappings to load aggregate tables for reporting ease.
• Responsible for fixing data quality problems in Informatica using IDQ.
• Responsible for unit testing and unit test cases preparation.
• Written SQL Queries on Oracle Database to optimize the mappings in informatica.
• Tested SQL queries at the database level for Quality Check.
• Perform code Reviews and Internal Quality checks on mappings created by the team.
• Responsibility to create documentation/release notes for each release.

Environment: Informatica Power Center 9.5.1, Oracle 9i, SQL Loader, PL/SQL

Confidential, Woonsocket, RI

Informatica Developer

Responsibilities:

• Analyzed business process and gathered core business requirements. Interacted with business analysts and end users.
• Created the data model structure and E-R modeling with all related entities and relationship with each entities based on the rules provided by the business manager.
• Coordinating with the client and gathering the user requirements to create mapping specifications.
• Performance tuning on sources, targets, mappings and SQL queries in the transformations
• Worked on flat files as sources, targets and lookups
• Developed ETL and source to target mappings
• Created Several Informatica Mappings to populate the data into dimensions and fact tables
• Involved in the development of Informatica mappings and mapplets and also tuned them for optimum performance, Dependencies and Batch Design
• Extensively used ETL to load data from multiple sources to Staging area (Oracle 9i) using Informatica Power Center Worked with pre and post sessions, and extracted data from Transaction System into Staging Area
• Extensively used Source Qualifier Transformation to filter data at Source level rather than at Transformation level
• Created different transformations such as Source Qualifier, Joiner, Expression, Aggregator, Rank, Lookups, Filters, Stored Procedures, Update Strategy and Sequence Generator
• Tuned the workflows and mappings
• Written SQL Queries on Oracle Database to optimize the mappings in informatica.
• Tested SQL queries at the database level for Quality Check.
• Coordinated with OBIEE Team regarding the reporting data for Answers and BI Publisher reports and also for the Dashboard Designs.
• Used Informatica designer for designing mappings and mapplets to extract data from Oracle sources
• Used Various Transformations like Expression, Filter, Router, Joiner, Look Up, and Update strategy, Source Qualifier in many mappings
• Created workflows using Workflow manager for different tasks like sending email notifications, timer that triggers when an event occurs, and sessions to run a mapping
• Executed Workflows and Sessions using Workflow Monitor
• Partitioned Sessions for concurrent loading of data into the target tables
• Worked on Data Quality using IDQ.
• Executed the workflow using pmcmd command in UNIX
• Involved in identifying the bottlenecks and tuning to improve the Performance
• Developed shell scripts to automate the update process.
• Prepared reports for Business Analysis purpose using Microstrategy Reporting Tool.

Environment: Informatica Power Center 9.1, Oracle 9i, PL/SQL, SQL, TOAD, SQL*LOADER, UNIX Shell Scripting.

Confidential, Seattle, WA

ETL/Informatica Developer

Responsibilities:

• Participated in collecting user requirements.
• Interacted with business representatives for requirement analysis and to define business and functional specifications.
• Involved in drafting Software Requirement Specification for the project.
• Co-ordinated with Informatica Admin to setup the environment and to move objects to different repositories and folders.
• Worked on Informatica Power Center tools - Source Analyzer, Target designer, Mapping Designer, Workflow Manager, Mapplet Designer and Transformation Developer.
• Designed and created mappings, sessions and workflows and schedule the workflow as per the Functional & Technical specifications.
• Extracted the data from Oracle10g, Netezza, XML, Flat files, DB2 load the data in to Oracle warehouse.
• Worked on batch scripting.
• Designed mappings using connected/Unconnected Lookups, Filter, Expression, Aggregator, Update strategy, Joiner, Normalizer, Transaction Control, Source Qualifier, Union, Rank and Router transformations for populating target tables as per business requirements.
• Developed Index Cache and Data Cache in cache using transformation like Rank, Lookup, Joiner, and aggregator Transformations.
• Worked with Change Data Capture (CDC).
• Worked on Data staging.
• Worked with Shortcuts across Shared and Non Shared Folders.
• Created and Executed workflows and Worklets using Workflow Manager to load the data into the Target Database.
• Worked on scheduling tool and versioning tool.
• Worked on Oracle utilities.
• Analyzed Session log files to resolve errors in mapping and managed session configuration.
• Created, configured, scheduled and monitored the sessions and workflows on the basis of run on demand, run on time using Informatica Power Center Workflow Manager.
• Worked on performance tuning at various levels including Target, Source, Mapping and Session for large data files.
• Used mapping variables and parameters for the reusability of the code.
• Maintained naming standards and warehouse standards for future application development, and also created functional and technical specification documents.
• Involved in designing snow flake schema, star schema, dimension tables, fact tables.
• Worked with Surrogate keys, primary keys, foreign keys, triggers, normalization/DE normalization types.
• Worked on agile methodology.

Environment: Informatica Power Center 8.6.0,Oracle10g, DB2, PL/SQL, SQL loader, Toad, PL/SQL Developer tool.

Confidential

ETL Developer

Responsibilities:

• Designed the Data Warehouse (logical and physical models), designed and developed the dimensional data models (star schema), and supported the UAT and production phases.
• Created the Transformation Rules, Mapping Specifications and Workflow Specifications.
• Involved in doing the Impact Analysis of the changes done to the existing mappings and providing the estimations.
• Created the design specs for loading the data from OLTP to STG Schema, STG schema to DWH Schema.
• Developed and maintained ETL mappings using Informatica Designer 8.1 to extract the data from multiple source systems which comprise of Oracle 9i, flat files to multiple targets like Oracle and Flat files.
• Migrated mappings from Development Repository to Test Repository and also from Test Repository to Production Repository.
• Created extensive mapping/Mapplets, reusable transformations using all the transformations like Normalizer, lookup, filter, expression, stored procedure, aggregator, update strategy, worklets etc.
• Extensively worked on tuning and improving the Performance of Mappings.
• Created utility programs for file manipulations, pre-session, post-session using shell scripts.
• Performed ETL testing, created Unit test plan and Integration test plan to test the mappings and created the test data

Environment: Informatica Power Center 8.1, Oracle 9i, SQL, PL/SQL, SQL*Plus, TOAD, Windows 2000, UNIX.