SUMMARY

• 7+ years of IT experience in Data Warehouse applications using Informatica power center tool 9.x/8.x, Oracle, DB2, Teradata, MS SQL server on Windows, IBM and UNIX platforms.
• Experience in Architecture, Analysis, Design, Development, Testing,Implementation of DWBI applications which includes strong experience inData Warehousing (ETL & OLAP) environment.
• Experience in Data Modelingusing ErwinTool, Star/Snowflake Modeling, Data marts, OLAP, FACT & Dimensions tables, Physical & Logical data modeling.
• Excellent understanding of ETL(Extract, Transform and Load) design principles and practical knowledge of performing ETL design processes through Informatica Power Center Tool.
• Excellent understanding of Business Intelligence and Data Warehousing Concepts mainly emphasis on ETL and SDLC (Software Development Lifecycle) methodologies like Waterfall and Agile methodology which includes requirement gathering, designing, implementing and testing.
• Efficient in creating SSIS Packages. Created packages to extract data from flat files, Teradata, Oracle and DB2 and transform the data according to the business requirements and load the data in SQL server tables.
• Solid understanding of ETL design process and principle, development and maintenance using Oracle SQL, PL/SQL, Informatica Power Center.
• Experience in extraction of data from various Heterogeneous sources (Relational database, Flat Files, XML Files) to load into Data Warehouse/Datamart targets.
• Designed and developed Complex mappings from various Transformations like re - usable transformations, and Mappings/Mapplets, Unconnected / Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and more, mappings using Stored Procedure’s, Normalizer, XML, External Procedure.
• Extensively worked in Repository configuration using transformation, creating Mapping, Mapplets, Workflow SessionsWorklets, and processing tasks usingDesigner/ Workflow Manager to move the data from multiple Source system to Targets.
• Solid understanding of Data Warehousing concepts and Dimensional modeling (Star schema and Snowflake schema) and Relational Data Modeling and Slowly Changing Dimensions.
• Proficiency in data warehousing techniques for Data cleansing, Slowly Changing Dimension phenomenon, Surrogate key assignment.
• Expertise in writing DDL, DML, DCL, and TCL command.
• Proficient in Oracle Tools and Utilities such as TOAD and SQL*Loader
• Experience with managing ODBC connections.
• Experience in coding database scripts such as SQL queries and database objects such as PL/SQL Packages, Stored procedures, Indexes, Functions, Views and Triggers.
• Strong with relational database design concepts.
• Ability to learn new technologies and tools quickly.
• Excellent interpersonal skills, customer skills,technically proficient, decision making and detailed-oriented with problem solving skills and also ability to work independently.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.6/9.5/9.1/8.6

DBMS/RDBMS: Oracle 11g/12c/10g, SQL server,DB2,Tera data

Operating Systems: UNIX, Linux, DOS, Windows XP/ 2003/2000/2008/ NT

Languages: SQL, PL/SQL, Unix Shell Programming

ReportingTools: Cognos,MicroStrategy,OBIEE

Version ControlTools: Sub Version, SharePoint

Job SchedulingTools: Autosys, Informatica Job Scheduler,Control M

Data Access Tools: TOAD, SQL Navigator, Oracle SQL Developer,SQL*PLUS

PROFESSIONAL EXPERIENCE

Confidential, BUFFALO, NY

ETL Informatica Developer

Responsibilities:

• Understanding business requirements and technicaldesign specifications.
• Prepared Source to Target data mapping specification documents by analyzing the data fromSource systems and Warehouse.
• Prepared technical design documents for the development of Informatica (ETL) process to loaddata into various target tables.
• Created data models for the new and existing ETL process.
• Performed code reviews on the programs developed by other teams.
• Worked extensively with Agile Project methodology with daily stand-ups and weekly groomingsessions.
• Worked on data cleansing by creating SSIS packages against the Flat Files.
• Responsible for the design, development and implementation of dynamic SSIS packages for ETL (extract, transform, and load) development following company standards and conventions.
• Worked with team of developers to design, develop, and implemented the solutions.
• Extensively used Informatica Client tools - Source Analyzer, Warehouse Designer, MappingDesigner, Mapplet Designer, Informatica Repository Manager and Informatica WorkflowManager.
• Extracted data from various source systems like DB2, SQL Server, Oracle and flat files and loadedto a relational data warehouse and flat files.
• Designed and developed complex ETL mappings in Power center making use of transformationslike Source Qualifier, Joiner, Update Strategy, Connected and unconnected Lookup,Expression, Router, Filter, Normalizer, Aggregator, SQL, Sequence Generator and XMLtransformations.
• Developed database objects like Stored Procedures,Functions, Packages and Triggers using SQL and PL/SQL to disable and enable PK/FK keys and constraints, Truncate tables, Drop and Build Indexes.
• Designed and developed Mapplets, shortcuts for faster development, standardization andreusability purposes.
• Implemented Slowly Changing Dimension Type1, Type2 and Type3 for inserting and updatingTarget tables for maintaining the history.
• Developed full and incremental loads of data into the target databases.
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables, SessionParameters and Parameter Files.
• UsedWorkflow Manager for Creating, Validating, Testing and running the sequential and concurrentSessions and scheduling them to run at specified time.
• Extensively tuned the SQL queries which are being used as a part of different transformationssuch as look ups, source qualifiers and SQL transformations.
• Extensively optimized all the Informatica sources, targets, mappings and sessions by findingthe bottlenecks in different areas and also debugged some existing mappings using the Debuggerto test and fix the mappings.
• Used pre-session and post-session scripts for dropping and recreating indexes before and afterloading data into target table to optimize performance.
• Created and scheduled Sessions, Jobs based on demand, run on time and run only once usingWorkflow Manager.
• Debugged and implemented the best practices in mappings, sessions, and workflows for dataextraction and loading from source to target databases.
• Extensively involved in performance tuning of the Informatica Mappings/Sessions by increasingthe caching size, overriding the existing SQL.
• Created and adapted existing UNIX Shell scripts for automation of different processes.
• Scheduled Informatica workflows, Unix Scripts, database jobs by creating job groups, jobs, EmailEvents, File Events, Variables etc. using TIDAL scheduling tool.
• Worked on SQL tools like TOAD for oracle and Surveyor for DB2 to run SQL queries and validatethe data.
• Performed Unit Testing for ETL Mappings and created Test cases Documents.
• Prepared ETL mapping Documents for every mapping and Data Migration document for smoothtransfer of project from development to testing environment and then to production environment.

Environment: Informatica PowerCenter 9.1.1/8.1.1, Kalido, DB2 AS/400, Agile/Waterfall, Visio, SQL Server, Oracle 11g/10g, SQL, Flat Files, XML Files, Visual Source Safe, SVN, Reflection, Unix, TOAD, SQL Developer, Surveyor, DST PowerMHS, Health Rules/Health Edge, Tidal, Altiris, Service Desk, EDI, AIX.

Confidential, Mclean, VA

ETL Informatica Developer

Responsibilities:

• Took major role in understanding the business requirements, designing and loading the data into Datamart.
• Used ETL Informatica to load data from CDW DB2 to Oracle DatamartSFCDM .
• Worked on PowerCenter Designer client tools like Source Analyzer, Target Designer, Mapping Designer and Mapplet Designer.
• Informatica workflow manager was used to create, schedule, execute Sessions, Worklets, Command, E-Mail Tasks and Workflows. Performed validation and loading of the Flat files received from business users. Wrote UNIX Shell scripts for Informatica ETL Tool.
• Participated in Performance Tuning of ETL maps at Mapping, Session, Source and Target level as well as writing Complex SQL Queries from ABSTRACT Data model.
• Tuned SQL Queries in Source qualifier Transformation for better performance.
• Created and executed unit test cases for various scenarios for all the mappings, workflows and scripts.
• Used Parameter files to reuse the mapping with different criteria to decrease the maintenance.
• Extensively used Informatica Debugger for testing the mapping logic during Unit Testing.
• Provided data to the reporting team for their daily, weekly and monthly reports.
• Used Autosys to schedule Informatica, SQL script and shell script jobs.

Environment: Informatica9.6/9.5/9.1, Erwin 7.2/4.0,Flat Files, Oracle 11g/10g, Rapid Sql, DB2,SQL Server 2008/2005, PL/SQL, UNIX, Clear Case, IBM Rational Doors, HP ALM, Autosys, OBIEE 11g.

Confidential

Informatica Developer

Responsibilities:

• Understanding the customer requirement & Analysis
• Understanding XML data structure
• Learning and using the new transformations like XML Parser, XML Source Qualifier & Transaction Control extensively
• Importing Source/Target tables from the respective databases.
• Extensively involved in development of mappings using various transformations of Informatica according to business logic.
• Used various Informatica transformations like Lookup, Joiner, Aggregator, Expression, Filter, Router and Update Strategy for framing business logic in the mapping.
• Participated in preparing mapping transformation logic documentation as per Client requirements
• Create and Monitor the sessions using workflow manager and workflow monitor.

Environment: Windows XP, Informatica Power Center 7.1,Oracle 9i,SQL*Plus, TOAD, UNIX, Autosys, Cognos.

Confidential

Informatica Developer

Responsibilities:

• Extensively used InformaticaPowerCenter 8.6.1 to extract data from various sources and load in to staging database.
• Extensively used transformations such as Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Joiner, Transaction Control and Stored Procedure.
• Extensively used ETL to load data from multiple sources to Staging area (Oracle 9i) using InformaticaPowerCenter 8.6.1 Worked with pre and post sessions, and extracted data from Transaction System into Staging Area. Knowledge of Identifying Facts and Dimensions tables.
• Tuned sources, targets, mappings and sessions to improve the performance of data load.
• Designed Logical and Physical Modeling using Erwin Data Modeler tool.
• Did data migration of Informatica Mappings, Sessions, and Workflows to Data Integrator.
• Created data stores, project, jobs, and data flows using Data Integrator
• Created complex Cognos reports using calculated data items, multiple lists in a single report. Prepared functional and technical documentation of the reports created for future references.
• Involved in the Development of Informatica mappings and mapplets and also tuned them for Optimum performance, Dependencies and Batch Design.
• Created Several InformaticaMappings to populate the data into dimensions and fact tables.
• Rectifying errors at mapping level and session level.
• Error or bad rows coming from source are stored in a flat file and email to business user for correction and resend the corrected data in next load.
• Worked using Parameter Files, Mapping Variables, and Mapping Parameters for Incremental loading.
• Worked cooperatively with the team members to identify and resolve various issues relating to Informatica and other database related issues.
• Designing mapping templates to specify high level approach.
• Involved in creating/modifying reports using Business Objects and Web Intelligence.
• Involved in debugging the mappings.
• Resolving if any issues in transformations and mappings.

Environment: InformaticaPowerCenter8.6, Oracle 10g/9i,PL/SQL, TOAD, SQL*Plus,Windows, UNIX HP UX, Control M.