SUMMARY

• Over 8 years of strong experience in design and development of Informatica Mappings and workflows using Informatica Power Center 9.x, 8.x, 7.x versions.
• 8 Years of experience wif extensive data warehousing Implementations across various verticals.
• 8 Years of experience wif ETL and data Integration tools in developing ETL Mappings and Workflows.
• Worked in all teh Phases of SDLC Life Cycle Involving Requirement Analysis, Design, Development, Testing and Deployment.
• Experience in working wif business analysts to identify study and understand requirements and translated them into ETL code in Requirement Analysis phase.
• Experience in creatingHigh Level Design and Detailed Designin teh Design phase.
• Worked on IDQ/IDE tools for data profiling, data enrichment and standardization
• Worked in integration of various data sources like Oracle, DB2, SQL server and Teradata and non - relational sources like flat files into staging area.
• Experience in creating Reusable Transformations (Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank) and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Experience in creating Reusable Tasks (Sessions, Command, Email) and Non-Reusable Tasks (Decision, Event Wait, Event Raise, Timer, Assignment, Worklet, Control).
• Tuned mappings using Power Center-Designer and used different logic to provide maximum efficiency and performance.
• Experienced in UNIX work environment, file transfers, job scheduling and error handling.
• Extensively worked on developing and debugging Informatica mappings, mapplets, sessions and workflows.
• Worked on Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Experience in Writing Oracle SQL Queries and PL/SQL Scripts in Handling Complex logic like calculation of Monthly aggregate measures.
• Expertise in Business Model development wif Dimensions, Hierarchies, Measures, Partitioning, Aggregation Rules, Time Series, Cache Management.
• Experience in working wif Version Control of Informatica Power center tool and was Involved in code Migration using Labels, Queries and deployment groups.
• Involved inUnit testing, System testingto check whether teh data loads into Confidential are accurate.
• Experience in support and noledge transfer to teh production team
• Good interpersonal and communication skills, and experienced in working wif senior level managers, business people and developers across multiple disciplines.
• Ability to work independently as well as in any challenging team environment wif strong analytical and problem-solving skills.

TECHNICAL SKILLS

ETL TOOLS: Informatica Power center 9.5/9.1, 8.6.1/8.1, 7.1.2, IDQ 9.6.1/9.0.1/8.6

Operating Systems: Unix, Windows

Databases: Oracle 9.x/10.x/11.x, Teradata V2R12/V2R6

Oracle Tools: SQL*Plus, SQL*Loader, SQL developer, Toad

Data Modeling Tools: ERWIN, Visio

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

PROFESSIONAL EXPERIENCE

Confidential, Detroit, MI

Senior ETL Developer

Responsibilities:

• Interacted wif teh Business users to identify teh process metrics and various key dimensions and measures. Involved in teh complete life cycle of teh project.
• Involved in development of FRD (Functional Requirement Document) and data architecture document and communicated wif teh concerned stakeholders. Conducted Impact and feasibility analysis.
• Involved in Fact and Dimension data modelling.
• Involved in Design Document Preparation of teh Project.
• Developed Informatica Mappings and workflows to populate different fact and dimension tables using reusable transformations.
• Implemented change capture logic to pull Incremental data transactions from Source and Insert/Update Confidential table accordingly.
• Involved in development of PLSQL blocks/Stored Procedures for handling complex business logic of measures calculation in Monthly manner.
• Performance tuned Informatica session, for large data files by increasing block size, data cache size, and Confidential based commit
• Created partitions for parallel processing of data and also worked wif DBAs to enhance teh data load during production.
• Worked on CDC (Change Data Capture) and implemented SCD (Slowly Changing Dimensions) Type 1 and Type 2.
• Developed shell scripts for Daily and weekly Loads and scheduled using Unix Maestro utility.
• Prepared ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and tan to production Environment.
• Involved in Unit testing, System testing to check whether teh data loads into Confidential are accurate, which was extracted from different source systems according to teh user requirements.
• Actively involved in production support. Implemented fixes/solutions to issues/tickets raised by user community.

Environment: Informatica Power Center 9.x, IDQ 9.0.1, Oracle 11g, Teradata, SQL Developer, SQL*Loader, Teradata SQL Assistant, UNIX Maestro, Unix.

Confidential, Princeton, NJ

Senior ETL Developer

Responsibilities:

• Involved in teh Fact and Dimension data modeling.
• Involved in development of FRD (Functional Requirement Document).
• Involved in Design document preparation of teh Project.
• Translated Business specifications into PL/SQL code. Extensively developed and fine-tuned Oracle Stored Procedures and triggers.
• Created mappings using transformations like Source Qualifier, Joiner, Aggregator, Expression, Filter, Router, Lookup, Update Strategy, and Sequence Generator.
• Handled Slowly changing dimensions (SCD) Type 1, Type 2 in Informatica Mappings / Workflows.
• Involved in cleansing and extraction of data and defined quality process using IDQ for teh warehouse.
• Worked on Informatica mappings or Workflows development for population of Confidential fact and dimension tables.
• Provided Knowledge Transfer to teh end users and created extensive documentation on teh design, development, implementation, daily loads and process flow of teh mapping.
• Implemented teh error handling functionality and enabled email notifications and validations through UNIX scripting.
• Implemented various loads like Daily Loads, Weekly Loads, and Quarterly Loads using Incremental Loading Strategy using teh concepts of Change Data Capture (CDC).
• Involved in Unit testing, User Acceptance testing to check whether teh data is loading into Confidential, which was extracted from different source systems according to teh user requirements.
• Involved in migrating objects from DEV to QA and testing them and tan promoting to Production
• Involved in production support working wif various tickets created while teh users working to retrieve teh database

Environment: Informatica Power Center 8.x, Oracle 10g, SQL/PLSQL, SQL Developer, SQL*Loader, UNIX (IBM - AIX), Autosys.

Confidential, San Francisco, California

Senior ETL Informatica Developer

Responsibilities:

• Involved in complete SDLC phase in collecting and documenting requirements. Wrote TSD documents for developers to easily understand teh code.
• Developed Informatica mappings to consolidate data from multiple source systems into teh new data warehouse dat we built. All teh data sources resided on various platforms. These sources include fixed width and delimited flat files, DB2 Excel, Oracle.
• Developed complex mappings using Informatica Power Center Designer to transform and load teh data from various source systems like Oracle, Teradata, and Sybase into teh Oracle Confidential database.
• Developed ETL routines using Informatica Power Center and created mappings involving various transformations.
• Generated Dynamic Confidential File in Informatica Based on Column Value by using TC when number of Confidential file is not certain.
• Extensively used Mapping Variables, Mapping Parameters to execute complex business logic.
• Formulated and implemented Historical load strategy from multiple data sources into teh data warehouse. Data concurrency, Prioritization, comprehensiveness, completeness and minimal impact to existing users are taken as key attributes for Historical data load strategy.
• Development of PL/SQL Stored Procedures to implement complex business logic and integrate them wif teh ETL process as pre/post Stored Procedures.
• Responsible for teh documentations of teh different processes carried out like design documents and mapping documents, share point for teh version control of teh documents and for teh version control of source code for all teh interfaces in teh Interface Project.
• Designing teh dimensional model and data load process using SCD Type II for teh quarterly membership reporting purposes.
• Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations and Create mapplets dat provides reusability in mappings.

Environment: Informatica Power Center 8.x, Oracle 10g, Teradata, DB2, IDQ, SQL Developer, SQL*Loader, UNIX.

Confidential, WI

ETL Informatica Developer

Responsibilities:

• Designed and Developed Informatica mapping and sessions to create flat files.
• Developed PL/SQL Stored Procedures, Packages.
• Developed Database triggers for implementing Business logic.
• Involved in Informatica Administration activities such as creating & managing Informatica users, groups and privileges.
• Involved in taking backup of teh repository, restoring repository etc.
• Tuned teh performance of Mappings, Sessions, relational source and targets.
• Interfaced Trillium to cleanse, de-duplicate and identify household Customers.
• Prepared Software engineering quality documents related to design, development, testing as per CMM standards.
• Developed mapping (interfaces) data transfer strategy from data sources to Confidential systems.
• Developed and tested all teh Informatica mappings, sessions and workflows - involving several Tasks.
• Worked on Dimension as well as Fact tables, developed mappings and loaded data on to teh relational database.
• Good exposure on Normalized, De normalized Data.
• Developed extract logic mappings and configured sessions.
• Used aggregator, router, joiner, stored procedures, look up, filter, source qualifier and update strategy transformations extensively.
• Created reusable transformations and mapplets to use in multiple mappings.
• Handled teh performance tuning of Informatica mappings.
• Developed Shell Scripts as per requirement.

Environment: Informatica 8.x/7.x (Power Center, Power Exchange), Windows 2000/XP, Oracle 9i/10g, SQL Developer, Teradata.

Confidential

ETL Informatica Developer

Responsibilities:

• Responsibilities include designing teh documents.
• Created mappings using various transformations in Informatica.
• Worked on teh performances tuning of teh Informatica mappings.
• Unit testing teh data flows.
• Perform various levels of testing at various levels of teh ETL.
• Done extensive testing and wrote queries in SQL to ensure teh loading of teh data.
• Created test cases for various test scenarios to test teh functionality of teh objects.
• Developed and implemented teh coding of Informatica Mapping for teh different stages of ETL.

Environment: Informatica 8.x/7.x (Power Center, Power Exchange), Windows 2000/XP, Oracle 10g, SQL Developer, SQL*Plus, SQL*Loader.