SUMMARY

• About 5 years of IT experience in analysis, design, development, testing, trouble - shooting, deployment, performance tuning and documentation of data warehousing/ ETL using Informatica tools.
• Responsible for all activities related to development, implementation and support for ETL process for large scale data warehouses using Power Center, Designer, Workflow Manager, and Workflow Monitor.
• Experience in the field of Enterprise Data Warehousing, Data Integration and Data/Code Migration.
• Worked on Star Schema, Snowflake modeling, FACT & Dimensions tables, Physical & logical data modeling.
• Experience working in Banking, Healthcare and Telecommunication industries.
• Experience in working with different heterogeneous source systems like Oracle, SQL Server, DB2, Flat Files, PL/SQL, Excel and Teradata.
• Good understanding of Software Development Life Cycle (SDLC), Data warehousing concepts and RDBMS concepts.
• Worked extensively with Slowly Changing Dimensions.
• Experience in Debugging/Optimizing/Tuning Informatica 9.x, 8.x mappings for better Understand the business rules completely based on High Level document specifications and implemented the data transformation methodologies.
• Good Knowledge with UNIX Operating System, Shell scripting, job scheduling and server communication using pmcmd.
• Performed Informatica code Migration from Development/ QA/ Production and fixed and solved mapping and workflow problems
• Experience in creatingReusable Transformations(Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank) and processing tasks usingWorkflow Managerto move data from multiple sources into targets.
• Team player, self-starter with excellent communication and interpersonal skills.

TECHNICAL SKILLS

ETL Tools: Informatica 9.x/8.x(Power Center/Power Mart/Power Exchange) (Designer, Transformations, 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, DB2, MS Access, SQL, PL/SQL, SQL*Plus.

BI Tool: Business Objects, Cognos

Operating System: UNIX, Windows.

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

PROFESSIONAL EXPERIENCE

Confidential, DE

Sr Informatica Developer

Responsibilities:

• Developed complex mappings using Informatica Power Center Designer to transform and load the data from various source systems like Oracle, Teradata, and Sybase into the Oracle target database.
• Analyzed and understood all data in the source databases and designed the overall data architecture and all the individual data marts in the data warehouse for each of the areas Finance, Credit Cards, Brokerage.
• Involved in the creation of oracle Tables, Table Partitions, and Indexes.
• Involved in quality assurance of data, automation of processes.
• Involved in the development and testing of individual data marts, Informatica mappings and update processes.
• Identified and tracked the slowly changing dimensions, heterogeneous Sources and determined the hierarchies in dimensions.
• Used Task developer in the Workflow manager to define sessions
• Created application-specific Data Marts so that users can access personalized dashboards of information that is specific to their department and business unit.
• Responsible for monitoring all the sessions that are running, scheduled, completed and failed.
• Worked on database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Defined the program specifications for the data migration programs, as well as the necessary test plans used to ensure the successful execution of the data loading processes.
• Involved in writing UNIX shell scripts for Informatica ETL tool to run the Sessions.
• Connection management and scheduling of jobs to be run in the batch process
• Generated detailed reports from the data marts using Business Objects.

Environment: Informatica PowerCenter 9.6, Business Objects, Oracle 11g, DB2, SQL/PLSQL, Teradata, Sybase, UNIX Shell Programming.

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.1 for extraction, transformation and loading (ETL) of data in the Data Warehouse and used velocity methodology.
• Designed, developed and documented several mappings to extract the data from Flat files and Relational sources.
• Performed ETL into ORACLE Data Warehouse using Informatica Mappings including transformations Aggregator, Joiner, Lookup (Connected & unconnected), Filter, Update Strategy, Stored Procedure, Router, Expression, Sql and Sorter.
• Involved in design and development of ad-hoc data load or business critical code enhancement
• 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.1, Oracle 11g, DB2, SQL, PL/SQL, Business Objects.

Confidential, Fairfax, VA

Responsibilities:

• Involved in collecting the requirements from the Professor.
• Participated in analysis of data
• Developed mappings using different transformations like Filter, Joiner, Expression, Aggregate, Router and Lookup transformations.
• Developed reusable transformations to use in multiple mappings.
• Used debugger to test the data flow and fix the mappings, Created and Monitored Sessions.
• Identified and solved technical problems in the Data mart design and ETL implementations.

Environment: Informatica Power Center 9.1, Oracle 11G.

Confidential, MI

ETL Specialist

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.
• Worked closely with BI team.
• 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.
• Auditing is captured in the audit table and EOD snapshot of daily entry is sent to the distributed list to analyze if anything is abnormal.
• 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, CA

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

Jr. Developer

Responsibilities:

• Developed mappings using transformations like Filter, Joiner, Expression, Aggregate, Router and Lookup transformations.
• Developed reusable transformations to use in multiple mappings.
• Used debugger to test the data flow and fix the mappings, Created and Monitored Batches and Sessions.
• Involved in tuning the sessions, mappings and fine-tuned the SQL queries using hints for better performance.
• Written and executed UNIX shell scripts to automate few reports.
• Created complex SQL queries, Stored Procedures, functions and database triggers and Views for the purpose of data analysis.
• Planned coordinated and executed Business Objects deployment for End-users and documented the project.

Environment: Informatica Power Center 8.6, Oracle 9i, DB2, SQL, PL/SQL, UNIX, Business Objects.