SUMMARY:

• Over 14 years of experience in all phases of Software Development Life Cycle for Client/Server applications and Data Warehouse / Data Mart solutions. Involved in requirement analysis, design, development, testing and implementation using Oracle 10g /9i / 8i, Informatica Power Center / Power Mart 9.1/8.6/8.1.1/7.1/6.2/6.0/5.1 , Informaica Power Exchange9.5.1, Informatica Data Quality, Power center Scheduler, Business Intelligence using Cognos 7.x /6., Erwin 8.1,SQL Developer, SQL Developer Data Modeler, Oracle Warehouse Builder 3.0, Designer2000, Developer2000 on Windows and Unix platforms.
• Around 10 years of experience working on Informatica.
• Experience in Data Modeling and database designing with Business Process Re - engineering (BPR) and Information Engineering (IE)methodologies.
• Data modeling experience using Ralph-Kimball methodology and Bill-Inmon methodology, implementing Star Schema, Snow Flake Schema, and Extended Star Schema.
• Extensive knowledge with Dimensional Data modeling, Star Schema / Snowflakes Schema, Fact and Dimension tables.
• Extensive experience in Business Intelligence using, Business Objects6.1 (Supervisor, Designer, Report Writer, Broadcast Agent, Infoview and Web Intelligence2.6),
• Extensive experience in developing strategies for Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouse and Data Marts using Informatica PowerMart/PowerCenter (Repository Manager, Server Manager, Mapping Designer, Mapplet Designer, Transformation, Designer, Warehouse Designer)
• Excellent experience in Relational Database (RDBMS) Oracle 11i/10g/9i/8i/7.x, T-SQL, MS SQL Server 2000/7.0/6.5 , , TeraData and other file formats like flat-files, CSV files, COBOL files and XML files Sybase, DB2 UDB 8.0/7.0/6.0, MS Access 7.0/2000,
• Data Analysis: strong Business Analysis experience on Data Analysis, User Requirement Gathering, User Requirement Analysis, Gap Analysis, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis.
• Extensive experience in supporting Informatica applications
• Good experience in Performance Tuning of Informatica mappings
• Involved in Relational database design and development of data warehouse data feeds
• Extensively worked on database applications using Oracle, SQL* Plus, PL/SQL
• Excellent skills in retrieving the data by writing simple/ complex SQL Queries
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, MS Access and Worked on integrating data from flat files and XML
• Worked with Stored Procedures, Triggers, Cursors, Indexes, and Functions
• Analyzed, designed, developed, implemented and maintained moderate to complex initial load and incremental loads using Informatica mappings and workflows to provide data for Data Warehouse.
• Experienced in environments requiring direct customer interaction during specifications, design, development and product implementation phases
• Involved in high level design and low level design documentation of database scripts, triggers,procedures and Informatica mappings
• Used Informatica to load data from various sources and targets like, oracle,DB2,Flatfiles,XML, IBMMQ SERIES.
• Experience on IBM MQ SERIES with informatica .
• Experience with XML, XML Schema (XSD) design and loading xml using Informatica.
• Excellent knowledge in shell scripting and scheduling of jobs under the UNIX Environment.
• Coordinate and deliver application development related activities with data integration team members to achieve success in design, development and deployment activities.

SKILL:

ETL Tools: Informatica Power Center / Power Mart 6.2/7.1/8.1.1/8.6 , Ab initio, Oracle Warehouse Builder.

Data Modeling Tools: Erwin, Designer2000/6i

OLAP Tools: Cognos Impromptu 6.0, Impromptu Web Reports 6.0 (IWR), PowerPlay

6.6, Business Objects 6.1/5.1, Web Intelligence 2.5/2.6, Broadcast Agent:

2.6/5.1 and Crystal Enterprise.:

Database Tools: SQL*PLUS, SQL* Loader, TOAD

Languages: C, SQL, and PL/SQL

Scripting languages: UNIX Shell scripting, PERL, VBScript

Databases: Oracle 7.x / 8 / 8i / 9i, SQL Server 6.5/7.0, Sybase, Tera data V2R5

Hardware: IBM PC and Compatibles, Analog and Digital Control Systems.

Systems: UNIX (IBM AIX, SUN Solaris), Windows 95/98/NT/2000, MSDOS 6.22

PROFESSIONAL EXPERIENCE:

Confidential

ETL lead

Responsibilities:

• Involved in requirement Gathering and analysis of source data as data comes in from different Source systems.
• Performed ETL code reviews and Migration of ETL Objects across repositories.
• Developed ETL's for masking the data when made available for the Offshore Dev team.
• Documentation on Detailed Technical Design, Migration process, Test cases and ETL Run Book.
• Worked on Tuning both ETL and Database Objects for better performance.
• Developed UNIX scripts for dynamic generation of Param Files & for FTP/SFTP transmission
• Monitored day to day Loads, Addressed & resolved Production issues in an abrupt & timely manner and provided support for the ETL jobs running in Production in order to meet the SLA's
• Performance tuning was done at the functional level. Used relational SQL wherever possible to minimize the data transfer over the network.
• Responsible for Performance Tuning at the Mapping Level, Session Level, Source Level and the Target Level for Slowly Changing Dimensions Type1, Type2 for Data Loads
• Involved in enhancements and maintenance activities of the data warehouse including tuning, modifying of stored procedures for code enhancements.
• Worked extensively on Informatica Partitioning when dealing with huge volumes of data and also partitioned the tables in Oracle for optimal performance.
• Created mappings which involved Slowly Changing Dimensions Type 1 and Type 2 to implement business logic and capturing the deleted records in the source systems.
• Widely used Informatica client tools -- Source Analyzer, Warehouse designer, Mapping designer, Transformation Developer and Informatica Work Flow Manager.
• Used look up, router, filter, joiner, stored procedure, source qualifier, aggregator and update strategy transformations extensively .
• Prepared ETL design document which consists of the database structure, change data capture, Error handling, restart and refresh strategies
• Worked with different scheduling tools like Autosys.

Environment: Informatica Power Center 9.1/ Informatica Power Exchange, Oracle 11g/10g, WinScp, TOAD, Windows NT/XP, Putty, UNIX, SFTP/FTP, Autosys, MS-SQL Server

Confidential

ETL lead /Admin

Responsibilities:

• Involved in interacting with Business Managers and users to gather requirements, as and when required, and analyzed the data provided by them and put these data together to do the documentations.Developed Excel mappings for documentation purposes.
• Interaction with Team everyday for on going work, based on the Tickets/issues and to follow up with them for its progress.
• Administrating User Privileges, Groups and Folders which includes creation, update and deletion.
• Migration of New and Changed Informatica objects across the environments using Folder to Folder and Deployment Group methods.
• Prepared Change Request's, Work Order's, Problem Ticket's, and Work Request are for the deployment process.
• Responsible for best practices like naming conventions, Performance tuning, and Error Handling
• Created mappings which involved Slowly Changing Dimensions Type 1 and Type 2 to implement business logic and capturing the deleted records in the source systems
• Design of ETL mappings for the CDC change data capture
• Understand the components of a data quality plan. Make informed choices between sources data cleansing and target data cleansing.
• Design the testing strategy to ensure the functionality and performance.
• Involved in the development of Star-Schema data model along with the business analysts and Data-Modeling Team.
• Served as the lead troubleshooter to diagnose technology and functional related issues in development
• Developed the High-level design and low-level document in response to Business Requirements..
• Instantaneously attended the defects and provided solutions in quick turnaround time.
• Responsible for Production Support and Issue Resolutions using Session Logs, and Workflow Logs
• Working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Designed and developed Informatica workflows using various transformations for extracting data from source system and loading data into Staging,Data mart, ODS and DW tables.
• Created Informatica mappings and sessions for extracting data from different sources like Oracle, SQL Server, Flat files, Queue, XML Files, Messages, DB2 and written to different Targets like SQL Server, Oracle, FlatFiles, generating XML files.
• Extensively used Informatica Transformations like Filter, Router, Union, Look Up, Aggregator, Joiner, Sequence Generator, Expression, Update Strategy, Stored procedure, SQL, Normalizer and Java.
• Developing several complex mappings in Informatica a variety of PowerCenter transformations, Mapping Parameters, Mapping Variables, Mapplets & Parameter files in Mapping Designer.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Improved the performance of the mappings using various optimization techniques . Validated and fine-tuned the ETL logic in the mappings.
• Created equal partitions to ensure the smooth flow of data concurrently for better performance.
• Followed ETL development standards like naming standards and Migration procedures for Informatica code.
• Used Informatica Power Exchange for capturing recent changes on Database (CDC) for one of my project.
• Worked with Informatica Infrastructure team in setup of the project environment in Power Exchange.
• Created the Registration groups in Power Exchange and added the registrations(tables) to capture the changes. Executed the queries to see the data changes on the DB.
• Schedule of workflow by using UC4

Environment: Informatica Power Center 9.5/ Informatica Power Exchange 9.5, IDQ, ICS, Uc4, Oracle 11i/10g, PL/SQL, SQL Server 2012, IBM DB2 UDB, Flat files, IBM MQ series

Confidential

ETL Lead Developer

Responsibilities:

• Work with a team of architects and engineers to develop proof-of-concept components
• Manage a team of senior engineers and contractors to implement the key components of the product according to specifications
• ETL architecture and design of data integration from different sources-legacy, relational and 3rd party data
• Involved in the development of Star-Schema data model along with the business analysts and Data-Modeling Team.
• Served as the lead troubleshooter to diagnose technology and functional related issues in development.
• Coordinated between offshore team members and onsite business analysts.
• Developed the High-level design and low-level document in response to Business Requirements.
• Developed the technical design documents in response to Business Requirements.
• Design the testing strategy to ensure the functionality and performance.
• Involved in the development of Star-Schema data model along with the business analysts and Data-Modeling Team.
• Served as the lead troubleshooter to diagnose technology and functional related issues in development
• Responsible for Production Support and Issue Resolutions using Session Logs, and Workflow Logs
• Working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Perform design and code review
• Extensively used Informatica Transformations like Filter, Router, Union, Look Up, Aggregator, Joiner, Sequence Generator, Expression, Update Strategy, Stored procedure, SQL, Normalizer and Java.
• Developing several complex mappings in Informatica a variety of Power Center transformations, Mapping Parameters, Mapping Variables, Mapplets & Parameter files in Mapping Designer.
• Used Informatica's features to implement Type I, II changes in slowly changing dimension tables and also developed complex mappings to facilitate daily, weekly and monthly loading of data.
• Prepared high-level design document for extracting data from complex relational database tables, data conversions, transformation and loading into specific formats.
• Designed and developed the Mappings using various transformations to suit the business user requirements and business rules to load data from Oracle, SQL Server, DB2, flat file. Performed ETL code reviews and Migration of ETL Objects across repositories.
• Used Lookup Transformation to access data from tables, which are not the source for mapping.
• Used Stored Procedure Transformation for executing the stored proc to truncate the target tables before loading the data to SQL Server staging as per requirement.
• Improved the performance of the mappings using various optimization techniques . Validated and fine-tuned the ETL logic in the mappings.
• Made substantial contributions in simplifying the development and maintenance of ETL by creating re-usable objects like Mapplets and Transformation objects.
• Followed ETL development standards like naming standards and Migration procedures for Informatica code.

Environment: Informatica 9.1/ 8.1.1, Informatica Power Exchange 9.5, Oracle 10g, PL/SQL, SQL Server 2012, IBM DB2 UDB, Flat files, SQL*Loader, Confidential, Windows NT.

Confidential, Alpharetta, Ga

Team Lead/ETL Lead Developer

Responsibilities:

• Provided leadership and direction to project team by understanding business processes, gathering requirements, identifying potential usability issues, managing scope, and ensuring that an appropriate level of application quality was maintained at all times.
• Responsible for ETL design, coding, Unit test and Integration Test from source to target.
• Directed the software development efforts of 2 senior developers and 4 junior developers and provided mentoring to prepare them for taking on more responsibility at the end of the project.
• Participation: I was the Informatica Developer/Informatica Lead, responsible for developing and leading the onshore developers in designing, developing, implementing, and supporting five critical database systems that were used for data migration and conversion project
• Requirement Gathering and data Analysis of all supporting systems. Designed Informatica architecture and data flows.
• Primary Data Analyst/Data Modeler performing Business Area Analysis and logical and physical data modeling for a Data Warehouse utilizing the Bill Inmon Methodology. Also designed Data Mart application utilizing the Star Schema Dimensional Ralph Kimball methodology.
• Created conceptual, logical and physical models based on requirements gathered through interviews with the business users.
• Primary Data Modeler supporting existing Data Warehouse/Data Mart applications. Used the following tools: CA/ERWIN; Quest/TOAD; Oracle RDBMS
• Gather Business Requirements and translate into Technical Specifications for Informatica ETL team.
• Provide technical strategies and directions to five onshore Informatica developers
• Worked with DBA's to Design and Build the Staging/Target databases
• Assisted business users for Data cleansing and user acceptance testing
• Worked in Informatica for the Extraction, Transformation and Loading from various sources to the Enterprise Data warehouse and Data marts
• Developed and tested extraction, transformation, and load (ETL) processes
• Responsible in preparing Logical as well as Physical data models and document the same
• Participated in Data modeling meetings, helped to identify the relationship between tables according to the requirements
• Extensively used Informatica Client tools -- Informatica Repository Manager, Informatica Designer, Informatica Workflow Manager and Informatica Workflow Monitor.
• Developed mappings using Mapping Designer and worked with Aggregator, Lookup (connected and unconnected), Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.
• Created mappings which involved Slowly Changing Dimensions Type 1 and Type 2 to implement business logic and capturing the deleted records in the source systems
• Responsible for scheduling workflows, error checking, production support, maintenance and testing of ETL procedures using Informatica session logs.

Environment: Informatica 9.1, Erwin 7.3/9.5, Seaquest, Oracle, Vertica,, QlikView, Dial, Oracle 10g, PL/SQL, SQL Server 2012,SharePoint

Confidential

Informatica Consultant

Responsibilities:

• Design, Development, Deployment and Production Support.
• Interfaces are built and automated with Informatica ETL tool, PL/SQL
• The objective is to automate job, which runs every day by maintaining the data integrity, data correctness and record count.
• All the jobs are integrated using complex Mappings including Mapplets and Workflows using Informatica power center designer and workflow manager.
• Performance tuning has been done to increase the through put.
• Production Support has been done for ongoing issues and trouble shoot the issues to identified the bugs
• Experienced in ETL Administration responsibilities for the Enterprise Data Group using the Informatica tool
• Power Exchange Change Data Capture has been done for data updates
• Involved in change data capture (CDC) ETL process
• Informatica SCM(Folder Level migration/Object Level Migration)
• Informatica object Migration using Repository Manager
• Informatica Administration activity(by using Admin console)
• Performance tuning of informatica application
• Outage Handling(Escalation Procedure, Running metadata queries and procedures, checking database blocking, creating outage log)
• Performed Informatica code migrations, test, debug, document and maintain programs
• Experienced in informatica and administration functions such as user access accounts, roles, setting standards, etc.
• Extracted data from various sources like Teradata and relational databases (Oracle).
• Created ETL processes to extract data from Mainframe DB2 tables for loading into various oracle staging tables.
• Developed ETL into data mart for phase-II data elements from staging.
• Worked with Informatica PowerMart client tools like Source Analyzer, Warehouse Designer and Mapping designer.
• Created complex Informatica mappings to load the data mart and monitored them. The mappings involved extensive use of transformations like Aggregator, Filter, Router, Expression, Joiner, Union, Normalizer and Sequence generator.
• Configured the mappings to handle the updates to preserve the existing records using Update Strategy Transformation.
• Create detailed project outlines and application design specifications.
• Worked with production data and ensure enterprise data quality using First Logic tool set.
• Interaction with Offshore Team everyday for ongoing work, based on the Tickets/issues and to follow up with them for its progress.

Environment: Informatica 9.1.0, Informatica Power Exchange 9.1.0, Change Data Capture, Oracle 10g, DB2, Mainframe (VSAM files), Flat files PL/SQL, SQL Server, Net suite.

Confidential

Informatica Developer

Responsibilities:

• Developed and support the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Informatica and provide technical support and hands-on mentoring in the use of Informatica
• Provided support to Informatica developers including creating users, granting user/group permissions, creating folders, data sources.
• Defined and documentation ETL development standards like naming standards and Migration procedures for Informatica code.
• Involved in debugging the mappings for fixing the problems.
• Administering development, production and test environments. Migrated code from development to IT and Production.
• Created complex Informatica mappings to load the data mart and monitored them. The mappings involved extensive use of transformations like Aggregator, Filter, Router, Expression, Joiner, Sequence generator.
• Involved in data normalization and access of legacy systems using Normalizer transformation
• Design and develop mappings for loading the sales forecast data from various sources like oracle, Flat Files.
• Involved in creating the PL/SQL procedures to implement the business logic. Involved in development of database objects stored procedures, functions and triggers.
• Provided 24X7 support for Informatica production applications.

Environment: Informatica 8.6, Oracle 10g, DB2, Sybase, Confidential, PL/SQL, SQL Server.

Confidential, Charlotte, NC

Informatica Developer

Responsibilities:

• Analyzed business requirements, performed source system analysis, prepared technical design document and source to target data mapping document
• Designed the Data Mart defining Entities, Attributes and relationships between them
• Performed impact analysis for systems and database modifications
• Developed STAR Schema's including identifying FACTS and Dimensions and Designed tables.
• Created error log tables and Data recoverable option in session level.
• Extensive experience in implementation of Data Cleanup procedures, transformations, Scripts, Stored Procedures and execution of test plans for loading the data successfully into the targets
• Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements.
• Designed the Data Mart defining Entities, Attributes and relationships between them
• Performed impact analysis for systems and database modifications
• Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements.
• Involved in writing the PL/SQL procedures to load the data for implementing the complex business logic.
• Involved in the Development of Informatica mappings and mapplets and also tuned them for Optimum performance, Dependencies and Batch Design.
• Created Informatica Mappings to load data using transformations like Source Qualifier, Aggregations, Expression, Joiner, Lookup, Filters, Sequence, Router and Update Strategy.
• Performed incremental aggregation, built slowly changing dimensions using lookup and update strategy transformations, used re-usable transformations.
• Developed ETL processes to populate the Enterprise Product Orders data mart Dimensions and Fact using Informatica, Oracle SQL, Confidential .
• Monitored and scheduling in-house financial applications and ensure daily, weekly, and monthly processes successfully complete.

Environment: Informatica 9.1.0/8.6, Oracle 10g, DB2, XML, Flat files, Oracle 10g/11i, PL/SQL, SQL Server, Confidential, ERWIN 4.0

Confidential

Informatica Consultant

Responsibilities:

• Developed and support the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Informatica and provide technical support and hands-on mentoring in the use of Informatica
• Provided support to Informatica developers including creating users, granting user/group permissions, creating folders, data sources.
• Defined and documentation ETL development standards like naming standards and Migration procedures for Informatica code. Involved in debugging the mappings for fixing the problems.
• Administering development, production and test environments. Migrated code from development to IT and Production.
• Created equal partitions to ensure the smooth flow of data concurrently for better performance.
• Used Key Range, Round Robin, Hash Key and Pass Through partitioning.
• Used Mapplets, Parameters and Variables to implement Object Orientation techniques and facilitate the reusability of code.
• Created complex Informatica mappings to load the data mart and monitored them. The mappings involved extensive use of transformations like Aggregator, Filter, Router, Expression, Joiner, Sequence generator.
• Involved in data normalization and access of legacy systems using Normalizer transformation
• Design and develop mappings for loading the sales forecast data from various sources like oracle, Flat Files.
• Involved in creating the PL/SQL procedures to implement the business logic. Involved in development of database objects stored procedures, functions and triggers.
• Provided 24X7 support for Informatica production applications.

Environment: Informatica 8.6, Oracle 10g, DB2, Sybase, Confidential, PL/SQL, SQL Server.

Confidential, Charlotte, NC

Informatica Developer

Responsibilities:

• Developed complex mappings using transformations such as the Source qualifier, Aggregator, Expression, Lookups, Filter, Router, Sequence Generator, Update Strategy and Joiner
• Optimized performance by tuning the Informatica ETL code as well as SQL
• Involved in developing SQL and PL/SQL codes through various procedures, functions, and packages to implement the business logics of database in Oracle.
• Used Lookup Transformation to access data from tables, which are not the source for mapping and also used Unconnected Lookup to improve performance.
• Performance tuning of the Informatica mappings using various components like Parameter files, Variables and Dynamic Cache
• Extensively worked on Database Triggers, Stored Procedures, Functions and Database Constraints optimized for maximum performance
• Involved in Developing Unix script to load data to Teradata using FLOAD, TPUMP, MLOAD, BTEQ, etc.
• Created, optimized, reviewed, and executed Teradata SQL test queries to validate

Environment: Informatica 7.1/8.6, DataStage, XML, Flat files,, OBIEE, Oracle 9i,/10g, COBAL, Tera data V2R6, Confidential, PL/SQL, ERWIN 4.0, Windows XP & UNIX

Confidential, Louisville, KY

Informatica Developer/Admin

Responsibilities:

• Involved in interacting with Business Managers and users to gather requirements, as and when required, and analyzed the data provided by them and put these data together to do the documentations.
• Used Informatica Designer to import, edit the metadata of sources and targets.
• Designed and developed Informatica workflows using various transformations for extracting data from source system and loading aggregated data into staging and target data mart.
• Involved in development of database objects stored procedures and functions.
• Developed various Transformations, validated and fine-tuned the ETL logic coded into mappings.
• Extensively used Informatica Transformations like Union, Look Up, Aggregator, Filter, Router, Joiner, Sequence Generator, Expression, Update Strategy, Stored procedure, Normalizer and Rank.
• Made substantial contributions in simplifying the development and maintenance of ETL by creating re-usable Mapplets and Transformation objects.
• Used Lookup Transformation to access data from tables, which are not the source for mapping and also used Unconnected Lookup to improve performance.
• Used Stored Procedure Transformation for truncating the target tables before loading the data to SQL Server staging.
• Involved in partitioning of very large tables. Used Informatica Power Connect MQ Series to extract data from message queues, and load data to target data mart.
• Provided support to Informatica developers including creating users, granting user/group permissions, creating folders, data sources, connections, Exchange distribution lists and monitoring workflows.
• Involved in debugging the mappings for fixing the problems. Involved in re designing the mappings for improving the performance.
• Used list and range partitioning.- Associated with DBA in monitoring the performance related issues
• Administering development, production and test environments. Migrated code from development to Test and Production.
• Created error log tables and Data recoverable option in session level.
• Implemented Error handling strategy for trapping errors in a mapping and sending to an error table.
• Creating test plans, test cases and test data Strong testing methodology
• Develop, configure, test & maintain batch interfaces using Informatica PowerCenter
• All the jobs are integrated using complex Mappings including Mapplets and Workflows using Informatica power center designer and workflow manager. Ver 8.6
• Used Web-Based Administration Console
• Used Type 2 changes in Slowly Changing Dimensions tables .
• Used dynamic group deployments for Repository level migrations
• Developed DTS packages to extract, transform and load into the Campaign database from OLTP database.
• Involved in Developing Unix script to load data to Teradata using FLOAD, MLOAD, BTEQ, etc.
• Created, optimized, reviewed, and executed Teradata SQL test queries to validate
• Involved in SQL scripts and stored procedures in Teradata to implement business rules.
• Used Teradata Sql Assistant to query the data in the target Teradata data warehouse.

Environment: Informatica 8.1.2/8.5/8.6 , DB2, Power exchange, Change Data Capture Informatica Power Connect MQ Series, DataStage, XML, Autosys, Flat files, Cognos 8, Mainframe, Oracle 9i,/10g, COBAL, Tera data V2R6, Confidential, PL/SQL, SQL Server DTS, Confidential, ERWIN 4.0, Windows XP & UNIX

Confidential, Columbus, OH

Informatica Developer

Responsibilities:

• The data migration included identifying various databases where the information/data lay scattered, understanding the complex business rules that need to be implemented and planning the data transformation methodology.
• Used Maestro Conman (v7.0 1.13) and Composer (v7.0 1.21) for Schedule and execute workflows
• Performed quantitative analyses on the data loaded into the data warehouse on a daily, weekly, monthly and quarterly basis. Upon completion of the data warehouse refresh cycle, reconciled data with the source system. Maintained the master schedule via Maestro as to when the fact & dimension tables were populated in the data warehouse.
• Performed regression testing of Informatica mappings & workflows after an upgrade from PowerCenter v6.1 to v7.1.3
• Configured the mappings to handle the updates to preserve the existing records using Update Strategy Transformation.
• Created and configured Workflows, Worklets and Sessions to transport the data to target using Informatica Workflow Manager.
• Configured the mappings to handle the updates to preserve the existing records using Update Strategy Transformation.
• Defined Target Load Order Plan and Constraint based loading for loading data correctly into different Target Tables.
• Data mapping of EIM tables to Base tables.
• Used Teradata Sql Assistant to query the data in the target Teradata data warehouse.

Environment: Informatica 7.1.3, DB2, Sybase, Seibel 7.x, XML, Flat files, Business Objects 6.1, Microstrategy, web intelligence 2.6, Oracle 9i, Lotus Notes, SQL*Loader, Java, Maestro Conman (v7.0 1.13), Confidential, PL/SQL, SQL Server, Tera data V2R5, Oracle HRMS, People Soft, Windows NT

Confidential, Miami, FL

Informatica Developer

Responsibilities:

• Involved in Data modeling and design of data warehouse in star schema methodology with confirmed and granular dimensions and FACT tables.
• Creating and running Sessions & Batches using Work flow Manager to load the data into the Target Database.
• Using Informatica Repository Manager, maintained all the repositories of various applications, created users, user groups, security access control.
• Designed and developed Informatica Mappings, applets, Sessions, Work flows and Work lets for data loads and data cleansing.
• Involved in the development of Informatica mappings and also performed tuning for better performance.
• Tested all the applications and transported the data to the target Warehouse Oracle tables, schedule and run extraction and load process and monitor sessions and batches.
• Written Confidential for getting the data from all systems to the data warehousing system. The data was standardized to store various business units in tables.
• Analyzed the sources according to Business rules and developed Validation Database.
• Worked on Work flow Manager Tools - Task Developer, Work flow Designer & Work let Designer.
• Managed the Meta data associated with the ETL processes to populate the Data Warehouse.
• Tested all the applications and transported the data to the target Warehouse Oracle tables, schedule and run extraction and load process and monitor sessions and batches by using Informatica work flow manager.
• Identified and tracked the slowly changing dimensions on heterogeneous Sources.
• Tested the target data against source system tables by writing some QA Procedures.

Environment: Informatica 7.1.3, Business Objects 6.1,web intelligence 2.6, web intelligent SDK, ZABO, JSP, Oracle 9i,Teradata Bteq, SQL*Loader, Confidential, SUN Solaris, PL/SQL, SQL Server, Tera data V2R5, Toad.