SUMMARY

• Over 7 yearsof experience in Data warehousing and ETL process using Informatica Technology.
• Good understanding of ETL, Dimensional Data Modeling, Slowly Changing Dimensions (SCD) and Data Warehouse Concepts.
• Experience in Data Warehouse/Data Mart Development Life Cycle and performed ETL procedure to load data from different sources into data warehouse using Informatica Power Center (Repository Manager, Designer, Workflow Manager and Workflow Monitor).
• Expertise in ETL design, including process flow, data flow, data mapping, physical database designs, data models.
• Used Informatica designer tools - Source Analyzer, Target designer, Transformation Developer, Mapplet designer and Mapping designer.
• Designed and developed mappings from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, SQL transformation.
• Actively involved in Performance Tuning and Trouble Shooting.
• Thorough experience in integration of various data sources like Oracle, SQL Server, Teradata and MS Access and worked on integrating data from flat files, COBOL files and XML files.
• Involved in the SDLC (system development life cycle) of a data warehouse and responsible for designing, coding, testing, implementing, supporting the ETL processes for data warehouse solutions/data marts and implementing the reporting requirements.
• Developed Database Design, Data Modeling experience using Dimensional Data modeling, Star Schema/Snow flake schema, Fact & Dimensions tables, Physical & logical data modeling, Erwin Data Modeler with data source, Data Extracted from various sources like Oracle, Flat files, SQL Server and MS access.
• Developed the code in SQL and PL/SQL. Developed the Unix shell scripts to run SQL scripts and Informatica work flows from Unix server.
• Analytical and Technical aptitude with ability to work in a fast paced, highly flexible environment where in-depth knowledge of technology, hard work and ingenuity are highly appreciated.
• Excellent interpersonal and communication skills, technically competent and result-oriented with problem solving skills and ability to work effectively as a team member as well as independently.
• Developed effective working relationships with client team to understand support requirements, develop tactical and strategic plans to implement technology solutions and effectively manage client expectations.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.x/8.x/7.x, Informatica Power Exchangefor Salesforce.com, OLAP, OLTP

Platforms: Windows (all flavors), UNIX, AIX 6.1

Databases: Oracle 8i/9i/10g, MS SQL Server 2000/05, MS Access2003/05/07,Netezza, DB2, Kalido MDM

Languages: C, C++, VC++, SQL, PL/SQL, Shell Scripting,VB6.0,VB.Net, XML

Data Modeling: Visio, Erwin

Tools: Toad, PL/SQL Developer, SQL*Plus, Crystal Reports 9.2, Surveyor 3.2

Scheduling tools: $Universe, Tidal

PROFESSIONAL EXPERIENCE

Confidential - NY

Informatica Developer

Responsibilities:

• Design and Implement software applications and packages customized to meet client requirements.
• Review and create software programs to ensure technical accuracy & reliability of programs.
• Analyze the communications, informational, database and programming requirements of clients, plan, develop, design, test and implement appropriate information systems.
• Analyze the data in EDW and design the extracts accordingly.
• Develop and debug Informatica mappings to perform the extracts.
• Create the crosswalk using Kalido tool to integrate the data.
• Documentations for UAT and System testing.
• Load the extract data into client database product called Jiva.
• Actively participated with QA team as well as Production support team.
• Scheduled jobs in Tidal.

Environment: s used: Windows XP, Unix AIX 6.1, Oracle 11g, Informatica 8.1, Toad 10.6, PL/SQL Developer 7.1, Kalido MDM, DB2 7.1, Tidal scheduling tool, Flat files, Tortoise SVN 1.6, Surveyor 3.2

Confidential - Louisville, KY

Sr. Informatica Developer

Responsibilities:

• Design and Implement software applications and packages customized to meet client requirements.
• Review and modify software programs to ensure technical accuracy and reliability of programs.
• Analyze the communications, informational, database and programming requirements of clients, plan, develop, design, test and implement appropriate information systems.
• Participated in design discussions and exchanged the inputs.
• Design the detailed DFD diagrams as well as process diagrams.
• Developed data mapping document for each mapping.
• Review existing code and analyze the changes needed as per the requirement and develop the code in SQL accordingly.
• Design, develop, implement and debug Unix shell scripts using KORN shell to meet the client requirements.
• Develop and debug SQL, PL/SQL scripts including in ORACLE 10g databases to perform various tasks.
• Develop and debug Informatica mappings in INFORMATICA Power Center 8.6 to perform the spooling into flat files. Created mapping to generate file name dynamically and split the files based on record count and other variable fields.
• Scheduled the jobs in $Universal tool.
• Actively participated in UAT and System testing. Maintained different documentation including Defect tracking sheet.
• Co-ordinate with Offshore team members and helped them to understand the mapping documents. Also reviewed their work before passing it to client.
• Give timely project tasks updates to reporting managers also update Sharepoint.
• Worked in different support activities when needed.

Environment: s used:Windows XP, Unix, Oracle 10g, Informatica 8.6, Toad 9.7, PL/SQL Developer 7.1, MS Visio 2003, AIX 6.1, $Universe

Confidential - Pittsburgh, PA

Informatica Developer

Responsibilities:

• Analyzing the source data coming from different sources and working with business users and developers to develop the Model.
• Used Source Analyzer, Target Designer, Transformation Developer and Mapping Designer to map data sources to targets.
• Involved in designing the informatica mappings by translating the business requirements and extensively worked on informatica lookup, update and router to implement the complex rules and business logic.
• Load data using Informatica mappings to Data Warehouse (from Transient to Staging to Data warehouse).
• Designed and developed complex aggregate, join, lookup transformation rules to generate consolidated (facts/summary) data identified by dimensions using Informatica ETL tool.
• Configuration of Informatica repository to connect to database through ODBC.
• Understood the server architecture and designed the sessions for the mappings using the Task Developer and implemented those sessions.
• Used Workflow Manager for creating, validating, testing and running the sequential and concurrent batches and sessions.
• Monitored the workflows in the workflow monitor and resolved the issues in the process using the session logs.
• Worked with Shell scripts and pmcmd to interact with informatica server from command mode.
• Scheduled the ETL jobs daily, weekly and monthly based on the business requirement.
• Created reports using Crystal Reports.
• Performed Drill down, Slice and Dice operations in business objects.

Environment: s used:Informatica Power Center 8.6, Crystal Reports 9.2, Oracle 9i, Windows 2000 server, Flat files.

Confidential - Commack, NY

ETL Developer

Responsibilities:

• Involved in case study discussions and procurement of Power Exchange for Salesforce.com adapter for data access to SFDC through Informatica.
• Used Salesforce Lookup Transformation to pull data from SFDC sources during the update of data into SFDC target system.
• Migrated Registration, Sales and Customer data from source system to SFDC by creating the migration mapping and using the Power Exchange for SFDC adapter.
• Developed Unit test cases and Unit test plans to verify the data loading process.
• Created debugging sessions before the session to validate the transformations and also used existing mappings in debug mode extensively for error identification by creating break points and monitoring the debug monitor.
• Conducted performance tuning on sessions by optimizing block size, data cache size, sequence buffer length and commit interval.
• Involved in logical and physical data modeling and analyzed and designed the ETL processes.
• Implemented design improvements that provided increased scalability of the target data mart.
• Increased parallelism to allow sessions to be spread across all available processors.
• Identified all the conformed dimensions to be included in the target warehouse design and confirmed the granularity of the facts in the fact tables.
• Developed several complex Mappings, Mapplets and Reusable Transformations to facilitate one time, daily, monthly and yearly loading of data.
• Used Informatica Workflow Manager for Creating, running the Batches and Sessions and scheduling them to run at specified time.
• Involved in Performance Tuning of Informatica ETL mappings and database.
• Involved in Debugging, Troubleshooting, Testing, and Documentation of Data Warehouse.

Environment: s used:Informatica Power Center 8.6.1, Salesforce.com (SFDC), Power Exchange for Salesforce.com, Oracle 10g, SQL Server 2005, Windows, XML, Flat files.

Confidential - Atlanta, GA

Informatica Developer

Responsibilities:

• Conducted user interviews and reviewed existing reporting / analytical solutions to understand the clients specific needs.
• Prepared the Project Plan and update the status of the Project to the client with progress and s.
• Developed mappings to extract data according to the report specifications.
• Worked with complex mappings, mapplets, worklets and transformations.
• Implemented SQL/PLSQL Stored Procedures/Functions.
• Involved in fixing invalid Mappings, testing of Stored Procedures and Functions, testing of Informatica Sessions, and the Target Data using the debugger.
• Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, and sessions.
• Loaded full data in test and QA environment.
• Compared legacy data with QA data.
• Was involved in the documentation of the project.

Environment: s used:Informatica Power Center 7.x, Teradata, SQL, PL/SQL, Shell Scripting, Oracle 9i, Windows XP.

Confidential - Woonsocket, RI

ETL Developer

Responsibilities:

• Developed ETL mappings, Transformations and Loading using Informatica Power Center 8.1.1.
• Developed mappings and workflows as per business logic, quality and coding standards prescribed for the module using Informatica Power Center 8.1.1.
• Conducted performance tuning to increase performance of the mappings, sessions & workflows.
• Used PL/SQL with Informatica Power Center 8.1.1 for Oracle 10g database.
• Developed mapping document indicating the source tables, columns, data types, transformation required, bulk loading routines, business rules, target tables, columns and data types.
• Performed project management duties including analysis, design, and implementation of Extraction, Transformation and Loading methodologies.
• Resolved issues and bugs raised by QA team.
• Developed, implemented and enforced ETL best practices standards.
• Performance tuning and bottleneck resolution.
• Created and Implemented Reusable tasks like E-mail.
• Involved in Data modeling team for developing Star Schema.
• Developed application using UNIX operating system including scripting.

Environment: s used:Informatica Power Center 7.x, Mainframes, Oracle 10g, SQL Server 2005, Unix, Toad 9.5, SQL*Plus, Windows XP.

Confidential

Responsibilities:

• Installed and configured Sql Server. Designed and developed the databases.
• Configured the DTS packages to run in periodic intervals. Extensively worked with DTS to load the data from source systems.
• Maintained security and data integrity of the database.

Environment: s used:Windows 95/98, Sql, Ms Access 2003, MS Excel 2003.