PROFESSIONAL SUMMARY:

• Around 8.5 years of extensive experience in ETL (Extract Transform Load), Data Integration and Data Warehousing using Informatica Power Center & Oracle PL/SQL
• Knowledge of Data Profiling using Informatica Developers tool.
• Knowledge in Business Intelligence and Data Warehousing Concepts with emphasis on ETL and System Development Life Cycle (SDLC).
• Knowledge in Data Modeling (Logical, Physical, Star Schemas) with Erwin.
• Extensively created and used various Teradata Set Tables, Multi - Set table, global tables, volatile tables, and temp tables.
• Ability to exercise independent judgment and creative problem-solving techniques in a highly complex environment using technology and/or integrating diverse user systems.
• 4+ years of experience in developing UNIX scripts.
• Proficiency in designing and developing ETL objects using Informatica Power center with various Transformations like Joiner, Aggregate, Expression, SQL, Lookup, Filter, Update Strategy, Stored Procedures, Router, Rank, normalizer transformations etc.
• Knowledge and experience with SSIS.
• Used various DDL and DML commands, secondary indexes and join indexes.
• Coordinated with offshore resources and exhibited leadership skills for a smooth flow of the project.
• Collaborated with members of the project team to ensure harmony in achieving project deliverables.
• Responsible for System Testing, Regression Testing, and User Acceptance Testing and ensured that the code is legible. Other activities include archiving the test logs and publishing the User Acceptance test logs to the respective stake holders.

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

Sr ETL Informatica Developer

Responsibilities:

• As part of a team, involved in gathering and analyzing the requirements.
• Designed and developed complex mappings by using Expression, Update, Lookup, Sequence generator, Router, Stored Procedure, Aggregator transformations to implement complex logics during mappings.
• Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Oracle, SQL server and Flat files and loaded them into target Teradata database.
• As an active team member, converted functional requirements into developmental tasks and deliverables.
• Established facts from fact Tables.
• Worked with Informatica power center Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Coded and debugged packages in stored procedures and triggers per the requirements document.
• Involved in the creation of table structures and modification of existing tables for the Data Model design.
• Developed normalized forms in second and third per business rules.
• Developed Informatica Workflows and sessions associated with the mappings using Workflow Manager.
• Extracted data from different databases like Oracle and external source systems like flat files using ETL tool.
• Involved in the planning phase of the project along with stakeholders.
• Involved in debugging Informatica mappings, testing of Stored Procedures and Functions, Performance and Unit testing of Informatica Sessions, Batches and Target Data.
• Worked with OLAP dimensional models as required by stakeholders.
• Generated queries using SQL to check for validity of the data in the tables and updated the tables according to the Business requirements document.
• Involved in Performance Tuning of the mappings in Informatica.
• Developed Mapplets, Reusable Transformations, Source and Target definitions, mappings using Informatica 9.1.0.

Environment: Informatica 9.1, Teradata, SQL, T-SQL, triggers, Toad 10.6, SQL Loader, Unix, Flat files.

Confidential, Dallas, TX

ETL Informatica Developer

Responsibilities:

• Worked with various stakeholders for the project including business analysts for requirement gathering, and translated the business requirements into technical specifications to build the Enterprise Data Warehouse.
• Applied Software Development Lifecycle to comply with standards and procedures.
• Involved in team meetings to discuss the design and followed up with the development of the application.
• Designed, developed and tested and implemented ETL solutions as per business requirements.
• Worked on Power Center 9.1 Designer client tools like Source Analyzer, Target /Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Created mappings using Unconnected Lookup, newly changed dynamic Lookup Sorter, Aggregator, and Router transformations for populating target table in an effective approach for the application.
• Involved in Monitoring sessions using the workflow monitor, which were scheduled, running, and showed completed or failed sessions as well as Debugged mappings for failed sessions.
• Responsible for the transportation of mappings, sessions, workflows, and mapplets from one environment to another as required.
• Developed PL/SQL code to enhance performance.
• Coded and debugged packages using stored procedures and triggers as per the requirements document.
• Worked with power exchange to extract data from mainframes.
• Worked on performance tuning of the ETL processes. Optimized/tuned mappings to increase better performance and efficiency.
• Used Informatica debugger to test the data flow and fix the mappings.
• Modified and developed ETL programs, indexes, data staging areas, transformations, summary tables based upon redesign activities.
• Extensively worked on Transformations like Lookup, SQL Joiner and Source Qualifier Transformations using Informatica Designer.
• Performed ETL Tests to validate data on database backend.
• Worked with OLAP dimensional models as required by stakeholders.
• Responsible for troubleshooting mappings that do not execute
• Loaded data into and from the Flat files and databases like oracle.
• Developed UNIX Shell scripts to archive files after performing extraction and data load into the Warehouse.
• Worked with PLSQL views and created packages as per updated business specification documents.
• Worked with Cognos reporting tool.
• Performed normalization in second and third forms.
• Used Informatica Power exchange 9.1 for Change Data Capture (CDC).
• Defined Target Load Order Plan and loaded data as required, into the different Target Tables.
• Involved in Unit and Integration testing of Informatica Sessions, Batches and the Target Data.

Environment: Informatica Power Center 9.1, PL/SQL, Cognos Reporting, Power Exchange 9.1, Oracle 11g, SQL * Plus, Toad, UNIX

Confidential, Buffalo, NY

ETL Informatica Developer

Responsibilities:

• Involved in a full Software Development Life Cycle (SDLC) - Business Requirements Analysis, preparation of Technical Design documents, Data Analysis, Logical and Physical database design, Coding, Testing, Implementation, and deployment to business users.
• Responsible in the convertion of business requirements into developmental deliverables.
• Defined the schema, staging tables, foreign-key relationships, complex joins and checked proper normalizations.
• Designed and developed ETL Mappings using Informatica to extract data from Mainframe DB2 tables, flat files and Oracle, and loaded the data into the target database.
• Worked with OLTP and Cognos reporting tools to run reports with reference to the business requirements.
• Worked with PL/SQL to trigger the database.
• Defined Target Load Order Plan and Constraint based loading for loading data correctly into different Target Tables.
• Worked on Informatica Power Center tools such as Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Coded and debugged packages in stored procedures and triggers
• Utilized SQL tools like TOAD to run SQL Queries to validate the data.
• Responsible for the creation, update and maintenance of ETL technical documentation.
• Developed Informatica mappings to load the data mart and monitored them. The mappings involved the use of transformations like Router, aggregator, filter, Joiner, Union, Normalizer and Sequence Generator Transformations.
• Involved in Informatica PowerCenter Migrations, Repository Backup/Restores and Upgrades.
• Created mapplets for usage in different mappings.
• Created, updated and maintained ETL technical documentations.
• Involved in gathering business requirements, logical modelling, physical database design, data sourcing and data transformation, data loading, SQL and performance tuning.

Environment: Informatica PowerCenter 7.1.3, Oracle10g, PL/SQL, UNIX Shell Scripting, SQL Plus, TOAD.

Confidential, Minneapolis, MN

ETL Informatica Developer

Responsibilities:

• Designed and deployed overall ETL strategy including CDC, SCD’s, Partition Management, Materialized Views and other complex mapping logics.
• Debugged and Troubleshooted Informatica Mappings.
• Worked closely with the Requirements Manager and business Analysts on the requirements collection process.
• Involved in the design of logical and physical database using ERWIN.
• Designed the ETL process and scheduled the stage and mart loads for the data mart.
• Developed and debugged complex stored procedure packages along with triggers.
• Developed shared objects in Informatica for source/target/lookup transformations, developed complex mappings, sessions/workflows/worklets, database connections.
• Worked with normal forms including first, second and third normal forms and maintained historical data.
• Assisted the QA Team in the development of test cases for the project and reviewed them.
• Entered metadata descriptions at both the transformation and port level during complex mappings.
• Established "Best Practices" and plans for continuous improvement of processes.

Environment: Informatica 8.5.1, Oracle 10g, Informatica Power Center 8.1.1, Teradata, Erwin 4.5, Oracle Applications, Flat files, PL/SQL, TOAD 9.0, SQL, UNIX, Quality Center 9.0

TECHNICAL SKILLS:

Data Warehousing/ ETL: Informatica Power Center 9.1/8.6/8.1/7.1.2/7.1.1/7.0 , (Workflow Manager, Workflow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Repository manager), Metadata, DataMart, OLAP, OLTP.

Dimensional Data Modeling: Dimensional Data Modeling, Data Modeling, Star Schema ModelingSnow Flake Modeling, Physical and Logical Data Modeling, Erwin and Oracle Designer.

Databases & Tools: Oracle 11g/10g/9i/8i/8.x, Teradata, SQL*Server, MS SQL Server 2005/2000/7.0/6.5 , SQL*Plus, SQL*Loader, TOAD

Scheduling Tools: Informatica Workflow Manager

Programming Languages: Unix Shell Scripting, SQL, PL/SQL

Environment: UNIX, Win XP/NT 4.0, HP-UX 10.20/9.0, IBM AIX 4.2/4.3