SUMMARY

• 10 years of Experience on Data warehouse, Data Integration, Data Migration projects using ETL tool Informatica PowerCenter 9.x/8.x, Power Exchange 8.6.1, Oracle, DB2,Teradata, UNIX.
• Demonstrated expertise utilizing ETL tools, Informatica 9.6.1,9.1, 8.x, Informatica Data Quality, RDBM systems Oracle and DB2 and Teradata.
• Worked on all phases of data warehouse development lifecycle, from ETL Architecture, Data Design, implementation, and support of new and existing applications.
• Excellent technical and analytical skills with clear understanding of ETL design and project architecture based on reporting requirements.
• Experience in solution design of ETL components to meet performance requirements and enhancing overall ETL Informatica architecture.
• Extensive experience in creatingpackages, stored procedures,Functions, Triggers, Viewsand other database objects usingSQL, PL/SQL programming.
• Good working experience in PL/SQL including Packages, procedures/functions, database triggers, EXPLAIN PLAN, Hints, PL/SQL Collections, Ref cursors, Performance Tuning, co - related queries, complex joins for existing and new programs.
• Experience in complex ETL solution design and implementation like Dynamic Aggregation, Dynamic sorting and Dynamic Expression Evaluation. working experience in reading data from various data applications like SAP using SAP connector (File Mode and stream mode), Mainframe using IBM MQ Series, real-time CDC data using Power Exchange and XML sources using XML Parser.
• Good experience in Massively Parallel Processing systems (MPP) like Teradata, Teradata Architecture, utilities like BTEQ, FastLoad, MultiLoad, FastExport, Teradata SQL Assistant.
• Experience in Informatica partitioning with various partition techniques including dynamic partitioning.
• Experience in Advanced workflow concepts like Push Down Optimization, Concurrent workflow execution in Informatica.
• Experience in developing the best practices and quality assurance standards for ETL and BI solutions and having knowledge of reporting Tool Cognos.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 9.6.1,9.1, 8.x,7.1

Other Tools: Informatica Data Quality (IDQ) 9.1, Informatica Power Exchange 8.6.1, Autosys, Control-M, DAC 10g/11g, SVN, HPQC

Databases: Oracle Exadata,10g,11g, DB2, Teradata 12

Operating Systems: UNIX, Windows

Languages: SQL, PL/SQL, Shell Scripting

Reporting Tools: Cognos 8.1, OBIEE

Utilities: Bteq, Fast Load, MultiLoad, Fast Export.

Methodologies: Star Schema, Snowflake Schema

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Informatica Lead Consultant

Environment: Power center 9.1, DAC 10g/11g, OBIEE 11g, OBIA 11g, Oracle Exadata, PLSQL, Peoplesoft, JDE, Erwin, Unix.

Responsibilities:

• Responsible for Business Analysis and Requirements Collection.
• Parsed high-level design specification to ETL informatica coding and mapping standards.
• Creating Design documents using the high level requirement document.
• Designed and customized data models for Data warehouse supporting data from Peoplesoft and JDE sources
• Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.
• Created informatica mappings, mapplets, sessions, workflows to implement fraud analytics with risk scoring mechanism.
• Used mapping parameters and expression variables extensively within informatica mappings.
• Used Oracle and Informatica Regular expressions extensively to search/replace string patterns.
• Worked on advanced PLSQL procedures with Hierarchical queries, analytical functions Lead, Lag, Listagg.
• Created complex SQL queries to implement ETL logic in informatica mappings and for testing purposes.
• SQL queries are used in mappings to replace informatica transformations for improving performance wherever required.
• Created Unix script to automate the ftp transfer and archiving the old files.
• Used DAC to create jobs for incremental and full load and maintain the dependency between informatica jobs.
• Created and used the Patch utility in DAC 11g to migrate the DAC configuration to higher environment.
• Created and used deployment groups to migrate informatica code to higher environments.

Confidential, Columbus, OH

Informatica Lead Consultant

Environment: Power center 9.6.1, Informatica Data Quality 9.6.1, DB2, UNIX, Micro Strategy 9.3.1

Responsibilities:

• Working on Application Enhancements.
• Creating Design documents, Implementation, Unit and application test for new work orders.
• Creating Design Instruction document containing the ETL solution to meet performance requirements, taking inputs from the SRS document.
• Creating the Deployment Order, Application Plan documents as part of design deliverables.
• Integrated various data sources of DB2, SQL Server, VSAM (Cobol file in EBCIDIC format) and sequential files into staging area using informatica.
• Designed and developed ETL and Data Quality mappings to load and transform data from source to DWH using PowerCenter and IDQ
• Experience in Informatica Data Quality transformations like Match, Consolidation, Exception, Parser, standardizer.
• Developer Match and Merge strategy and Match and consolidation based on customer requirement and the data.
• Built several reusable components on IDQ using Parsers, Standardizers and tables.
• Performed analysis, design, and programming ofETLinformatica processes.
• Creating Test plan document containing the positive and negative test cases.
• Creating Understanding documents for existing applications.
• Used SQL queries in informatica Source Qualifier and Lookup override to improve informatica performance.
• Upgrading of Informatica PC client from 9.1 to 9.6.1 and prepared a step wise guide for the onsite/offshore team.
• Supporting existing applications, Monitoring, responding and assigning existing and new incidents using Remedy Tool.

Confidential, Columbus, OH

Informatica Lead Developer

Environment: Power center 9.1, DB2, SAP, UNIX, HPQC

Responsibilities:

• Participated in the initial project planning and knowledge transfer sessions.
• Lead a team of five developers and assigning tasks to them.
• Created detailed level technical design specification document based upon the high level specifications provided, for offshore ETL developers.
• Prepared the technical solution document, ETL mapping specification documents.
• Worked on Design and implementation of various stages.
• Worked for fast closure of the UAT defects and performance tuning of the code and presenting the code to the client.
• Created ETL workflows, sessions and mappings.
• Created dynamic expression evaluation using Java transformation.
• Created ETL design documents and support documents.
• Prepared test case document.
• Mentored team members and provided technical guidance to project team for query/issue resolution in timely manner.
• Performed tuning of SQL and Informatica objects, which involved tuning source, target and adding parallel processing and modifying the Informatica code for optimal performance.
• Involved in ETL process from development to testing and production environments.
• Provide post implementation support to the production support team

Confidential

Senior Informatica Developer

Environment: Informatica 9.0, Teradata 12, FastLoad, MultiLoad, FastExport, SQL Server, Tandem, BRIO

Responsibilities:

• Developed complex Informatica mappings using various transformations.
• Developed Reusable codes which can be used thru out the application.
• Providing estimates (in man hours) for ETL and database objects involved.
• Involved in Unit testing and System Integration testing.
• Worked with XML Source qualifier transformation for reading XML files in a mapping.
• Created DML for creating tables using XSD files.
• Created mappings with CDC logic using Informatica variables.
• Creation of Complex mappings such as Incremental aggregation and Slowly Changing Dimensions.
• Good working experience with MPP systems (Teradata).
• Coding using Teradata Analytical functions, BTEQ SQL of TERADATA
• Developed processes on Teradata using RDBMS utilities such as Multi Load, Fast Load, Fast Export, BTEQ (Teradata).
• Involved heavily in writing complex SQL queries based on the given requirements and used volatile tables, temporary tables, derived tables for breaking up complex queries into simpler queries
• Fine tuned transformations and mappings for better performance.
• Involved in debugging of mappings using Informatica Debugger.
• Prepared test case scenarios and executed the scenarios.
• Tested the reports generated by BRIO tool by comparing reports from both Old and New systems.
• Mentored team mates on Informatica coding and testing.

Confidential

ETL Developer

Environment: Informatica 8.6.1(PowerCenter, power Exchange), Oracle 10g, PLSQLDB2, IBM MQ Series, ABC Framework,Unix

Responsibilities:

• Developed both one-time and real-time mappings using Power Center 8.6.1, Power Exchange and IBM MQ Series.
• Registered the Data maps for Real-time CDC (Changed Data Capture) data, in Power Exchange. Worked on Extraction maps, Row Test in Power Exchange Navigator.
• Worked on importing MQ Series Source and developing mapping using MQ Source and XML Parser transformation and XML Generator transformation.
• Worked with XML Source qualifier transformation for reading XML files in a mapping.
• Worked with web services consumer transformation for consuming web services in Informatica.
• Worked on Configuring workflow properties to convert it to a web service and expose it in Web Service Hub.
• Validated XML files with XSD files provided by client.
• Created DML for creating tables using XSD files.
• Extensive experience in creatingpackages, stored procedures,Functions, Triggers, Viewsand other database objects usingSQL, PL/SQL programming.
• Writing Queries, Complex SQL Queries/DML Statements, PL/SQL
• Worked on Transformations like Normalizer, Dynamic Lookup, SQL Transformations, and Stored Procedure Transformations for various Bussiness Logic.
• Developed mapplets which were used in Real-time and reprocess mappings.
• Developed mappings with target update override where Merge Statement is used.
• Involved in writing the SQL Statements for SQL Override in Source Qualifier as well as Target Update Override.
• Worked on Unit Testing the Data Acquisition Module.
• Involved in ABC Framework Component development.

Confidential

ETL Developer

Environment: Informatica 8.1, Oracle9i/10g, Mainframe, PLSQL, Autosys, UNIX

Responsibilities:

• Develop or enhance the ETL mappings to extract data from the various Sources and load it into the Oracle databases or Flat files as required.
• Do the error validation of the data moving from various sources to targets.
• Analyzing Informatica mappings and session level properties and logs for performance bottlenecks.
• Creating the Mapping and Reviewing Technical specifications. worked on creating mappings with CDC ( changed data capture) using Informatica variables.
• Creation of Complex Jobs using Aggregator, Transformer, Filter, Joiner, Lookup Stages.
• Fine tuned Stages and Jobs for better performance.
• Validating, Run, Monitor & Test the developed Jobs.
• Validating integrity of the data after successful load.
• Involved in Developing Mappings, Transformations, Workflows using Source Qualifier, Aggregator, Connected Lookups, Expressions, Filters And Sequence generator Transformations
• Tuned and tested the mappings to perform better using different logics to provide maximum efficiency.
• Implementing the Performance Optimization solution to various components, wherever applicable.
• Unit Test Case Document Preparation

Confidential, Houston, TX

ETL Developer

Environment: Informatica 7.1.4, 8.0, Oracle, Unix

Responsibilities:

• Majorly involved in ETL developing
• Creating the mappings and involved in Extraction, Transformations and Loading
• Used Informatica to load data from Oracle and flat files to Oracle
• Extracting the data from the source system and creation of the target database
• Worked on Informatica Source Analyzer, Mapping Designer and used various transformations such as the Source Qualifier, Aggregators, Connected & Unconnected lookups, Filters & Sequence, Joiner
• Used SQL overrides in source Qualifier to meet business requirements.
• Creating Targets, Mapplets
• Configuring and Scheduling Sessions in Workflow Manager
• Creating and testing sessions