SUMMARY

• Around 7 years of IT experience in analysis, design, development and implementation of Data warehouses, data marts and Decision Support Systems (DSS) using Informatica Power Center with Oracle, MS SQL server, DB2 and Teradata databases.
• Experience with ETL process using Informatica Power Center 9.x/8.x, Designer (Source Analyzer, Mapping designer, Mapplet Designer, Transformation Developer), Repository Manager, Repository Server, and Workflow Manager & Workflow Monitor.
• Experience in the successful implementation of ETL solution between an OLTP and OLAP database in support of Decision Support Systems/Business Intelligence with expertise in all phases of SDLC.
• Developed Slowly Changing Dimension mappings of Type1, Type2 and Type3 (version, flag and time).
• Strong experience in developing complex mappings using transformations like Unconnected and Connected Lookups, Router, Aggregator, Sorter, Joiner, Transaction Control, Filter and Update Strategy.
• Expertise in data extraction from Flat Files (XML, mainframes,excel, csv, fixed width, delimited, txt), and Oracle server.
• Good in scheduling jobs and administration activities using control - M
• Experienced with Teradata utilities FastLoad, MultiLoad, BTEQ scripting, FastExport, SQL Assistant.
• Good experience in handling terabytes of data and good at analyzing the data related issues.
• Created various tasks like sessions, and workflows in the workflow manager to test the mapping during development.
• Having very good understading on the usage of webservices in informatica
• Good at analyzing AWR (Automatic Workload Repository) report and good in providing suggestions on SQL tuning techniques using explain plans.
• Good in suggesting the performance tuning techniques to increase the data load through put.
• Strong in UNIX Shell scripting Developed UNIX scripts using PMCMD utility and scheduled ETL load
• Strong Knowledge in ETL design document and mapping sheet creation.
• Proficient in understanding Functional Requirements and Design documents.
• Extensive expertise in designing, developing and executing test scenarios and test cases.
• Excellent technical and professional client interaction skills. Interacted with both Technical, functional and business audiences across different phases of the project life cycle.
• Versatile team player with excellent analytical, presentation and interpersonal skills with an aptitude to learn new technologies.

TECHNICAL SKILLS

ETL /DW Tools: Informatica Power Center 7.x, 8.x, 9.x, IBM Infosphere Datastage

Operating Systems: Unix, MS Windows NT/95/98/2000/XP

DBMS: Oracle 12c,11g,10g/9i, Sql Server 2000, 2005, 2008, 2012, DB2, Teradata

Reporting Tools: Business Objects XI, MS SQL Server Reporting services 2005

Programming Languages: SQL, PL/SQL, SQL*PLUS.

Other Tools: TOAD, Autosys, control-M

PROFESSIONAL EXPERIENCE

Confidential, IL

Senior Informatica Developer

Responsibilities:

• Involved in design and development of Business Requirements in liaison to business users and Technical teams by gathering requirement specification documents and identifying data sources and targets.
• Analyzed application requirements and provided recommended design and studied the current system to understand the existing data structures.
• Participated actively in user meetings and collected requirements from users.
• Used Informatica Power Center for extraction, transformation and loading (ETL) of source data from Database sources like Teradata, Oracle, DB2 & flat files.
• Designed and developed a number of complex mappings using various transformations like Source Qualifier, Aggregator, Router, Joiner, Union, Expression, Lookup (Connected & unconnected), Filter, Update Strategy, Stored Procedure, Sequence Generator and used reusable transformations as well as mapplets.
• Worked with Variables and Parameters in the mappings to pass the values between sessions.
• Worked with Workflow Manager for the creation of various tasks like Worklets, Sessions, Batches, E-mail notifications, Decision and to Schedule jobs.
• Extensively used the Slowly Changing Dimensions-Type II in various data mappings to load dimension tables in Data warehouse.
• Scheduled jobs using Autosys.
• Involved in extensive performance tuning by determining bottlenecks using Debugger at various points like targets, sources, mappings, sessions or system. This led to better session performance.
• Extensively involved in coding of the Business Rules through PL/SQL using the Functions, Cursors, Triggers and Stored Procedures in the server side.
• Involved in creation of Classes, Objects and Universes for reporting purpose using Business Objects Designer.
• Wrote UNIX Shell Scripts and pmcmd command line utility for automating the Workflows.
• Involved in Production Scheduling to setup jobs in order and provided 24x7 production support.
• Involved in trouble shooting and resuming failed jobs.

Environment: Informatica Power Center 9.0.1, Erwin 7.1, BO XI, Teradata, Oracle 11g, DB2, Unix, Autosys.

Confidential, Malvern, PA

Sr. ETL Informatica Developer

Responsibilities:

• Understanding existing business model and customer requirements in different local markets.
• Designed and implemented type II slowly changing dimension.
• Worked with iterative and incremental model of development cycle.
• Extensively worked in data Extraction, Transformation and loading from source to target system.
• Designed and Created data cleansing and validation scripts using Informatica ETL tool.
• Did error handling and performance tuning in Teradata queries and utilities.
• Designed a workflow to load data from multiple flat files using list file load concept.
• Configured sessions, setup workflow and tasks to schedule data loads at desired frequency.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager with changing requirements.
• Extensively worked with various lookup caches like Static Cache, Dynamic Cache, and Persistent Cache Implemented various loads like Daily Loads, Weekly Loads, and Monthly Loads using Incremental Loading Strategy and Informatica scheduling.
• Provided resolution to issues by correcting and validating specification changes.
• Modified existing mappings for enhancements of new requirements.
• Developed dashboards and dashboard pages.
• Developing number of Complex Informatica Mappings, Mapplets and Reusable Transformations for weekly loading of Data.
• Prepared validation scripts for user acceptance testing.

Environment: Informatica 9.1, Autosys, Oracle 11g/10g, SQL Server 2008, UNIX

Confidential, Sacramento, CA

ETL Developer

Responsibilities:

• Responsible for Requirement Gathering Analysis and End user Meetings
• Responsible for Business Requirement Documents BRD's and converting Functional Requirements into Technical Specifications
• Involved in the Designing of ETL process, load strategy and the SRDS after collecting the requirements from the end users.
• Analyzing the source data and deciding on appropriate extraction, transformation and loading strategy
• Used transformation Logic to cleanse the data.
• Extensively worked on all the transformations like Filter, Aggregator, Expression, Router, Lookup, Update Strategy, Sequence generator, Rank, Union, Joiner, Source Qualifier, etc.,
• Created Joiner Transformation to join heterogeneous sources using various kinds of joins like Normal Join, Master Outer Join, Detail Outer Join, and Full Outer Join
• Developed slowly changing dimensions mapping to accommodate the passive mode phase.
• Worked with Informatica Power Center-Source Analyzer, Warehousing designer, Mapping Designer &Mapplet and Transformation Developer for creating Mappings.
• Using Informatica Workflow Manager for Creating, running the Workflows and Sessions and scheduling them to run at specified time.
• Generated SQL based reporting queries to run in Informatica and send automated csv reports to stake holders
• Worked on Data Extraction, Data Transformations, Data Loading, Data Conversions and Data Analysis.
• Tuned performance of Informatica Sessions for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Extensively Used Environment SQL commands in workflows prior to extracting the data in the ETL tool.
• Extensively used UNIX commands within Informatica for Pre Session and Post Session Data Loading Process.
• Responsible for best practices like object Shortcuts to Shared folder, checklists, naming conventions and Error Handling
• Migrated Mappings, Sessions, Workflows and Common Objects from Development higher regions using deployment groups.
• Responsible for mentoring Developers and Code Review of Mappings developed.
• Production Support and Issue Resolutions using Script Logs, Session Logs, and Workflow Logs

Environment: Informatica, Toad, Oracle SQL, PL/SQL, UNIX scripting and AIX Platform, DB2

Confidential

ETL Developer

Responsibilities:

• Worked on running the existing workflows in Data stage
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Parsed high-level design specification to simple ETL coding and mapping standards to create a Technical Design Document.
• Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.
• Extracted the data from the flat files into staging area and populated onto Data warehouse.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, and Stored Procedure to develop robust mappings in the Informatica Designer.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Modified existing mappings for enhancements of new business requirements.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Prepared migration document for admin team to move the mappings from development to testing and then to production repositories.
• Worked on developing integration objects for inbound and outbound web services and also worked on configuration of applets, views, screens and customizing business objects, business components.
• Worked on creating Unit Testing scripts and performed Unit Testing.
• Worked to monitor regular batch jobs and data loads and perform regular support activities.
• Worked with maintenance team to resolve and do major bug fixes in Informatica.
• Used relational SQL wherever possible to minimize the data transfer over the network.
• Worked on writing Stored Procedures PLSQL.

Environment: Informatica, Datastage, Autosys, Oracle, Teradata, UNIX shell scripting and AIX platform

Confidential

ETL Developer

Responsibilities:

• Developed the transformation logic, identifying and tracking the slowly changing dimensions from heterogeneous sources and determining the hierarchies in dimensions.
• Used transformations like Aggregator, Filter, Router, Sequence Generator, Update Strategy, Rank, Expression and lookup (connected and unconnected) while transforming Data according to the business logic.
• Created Sessions, reusable Worklets and Batches in Workflow Manager and Scheduled the batches and sessions at specified frequency.
• Worked extensively on fixing invalid Mappings, and performing Unit and Integration Testing.
• Defined, captured metadata and rules associated with ETL process.
• Designed the layout of the pages.
• Build the Universe by using Business Objects to create various reports for the end customers.
• The project was migrated from Informatica to DataStage as per the need from end customer.

Environment: Informatica, Datastage, Business Object, Oracle & SQL Server, UNIX