SUMMARY

• About 7 years of experience in Information Technology including Data Warehouse/ Data Mart development using ETL/Informatica Power Center.
• Experience in all the phases of Data warehouse life cycle involving Requirement Analysis, Design, Coding, Testing, and Deployment.
• Extensive experience in using Informatica tool for implementation of ETL methodology in Data Extraction, Transformation and Loading.
• Good exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation, production support.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star - Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Experience in performance tuning and extraction, transformation and loading of data directly from different heterogeneous source systems like SQL Server, Teradata, Flat files (Fixed width & Delimited), XML Files, Excel, Oracleand Teradata.
• Worked extensively with Informatica Workflow Manager (using tools such as Task Developer, Workletand Workflow Designer, and Workflow Monitor) to build and run workflows.
• Extensive experience with Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Normalizer and Union.
• Extensive experience in Informatica Power Center to implement data marts which involve creating, debugging and executing mappings, sessions, tasks, and workflows. knowledge in identifying performance bottlenecks and also in tuning the Mappings and Sessions by implementing various techniques like partitioning techniques and pushdown optimization
• Proficient in Analyzing Business processes requirements and translating them into technical requirements.
• Good Knowledge with UNIX Operating System,Shell scripting, job scheduling and server communication using pmcmd.
• Extensively used SQL, PL/SQL in writing Stored Procedures, Functions, Packages and Triggers.
• Excellent analytical, problem solving, and communication skills with ability to interact with individuals at all levels.

TECHNICAL SKILLS

ETL TOOLS: Informatica 9.x/8.x(Power Center/Power Mart/Power Exchange)(DesignerTransformations, Workflow Manager, Workflow Monitor, Source Analyzer, Repository Manager, Mapping Designer, Mapplets) Power Analyzer, OLAP, OLTP.

Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling.

Databases: Oracle11g/9i, MS SQL Server, Teradata, MS Access, SQL, PL/SQL, SQL*Plus.

BI Tool: Business Objects, Cognos, TOAD.

Operating System: UNIX, Windows.

Programming: SQL, PL/SQL, SQL*Plus, HTML, C, C++, Java, UNIX Shell Scripting.

PROFESSIONAL EXPERIENCE

Confidential, VA

Sr. Informatica Developer

Responsibilities:

• Involved in design and development of Business Requirements with business users and Technical teams by gathering requirement specification documents and identifying data sources and targets.
• Analyzed application requirements and provided recommended design and studied the current system to understand the existing data structures.
• Participated actively in user meetings and collected requirements from users.
• Used Informatica Power Center 9.5for extraction, transformation and loading (ETL) of data in the Data Warehouseand used velocity methodology.
• Designed, developed and documented several mappings to extract the data from Flat files and Relational sources.
• Worked on Informatica IDQ for data cleansing and data profiling.
• Worked closely with BI team.
• Performed ETL into ORACLE Data Warehouse using Informatica Mappings including transformations Aggregator, Joiner, Lookup (Connected & unconnected), Filter, Update Strategy, Stored Procedure, Router, Expression, Sqland Sorter.
• Worked on stored procedures, functions, views.
• Developed data Mappings between source systems and warehouse components.
• Created workflows and tested mappings and workflows in development, test and Production environment.
• Developed re-usable transformations, mappings and mapplets confirming to the business rules. Used Debugger to test the mappings and fix the bugs.
• Implemented SCD type 1 and type 2 to capture changes and maintain the historical data
• Actively involved in Performance improvements of Mapping and Sessions and fine-tuned all transformations.
• Performed Informatica code Migration from Development/ QA/ Production and fixed and solved mapping and workflow problems.
• Developed and maintained optimized SQL queries in the Data Warehouse.

Environment: Informatica Power Center 9.5, Oracle 11g, Teradata, SQL, PL/SQL, Flat Files, ODI, Business Objects.

Confidential, PA

ETL Developer

Responsibilities:

• Involved in Requirement analysis in support of Data Warehousing efforts.
• Maintain Data Flow Diagrams (DFD’s) and ETL Technical Specs or lower level design documents for all the source applications.
• Worked with source databases like Oracle, SQL Server and Flat Files.
• Extensively worked with various Active transformations like Filter, Sorter, Aggregator, Router, Lookup and Joiner transformations.
• Extensively worked with various Passive transformations like Expression, Sequence Generator, Mapplet Input and Mapplet Output transformations.
• Created complex mappings using Unconnected and Connected lookup Transformations.
• Implemented Slowly changing dimension Type 1 and Type 2 for change data capture.
• Worked with various look up cache like Dynamic Cache, Static Cache, Persistent Cache, Re Cache from database and Shared Cache.
• Responsible for definition, development and testing of processes/programs necessary to extract data from client's operational databases, transform, cleanse data and load it into data marts.
• Worked with various Informatica PowerCenter objects like Mappings, transformations, Mapplet, Workflows and Session Tasks.
• Responsible for the performance tuning of the ETL process at source level, target level, mapping level and session level.
• Worked extensively with update strategy transformation for implementing inserts and updates.
• Extensively used the tasks like email task to deliver the generated reports to the mailboxes and command tasks to write post session and pre session commands.
• Extensively used debugger to test the logic implemented in the mappings.
• Performed error handing using session logs.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size and target based commit interval.
• As per business we implemented Auditing and Balancing on the transactional sources so that every record read is either captured in the maintenance tables or wrote to Target tables.
• Monitored workflows and session using PowerCenter workflows monitor.
• Used Informatica Scheduler for scheduling the workflows.

Environment: Informatica PowerCenter 9.1, Oracle 10g, Sybase 12, Flat Files, SQL* Plus, SQL, PL/SQL, Business Objects, Cognos.

Confidential, CO

Informatica Developer

Responsibilities:

• Imported various Sources, Targets and Transformations using Informatics Power Center.
• Tuning of Informatics Mappings for better performance.
• Developed various Sessions, Batches for all Mappings for data loading from Source TXT files, Tables to Target tables.
• Involved in Designing Logical and Physical Database Designing using ERWIN Tool.
• Used different Data Warehouse techniques like Star-Schema.
• Analyzed and Created Facts and Dimension Tables.
• Created Mappings between Source and Target using Power Center Designer.
• Developed different Transformations to load the data into target.
• Created various data marts from data warehouse and generated reports using Business Objects.
• Worked with various Informatica PowerCenter objects like Mappings, transformations, Mapplet, Workflows and Session Tasks.
• Improving workflow performance by shifting filters as close as possible to the source and selecting tables with fewer rows as the master during joins.
• Tuned the mappings and sessions for better performance by eliminating various interacted performance bottlenecks.
• Developed PL/SQL stored procedures to implement business logic.
• Tuning of SQL queries for better performance.
• Use of filters, conditions, calculations, etc.
• Presentation of the advanced features of Business Objects to users and developers to enable them to develop queries and reports easily.

Environment: Informatica Power Center 8.6, Oracle 9i, DB2, SQL, PL/SQL, UNIX, TOAD, SQL Server 2000.

Confidential

Informatica Developer

Responsibilities:

• Interacted with the Business Personnel to analyze the business requirements and transform the business requirements into the technical requirements.
• Developed standard and re-usable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup Connected/Unconnected, and filter.
• Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance.
• Used Workflow Manager for creating, validating, testing and running the sequential and concurrent sessions and scheduling them to run at specified time and as well to read data from different sources and write it to target databases.
• Preparing ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.
• Extensively used Stored Procedures, Functions and Packages using PL/SQL for creating Connected and Unconnected Stored Procedure Transformations.
• Maintaining issue log of the issues during the UAT phase for future reference
• Preparing and using test data/cases to verify accuracy and completeness of ETL process.
• Assisted inproduction support and also transferred knowledge to the other team members.
• Prepared ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.

Environment: Informatica Power Center 8.6, Oracle 9i, DB2, SQL, PL/SQL, UNIX, TOAD, Flat Files Erwin.