SUMMARY

• 7+ years of ETL experience with Informatica PowerCenter (9.1,8.6, 8.1.1)and in developing & Administering ETL mappings with Designer (Source Analyzer, Target Designer, Transformation Developer, Mapping designer, Mapplet Designer), Repository Manager, Workflow Manager, Workflow Monitor
• Experience in Database front using Oracle 9i/8i/8.0, Teradata, MS SQLServer 2005/2000/ 2008 , MS Access and PL/SQL.
• Experience in using Dimensional Data Modeling, Star Join Schema Modeling, Snow - Flake Modeling, FACT and Dimensions Tables.
• Experienced in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to apply businesslogics and to move data from multiple sources into targets.
• Experienced in automating and integration of Informatica jobs through Autosys (scheduling tool).
• Worked extensively with complex mappings using different transformations like XML transformations, Stored procedure transformations, Source qualifiers, Union, Update strategy, unconnected & connected lookups, aggregator, and SCD type2
• Experienced in preparing Technical design document, Mapping documents, data definition documents, Detail design document for the Source/Target mapping.
• Experience in using the Informatica command line utilities like pmcmd, pmrepserver and pmrepagent to execute or control sessions, tasks, workflows and deployment groups in non-windows environments
• Extensively worked on Teradata tools & utilities like Fast Load, Multi Load, TPump, Fast Export, Teradata Parallel Transporter (TPT) and BTEQ.
• Experienced in using database interface tools like Toad and PL/SQL Developer.
• Experienced in Testing, Debugging, Validation and Tuning of mappings, workflows.

TECHNICAL SKILLS

Data Warehousing Tools: InformaticaPowerCenter 9.5.1/9.0.1/8. x/7.x,InformaticaPowerExchange 9.0.1/8.6/8.5/8.1 , Data cleansing, OLAP, ROLAP, MOLAP, Star Schema, Snowflake Schema, OLTP, BTEQ, MLOAD, FLOAD, FEXPORT, TPUMP.

Data Modeling: Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake, FACT, Dimensions), Entities, Attributes, Cardinality, ER Diagrams,salesforce.com Erwin 4.0/3.5.2/2. x

Databases: Oracle 11g/10g/9i, MS SQL Server 2008, DB2, PL/SQL, Teradata 13/V2R6,Sybase, Sap, MS Access

Scheduling Tools: ESP Job Scheduler, Autosys

Database Tools: SQL PLUS, SQL Developer, TOAD, SQL Loader.

Environment: Windows 95/98/00/XP/7,8, UNIX, LINUX

Programming: C,C++, SQL, PL/SQL, Shell Scripting, HTML, Java Script

Other Tools: Putty, WinScp, MS Office,Selenium

PROFESSIONAL EXPERIENCE

Confidential, CHICAGO, IL

Informatica Developer

Responsibilities:

• Worked closely with business analyst and Data Warehouse architect to understand the source data and need of the Warehouse.
• Translate customer requirements into formal requirements and design documents.
• Involved in creating the design and technical specifications for the ETL process based on Functional specifications.
• Written Informatica mapping for dropping and recreating the indexes of database tables.
• Development of address cleansing Mapplet and mapping using First logic plug-in.
• Worked extensively with Extraction, Transformation and Loading of data from Multiple Sources (oracle, Netezza, Teradata, fixed width and delimited flat files) to ORACLE usingInformatica.
• Worked on Scheduling workflows and sessions usingInformaticascheduler and have implemented decision task and email task for tracking the successful completion
• Handled the creation of tables, views, triggers, stored procedures, functions, sequences in the database using SQL and PL/SQL scripts.
• Experience in using Teradata tools like Fast Load, Multi Load, TPump, Fast Export, Teradata Parallel Transporter (TPT) and BTEQ.
• Extensively used T-SQL in creating Procedure.
• Implemented complex mapping such as SLOWLY CHANGING DIMENSIONS (Type II).
• Worked on various types of transformations like Expression, Joiner, update strategy, Aggregator, Filter and Lookup.
• Created UNIX scripts for parsing and modifying data and experience in using AUTOSYS job scheduler for automation of UNIX shell scripts and batch scheduling.
• Facilitate end-user procedures development.

Environment: Informatica Power Center 9.0.1/8.6.1 (Power Center Designer, workflow manager, workflow monitor), Oracle 1g,DB2,TARADATA,NETEZZA,XML,SQLServer2008,UNIX,TOAD,AUTOSYSCOGNOS.

Confidential, CHICAGO, IL

Sr. Data Warehouse/ETL Developer

Responsibilities:

• Performed Business Analysis, Requirements gathering and converted them into technical specifications.
• Coordinated design reviews, ETL code reviews with offshore developers.
• Prepared various design documents like technical design documents, mapping specification documents, target to source mapping document.
• Developed mappings using Informatica to load data from sources such as Relational tables, Sequential files into the target DB2 tables, Sequential files.
• Extensively worked with transformations like Lookup, Update Strategy, Expression, Filter, Router, Joiner, and Aggregator, Source Qualifier Transformations.
• Created datamaps in Informatica PowerExchange to extract data from mainframe VSAM, Sequential files.
• Used debugger to test the data flow between source and target and to fix the logical errors in the mappings.
• Tuned the Sessions for better performance by eliminating various performance bottlenecks.
• Worked on different tasks in Workflows like Sessions, Event Raise, Event Wait, Decision, E-mail, Command, Worklets, Assignment, Timer and scheduling of the workflow.
• Extensively worked on UNIX Shell Scripting for loading the data to DB2 tables, scheduling the Informatica session runs using ESP Job Scheduling.
• Created Pre Session and Post Session UNIX Shell Scripts.
• Performed Unit, Integration and System testing of various jobs.
• Assisted in UAT Testing and provided necessary reports to the business users.
• Deployed package from Dev to Test environment, created packages for Test to Prod migrations. Associated with Production support team in various performances related issues.

Environment: Informatica Power Center 8.6.1, DB2 UDB V9, V8, Oracle 10g, SQL Server 2005, Informatica PowerExchange for VSAM, AIX V5.3, UNIX Shell Scripting, ESP.

Confidential, New York, NY

Informatica Developer

Responsibilities:

• Requirement gathering and Business Analysis. Involved in data modeling and created LDM and PDM.
• Participated and coordinated in onsite-offshore meetings.
• Worked on various HIPAAterms &functionalities.
• Translated business requirement to technical specifications and developed Informatica mapping/Workflows.
• Used shell Scripting and Scheduled pmcmd to interact with Informatica Server from command mode.
• Used ETL to extract and load data from GlobalRepositories, Folders, Permission and user using repository manger.
• Maintaining source definitions, transformation rules and targets definitions using Informatica Repository Manager.
• Worked on performance tuning for ETL processes.
• Created complex mappings using Unconnected, Lookup, and Aggregate transformations for populating target table in efficient manner.
• Developed various Sessions, Batches for all Mappings for loading from verious sources like flat files, tables, XMLs and csv file to Target tables.
• Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
• Used PL-SQL procedures to detect CDC methodologies and developed Slowly Changing Dimension for Type 1 and Type 2.
• Created Indexes, primary keys and checked other performance tuning at data base level.
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows.
• Developed Oracle PL/SQL Stored Procedures. Performance and fine Tuning of SQL & PL/SQL stored procedures.
• Performed Unit testing by comparing the source and target data.
• Loaded data to Staging area using Terdata FLOAD utilities. Created BTEQ Script for ETL processing.

Environment: Informatica PowerCenter 8.5/8.1, Oracle 10g, SQL*Plus, PL/SQL, Microsoft SQL Server 2005, COBOL Files, Sun Solaris 5.8 Windows 2000.

Confidential

ETL Developer

Responsibilities:

• Attended user design sessions, studied user requirements, completed detail design analysis and wrote design specs.
• Developed Informatica mappings, sessions and workflows.
• Extensively worked with Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Developed standard and re-usable transformations and mapplets. Used various transformations like Expression, Aggregator, Joiner, Normalizer, Router, Lookup, and Filter.
• Used Informatica variables to implement complex logic for Informatica mappings.
• Designed and developed the workflows, validated the dependencies in between the workflows which involved various tasks like event-wait, command, session tasks.
• Wrote UNIX shell scripts / Perl Scripts and used them as Pre/Post Session commands in the Sessions.
• Scheduled the Workflows and monitored them.
• Designed the Migration Plan document to migrate the Mappings and work-flows to the Testing and Production environments.
• Provided Pro-Active Production Support after go-live.
• Documented the number of source / target rows and analyzed the rejected rows and worked on re-loading the rejected rows.
• Migrated Informatica Objects from Dev/Test environment to Production environments. Worked in Team based environment. Conducted peer-to-peer code review meetings.
• Created test plans, did unit testing, worked with QA team for System Integration Testing.
• Interacted with key users and assisted them with various data issues, understood data needs and assisted them with Data analysis.
• Wrote UNIX scripts to extract files using SFTP.

Environment: Informatica PowerCenter 8.5/8.1, Oracle 10g, SQL*Plus, PL/SQL, Microsoft SQL Server 2005, COBOL Files, Sun Solaris 5.8 Windows 2000.

Confidential

Database/ETL Developer

Responsibilities:

• Involved in analyzing and development of the Data Warehouse.
• Translation of Business Processes into Informatica mappings for building Data Marts.
• Worked on Informatica - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplets, and Transformations.
• Implemented Aggregate, Filter, Join, Expression, Lookup, Update Strategy, and Stored Procedure Transformations.
• Involved in the development of Informatica mappings and tuned them for better performance.
• Involved in designing the procedures for getting the data from Flat files, Databases to Data Warehousing system.
• Created mappings with PL/SQL procedures/functions to build business rules to load data.
• Extensively used ETL to load data from different databases and flat files to Oracle.
• Creating and running sessions and batches to load the data into the Target Database.

Environment: Informatica PowerCenter 8.5/8.1, Oracle 10g, SQL*Plus, PL/SQL, Microsoft SQL Server 2005, COBOL Files, Sun Solaris 5.8 Windows 2000.

Confidential

ETL Developer

RESPONSIBILITIES:

• Extensively worked with Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Created mappings involving Slowly Changing Dimensions and capturing deleted records.
• Developed T-SQL stored procedures for checking integrity constraints and database updates.
• Created and scheduled sessions based on demand, run on time and run only once.
• Involved in migrating the mappings and sessions from development to testing.
• Worked on database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Using the debugger in Informatica tested the data.
• Performed unit testing and system testing.

Environment: Informatica Powercenter 7.1, Windows Server 2003, SQL Server 2003, T-SQL