SUMMARY

• Over 7 years of IT experience in Data warehousing using the Informatica ETL tool, possessing superior analytical skills and the ability to meet deadlines. Enjoy sharing technical expertise and coordinating projects with team members.
• Experience in Requirement Gathering and Analysis, System Design and Development phases of Software Development Life Cycle (SDLC), Agile and waterfall methodologies.
• 5+years of strong experience in Data Warehousing experience using Informatica Power Center/Power Mart with various versions 9.x/8.x/7.x.
• Extensive experience in using Informatica for implementation of ETL methodology in Data Extraction, Transformation and Loading.
• Extensively worked on Informatica Tools - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplets Designer, Transformation Developer, Workflow Manager and Workflow Monitor.
• Experienced in designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy etc.
• Proficient in using Informatica Workflow Manager, Workflow Monitor, Pmcmd (Informatica command line utility) to create, schedule and control Workflows, tasks and Sessions.
• Experience in integration of various data sources like Oracle, SQL Server, Teradata, Flat Files, XML files, DB2 into the data warehouse.
• Experienced in troubleshooting Teradata scripts, fixing bugs and addressing production issues.
• Good experience in Data Cleansing, Data profiling and Data Analysis.
• Hands on experience with managing Slowly Changing Dimensions (SCD) such as Type 1,2,3 and Cleansing,Profiling,Conversion,Aggregation, and Performance Optimization and setting up Change Data Capture(CDC) mechanisms.
• Strong working experience in Data Warehousing concepts, Star Schema and Snowflake Schema methodologies.
• Demonstrated proficiency in improving Re-usability, automation of data loads, Performance Tuning in Informatica by identifying Bottlenecks in Source, Targets or database level and De-bugging/Rectification of data load errors.
• Good knowledge and understanding of Scheduling tool Autosys, ESP.
• Worked on logical and physical database designing using ERWIN.
• Experienced in coding using SQL.
• Experience in UNIX Shell Scripting on UNIX & Linux platform.
• Maintain outstanding relationship with Business Analysts and Business Users to identify information needs as per business requirements.
• Excellent Team player with strong Analytical and Logical skills, Good communications skills and ability to provide 24x7 application support.

TECHNICAL SKILLS

Data Warehousing: Informatica Power Center 9.x/8.x/7.x(Designer, Workflow Manager, Workflow Monitor, Repository Manager), OLAP, OLTP, ETL, Autosys, Data Analysis, Data Cleansing, Data Profiling

Data Modeling: Dimensional Data Modeling- FACT & Dimensions tables, Logical & Physical data modeling, Star & Snowflake schema, Relational, dimensional and multidimensional modeling and De-normalization techniques, Erwin

Databases: Oracle 11g/10g/9i, SQL,PL/SQL,MS SQL Server,DB2, Teradata 14.10/13.10.

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

Utilities and Tools: SQL Loader, SQL Developer, TOAD, Teradata SQL Assistant.

Version Control Tools: PVCS, VSS

Environment: UNIX, LINUX, Windows

Others: Microsoft Word, Microsoft Excel

PROFESSIONAL EXPERIENCE

Confidential, Durham, NC

Sr.ETL Informatica Developer

Responsibilities:

• Responsible for Business Analysis and Requirements Collection.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Created mapping documents to outline data flow from sources to targets.
• Extracted the data from the Oracle, flat files, Teradata, COBOL and other RDBMS databases into staging area and populated onto Data warehouse.
• Extensively used SQL* loader to load data from flat files to the database tables in Oracle.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Developed mapping parameters and variables to support SQL override.
• Analyzed the query performance using SQL Assistant (Query man) front-end tools to issue SQL commands matching the business requirements to Teradata RDBMS.
• Created Mapplets to use them in different mappings.
• Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Used existing ETL standards to develop these mappings.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Worked on different Tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, work lets, Assignment, Timer and scheduling of the workflow.
• Modified existing mappings for enhancements of new business requirements.
• Created Autosys Scripts for installing Autosys Jobs for daily scheduling & alerting scenarios.
• Used Debugger to test the mappings and fixed the bugs.
• Wrote UNIX shell Scripts&PMCMD commands for FTP of files from remote server and backup of repository z
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Prepared migration document to move the mappings from development to testing and then to production repositories.

Environment: Informatica Power Center 9.5.1, Workflow Manager, Workflow Monitor, Informatica Power Connect / Power Exchange, Data Analyzer, PL/SQL, SQL Developer, UNIX, Oracle 11g, Erwin, Autosys, SQL Server, Sybase, Teradata 14.10, Teradata SQL Assistant.

Confidential, Washington DC

Sr.ETL Informatica Developer

Responsibilities:

• Used Informatica Manager for managing Informatica repository define custom routines & transforms, import and export items between different Informatica systems or exchange metadata with other data warehousing tools
• Dealt extensively with the data from Oracle 11g, SQL Server.
• Used Informatica Monitor and the runtime engine to schedule running the server jobs, monitoring scheduling and validating its components
• Designed and populated dimensional models both star and snowflake schemas for a data warehouse and Data marts.
• Configured File for Parallel extender as per number of processors available to process the data by using Informatica Manager
• Used Informatica Designer for developing various jobs to extract, cleansing, transforming, integrating and loading data into Data warehouse
• Generating of unique keys for composite attributes while loading the data into Data warehouse.
• Develop and debug complex SQL's, UNIX scripts and stored procedures to resolve production issues and in the processing of new source feeds.
• Extensively used various Transformations like Source Qualifier, Aggregator, Filter, Joiner, Sorter, Lookup, Update Strategy, Router, Sequence Generator etc. and used transformation language like transformation expression, constants, system variables, data format strings etc.
• Analyzed the session logs, bad files and error tables for Troubleshooting mappings and sessions
• Performance tuning of mappings, transformations and sessions to optimize session performance.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Participates in bug reviews to see that quality criteria are upheld.
• Suggests designs that facilitate testing and looks for opportunities to automate.
• Ensures that all bugs are entered with adequate information to assist developers in reducing the problem.
• Used Informatica Administrator to assign privileges to users or user groups to control purging of Repository and Informatica client applications or jobs they run, move, and rename projects
• Using ERWIN 4.5 as leading data modeling tool for Logical and physical data model
• Developed postscripts and pre scripts for downloading and uploading data as before and after job routines using shell and SQL
• Used Constraint Based loading & target load ordering to load data into the tables with maintaining the PK-FK relation in the same mapping.
• Involved in the creation of Oracle Tables, Views, Materialized views and PL/SQL stored procedures and functions.
• Used Debugger to create break points, run the mapping till the break points, find out the cause/error and modify the data and debug the mapping in the transformations.
• Expertise in Performance Tuning by identifying the Bottlenecks at sources, targets, databases, Power Center transformations and sessions.
• Developed UNIX/Linux Shell scripts for the command tasks in the workflow and Stored Procedures for partitions of the tables.

Environment: Oracle 10g/11g, Informatica Power Center 8.6.1/9.1.1, Power Exchange, UNIX (bash), Control M, Toad, SQL, PL/SQL, Flat files, Unix Shell Scripting and Business objects, Windows.

Confidential, NYC, NY

ETL Developer/Analyst

Responsibilities:

• Extracted data from Sybase and Oracle tables.
• Extensively used SQL* loader to load data from flat files to the database tables in Oracle.
• Involved in detail design and development of mappings using Informatica power center.
• Created versions for ETL mappings and maintained the backup of the artifacts in clear case.
• Implemented various Transformations like Joiner, Aggregate, Expression, Lookup, Filter, Update Strategy, Stored Procedures, and Router in etl mappings.
• Created and Monitored Sessions and various other Tasks such as Event-Raise Task, Event-Wait Task, Decision Task, Command Task etc. in Informatica workflows.
• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Modified existing mappings for enhancements of new business requirements.
• Tuning the Mappings for Optimum Performance, Dependencies and Batch Design.
• Created Unit test plans and System Integration test plans to validate requirements.
• Scheduled the tasks using the Workflow Manager and monitored the loads using workflow monitor. Used Debugger to test the mappings and fixed the bugs.
• Created UNIX Shell scripts to abort the job upon critical warnings and to transfer files between servers.
• Wrote UNIX shell Scripts & PMCMD commands for FTP of files from remote server and backup of repository’s
• Extensively involved with end user training for long term support.
• Logical database design, physical database design, data modeling with Erwin/Model mart.
• Created design document and test case documents as part of project implementation.
• Worked on migrating Informatica mappings between environments for development, testing and production implementation purposes.
• Provided infant care support for project once the project is implemented.

Environment: Informatica Power Center 8.6.1 (Power Center Designer, Workflow Manager, Workflow Monitor, Repository Manager), Oracle 11g,Power Exchange, PL/SQL, SQL Developer, Testing, UNIX, XML, Windows, MS Office.

Confidential, Herndon, VA

ETL Informatica Developer

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Assisted in Creating Logical and Physical Data Modeling.
• Creating the design and technical specifications for the ETL process of the project.
• 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 Mappingsand Mapplets using corresponding Sources, Targets and Transformations
• 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.
• Effectively worked in Informatica version based environment and used deployment groups to migrate the objects.
• Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations
• Reviewed and analyzed functional requirements, mapping documents, problem solving and trouble shooting.
• Performed unit testing at various levels of the ETL and actively involved in team code reviews.
• Identified problems in existing production data and developed one time scripts to correct them.
• Fixed the invalid mappings and troubleshoot the technical problems of the database.

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

Confidential

ETL Informatica Developer

Responsibilities:

• Analyzed source systems, business requirements and identified business rules for building the data warehouse.
• Developed Technical Specifications of the ETL process flow.
• Designed and developed Informatica Mappings, Workflows to load the data into Oracle DB, SQL server.
• Used Informatica workflow manager, monitor, and repository manager to execute and monitor workflows and assign User Privileges.
• Extensively worked with Aggregator, Sorter, Router, Filter, Join, Expression, Lookup and Update Strategy, Sequence generator transformations.
• Used Debugger to test the mapping and fixed the bugs.
• Performingmanualtesting by performing the operations mentioned in the design steps. Compared the expected results with the actual outcome and recorded the results.
• Involved in Performance Tuning of Sessions and Mappings.
• Used the Workflow manager to create workflows and tasks, and also created Worklets.
• Involved in Production Support in resolving issues and bugs.
• Worked on SQL stored procedures, functions and packages in Oracle.
• Wrote Test Cases for ETL to compare Source and Target database systems.

Environment: Informatica Power Center 7.1, Oracle 10g, SQL, UNIX, SQL Plus, Testing, MS Access, Windows XP.