SUMMARY

• Having 7 years of experience in IT Industry with emphasis on Data Warehousing tools using industry accepted methodologies and procedures.
• Extensively worked on ETL for over 6 years using Informatica.
• Technical expertise in ETL methodologies, Informatica 6.x/7.x/8.x - Power Center, Power Mart, Client tools - Mapping Designer, Workflow Manager/Monitor and Server tools - Informatica Server Manager, Repository Server Manager, and Power Exchange.
• Expertise in Data Warehousing, Data Migration, Data Modeling, and Data Cleansing.
• Worked on Data Integration projects.
• Directly responsible for the Extraction, Transformation & Loading of data from multiple sources into Data Warehouse.
• Expertise in source to target mapping in Enterprise and Corporate Data Warehouse environments.
• Designed and developed complex mappings, from varied transformation logic like connected and unconnected lookups, source qualifier, router, filter, union, sorter, expression, aggregator, sequence generator, transaction control, joiner and update strategy and more.
• Involved in designing ETL data load strategy for SCD type1, 2 Dimensions and Fact tables, ETL reject handling, ETL restart recovery logic.
• Very strong knowledge in Relational Databases (RDBMS), Data modeling and building Data Warehouse, Data Marts using Star Schema and Snow Flake Schema.
• Extensive database experience and highly skilled in SQL in Oracle, MS SQL Server, DB2, Teradata, Sybase, Mainframe Files, Flat Files, MS Access.
• Skilled in SQL, PL/SQL, SQL*Plus, TOAD, SQL Assistant.
• Excellent communication, interpersonal, quick learner and analytical skills.
• Excellent analytical, problem solving, and communication skills, with ability to interact with individuals at all levels.

TECHNICAL SKILLS

Operating Systems: MS-DOS, UNIX, MS Windows 9x/NT/2000/XP.

ETL Tools: Informatica Power Center 6.x/7.x/8.x, Power Exchange 5.x

Languages: C, C++, SQL, PL/SQL, HTML, DHTML, Java (JSP, JDBC), Visual Basic, UNIX Shell Scripting.

Databases: Oracle 8i/9i/10g, DB2, Teradata, MS SQL Server, Sybase, Flat Files, IBM MainFrame Systems.

Querying Tools: TOAD 7.x, SQL Assistant 7.x.

Packages: MS Office (MS Access, MS Excel, MS PowerPoint, MS Word).

Source Control Package: MS Visual SourceSafe.

PROFESSIONAL EXPERIENCE

Confidential, NJ

Senior Informatica developer

Responsibilities:

• Used Informatica Power Center to create mappings for extracting data from various systems. (DB2, oracle and Flat files)
• Worked extensively on moving data from one environment to another.
• Used Mapping Designer, Workflow Manager, Workflow Monitor extensively to create, execute and monitor a mapping’s run process.
• Worked extensively with various transformations like expression, filter, joiner, aggregator, lookup, rank, sequence generator, sorter, etc.
• Worked extensively on performance tuning of programs, ETL procedures and processes.
• Used SQL tools like TOAD and SQL Assistant to run SQL queries and validate the data loads.
• Wrote UNIX scripts to ensure the smooth/correct execution of a test, apart from concatenation and deletion of 2 or more target files, using the Post-Session or Pre-Session functionalities.
• Used MS Visual SourceSafe to save mappings as XML files.
• Helped the team by working on Production Support. Was responsible for fixing failed tests in the Production Server.
• Trained a team on Production Support and other necessary documentation.
• Helped systems analysts to create requests/tests by early investigation of data.
• Helped other programmers to correctly and efficiently design their mappings/programs.
• Used SharePoint to upload files and manage them.
• Worked on information that is secure, accurate, consistent, organized, and timely as in an enterprise or corporate data warehouse.

Environment: Informatica 7.1.5/8.6, Oracle 10g, DB2, UNIX, Windows NT, TOAD 7.3.

Confidential, New York, NY

Informatica developer

Responsibilities:

• Designed & executed SQL, PL/SQL, stored procedures, triggers according to need of database environment.
• Deployed Informatica tools - Power Center, Workflow Manager and Workflow Monitor.
• Utilized the Mapping Designer tools - Source Analyzer and Warehouse Designer to create and/or import the source and target database schemas.
• Used the Mapping Designer to map the sources to the target and to create the various transformations.
• Used Source Analyzer to work on SQL override for performance tuning.
• Worked extensively on different types of transformations like expression, filter, aggregator, rank, lookup, stored procedure, sequence generator, and joiner etc.
• Used Workflow Manager to create workflows and sessions to run mappings and load data into tables, warehouses or just folders in the form of reusable files.
• Extensively used Informatica to load data from Oracle and flat files to Oracle.
• Worked on various kinds of data sources while making them extremely consistent and secure for the enterprise data warehouse.
• Configured & managed Informatica Server Manager to create database connections, sessions, and batches to run the mappings.
• Created and executed UNIX shell scripts and PL/SQL procedures, pre-session and post-session scripts to ensure timely, accurate processing and ensure balancing of job runs.
• Used Erwin to visualize and organize data for future managing and programming of the same.
• Supported users with word processing files, spreadsheets, and presentation software.

Environment: Informatica 7.2, Oracle 10g, Erwin 4.1, PL/SQL, SQL Server, UNIX, Windows NT.

Confidential, Columbus, IN

Informatica Consultant

Responsibilities:

• Used Informatica Mapping Designer to create mappings to source from and load into Oracle databases and Flat Files.
• Used Source Qualifier to develop SQL code for performance tuning, as part of tuning mappings built earlier. It involved converting a mapping (with many transformations) into a smaller one that has a SQL code which integrates all the transformations.
• Worked extensively on different types of transformations like expression, filter, aggregator, lookup, stored procedure, sequence generator, and joiner etc.
• Used Workflow Manager to create workflows and sessions to run mappings and load data into tables, warehouses or just folders in the form of reusable files.
• Used Informatica to load data from Oracle and Flat Files to Oracle.
• Worked on various kinds of data sources while making them extremely consistent and secure for the enterprise data warehouse.
• Configured & managed Informatica Server Manager to create database connections, sessions, and batches to run the mappings.
• Created and executed UNIX shell scripts and PL/SQL procedures, pre-session and post-session scripts to ensure timely, accurate processing and ensure balancing of job runs.
• Used Erwin to visualize and organize data for future managing and programming of the same.
• Supported users with word processing files, spreadsheets, and presentation software.

Environment: Informatica 7.1.4, Oracle 9i, Erwin 3.0, PL/SQL, SQL Server, UNIX, Windows NT, MS Excel.

Confidential, Chicago, IL

Data Warehouse Consultant

Responsibilities:

• Designed and developed ETL code to deal with Oracle and flat file sources for transactions such as voice, message (SMS and MMS), and data usage. Also designed and created code for marketing, advertising, and campaigning strategies for the client.
• Worked extensively with various transformations like expression, filter, joiner, aggregator, lookup, sequence generator, sorter, etc.
• Worked directly with the end business users, analysts, DBAs, architects to correctly understand the requirements to deliver the end result before the actual due date.
• Created Detailed Design Documents for the business users to understand the development process. Used MS Visio to create diagrams for use in such documents.
• Built Unit Test Plans and executed them using an existing Perl Framework. This was to ensure correct and error-free execution of code in all environments.
• Created DDLs and used TOAD to create relational sources and targets, for use in Informatica.
• Made changes to table models as and when required by the business.
• Made changes to existing code to accommodate new requirements.
• Used Informatica to build and handle code. Incorporated all changes as and when required.
• Used PuTTY to connect to UNIX/AIX systems, and to make changes to files using the vi editor.
• Created and/or made changes to parameter (prm) files for use in code execution.
• Fixed defects, whenever assigned, and used IBM Rational ClearQuest to close those defects.
• Used WinSCP to securely move files to/from various locations.
• Helped other programmers to correctly and efficiently design their mappings/programs.
• Used SharePoint to upload files and manage them.

Environment: Informatica 8.6.1, Oracle 11g, Flat Files, TOAD 10.1.1.8, AIX 6.1, UNIX, Windows XP, PuTTY 0.60, Microsoft Visio 2003, Microsoft SharePoint, Win SCP 4.2.9, IBM Rational ClearQuest 7.1.2.03.

Confidential

Informatica Developer

Responsibilities:

• Involved in design & development of operational data source and data marts in Oracle
• Reviewed source data and recommend data acquisition and transformation strategy
• Involved in conceptual, logical and physical data modelling and used star schema in designing the data warehouse
• Designed ETL process using Informatica Designer to load the data from various source databases and flat files to target data warehouse in Oracle
• Used Power mart Workflow Manager to design sessions,
• Created parameter based mappings, Router and lookup transformations
• Created mapplets to reuse the transformation in several mappings
• Used Power mart Workflow Monitor to monitor the workflows
• Optimized mappings using transformation features like Aggregator, filter, Joiner, Expression, Lookups
• Created daily and weekly workflows and scheduled to run based on business needs
• Created Daily/weekly ETL process which maintained 100GB of data in target database
• Involved in Unit Testing, Integration Testing, and System Testing

Environment: Informatica Power Center 5.0, Oracle 9i, Cognos 6.5 (Impromptu), ERwin 3.5, Sun Solaris 7, Shell scripting, Windows 2000.

Confidential

Informatica Developer

Responsibilities:

• Involved in analysis and development of the Data Warehouse.
• Translation of Business Processes into data mappings for building the Data Warehouse
• Designed the logical and physical models of the database including referential integrities, keys, capacity planning and object creation as per business requirements
• Designed and developed the environment for the Staging area, loading the Staging area with data from multiple sources such as flat files and RDBMS tables
• Developed Staging jobs which formatted, cleansed, aggregated and transformed data from various sources into the Data Warehouse
• Implemented Aggregate, Filter, Join, Expression, Lookup, Update Strategy, and Stored Procedure Transformations
• Documented the procedures for interfacing data from all source systems to the Data Warehousing system
• Designed and DevelopedStored procedures and Functions, Database Triggers using PL/SQL
• Developed Triggers, Views, Sequences, Indexes using SQL and PL/SQL.
• Used SQL Loader to load data to Database.
• Developed scripts using SQL and PL/SQL.
• Created mappings with PL/SQL procedures to build business rules to load data
• Extensively used ETL to load data from different databases and flat files to Oracle
• Created batch sessions using Server Manager to load the data into the target database
• Involved in the Data Quality Analysis

Environment: Informatica Power center 7.1.1, Erwin 3.5, SQL, PL/SQL, Oracle 9i, Flat files, TOAD.