SUMMARY

• 6 years of IT experience in development of various projects using Data Warehousing tools Informatica Power Center, Informatica Data Quality and Informatica MDM (Master Data Management) and Databases like Oracle, Teradata and SQL Server.
• Experience in various phases of project lifecycle such as Planning, Requirement Analysis, Design, Development, Testing and Deployment.
• Good experience in working Informatica Client Tools Informatica Power Center Repository Manager, Informatica Power Center Designer, Informatica Workflow Manager and Informatica Workflow Monitor.
• Experience in developing mappings using different transformations like expression, filter, router, joiner, aggregator, sorter, lookup, update strategy, xml generator, xml parser, web service consumer.
• Worked on design and implementation of Slowly Changing Dimensions (SCD) type1 and type2.
• Good experience in extracting data from different database sources like SQL Server, Oracle, Teradata and also with flat and csv files(excel).
• Standardized Parameter Files to define session parameters such as database connection for sources and targets and also for file path.
• Experience in working with tools like TOAD, SQL Server Management studio and SQL plus for development and customization.
• Experienced in loading data, troubleshooting, Debugging mappings, performance tuning of Informatica (Sources, Targets, Mappings and Sessions) and fine - tuned transformations to make them more efficient in terms of session performance.
• Applied the concept of Change Data Capture (CDC) and imported the source from databases using Informatica Power Center.
• Created mappings using Pushdown Optimization to achieve good performance.
• Experience in doing Unit Testing, Integration Testing, System Testing and Data Validation for Developed Informatica Mappings.
• Created shell scripts for zipping, moving and cleaning the files.
• Experience and working knowledge of Informatica MDM (Master Data Management).
• Worked as techno functional analyst for different types of Connectors (web services, database, message connectors and files), Event Management and Workflows. Well versed with business process flows.
• Experience in working with web services and API's using SOAP UI/ REST.
• Worked on Enterprise applications using SOAP webservices supporting XML.
• Created message queues and sent messages to Active MQ, IBM MQ and TIBCO platforms.
• Worked on XSLT 1.0 & 2.0 for creating XML from flat files (txt, csv, delimiter).
• Excellent Analytical, Communication skills, working in a team and ability to communicate effectively at all levels of the development process.
• Responsible for developing the code by following Informatica best practices.

TECHNICAL SKILLS

Data Warehousing ETL & Business Intelligence: Informatica Power Center 9.x, 9.5.1, 8.6.1, Informatica Data Quality 9.x, ION (Intelligent Open Network), MDM, Business Intelligence, FACT & Dimensions tables, Physical & logical data modeling

RDBMS: Teradata 13.0, Oracle 11g, MS SQL Server 2008

Database Languages: SQL, PL/SQL, SQL Plus, TOAD

Programming Languages: C, C++, UNIX Shell Scripting

Office Package: MS Office-97, 2000, 2003and 2007

Environment: HP-UNIX, Windows2000/NT, Windows XP/Vista/7

Scheduling Tools: Informatica Scheduler, TWS Maestro, Autosys

Bug Tracking Systems: Jira, HP Quality Center, HPSM

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Informatica Developer

Responsibilities:

• Worked on developing mappings for loading data from flat files into Oracle tables using Informatica Power Center 9.5.1.
• Worked on transformation Source Qualifier, Expression, Router, Filter and Update Strategy.
• Created ETL design document with the help of data requirements specification (DRS) vs database tables.
• Used debugger in identifying bugs in existing mappings by analyzing data flow and evaluating transformations.
• Performed migration requests from lower environments to higher environments of ETL code.
• Created a list of the inconsistencies in the data load on the source side so as to review and correct the issues.
• Extensively used SQL developer utility for executing SQL scripts and worked on SQL for creating database tables.
• Followed Informatica recommendations, methodologies and best practices.

Environment: Informatica Power Center 9.5.1, Oracle, SQL Developer, Flat Files, UNIX, Tidal Scheduler.

Confidential, Atlanta, GA

ETL Informatica Developer

Responsibilities:

• Involved in all phases of SDLC from requirement, design, development, testing and support for production environment.
• Gather requirements from business and end users for project that include reports, extract file and data update and built Business Requirement Document.
• Collaborate with analysts to ensure projects are developed as per user requirements
• Good understanding of data and relational databases and technical data design
• Extracted data from different sources like Oracle, Teradata, Flat files and loaded into centralized oracle database.
• Developed mappings using Mapping Designer and worked with Aggregator, Lookup (connected and unconnected), Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, XML Generator, XML Parser, Sorter and Sequence Generator transformations.
• Worked with Informatica Data Quality 9.x for analysis, data cleansing, data matching, data conversion, address doctor, exception handling, and for reporting.
• Performed the data profiling and analysis making use of Informatica Data Quality (IDQ).
• Worked with different transformations like Case Converter, Labeler, Standardizer, Address Validator, Match, Consolidation, Filter, Parser and Key Generator in Informatica Data Quality.
• Worked on Master Data Management (MDM), Hub Development, extract, transform, cleansing, loading the data onto the staging and base object tables.
• Involved in implementing the loading process of customer/partner Data Set into Informatica MDM from various source systems.
• Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.
• Develops test plans to verify logic of new or modified programs.
• Provide technical support and respond to error reports, problems or questions.

Environment: Informatica Power Center 9.6.1, Informatica MDM, Informatica Data Quality, TOAD, Oracle, Teradata, UNIX, HEAT, TWS Scheduling (Maestro).

Confidential, Atlanta, GA

ETL Informatica Consultant

Responsibilities:

• Involved in requirements gathering, designing, development, unit testing.
• Involved in developing source to target mapping document, technical design document and business relationship document.
• Developed mappings for loading data from source objects to txt files, target tables and created sessions, workflows for the mappings based on the business rules and standards.
• Developed mappings using transformations connected lookup, unconnected lookup, aggregator, router, filter, expression.
• Developed data Mappings between source systems and warehouse components.
• Created Pre/Post Session/SQL commands in sessions and mappings on the target instance.
• Imported Source and Target definitions, developed mappings, performed unit testing using Informatica Data Quality tool.
• Imported xml file from Informatica Data Quality to Informatica Power Center tool.
• Designed and developed Informatica workflows, mappings, mapplets, transformations and DDL scripts to create database object.
• Good communication skill to work with client, business users and team members.
• Strong problem solving skills and able to work independently with minimum supervision.

Environment: Informatica Power Center 9.x, Informatica Data Quality,UNIX, Oracle 11g, Flat files, SQL server, SQL Developer

Confidential, Atlanta, GA

Database/Informatica Developer

Responsibilities:

• Involved in designing technical specifications for new applications.
• Used Informatica Designer to create mappings using different transformations to move data to a source tables to target tables.
• Developed mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Source Qualifier, Expression, Lookup, aggregate, Update Strategy, and Joiner.
• Worked on mapping parameters, mapping variables and parameter files.
• Monitor the workflow using workflow monitor and also used to stop, Abort and cancel the sessions while running.
• Involved in the production support of the Informatica applications
• Experienced in working with tools like TOAD, SQL Server Management studio and SQL plus for development and customization.
• Strong verbal, written and interpersonal skills with ability to communicate effectively across organizational lines and with virtual team members.

Environment: Informatica Power Center 8.0 Work Flow Manager/Monitor, Oracle 10g/9i, SQL, PL/SQL, SQL Loader, UNIX Shell Scripting, Win 2000/NT.