SUMMARY:

• 5+ years of experience in Software Development life cycle analysis, design, development and maintenance in IT industry.
• 4 years of extensive experience in Data Warehouse applications using Informatica, Oracle, DB2, MS SQL server on Windows, IBM and UNIX platforms.
• Developed tactical and strategic plans to implement technology solutions and effectively manage client expectations.
• Developed effective working relationships with client team to understand support requirements.
• Experienced to work in Development team, Production support teams in handling critical situations to meet the deadlines for successful completion of the tasks/projects.
• Experienced in Repository Configuration/using Transformations, creating Informatica Mappings, Mapplets, Sessions, Worklets, Workflows, Processing tasks using Informatica Designer / Workflow Manager to move data from multiple source systems into targets.
• Experienced in Installation, Configuration, and Administration of Informatica Power Center 8.x/7.x/6.x.
• Experienced in Performance tuning of Informatica (sources, mappings, targets and sessions) and tuning the SQL queries.
• Experienced in integration and transforming of various data sources from Databases like MS Access, Oracle, DB2, SQL Server and formats like flat - files, COBOL files, XML, etc.
• Experienced in using ETL tools like Informatica (Power Center) Designer, Repository Manager, Administration console and Workflow Manager.
• Experience in Oracle and MS SQL Server environments using Triggers, functions, SQL, T-SQL and PL/SQL.
• Expertise in scheduling Informatica jobs using Informatica, Windows scheduler and with Unix.
• Expertise in creating Unix shell scripts.
• Experienced in working for the post development cycle and applications in Production Support.

TECHNICAL SKILLS:

ETL, DW: Informatica Power Center 9.x, 8.x, 7.x,6.x, Power Exchange 9.1, 9.5, 9.6 CDCErwin 7.2, OBIEE

Databases: Oracle 11g/10g/9.x, DB2, SQL server 2005/2000, My SQL, MS-AccessSQL Developer 2008,Teradata

Operating Systems: Windows, Linux, UNIX, WINSCP, Tidal Enterprise Scheduler, AIXSun Solaris

Programming: SQL, PL/SQL,VB, C/ C++,Perl, HTML,XML, UNIX, Web services, Java Script

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Informatica/ ETL 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.
• Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• 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.
• Developed mapping parameters and variables to support SQL override.
• Created mapplets to use them in different mappings.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Used existing ETL standards to develop these mappings.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Extensively used SQL* loader to load data from flat files to the database tables in Oracle.
• Modified existing mappings for enhancements of new business requirements.
• 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 and folder.
• 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, Informatica Power Center 9.6.1 Workflow Manager, Workflow Monitor, Informatica Power Connect / Power Exchange 9.5.1, Power Exchange 9.6.1 Data Analyzer 8.1, PL/SQL, Oracle 10g/9i, Erwin, Autosys, UNIX Linux, Toad 9.0, Mainframe, Harvest, U-deploy.

Confidential, St louis, MO

ETL Developer

Responsibilities:

• Involved in creating Detail design documentation to describe program development, logic, coding, testing, changes and corrections.
• Extensively involved in writing ETL Specifications for Development and conversion projects.
• Created shortcuts for reusable source/target definitions, Reusable Transformations, mapplets in Shared folder.
• Involved in requirement definition and analysis in support of Data Warehouse.
• Worked extensively on different types of transformations like Source qualifier, expression, Aggregator, Router, filter, update strategy, lookup, sorter, Normalizer, sequence generator, etc.
• Worked with XSD and XML files generation through ETL process.
• Defined and worked with mapping parameters and variables.
• Designed and developed transformation rules (business rules) to generate consolidated (fact/summary) data using Informatica ETL tool.
• Performed the performance evaluation of the ETL for full load cycle.
• Checked Sessions and error logs to troubleshoot problems and also used debugger for complex.
• Worked on Parameterize of all variables, connections at all levels in UNIX.
• Created test cases for unit testing and functional testing.
• Coordinated with testing team to make testing team understand Business and transformation rules being used throughout ETL process.

Environment: Informatica Power center 8.6.1, Oracle 10g, Windows XP, Unix Shell Scripts, SQL, PL/SQL, Flat files.

Confidential, Hagerstown, MD

Informatica Developer

Responsibilities:

• Used Informatica ETL to load data from flat files, which includes fixed - length as well as delimited files and SQL Server to the Data mart on Oracle database.
• Used reverse engineering in Erwin 4.x to understand the existing data model of the data warehouse.
• Worked with creating Dimensions and Fact tables for the data mart.
• Created Informatica mappings, sessions, workflows, etc., for loading fact and dimension tables for data mart presentation layer.
• Have implemented SCD (Slowly Changing Dimensions) Type I and II for data load.
• Did performance tuning of Informatica components for daily and monthly incremental loading tables.
• Developed Mapplets, reusable transformations, source and target definitions and mappings using Informatica 7.1.
• Developed mapping using parameters and variables.
• Created complex workflows, with multiple sessions, worklets with consecutive or concurrent sessions.
• Used Timer, Event Raise, Event Wait, Decisions, and Email tasks in Informatica Workflow Manager.
• Used Workflow Manager for creating validating, testing and running sequential and concurrent batches.
• Implemented source and target based partitioning for existing workflows in production to improve performance so as to cut back the running time.
• Analyzed workflow, session, event and error logs for trouble shooting Informatica ETL process.
• Worked with Informatica Debugger to debug the mappings in Informatica Designer.
• Involved in creating test plans, test cases to unit test Informatica mappings, sessions and workflows.
• Involved in migrating Informatica ETL application and Database objects through various environments such as Development, Testing, UAT and Production environments.
• Documented and presented the production/support documents for the components developed when handing-over the application to the production support team.

Environment: Informatica Power Center 8.1, Workflow Manager, Workflow Monitor, Erwin 4.0/3.5.2, TOAD 8.6.1.0, PL/SQL, Flat files, XML, Oracle 10g/9i