SUMMARY

• Over 8+ Years of extensive experience in Informatica (Source Analyzer, Mapping Designer, Mapplet Designer, Transformations Designer, Warehouse Designer, Repository Manager and Workflow Manager) and implementation of Data warehouse and DataMart using Power Center.
• Extensively worked on Relational Databases Systems like Oracle11g/10g/9i/8i, MS SQL Server, Teradata and Source files like flat files, XML files.
• Extensively worked on transformations such as Source Qualifier, Joiner, Filter, Router, Expression, Lookup, Aggregator, Sorter, Normalizer, Update Strategy, Sequence Generator and Stored Procedure transformations.
• Hands on experience in identifying and resolving performance bottlenecks in various levels like sources, mappings and sessions.
• Usage of Informatica mapping variables/parameters and session variables where necessary
• Experience in implementing update strategies, incremental loads.
• Experience in scheduling the batch jobs using workflow designer, Zena, Cron Tab and Autosys.
• Worked with Dimensional Data warehouses in Star and Snowflake Schemas, created slowly changing (SCD) Type1/2/3 dimension mappings using Ralph Kimball methodology
• Experience in Optimizing the Performance of SQL scripts and Oracle database/application tuning.
• Excellent in coding using SQL*Plus, PL/SQL, Procedures/Functions, and Triggers.
• Data Modeler with strong Conceptual and Logical Data Modeling skills has experience for requirements gathering, creating data mapping documents, writing functional specifications, queries.
• Expertise in building Enterprise Data Warehouses (EDW), Operational Data Store (ODS), Data Marts and Decision Support Systems (DSS) using Multidimensional and Dimensional modeling (Star and Snowflake schema) Concepts.
• Developed Batch Jobs using UNIX Shell scripts to automate the process of loading, pushing and pulling data from different servers.
• Expertise on Exception Handling Mappings for Data Quality, Data Cleansing and Data Validation.
• Strong Data Analysis and Data Profiling background using Informatica Analyst, Informatica Data Explorer (IDE) and Informatica Data Quality (IDQ).
• Developed UNIX scripts using PMCMD utility and scheduled ETL load using utilities like CRON tab, Maestro, Zena.
• Expertise in OLAP/OLTP System Study, Analysis and E - R Modeling, developing database Schemas like Star Schema, Snowflake Schema, Conforming Dimensions and Slowly Changing Dimensions used in relational, dimensional and multi-dimensional modeling.
• Sound knowledge with business intelligence tools Cognos and Business Objects.
• Knowledge of complete software development life cycle including Requirement Gathering, Requirement Analysis, Cost Estimation, Project Management, Design, Development, Implementation and Testing.
• Excellent communication and interpersonal skills. Ability to work effectively as a team member as well as an individual.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter9/8.x/7.x, Informatica Data Quality (IDQ) 8.5

RDBMS: Oracle11g/10g/9i, SQL Server 2000/2005/2008 , Teradata, DB2

Operating System: Windows NT/2000/XP/7

Job Scheduling Tools: Cron Tab, Tivoli, Autosys & Control M

Languages: PL/SQL, Unix Shell Scripting, Transact SQL, SQL*Plus, XML, Visual Basic 6.0/5.0

Database frontend tools: Oracle PLSQL Developer, SQL Assistant, Oracle TOAD.

PROFESSIONAL EXPERIENCE

Confidential, Plano, TX

Informatica/ETL Consultant

Responsibilities:

• Analyze the requirements and accordingly plan, develop, design, test and implement the functionality and procedure.
• Given work estimates for the Informatica Development based on requirements
• Analysis of source systems and work with business analysts to understand the requirements and translate them into initial design.
• End-to-End Development/Testing for the Data warehouse using Informatica.
• Designed and created complex source to target mapping using various transformations inclusive of but not limited to Sorter, Aggregator, Joiner, Filter, Source Qualifier, Expression and Router Transformations.
• Preparation of the various technical and functional documents consisting of Detailed Design Documentation, function test specification with use cases.
• Worked on Data Domain BRS (DD Backup Recovery System) migration Project is to deliver customer data for the Analytical use and give support for the GreenPlum data warehouse users.
• Imported Source and target tables from Sales force, and Greenplum systems. Created Mappings in mapping designer by using transformations like Source Qualifier, Expression and Lookup, Update strategy, Sequence generator and Union.
• Worked on Informatica cloud and extracted data from Sales Force source.
• Debugged mappings by creating logic that assigns a severity level to each error, and sending the error rows to error table so that they can be corrected and re-loaded into a target system.
• Worked with Informatica Data Quality 8.6.1 (IDQ) toolkit, analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ 8.6.1.
• Applied business rules using Informatica Data Quality(IDQ) tool to cleanse data.
• Extensively involved in testing the system from beginning to end to ensure the quality of the adjustments made to the source system up gradation.
• Extracted data from legacy systems and uploaded into Oracle Data warehouse.
• Assisting Data Model development team based on Informatica dev requirements.
• Perform analysis on quality and source of data to determine accuracy of information being reported.
• Working with DB Team to address concerns on load related issues.
• Coordinating Onsite/Offshore team for final delivery.

Environment: Informatica Power Center 9.1/8.6, Shell scripting, MS SQL server 2005, Oracle 10g, Quality Toad, Green Plum 4.1, PL/SQL (Stored Procedures, Triggers, Packages), WINSQL, WINSCP, SAP R3, ECC

Confidential

Informatica/ETL Consultant

Responsibilities:

• Assisted gathering business requirements and worked closely in various Applications with Business Analysts to develop Data Model
• Used most of the transformations such as Source Qualifier, Aggregator, Lookups, Filters, Sequence generator, Joiner, Expression as per the Business requirement.
• Developed procedures to populate the customer data warehouse with transaction data, cycle and monthly summary data, and historical data.
• Designed the data ware houses using Ralph Kimball methodologies.
• Extensively used debugger to troubleshoot logical errors.
• Requirement gatherings with the Internal Users and sending requirements to our Source System Vendor.
• Used Teradata SQL Assistant to run the SQL queries and validate the data.
• Used Teradata and Oracle as sources for building the datamarts to analyze the business individually.
• Worked on Data Quality to proactively monitor and cleanse the data for allapplications and maintain its cleanstate .
• Created source, target, transformations, sessions, batches and defined schedules for the sessions.
• Used Shortcuts (Global/Local) to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Used HTTP transformation to connect to Web services from Informatica Power Center. Also used SOAP in one of my requirements.
• Responsible for creating Workflows and sessions using Informatica workflow manager and monitor the workflow run and statistic properties on Informatica Workflow Monitor.
• Involved in Unit testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.
• Working in Agile methodologies and participating daily scrum meetings for providing status reports to team regarding project status, task and issues

Environment: Informatica Power Center 8.1, Teradata, Oracle10g, SQL Loader, IDQ, PL/SQL, MS Access, Windows XP/2000/NT, TOAD 7.0 and Erwin 4.0

Confidential -Maryland

Informatica/ETL Consultant

Responsibilities:

• Assisted gathering business requirements and worked closely with Business Analysts to develop Data Model, ETL procedures to design Data Warehouse.
• Experience in writing functional specifications, translating business requirements to technical specifications, created/maintained/modified data base design document with detailed description of logical entities and physical tables
• Designed and developed schema model for target database using Erwin Data modeling.
• Involved in pre and post session migration planning for optimizing data load performance.
• Setup the data mart on Oracle database by running the SQL scripts from ERWIN designer.
• Used packages to load the base tables in the Oracle database from the flat file sources and XML sources.
• Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.
• Created Fast Load, Multi Load, and T Pump and BTEQ scripts to load data into Teradata.
• Used SQL tools like TOAD to run SQL queries and validate the data.
• Used various Oracle Index techniques like B*tree, bitmap index to improve the query performance and created scripts to update the table statistics for better explain plan.
• Wrote stored procedures and triggers in Oracle for managing consistency and referential integrity across data mart.
• Tuning the Mappings for Optimum Performance, Dependencies and Batch Design.
• Schedule and Run Extraction and Load process and monitor sessions using Informatica Workflow Manager.
• Involved in identifying bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing the bugs so that they conform to the business needs.
• Working experience using Push Down Optimization.
• Involved in analyzing, resolving and providing temporary fix for the Data issues Also he had to interact with the business users to intimate and do the recovery steps if there is any problem in the process
• Deployment to various servers & Migration activities.

Environment: Informatica Power Center 8.1, Oracle10g, SQL Loader, PL/SQL, MS Access, Windows XP/2000/NT, TOAD 7.0 and Erwin 4.0

Confidential

Informatica/ETL Consultant

Responsibilities:

• Studied and understood the warehouses, sources, and functionally analyzed the application domains, involved in various knowledge transfers from dependent teams understand the business activities and application programs and document the understandings for internal team referencing.
• Interacted with functional/end users to gather requirements of core reporting system to understand exceptional features users expecting with ETL and Reporting system and also to successfully implement business logic.
• Study of detailed requirement of end users of system & their expectations from Applications
• Involved in the data analysis for source and target systems and good understanding of Data Warehousing concepts, staging tables, Dimensions, Facts and Star Schema, Snowflake Schema.
• Involved in developing optimized code using PL/SQL for Server related Packages to centralize the application through procedures, functions and packages.
• Extensively used Debugger to modify data and applying Break Points while Session is running.
• Different database triggers containing PL/SQL were created and stored in the database and fired off when contents of database were changed.
• Created Test cases for Unit Test, System Integration Test and UAT to check the data.
• Tuned Performance of Informatica session for large Data Files by increasing block size, data cache size, Sequence buffer length and target based commit interval.
• Integration of various data sources like Oracle, SQL Server, Identify the flow of information, analyzing the existing systems, evaluating alternatives and choosing the "most appropriate" alternative.
• Developed and tested all the Informatica mappings, sessions and workflows - involving several Tasks.

Environment: Informatica 8.x, Oracle 8i, SQL, PL/SQL, SQL*Loader, TOAD, Windows 2000, MS Visio, UNIX Solaris/AIX, WINSCP

Confidential

Informatica/ETL Consultant

Responsibilities:

• Involved in design, development and maintenance of database for Data warehouse project.
• Involved in Business Users Meetings to understand their requirements.
• Involved with business to understand Healthcare standards like HIPAA, HL7 and many other rules
• Designed, Developed and Supported Extraction, Transformation and Load Process (ETL) for data migration with Informatica 8.x
• Identified the gaps in HLD provided by the customer and proposed the minimum required inputs from the client to start the low level design and database design.
• Developed various mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.
• Created complex mappings which involved Slowly Changing Dimensions, implementation of Business Logic and capturing the deleted records in the source systems.
• Worked extensively with the connected lookup Transformations using dynamic cache.
• Worked with complex mappings having an average of 15 transformations.
• Created and scheduled Sessions, Jobs based on demand, run on time and run only once.
• Monitored Workflows and Sessions using Workflow Monitor.
• Performed Unit testing, Integration testing and System testing of Informatica mappings
• Coded PL/SQL scripts.
• Wrote UNIX scripts for the business needs.
• Coded Unix Scripts to capture data from different relational systems to flat files to use them as source file for ETL process
• Created Universes and generated reports on using Star Schema.

Environment: Informatica Power Center 8.1, Oracle10g, Teradata, Cron Tab, Tidal, MS Visio

Confidential

Informatica/ETL Consultant

Responsibilities:

• Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user training and support for production environment.
• Create new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
• Develop the mappings using needed Transformations in Informatica tool according to technical specifications
• Created complex mappings that involved implementation of Business Logic to load data in to staging area.
• Used Informatica reusability at various levels of development.
• Applied slice-and-dice, drill-up and drill-down techniques in master detail reports for multi-dimensional analysis of retrieved data.
• Involved in unit testing and system testing and preparing Unit Test Plan (UTP) and System Test Plan (STP) documents.
• Developed mappings/sessions using Informatica Power Center 8.6 for data loading.
• Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union.
• Developed Workflows using task developer, Worklet designer and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries.
• Building Reports according to user Requirement.
• Extracted data from Oracle and SQL Server for data warehousing.

Environment: Power Center 8.6, UNIX scripting, MS SQL server 2005