PROFESSIONAL SUMMARY:

• Around nine+ 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.
• Experience working on Informatica Developer (IDQ) transformations like Case, Comparison, Rule Based Analyzer, Lookup, SQL, Expression etc. and created IDQ mappings.
• 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, IDQ, 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 - South San Francisco, CA

Sr. ETL Developer

Responsibilities:

• Working with business users and business analyst for requirements gathering and business analysis.
• Converted business requirement into high level and low level design.
• Extracted data from Force.com, flat files, MS Excel, MS Access and transformed the data based on user requirement using Informatica Power Center and loaded data into target, by scheduling the sessions.
• Worked on creating staging Tables, Constraints, Indexes, and Views.
• Created reusable mapplets and transformations starting concurrent batch process in server and did backup, recovery and tuning of sessions.
• Created sequential batches and concurrent batches for sessions.
• Optimized/Tuned mappings for better performance and efficiency, identifying the bottlenecks.
• Worked with Memory cache for static and dynamic cache for the better throughput of sessions containing Rank, Lookup, Joiner, Sorter and Aggregator transformations.
• 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.
• Written SQL Scripts and PL/SQL Scripts to extract data from Database for Testing Purposes.
• Used Redwood to design the job chains and scheduling as per requirements.
• Proactively identifying the changes required within the production environment and working on the enhancements/Change requests.

Environment: Informatica Power Center 9.6.1, Oracle 11, Toad, Shell Scripts, Redwood, Qlik, Windows XP.

Confidential - Fremont CA

ETL Developer

Responsibilities:

• Providing technical consulting and guidance to development teams for the design and development.
• Responsible for 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.
• Involved in business requirements gathering to enable Data Integration.
• Used most of the transformations such as the Connected & Unconnected Lookups, Filters, Routers, Joiners, Stored Procedure transformations, Normalizer, 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.
• 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.
• ETL performance tuning and the database tuning discussion with application team members and DBA.
• Implemented Error Handling Strategy.

Environment: Informatica Power Center 9.6.1, Oracle 11, Shell Scripts, Autosys, Windows XP.

Confidential - Brea, CA

ETL Developer - Consultant

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).
• Exported IDQ mappings to Informatica Power Center as mapplets.
• 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.5.1, Oracle 11, Toad, Shell Scripts, IDQ, Autosys, Windows XP.

Confidential

ETL Developer

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

ETL Consultant

Responsibilities:

• Involved in the source data analysis of the client data from various McKesson clients such as Illinois Medicaid, Baptist Health, Medication Therapy Management (MTM), Care First, and Health & Wellness which had various heterogeneous sources including flat file, xml, unstructured data, etc. and load into Oracle.
• 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, and 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

Software Engineer - ETL

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.