PROFESSIONAL SUMMARY:

• Over 7 years of experience in Information Technology including Data Warehouse development using ETL/Informatica Power Center across various industries such as Healthcare, Banking, Insurance, Retail
• Extensive experience in developing ETL mappings, scripts and data integration using Informatica Power Center 9.x/8.x/7.x, IDQ 9.6.1/9.0.1/8.6 .
• Experience in all the phases of Data warehouse life cycle involving Requirement Analysis, Design, Coding, Testing, and Deployment.
• Experience in working with business analysts to identify and understand requirements in order to create Technical Design Documents.
• Worked on IDQ/IDE tools for data profiling, data enrichment and standardization.
• Expertise in Business Model development with Dimensions, Hierarchies, Measures, Partitioning, Aggregation Rules, Time Series, Cache Management.
• Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements. Solid understanding of OLAP concepts and challenges, especially with large data sets.
• Experience in creating Reusable Transformations (Joiner, Sorter, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Aggregator, and Rank) for better usability.
• Well versed in OLTP Data Modeling, Data warehousing concepts.
• Strong knowledge of Entity - Relationship concept, Facts and dimensions tables, slowly changing dimensions and Dimensional Modeling (Star Schema and Snow Flake Schema).
• Experience in integration of various data sources like Oracle, DB2, Sybase, SQL server and MS access and non-relational sources like flat files into staging area.
• Experienced with Teradata utilities FastLoad, MultiLoad, BTEQ scripting, FastExport, SQL Assistant
• Good understanding of Views, Synonyms, Indexes, Joins and Sub-Queries.
• Extensively used SQL, PL/SQL in writing Stored Procedures, Functions, Packages and Triggers.
• Experience in using Exception handling strategies to capture errors and referential integrity constraints of records during loading processes to notify the exception records to the source team.
• Experience in UNIX environment, file transfers, job scheduling and error handling.
• Worked on Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Experience in creating Reusable Tasks (Sessions, Command, Email) and Non-Reusable Tasks (Decision, Event Wait, Event Raise, Timer, Assignment, Worklet, Control).
• Involved in Unit testing, System testing to check whether the data loads into target are accurate.
• Experience working in Agile methodology and ability to manage change effectively.
• Excellent communication, interpersonal skills, enthusiastic, self-starter, eager to meet challenges and quickly assimilate latest technologies concepts and ideas

TECHNICAL SUMMARY:

ETL Tools: Informatica 9.5/9.1/8.6.1/8.1//7.1.2/6.2 (Power Center), IDQ 9.6.1/9.0.1/8.6 , MDM 9.7.1/9.5.1/9.1 , SQL Server SSIS

Data Modeling: Ralph Kimball Methodology, Bill Inman Methodology, Star, Snow-Flake, Fact Tables, Dimension Tables, Physical and Logical Modeling, Normalization and De Normalization.

Databases: Teradata V2R12/V2R6, Oracle 11g/10g/9i/8i/8.0/7.x, MS SQL Server 2008/2005, DB2 UDB, MS Access 2000, Sybase

Others: Toad, SQL Navigator, Crystal Reports, TSA

Environment: MS Windows 2008/2005, LINUX, UNIX

Job Scheduling: Autosys, Shell Scripting

PROFESSIONAL EXPERIENCE:

Confidential, Walnut Creek, CA

ETL Developer

Responsibilities:

• Worked with business analysts for requirement gathering, business analysis, and translated the business requirements into technical specifications to build the Enterprise data warehouse
• Involved in various knowledge transfers to understand the business and application programs and document them for internal team referencing.
• Design database table structures for transactional and reference data sources.
• Design and implement all stages of data life cycle. Maintain coding and naming standards.
• Involved in analysis of source, target systems and data modeling sessions, to design and build/append appropriate data mart models to support the reporting needs of applications.
• Extracted data from heterogeneous sources like Oracle, SQL Server, Fixed Width and Delimited Flat Files and transformed into a harmonized data store.
• Involved in cleansing and extraction of data and defined quality process using IDQ and Created dictionaries using Informatica Data Quality (IDQ) that was used to cleanse and standardized Data.
• Extensively used IDQ which helped in debugging and also reducing development time.
• Used Match and Consolidator transformation in IDQ which helped in reducing the duplicates.
• Created several mappings in IDQ which we deployed by creating sessions and workflows in Power Center.
• Used SQL Loader to load data from flat files into Oracle tables
• Worked on Data Cleansing, Data Analysis and Monitoring Using Data Quality.
• Extensively used Transformations like Source Qualifier, Expression, Filter, Aggregator, joiner, Look up, Sequence Generator, Router, Sorter and Stored Procedures, Java Transformations to design and develop mappings.
• Involved in fixing of invalid Mappings using debugger and fixed the bugs.
• Experience with Performance tuning, testing of Stored Procedures and Functions, Testing of Informatica Sessions, Batches and the Target Data.
• Developed slowly changing dimension (SCD) mappings for loading Dimensions and Facts.
• Created the Test cases and Captured Unit test Results.
• Involved, Conducted and participated in process improvement discussions, recommending possible outcomes focusing on production application stability and enhancements.

Environment: Informatica Power Center 9.5.1, Oracle 9i/8i, IDQ 9.6.1, SQL Server 2000, PL/SQL, TOAD, SQL*Plus, SQL*Loader, Autosys, UNIX.

Confidential, IL

Sr. Informatica Developer

Responsibilities:

• Did an extensive requirement gathering, analysis and writing of technical specifications, supporting for various projects involved with Auto, Fire Data marts and State farm Organization Profile (SFOP).
• Worked with Business Analysts to get the functional Specifications, create test plans and scenarios to translate them into technical designs for implementation and deployment.
• Involved as an ETL Developer by gathering business requirements, Preparing Design specification, Designing mappings and Extensively used ETL to load data from flat files to Oracle Database.
• Worked extensively on transformations like Lookup, Filter, Expression, Aggregator, Router, Source Qualifier, Sorter, Sequence Generator, Rank, Lookup, Normalizer etc.
• Designed and developed new mappings using Connected, Unconnected Lookups and Update strategy transformations.
• Implemented Slowly Changing dimension methodology for accessing the full history of accounts and transaction information
• Error checking and Unit testing of the ETL procedures using Informatica session log and various tracing options
• Developed joiner transformation for extracting data from multiple sources.
• Extensively used workflow manager for creating and scheduling various sessions.
• Fine-tuned the Informatica Mappings and Session to get better performance.
• Created scripts to verify that all the data has been moved successfully.

Environment: Informatica Power Center 8.1/8.6/9.1.0 , Oracle, UNIX AIX, Visio, Flat Files, Toad for Data Analyst, Control-M Scheduling Tool

Confidential, Atlanta, GA

Informatica Developer

Responsibilities:

• Extraction, Transformation and Loading of the data using Informatica.
• Designed the target load process based on the requirements.
• Enhancing the existing mappings where changes are made to the existing mappings using Informatica Power center.
• Testing and debugging the Enhanced mappings.
• Creating the ETL run book.
• Develop Mappings and Workflows to generate staging files.
• Develop Mappings and Workflows to load the data into Oracle tables.
• Developed various transformations like Source Qualifier, Update Strategy, Lookup transformation, Expressions and Sequence Generator for loading the data into target table.
• Created Workflows, Tasks, database connections using Workflow Manager
• Developed complex Informatica mappings and tuned them for better performance
• Created sessions and batches to move data at specific intervals & on demand using Server Manager
• Responsibilities include creating the sessions and scheduling the sessions
• Recovering the failed Sessions and Batches.
• Involving in extracting the data from SQL Server, Sybase and Flat files
• Implemented performance tuning techniques by identifying and resolving the bottlenecks in source, target, transformations, mappings and sessions to improve performance Understanding the Functional Requirements.
• Responsible for identifying the missed records in different stages from source to target and resolving the issue
• Extensively worked in the performance tuning for mappings and ETL procedures both at mapping and session level.
• Developing, Testing and debugging the mappings in Informatica.
• Good experience in UNIX working environment
• Preparing the documents for test data loading.

Environment:  Development Tools: Oracle SQL * Plus, TOAD, Informatica Power center 8.6 and UNIX shell scripts Database: Oracle10g, Sybase.

Confidential, LA,CA

Sr. Informatica developer

Responsibilities:

• Involved in requirement gathering, data Analysis, and user meetings, discussing the issues to resolve and translated the user inputs into ETL design documents.
• Worked with Informatica power center 8.5 tools like Designer, Workflow Manager, Repository Manager, source analyzer, warehouse designer, mapping & mapplets designer and Transformation developer.
• Developed Informatica mappings using source qualifier, joiner, Lookups (connected and unconnected), expression, filter, router, and aggregator, sorter, update strategy and normalizer transformations.
• Involved in making the changes to the existing data models to accommodate the new requirements.
• Responsible for Optimizing the ETL loads and also redesigning ETL Interfaces which were not providing the accurate data for the business.
• Worked with mapping parameters and variables, session parameters, pmcmd commands, email tasks.
• Responsible for fixing PLSQL procedures for getting the accurate data.
• Worked with SQL override, Lookup override, Lookup caches, Index and Data caches while designing the mappings also Worked with TOAD SQL*Loader for loading the data from external files into RDBMS tables and Fine-tuned the SQL queries using Explain Plan and Tkprof to speed up the session runs.
• Handled Informatica administration work like migrating the code, creation of users, creating folders, Worked with Shortcuts across shared, non-shared folders and wrote Autosys Jil scripts for scheduling the workflows.
• Created and executed unit test plans based on system and validation requirements.Worked closely with Business during the testing phase and fixed bugs that were reported.
• Developed reports which used Conditional blocks/Variables and associated them with queries to show data only when the conditions were fulfilled.

Environment: COGNOS 10.1/10.2, Informatica Power Center, Programming, UNIX, Windows Microsoft office, Toad, Autosys

Confidential

Informatica Developer

Responsibilities:

• Imported various Sources, Targets, and Transformations using Informatica Power Center Server Manager, Repository Manager and Designer.
• Created and managed the global and local repositories and permissions using Repository Manager in Oracle Database.
• Responsibilities included source system analysis, data transformation, loading, validation for data marts, operational data store and data warehouse.
• Used heterogeneous files from Oracle, Flat files and SQL server as source and imported stored procedures from oracle for transformations.
• Designed and coded maps, which extracted data from existing, source systems into the data warehouse. 
• Used Dimensional Modeling Techniques to create Dimensions, Cubes and Fact tables.
• Written PL/SQL procedures for processing business logic in the database. Tuned SQL queries for better performance.
• Scheduled Sessions and Batch Process based on demand, run on time, run only once using Informatica Server Manager.
• Generated completion messages and status reports using Informatica Server manager.
• Tuned ETL procedures and STAR schemas to optimize load and query Performance.
• Starting Sessions and Batches and make Event based scheduling
• Managed migration in a multi-vendor supported Server and Database environments.

Environment: Informatica Power Center 7.1.2, DB2 v8.0, SQL, Windows 2000, UNIX, SQL Server 2000, Oracle 8i, Flat files, SQL *Plus, Business Objects 5.1.6