SUMMARY

• Over 7+ years of experience in Information Technology with a strong background in Database and Data warehouse Experience.
• Data Warehousing: strong Data warehousing experience using Informatica Power Center 9.5/9.0.1/8.6/8.1.1/7.1 (Source Analyzer, Repository Manager, Mapping Designer, Mapplets, Transformations, Workflow Manager, Task Developer), Power Connect for ETL, OLTP, OLAP, Data Mining, scheduling tool. Worked with heterogeneous source systems like flat files, RDBMS, DWH, parameterzing variables.
• Data Modeling: Data modeling knowledge in Dimensional Data modeling, Star Schema, Snow - Flake Schema, FACT and Dimensions tables, Physical and logical data modeling and De-normalization techniques.
• Database: Using Oracle 11g/10g, Teradata TD13/TD12, SQL, PL/SQL, SQL*Plus, SQL Server 2008/2005. Proficient in working with PL/SQL to write stored procedures and triggers. Expertise in WinSQL, TOAD (Tool for Oracle Application Developers).
• Proficient in Analyzing Business processes requirements and translating them into technical requirements.
• Upgraded Informatica Power Center Repository from 7.1 to 8.6.
• Worked with testing team to create test cases for unit and integration testing, expertise in User Acceptance Testing Consultation with SME’s.
• Excellent understanding of Client/Server architecture makes a valuable asset to any project, with Excellent Logical, Analytical, Communication and Organizational Skills.
• Excellent team player and can work on both development and maintenance phases of the project.
• Highly skilled in providing instantaneous and workable solutions to business problems.
• Efficient team player with excellent communication skills and good interaction with users.
• Experience with Sales, Retailing, Financial and Health care Domains.

TECHNICAL SKILLS

Data Warehousing: Informatica Power Center 9.5/9.0.1 / 8.6 / 8.5 / 8.1.1 / 7.1 (Designer, Workflow Manager, Workflow Monitor, Repository Manager)Power Connect MS SQL Server 2000 Analysis ServicesOLAP, OLTP, ETL, Autosys, Maestro, Data Cleansing, Data Profiling

Databases: Teradata TD13/TD12, Oracle 11g/10g/9i, MS SQL Server 2008/2005

RDMS Load Tools: TOAD 8.x, SQL Developer(Database tool), SQL Assistant

Languages/Web: SQL, PL/SQL, UNIX Shell Scripting

Environment: UNIX, Windows 2000/2003/XP, Windows NT, Red Hat Linux 7.2

PROFESSIONAL EXPERIENCE

Confidential, MI

Informatica Developer

Responsibilities:

• Understanding business needs and implement the same into a functional database design.
• Participated in requirements gathering.
• Involved in all the phases of SDLC.
• Developed new Informatica mappings and workflows based on specifications.
• Developed Batch Processing, Source and Target Reconciliation.
• Designed and developed various Informatica mappings using transformations like Expression, Aggregator, External Procedure, Stored Procedure, Lookup, Filter, Joiner, Rank, Router, and Update Strategy. Developed various Ad-hoc mappings for various business needs.
• Performed extraction, transformation and loading of data from RDBMS tables, Flat Files into Teradata in accordance with requirements and specifications.
• Developed and tested all the backend programs, Error Handling Strategies and update processes.
• Writing Stored Programs (Procedures & Functions) to do Data Transformations and integrate them with Informatica programs and existing applications.
• Created, scheduled, and monitored workflow sessions on the basis of run on demand, run on time, using Informatica Power Center workflow manager.
• Used Informatica Version Control for checking in all versions of the objects used in creating the mappings, workflows to keep track of the changes in the development, test and production environment.
• Used Erwin data modeling tool to do conceptual/logical/physical data models.
• Developed Unix shell scripts to scheduling Scripts by using scheduling tools.
• Designed Excel Sheets for each mapping of their Test Scenarios.
• Worked with production issues like bottlenecks, data validation and report errors.

Environment: Informatica Power Center 9.5 (Power Center Designer, workflow manager, workflow monitor), Teradata TD 13, UNIX, Flat files, Windows 7 Professional.

Confidential, Billerica, MA

Informatica Developer

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Creating the design and technical specifications for the ETL process of the project.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Worked on all the SCD like Type 1, 2, 3 and type 2 variant.
• Designing and creation of complex logic using SCD type II involving
• Used Informatica PowerCenter for data extraction from various sources like Oracle and flat files.
• Worked extensively on Source Analyzer, Mapping Designer, Mapplet designer and Warehouse Designer and Transformation Developer.
• Designed and developed Informatica Mappings and sessions based on business rules.
• Developed several Mappings and Mapplets using corresponding Sources, Targets and Transformations
• Transformations such as expression, joiner, aggregator, lookup, update strategy, filter.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Created sessions and workflows to run with the logic embedded in the mappings using Power center Designer.
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.

Environment: Informatica Power Center 9.0.1 (Power Center Designer, workflow manager, workflow monitor), Oracle 11g, UNIX, Flat files, Windows XP professional.

Confidential, Columbus, IN

Informatica Developer

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Creating the design and technical specifications for the ETL process of the project.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Developer.
• Developed complex mappings using Informatica Power Center Designer to transform and load data.
• Extensively used various types of transformations such as Expression, Joiner, Update strategy, Aggregator, Filter, and Lookup.
• Developed several Mappings and Mapplets using corresponding Sources, Targets and Transformations.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Implemented complex mappings such as Slowly Changing Dimensions.
• Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.
• Built in mapping variable/parameters and created parameter files for imparting flexible runs of workflows based on changing variable values.
• Designed and Developed pre-session, post-session routines for Informatica sessions to drop and recreate indexes and key constraints for bulk loading.
• Created sessions and workflows to run with the logic embedded in the mappings using Power center Designer.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Maintain Development, Test and Production mapping migration Using Repository Manager.
• Responsible for monitoring all the sessions that are running, scheduled, completed and failed.

Environment: Informatica Power Center 8.6 (Power Center Designer, workflow manager, workflow monitor), UNIX, Oracle.

Confidential, Franklin Lakes, NJ

Informatica Developer

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Creating the design and technical specifications for the ETL process of the project.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Developer.
• Developed complex mappings using Informatica Power Center Designer to transform and load data.
• Extensively used various types of transformations such as Expression, Joiner, Update strategy, Aggregator, Filter, and Lookup.
• Developed several Mappings and Mapplets using corresponding Sources, Targets and Transformations.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Implemented complex mappings such as Slowly Changing Dimensions.
• Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.
• Built in mapping variable/parameters and created parameter files for imparting flexible runs of workflows based on changing variable values.
• Designed and Developed pre-session, post-session routines for Informatica sessions to drop and recreate indexes and key constraints for bulk loading.
• Maintain Development, Test and Production mapping migration Using Repository Manager.
• Created sessions and workflows to run with the logic embedded in the mappings using Power center Designer.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Responsible for monitoring all the sessions that are running, scheduled, completed and failed.

Environment: Informatica Power Center 8.1 (Power Center Designer, workflow manager, workflow monitor), UNIX, Oracle, Teradata.

Confidential

ETL Developer

Responsibilities:

• Development of General Ledger, Transaction and Profit Margins processes.
• Development of staging for equities, Derivatives and Fixed income.
• Business Analysis and Requirements gathering from the Business Users and Technical document design of these requirements.
• Designed mapping documents and developed ETL mappings using Informatica. Designed and developed Informatica mappings to build business rules to load data.
• Extensively used almost all types of transformations like filter, joiner, sorter, rank, update strategy, expression and aggregation.
• Extracted data from heterogeneous source systems.
• Involved in importing Source/Target Tables from the respective databases and created Reusable Transformations, Mapplets using Designer module of Informatica.
• Involved in coding, testing in UAT.
• Created Workflow, Decision, Event Wait and Raise and Email Task, scheduled Task and Workflow based on Client requirements.
• Created reusable worklets and mapplets and transformations.
• Performance Tuning of sources, targets, mappings and SQL queries in transformations.
• Wrote Unix Shell Scripts to run mappings.
• Created Functions, Procedures and Triggers in PL/SQL.

Environment: Informatica PowerCenter 8.1.1, Oracle 9i, UNIX, Autosys.

Confidential

Informatica Developer

Responsibilities:

• Involved in OLTP system analysis
• Backup & Restore Oracle Table space containing Informatica data.
• Participated in system design and data modeling (logical and physical).
• Developed customized routine (ETL system) to capture and load data from external (Oracle 8x, Flat files) data sources into Oracle database.
• Extensively used Informatica to load data into Centralized Data Warehouse.
• Worked on Informatica tool - Source Analyzer, Target Designer, PowerCenter Designer, Mapping Designer, Mapplet Designer and Transformations.
• Created sessions and batches to run the mappings and set the session parameters to improve the load performance Developed Mapplets, reusable transformations and creation of shortcuts.
• Created Informatica mappings to build business rules to load data Most of the transformations were used like the Source qualifier, Aggregators, lookups, Filters & Sequence Generators.
• Creating Jobs and Scheduling the Jobs based on target load Order.
• Developed mapping based on ABAP Functional modules developed by ABAP developers and closely co-coordinated with them in migrating the data to staging tables using Informatica Power connect adaptor.
• Wrote stored PL/SQL procedures for certain Business Requirements
• Involved in Unit Testing and tuning process for better performance
• The ETL tool is an integral part of the data warehousing architecture that will be
• Used to model and create target Warehouse, extract data from multiple data sources, transform the data to make it Accessible to business analysis, and loading target data marts

Environment: Informatica PowerCenter 7.x, Oracle 9i, SQL*PLUS, SQL, PL/SQL, Erwin, UNIX, MS Excel, MS Visio.