SUMMARY

• Over 10 years of IT experience with expertise in data warehousing. 7+ years of strong experience in designing and implementing Data Mart / Data Warehouse applications using ETL tools such as INFORMATICA PowerCenter 9.5.1,9.1,8.6.1,8.1.3,7.1.3 and PowerMart to transfer the data from legacy systems (Mainframes) to common/ different targets and experience with Oracle SQL and PL/SQL development.
• Informatica: 7+ years of Data Warehousing experience using Informatica Power Center 9.5.1/9.1/8.6.1/8.1.3/7.1.3, OLAP, OLTP, Autosys, IXP. Strong experience in designing and developing complex mappings to extract data from diverse sources including flat files, RDBMS tables, and legacy system files.
• Data Modeling: Strong Dimensional Data Modeling experience worked on Erwin 4.5 for designing the Dimensional Modeling, Ralph Kimball Approach, Star/Snowflake Modeling, Data marts, OLAP, FACT & Dimensions tables, Physical & Logical data modeling. Strong Knowledge in Data Warehousing Concepts and experience in Quality Analysis.
• Production Support - Done extensive 24x7 production support and issue resolutions.
• Onsite-offshore co-ordination experience and well versed with off-shore team handling ensuring timely and quality results.
• Extensively worked on projects implementing Agile projectmanagement methodology. Current working on Kanban approach.
• Have an excellent quality of adapting to latest technology with Analytical, Logical and Innovative knowledge to provide accurate software solutions. Excellent team player with strong communication and Interpersonal skills.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.5.1/9.1/8.6.1/8.1.3/7.1.3 (Repository Manager, Designer, Workflow Manager, Workflow Monitor)

Databases: Netezza 7.2, Oracle 11g/10g, Oracle 9i/8i/7.3.

Data Modeling: Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake, FACT, Dimensions) ER Diagrams, ERwin 4.5/3.5.2/2. x. OLAP, Star Schema.

Miscellaneous Tools: Aginity, TOAD, SQL*Plus, iSQL*Plus, SQL*Loader, AutoSys, PL/SQL Developer

General Software & Prog: Excel, Word, PowerPoint, SQL, PL/SQL

Operating Systems: Windows 7/Vista/2000/98/XP/NT

PROFESSIONAL EXPERIENCE

Confidential, CA

Senior ETL Consultant

Responsibilities:

• Working with product managers, performance managers and internal partners on requirement gathering.
• Responsible for initial analysis and preparation of functional Specifications.
• Create Technical design documents and guide team members in development Informatica Mappings, Mapplets, Sessions and Workflow to implement the business rules and for data movement.
• Develop multiple free form SQL queries to support product/ performance specific data requirements.
• Design and developed ETL Mappings using Informatica to extract data from flat files or SQL Server/Netezza databases, and to load data into the target database. Created Mappings and Mapplets using Transformations like Filters, Aggregator, Lookups, Expression, and Sequence generator, Sorter, Joiner and Update Strategy.
• Worked on Optimizing / tuning mappings by following Informatica best practices.
• First point of contact for any product specific data related issues. Responsible for root cause analysis of issues reported.

Environment: Informatica Power Center 9.5.1, Netezza 7.2, SQL Server 2008, Flat Files, CSV and Delimited files, Unix Shell Scripts, Micro Strategy 10.

Confidential, CA

Senior ETL Consultant

Responsibilities:

• Worked on requirement gathering, source system analysis and design Specifications.
• Created Technical design documents from the functional specifications and developing Informatica Mappings, Mapplets, Sessions and Workflow to implement the business rules and for data movement.
• Developed ETL Mappings using Informatica to extract data from flat files and Oracle sources, and to load the data into the target database. Created Mappings and Mapplets using Transformations like Filters, Aggregator, Lookups, Expression, and Sequence generator, Sorter, Joiner and Update Strategy.
• Worked on Optimizing / tuning mappings to decrease the run time of workflows. Designed the automation process of Sessions, Workflows and Worklets (command, email, assignment, control, event wait/raise, conditional flows)
• Responsible for Production Support and first point of contact for any issue in production and QA.

Environment: Informatica Power Center 9.5.1, Oracle 11g, PL/SQL developer, Flat Files, CSV and Delimited files, Unix Shell Scripts.

Confidential, Fremont, CA

Senior ETL Developer

Responsibilities:

• Coordinated with Business Users for requirement gathering and prepare Technical Specification documents.
• Responsible for developing, support and maintenance for the ETL processes. Worked on designing and coding ETL process using Informatica for various transactions and loading data from different sources like Flat Files and Relational Database.
• Extensively used databases from Oracle, and MS Sql server.
• Involved in daily scrum meeting and creating Technical design documents from the functional specifications and developing Informatica Mappings, Mapplets, Sessions and Workflow to implement the business rules and for data movement.
• Designed and developed ETL Mappings using Informatica to extract data from flat files and Oracle sources and load the into the target database.
• Created numerous Mappings and Mapplets using Transformations like Filters, Aggregator, Lookups, Expression, and Sequence generator, Sorter, Joiner and Update Strategy.
• Created Mapplets and reusable transformations to be re-used during the development life cycle.Used Parameter files to define values for parameter and variable used in the mappings and sessions.
• Responsible for Production Support and Administrative activities such as creating folders, assigning security permissions to users and migrating the code to production in Informatica Repository Manager and admin console.
• Involved in performance tuning. Developed test data and test cases related to Text Analytics project

Environment: Informatica Power Center 9.5 Repository Manager, Designer, Source Analyzer, Workflow Manager, Workflow Monitor, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer and Task Developer, SQL Server 2005/2008, Oracle 10g, SQL Server Flat Files, CSV File, Delimiter, Unix Shell Scripts.

Confidential

Sr. ETL Developer

Responsibilities:

• Involved in end to end development using ETL tool-Informatica for data flow from Source system to Target.
• Involved in requirement gathering, source system analysis and design Specifications.
• Worked on preparing functional specs and technical design documents. Prepared low level design documents establishing mappings between sources and targets.
• Developed several complex ETL Mappings using various transformations like Update strategy, Lookup, Filter, Router, Joiner, Stored procedure etc., Created complex workflows and worklets using workflow manager.
• Extensively used Informatica debugger to figure out the problems in mappings. Worked on Optimizing / tuning mappings by following Informatica best practices to decrease the run time of workflows.
• Extensively used Mapping Variables, Mapping Parameters, and Parameter Files for the financial calculations.
• Involved in QA. Worked on unit testing, regression testing, UAT and prepared test cases. Worked on reviewing deliverables, system testing and user acceptance testing.
• Involved in Initial loads and Incremental loads. Initially monitored daily loads to ensure that the data is loaded timely and in appropriate manner.
• Carried out Impact Analysis of the new changes included in the project and involved in regression testing.
• Involved in training new heirs to work as production support and make sure all issues are fixed in the respective turn-around time.

Environment: Informatica 8.6.1, Oracle 11g-R2, Windows Server, Cognos, Erwin, Flat files.

Confidential

Sr. ETL Developer

Responsibilities:

• Was onsite (Netherland) coordinating with the clients, as a part of development team.
• Used Informatica Power Center 8.1.3 to extraction, transformation and load (ETL) data in to the dataware house using transformations like Joiner, Filter, Router, Expression, Lookup, Aggregation etc..
• Implemented slowly changing dimension to maintain current and historical data.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings. Developed schedules to automate the Informatica sessions and batches.
• Worked on performance tuning at the mapping level, session level, source level, and the target level.
• Developed PL/SQL stored procedures & cursors for implementing business rules in Informatica.
• Involved in Quality Analysis. Worked on Code Review, Unit testing, UAT, regression testing and migrated mappings from development environment to production.
• Developed mapping specification document and Unit Test cases. Involved in regression testing.

Environment: Informatica 8.1.3, Oracle 10g, Windows Server, Flat files.

Confidential

ETL Developer

Responsibilities:

• Involved in Coordinating with the Onsite team in understanding the Business Requirements.
• Responsible for monitoring the daily, weekly and quarterly warehouse load process. Expertise in troubleshoot time sensitive job failure issues.
• Worked with session logs, Informatica Debugger, and Performance logs for error handling when we had workflows and session fails.
• Prepared daily load error report and solutions.
• Involved data Analysis for the existing data warehouse to ensure that no data loss or rejections have occurred impacting the Business during the daily load process.
• Extracted data from flat files and oracle database, applied business logic to load them in the Oracle database.
• Worked on Joiner, Filter, Router, Expression, Lookup and Aggregation transformations.
• Prepared estimations, design documents and Unit Test cases for mappings.
• Carry out Impact Analysis for any new changes being pushed to Production.

Environment: Informatica 7.1.3, SQL Server 2000, Windows 2000, Business Objects.

Confidential

Responsibilities:

• Understanding existing business model and customer requirements.
• Analyzing the Production issues and timely fixing. Used AutoSys as scheduling tool.
• Developed mappings using informatica for data flows from Source to Target.
• Used various transformations like the Joiner, filter, lookup, expression, aggregator, update strategy etc... In mappings to perform the ETL process
• Extensively used Pre-SQL and Post-SQL scripts for loading the data into the targets according to the requirement.
• Worked on mapping review, to find design flaws and optimize performance.
• Created effective Unit Test cases to ensure successful execution of data loading processes. Worked on documentation.

Environment: Informatica 7.1, Oracle 9i, Windows 2000, Cognos.

Confidential

Responsibilities:

• Monitoring daily and weekly loads.
• Fixing production issues and closing Remedy tickets.
• Understanding the customer requirements for project enhancement.
• Worked on Informatica tool for developing mappings to extract and load the data from flat file sources to Oracle target tables.
• Involved in error handling, debugging and troubleshooting Sessions using Session logs, Debugger and Workflow Monitor. Used different tasks like Email and Command task.
• Used Autosys to automate the Informatica Sessions.
• Review existing mapping for performance optimization. Prepared unit test cases and involving User Acceptance Test.

Environment: Informatica 8.1, Oracle 9i, Windows 2000, Cognos