SUMMARY

• Over Eight years of progressive hands - on experience in Data warehousing and ETL processes using Informatica.
• Excellent understanding of ETL, Dimensional Data Modeling techniques, Slowly Changing Dimensions (SCD) and Data Warehouse Concepts - Star and Snowflake schemas, Fact and Dimension tables, Surrogate keys, and Normalization/Denormalization.
• Experience in Data Warehouse/Data Mart Development Life Cycle.
• Expertise in DWH technical architecture, design, business requirement definition and Data Modeling.
• Responsible for designing, coding, testing, integrating the ETL processes and implementing the reporting requirements.
• Well acquainted with Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer, Workflow Manager and Monitor.
• Well versed with ETL procedures to load data from different sources like Oracle, flat files, XML files into DWH using Informatica Power Center.
• Design and develop code in SQL and PL/SQL. Comfortable developing Unix shell scripts to run SQL scripts and Informatica workflows from Unix server.
• Extensively used various Performance Tuning techniques to improve ETL performance.
• Analytical and Technical aptitude with ability to work in a fast paced, challenging environment and keen to learn new technologies.
• Proficient in understanding business processes/requirements and translating them into technical requirement specifications.
• Excellent interpersonal and communication skills, technically competent and result-oriented with problem solving skills and ability to work effectively as a team member as well as independently.
• Developed effective working relationships with client team to understand support requirements, develop tactical and strategic plans to implement technology solutions and effectively manage client expectations.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 8.x/7.x, OLAP, OLTP

Databases: Oracle 10g/9i/8i, MS SQL Server, MySQL

Languages: SQL, PL/SQL, Java, C, Shell Scripting, Perl, PHP, XML, HTML

Data Modeling: MS Visio, Erwin

Tools: SQL Developer, Toad, SQL*Plus, AutoSys, MS Office.

Environment: Unix, Windows 7/XP/Vista, Linux, Mac OS X

IT Concepts: Data Structures and Algorithms, Software Development Life Cycle.

PROFESSIONAL EXPERIENCE

Confidential, Bloomington, IL

ETL Developer

Responsibilities:

• Involved in all phases including Requirement Analysis, Design, Coding, Testing and Documentation.
• Translated the business processes into Informatica mappings.
• Responsible for coordinating development and testing efforts with offshore team members.
• Develop, test and maintain ETL procedures employing both ETL tools and custom PL/SQL.
• Participated in the development and maintenance of a Date Warehouse Routine Load Schedule.
• Involved in business requirements gathering to enable Data Integration across all business groups.
• Extensive involvement with the Quality Assurance team for building exhaustive set of test cases.
• Implemented logic to control job dependencies between the workflows solely through the use of event-raise and event-wait tasks and entries made by ETLs in pilot database tables.
• Used most of the transformations such as the Connected & Unconnected Lookups, Filters, Routers, Joiners, Stored Procedure transformations, Sequence Generators & Mapplets.
• Worked on making session runs more flexible through the use of mapping parameters and variables by using parameter files and variable functions to manipulate them.
• Implemented Slowly Changing Dimensions (Type-2).
• Identified and resolved the bottlenecks in source, target, transformations, mappings and sessions to improve performance.
• Performed the Unit and Integration Testing which validated that the data is mapped correctly which provides a qualitative check of overall data flow.
• Created and Documented ETL Test Plans, Test Cases, Expected Results, Assumptions and Validations.
• Prepared the coding standards and quality assurance policies and procedures.

Environment: Informatica Power Center 8.6.1/9.1.1 , Oracle 11, Toad, Shell Scripts, Autosys, Windows XP.

Confidential, Bellevue, WA

ETL Developer - Consultant

Responsibilities:

• Study the existing source databases and interact with decision makers for analyzing their business plans.
• Worked with heterogeneous sources including relational sources and flat files.
• Worked on creating staging Tables, Constraints, Indexes, and Views.
• Developed ETL sessions for initial full loading and incremental loading.
• Used various Transformations like Joiner, Aggregator, Expression, Lookup, Filter, Update Strategy, Stored Procedures, and Router while developing the ETL mappings.
• Optimized/Tuned mappings for better performance and efficiency, identifying the bottlenecks.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, and scheduling of the workflow.
• Used Informatica debugger to identify the data issues and fix the mappings.
• Responsible for retrofitting the code to QA environment, and extending the support for the QA and UAT for fixing the bugs.
• Used PMCMD command to start and run the workflow from the UNIX environment.
• Proactively identifying the changes required within the production environment and working on the enhancements/Change requests.

Environment: Informatica Power Center 8.1, Oracle 9i, SQL Plus, Erwin, Windows XP, Visio.

Confidential, Broomfield, CO

ETL Consultant

Responsibilities:

• Preparation of ETL specifications and the transformation rules for the various Health care providers based on their business requirements and the Data Intake document provided by the business analyst
• Developed Informatica objects - mappings, sessions, workflows based on the prepared low level design documents.
• Involved in developing the SQLs, which are used to apply all business rules on the data before load into the target tables.
• Implemented optimization techniques for performance tuning and wrote necessary Pre & Post session shell scripts.
• Performed testing, knowledge transfer and provide technical support and hands-on mentoring in the use of Informatica.
• Debug the Informatica mappings and validate the data in the target tables once it was loaded with mappings.
• Analyze and fix defects raised during testing and tracking it to closure. Also involved in production support and fixing the production issues.

Environment: Informatica Power Center 7.x, Oracle 8i, SQL, PL/SQL, Mercury Quality Center, Windows XP

Confidential, San Francisco CA

ETL Developer - Consultant

Responsibilities:

• Developed Informatica mappings to move data from various databases to Data warehouse (Reporting Database).
• Replicated the existing functionality using Informatica 6.1 for Data Extraction, Transformation, Loading and automating the processes.
• Involved in Unit testing of the mappings.
• Involved in Performance tuning and bottleneck resolution.
• Debug and fix defects raised by the QA team.

Environment: Informatica 6.1, SQL Plus, PL/SQL and Windows 2000

Confidential, San Francisco CA

Database Intern

Responsibilities:

• Develop the database schema design using the Entity-Relationship model as per user requirements.
• Used complex SQL to query the database and was involved in SQL optimization of existing queries.
• Involved in writing Oracle PL/SQL Stored Procedures/Functions/Packages and Triggers.
• Worked with materialized views to obtain optimal query performance.
• Generate various reports to help business teams analyze various carrier and cell phone demands.

Environment: MySQL, SQL Plus, PL/SQL and Windows 2000