SUMMARY

• Eight years of solid ETL (Extract Transform Load) data integration experience using Informatica Powercenter 9.x/8.x/7.x/6.x, Repository Manager, Designer, Work Flow Manager, Work Flow Monitor, Source Analyzer, Warehouse Developer, Transformation Developer, Mapplet Designer, Mapping Designer, Task Developer, Worklet Developer, Workflow Designer, Shortcuts and Informatica Power Exchange.
• Skillful in mapping client's requirements, conducting business analysis, translation of complex business concepts/strategies into deliverable product requirements, custom designing solutions for applications and troubleshooting for complex application related problems.
• Experience in Dimensional and Relational Data Model using Star Schema/Snowflake modeling, Fact and Dimension tables, and Physical and Logical data modeling.
• Data modeling experience using Ralph - Kimball methodology and Bill-Inmon methodology, implementing Star Schema, Snow Flake Schema, and Extended Star Schema
• Extensive knowledge on tools like Informatica 8.x/9.x, SQL, TOAD and UNIX,WINSCP, EDIT PLUS, Tivoli Workload Scheduler.
• Created reusable ETL components and maintenance of ETL mappings. Performance Tuning, Performance Testing and Optimization of existing processes.
• Experience in Data Analysis, Data Extraction, Transformation and loading processes
• Experience in maintaining existing code and fix bugs whenever needed.
• Perform unit testing at various levels of the ETL, code reviews and prepared execution result documents based on unit testing.
• Implemented Slowly Changing dimensions Type 1, Type 2, and Type 3 methodology for accessing the full history of accounts and transaction information
• Good knowledge in identifying performance bottlenecks and tuning the Informatica Load for better performance and efficiency.
• Expert in Informatica Data Quality (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ.
• Demonstrated ability to visualize complex data structures, inventory information assets and established enterprise-wide standards for managing data.
• Vast experience in Designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy etc
• Experience on Data Analysis, User Requirement Gathering, User Requirement Analysis, Gap Analysis, Data Cleansing, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis
• Prepare regular status report and submit to project manager.
• Excellent team player with strong problem solving skills and positive attitude.
• Excellent interpersonal and communication skills and experienced in working with senior level managers, business people and developers across multiple disciplines.

TECHNICAL SKILLS

DATAWAREHOUSING ETL: Informatica Power Center 9.x, 8.x, 7.x, 6.x Informatica Power Exchange 8.x, IDQ, Data Mart, FACT & Dimensions tables, Physical & logical data modeling, Informatica Power Center, Data Management Express (DM Express).

DATABASES: Oracle 11g/10g/9i/8i, Teradata, SQL Server, DB2

PROGRAMMING LANGUAGES: C, C++, UNIX Shell Scripting.

ENVIRONMENT: UNIX, Windows2000/NT, Windows XP/Vista/7.

OFFICE PACKAGE: Ms Office-97, 2000, 2003 and 2007.

PROFESSIONAL EXPERIENCE

Confidential, Irving

Sr.Informatica Developer

Responsibilities:

• Production Support - Identify issues, review errors, approve resolution, and advise of potential downstream impacts.
• Validated the current production data, existing data and the programming logic involved.
• Analyzed the business requirements and framing the business logic for the ETL process.
• 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.
• Identified and eliminated duplicates in datasets thorough IDQ 8.6.1 components of Edit Distance, Jaro Distance and Mixed Field matcher, It enables the creation of a single view of customers, help control costs associated with mailing lists by preventing multiple pieces of mail.
• Informatica Data Quality (IDQ 8.6.1) is the tool used here for data quality measurement.
• Experience translating business problems into actionable data quality initiatives.
• Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Created workflows and tested mappings and workflows in development, test and Production environment.
• Setting up batches and sessions to schedule the loads at required frequency using Power center workflow manager.
• Performance tuning of the Informatica mappings using various components like Parameter files, variables and dynamic Cache.
• Generated completion messages and status reports using workflow manager.
• Worked on Dimension tables as well as Fact tables, developed mappings and loaded data into the relational database.
• Performed data manipulations using various Informatica Transformations like Joiner, Expression, Lookup, Aggregate, Filter, Update Strategy, and Sequence Generator etc.
• Converted the data mart from Logical design to Physical design, defined data types, Constraints, Indexes, generated Schema in the Database, created Automated scripts, defined storage parameters for the objects in the Database.
• Used BTEQ and SQL Assistant front-end tools to issue SQL commands matching the business
• Requirements to Teradata RDBMS.
• Developed MLoad scripts and shell scripts to move data from source systems to staging and from staging to Data warehouse in batch processing mode
• Created stored procedures, scripts for the Bulk application, tested them on the testservers and moved them to production.
• Involved in loading of data into Teradata from legacy systems and flat files using complex
• Multiload, BTEQ, created & modified databases, performed capacity planning, allocated space, granted rights for all objects within databases, etc
• Creation of Transformations like Lookup, Joiner, Rank and Source Qualifier Transformations in the Informatica Designer.
• Created and Developed re-usable transformations, mappings and mapplets confirming to the business rules. Used Debugger to test the mappings and fix the bugs.
• Coordinated with offshore site in developing and deploying mappings.
• Created database tables, indexes in Oracle Database by implementing various business rules using appropriate constraints and database triggers.

Environment: Informatica Power Center 9.5.1/9.1, IDQ 8.6.1,Workflow Manager, Windows Server 2003, Teradata, Oracle 9i/10g, SQL server 2005/2000, XML, Flat Files, Windows NT,SAS-BI

Confidential, Atlanta

Sr. Informatica Developer

Responsibilities:

• Involved in all phases of SDLC from requirement, design, development, testing and support for production environment.
• Extensively used Informatica Client tools - Informatica Repository Manager, Informatica Designer, Informatica Workflow Manager and Informatica Workflow Monitor.
• Analyzed and communicated ETL development issues, including problems with data integrity, data design, and functional and technical issues.
• Experience with Informatica Data Quality (IDQ) Analyst
• Experience in Informatica Data Quality standards, guidelines and best practices.
• Was Responsible to monitor the scheduled jobs or run the workflows and scripts which needs to run the day.
• Responsible If any issues or job fails, Immediately check the logs and contact with support team if needed. Frequently have to intimate all responding people.
• Experience in defining and deploying data quality programs and tools on enterprise data quality project.
• Performed data quality analysis, gathered information to determine data sources, data targets, data definitions, data relationships, and documented business rules.
• Developed mappings using Mapping Designer and worked with Aggregator, Lookup (connected and unconnected), Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.
• Created mappings which involved Slowly Changing Dimensions Type 1 and Type 2 to implement business logic and capturing the deleted records in the source systems.
• Experience with high volume datasets from various sources like Oracle, Text Files, Relational Tables and xml targets.
• Used debugger extensively to identify the bottlenecks in the mappings.
• Tested scripts by running workflows and assisted in debugging the failed sessions.
• Worked on developing workflows and sessions and monitoring them to ensure data is properly loaded on to the target tables.
• Responsible for scheduling workflows, error checking, production support, maintenance and testing of ETL procedures using Informatica session logs.
• Extensively dealt with the performance issues and made necessary coding changes for improving the system Performance.

Environment: Informatica Power Center 9.1, IDQ, Flat Files, Oracle 11g, SQL, PL/SQL, TOAD, SQL Developer, Windows XP, SQL Server 2008, Unix

Confidential

Informatica Developer

Responsibilities:

• Analysis of source systems and work with business analysts to identify study and understand requirements and translate them into ETL code.
• Perform analysis on quality and source of data to determine accuracy of information being reported and analyze data relationships between systems.
• Worked on complete life cycle from Extraction, Transformation and Loading of data using Informatica.
• Used Informatica’s features to implement Type I, II changes in slowly changing dimension tables and also developed complex mappings to facilitate daily, weekly and monthly loading of data.
• Prepared high-level design document for extracting data from complex relational database tables, data conversions, transformation and loading into specific formats.
• Designed and developed the Mappings using various transformations to suit the business user requirements and business rules to load data from Oracle, SQL Server, DB2, flat file.
• Developed standard and re-usable mappings and mapplets using various transformations like Expression, Lookups, Joiner, Filter, Source Qualifier, Sorter, Update strategy and Sequence generator.
• Used Debugger to test the data flow and fix the mappings.
• Modified PL/SQL stored procedures for Informatica mappings.
• Created Sessions and Workflows to load data from the SQL server, flat file and Oracle sources that exist on servers located at various locations all over the country.
• Involved in unit testing, Integration testing and User acceptance testing of the mappings.
• Used various performance enhancement techniques to enhance the performance of the sessions and workflows.
• Performance tuning on sources, targets mappings and SQL (Optimization) tuning.
• Responsible for creating business solutions for Incremental and full loads.
• Installation and configuring the Power Center tool including database connections.
• Providing technical support and troubleshooting issues for business users.

Environment: Informatica 8.6.1, Oracle 10g, SQL Server2008, TOAD, DB2, Flat Files, Windows 2000,unix.

Confidential, DENVER CO

Informatica Developer

Responsibilities:

• Involved in Preparing Mapping Document.
• Designing of Self-Funding and Care modules.
• Designed and developed mappings using Source Qualifier, Expression, Lookup, Router, Filter, Sequence Generator, Sorter, Stored Procedure, Update Strategy, Joiner and Rank transformations, SQL transformation, Union transformation.
• Extensively used Informatica client tools like Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer.
• Preparing Sessions, Workflows, Worklets for Mappings.
• Creating Mapping Parameters and Variables.
• Developed reusable mapplets using Mapplets Designer.
• Developed reusable transformations using Transformation Developer.
• Scheduling the Workflows.
• Extensively used Informatica debugger to figure out the problems in mappings. Also involved in troubleshooting existing ETL bugs.
• Performance Tuning of sessions and mappings.
• Involved in Unit testing of the mappings.
• Developed Shell scripts to automate the process.
• Designing of control tables, audit tables and data error tables.
• Resolved the issues raised by testing team.
• Synchronization of Self-Funding with Qcare.
• Developed the email tasks for failures and success.

Environment: Informatica Power Center 8.x, Informatica Power Exchange 8.x, Flat Files, Oracle 9i, SQL, PL/SQL, TOAD, SQL*Plus, Windows 2000, SQL Server, Teradata 13.0, Unix, Remedy, Syncsort DM Express, Maestro

Confidential 

Informatica Developer

Responsibilities:

• Designed, developed Informatica v8.1.1 mappings to extract, transform and load the data into Oracle 10g target tables.
• Designed and developed source to stage-ODS-DataMart mappings/sessions/workflows
• Extensively worked with heterogeneous sources from various channels like Oracle, DB2, SQL Server and Flat Files.
• Extensively worked on Informatica tools like source analyzer, warehouse designer, mapping designer, workflow manager, and workflow monitor and repository manager
• Developed UNIX shell scripts and PL/SQL procedures.
• Extensively worked on performance tuning of ETL mappings and sessions.
• Documented all mappings, crested effective test cases by performing unit testing and Integration testing to ensure the successful execution of data loading process.
• Analyzed session log files if the session failed and resolved the errors.
• Provided technical assistance by responding to inquiries regarding errors or questions with programs/interface.
• Tested the data and data integrity among various sources and targets.
• Associated with production support team in various performances related issues.

Environment: Informatica Power Center 6.2 & 7.1, Oracle 9i, DB2, SQL*Plus, PL/SQL, Windows