SUMMARY

• Over 7 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.
• 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 in Administration activities like Creating and Managing Repositories, Users, User Groups, Folders, Working with administrator functions of Repository Manager.
• Strong Understanding of Data 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 ongoing troubleshoot and support for maintenance and enhancing the 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 creating Reusable Transformations (Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank) and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Performed system Analysis and QA testing and involved in Production Support.
• Worked on PLSQL, Stored Procedures, Packages, Views, Synonyms, and Triggers.

TECHNICAL SKILLS

ETL Tools: Informatica 9.x/8.x/7.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

Operating System: UNIX, Windows.

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

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles CA

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 unit testing and unit test cases preparation.
• 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 8.x, Oracle 9i, SQL Loader, PL/SQL

Confidential, Atlanta, GA

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 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
• 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
• 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.

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

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.
• Migrated mappings from Development Repository to Test Repository and also from Test Repository to Production Repository.
• 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 7.1.2, Oracle 9i, SQL, PL/SQL, SQL*Plus, TOAD, Windows 2000, UNIX.