SUMMARY

• 8+ years of focused experience in Information Technology with a strong background in Data warehousing and above 7+ years of ETL experience using Informatica PowerCenter 9.5.1/9.1/8.6.1 /8.1.1/8.0/7.1.2/7.1.
• Extensive experience in developing strategies for ETL process using Informatica in large Warehouse environments
• Worked on complete SDLC including requirements gathering, functional design, development, testing, deployment and support
• Data Processing experience in designing and implementing Data Mart applications, mainly transformation processes using ETL tool Informatica PowerCenter in Extraction/Transformation/Loading of data and develop Worklets, Workflows and Mappings
• Experience in Repository Configuration and processing tasks using Workflow Manager & Workflow Monitor to move data from multiple sources into targets
• Developed complex Mappings, used transformations such as Lookup, Router, Filter, Expression, Aggregator, Joiner, Stored Procedure and Update Strategy
• Working Experience in E - R modeling-FACT & Dimensions tables, Physical & logical data modeling
• Strong experience in Data warehousing concepts, dimensional Star Schema and Snowflakes Schema methodologies used in relational, dimensional and multidimensional modeling, Data Profiling and Data cleansing
• Expertise in developing SQL, SQL*Plus and PL/SQL codes through various Procedures/Functions, Packages, Cursors and Triggers to implement the business logics of database
• Strong understanding of Performance tuning in Informatica and loading data into Data Warehouse/Data Marts
• Responsible for interacting with business partners to identify information needs and business requirements for reports
• Excellent interpersonal and communication skills, technically competent and result-oriented with problem solving skills and ability to work independently
• Developed effective working relationships with client team to understand support requirements, develop tactical and strategic plans to implement technology solutions, and effectively manage client expectations
• Worked in different development methodologies including agile (Scrum), Waterfall, Spiral etc..

TECHNICAL SKILLS

Language: C, C++, Java (jdk1.2, Servlets, JSP), SQL, PL/SQL.

Data warehousing Tools: Informatica PowerCenter 9.5.1/9.1/8.6.1 /8.5.1/7.1/6.2 , Informatica Power Exchange, Informatica Metadata Manager, Informatica Data Quality, Informatica Data Explorer, Business objects 5.1/6.5,Cognos BI suite 6.0/7.2.Reportnet1.1. Data Modeling Tools Erwin

RDBMS: Oracle 11g/10g/9i/8i/8.0,DB2, Siebel 7.8, Ms SQL Server, Sybase, Teradata, Netezza.

Script Languages: Perl, Script, Java script, korn shell script, Application Server IBM WebSphere 5

Others: Citrix, Telnet, PLSQL developer, Toad 9.7.2/6.5, Visio pro, PVCS, COBOL, IMS, VSAM

Operating System: Windows XP / Windows 2000, WinNT, UNIX (AIX, HP, SCO), Linux, Sun Solaris, Red Hat, AIX.

PROFESSIONAL EXPERIENCE

Confidential, HOUSTON, TX

Sr. Informatica Lead Developer

Responsibilities:

• Created Integration Requirements and Design Specification Document.
• Provided architectural design for Informatica.
• Defined and designed flow and standards for Informatica.
• Presented all of the Informatica tools to the Client, its usage, advantages and disadvantages for them to make up their mind to proceed with specific tools of Informatica.
• Documented ETL requirements translating STM’s Business logic into ETL language.
• Lead the offshore GDC team of ETL Developers providing them with in depth understanding of the Architecture, ETL system design and requirements.
• Retrieved data from unstructured sources like XML using Informatica B2B DT.
• Worked closely with data population developers, multiple business units and a data solutions engineer to identify key information that will enhance business decision-making.
• Created mappings for loading the data into OBIEE repository.
• Configured RPD and DAC for OBIEE.
• Integrated the Informatica workflows into OBIEE RPD and created connections for source/target in OBIEE RPD
• Worked closely with the OBIEE developers in creating the RPD of OBIEE (metadata layer).
• Used Informatica data explorer tool for data profiling.
• Involved in designing the Data warehouse based on the requirement document using Informatica Power Center 9.1/8.6.1.
• Created XML files, used XML Parser, XML source Qualifier for the entity as well as hierarchical data in XML.
• Created stored procedure to be called in Informatica for the nexval from Dual table of oracle.
• Created reusable expression transformation for Meta columns of Standardization area.
• Masked data and populated to the limited trust zone using Data masking transformation of Informatica.
• Used SQL, Stored Procedure.
• Used Exceed tool for scheduling the Autosys jobs.
• Retrieved data from JMS MQ Series from email server.
• Debugged and corrected mappings created by GDC.
• Fixed numerous bugs with Testers inputs.
• Created Visio documents for Autosys Production Schedule.
• Created Production readiness document.
• Created Autosys documents for one time, Daily loads of data.
• Used Exceed to execute the Autosys Jobs.
• Upgraded Informatica Power Center 8.6.1 to 9.0.
• Used Informatica Data Quality tool for Standardization by referring to the database dictionary tables and populating the flat file dictionaries.
• Good knowledge of Oracle major upgrade from 10.2.0.4 to 11g
• Worked with tools - Source Analyzer, Warehouse designer, Transformation and Mapping Designer, Transformations developer, Informatica Repository Manager and workflow Manager and Informatica workflow monitor.
• Read CSV and Tab delimited file and worked with code page.
• Created .CSV files from excel spreadsheets and loaded into the target Oracle Database.
• Worked with memory cache for static and dynamic cache for better throughput of sessions containing Rank, Sorter, lookup, joiner, Aggregator transformations.
• Wrote UNIX shell scripts extensively.
• Mentor and tutor Informatica users on the Power Center product suite.
• Created deployment groups for each iteration releases.
• Created labels for deployment groups for migration.
• Installed/configured SAP BW power connect for Informatica Power Center.
• Retrieved data from SAP BW for the target tables in Oracle.
• Did extensive data validation on SAP BW objects.
• Managed tools and services of Informatica.
• Managed user and folder permissions for the developers.
• Retrieved data from Unstructured sources like XML, Adobe using Informatica B2b DT and DE.
• Purged old repository objects weekly.
• Created shell script for repository backup weekly.
• Configured DAC with Informatica workflows in sync with OBIEE workflows.
• Developed data Mappings between source systems to Landing and from Standardization to warehouse components using Mapping Designer.
• Worked extensively on different types of transformations like source qualifier, expression, filter, aggregator, rank, update strategy, lookup, stored procedure, sequence generator, joiner.
• Did performance tuning on the mappings developed by developers.
• Wrote PL/SQL Packages, Stored procedures to implement business rules and validations in the actuarial system.
• Looked up and read session, event and error logs for troubleshooting.
• Created Informatica unit testing document.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Problem resolution involves resolving the issues raised by the client/actuarial users, validation of the data in the database or in the application functionality.
• Worked closely with Cognos Developers for building cubes and upgrade from Cognos 8.3 to 8.4.1.
• Optimizing/Tuning mappings/sessions, indexing and partitioning for better performance and efficiency.
• Created the reusable transformations for better performance.
• Design and implement data verification and testing methods for data warehouse.

Environment: Informatica Power center 9.5.1/9.1/8.6.1 , Informatica Metadata Manager, Informatica Data Quality 8.6.2, Informatica B2B DT and DE, Informatica Data Explorer, Oracle 11g/10g, SAP BW, OBIEE, Windows 2003/2008, Sun Solaris, Red Hat Linux, SUSE Linux, Talend Open Data Profiler, XML Sources, Cognos ePlanning 8.4.1, UNIX as Server and Citrix as Client, Exceed Autosys Tool and UNIX Shell Script.

Confidential, HOUSTON, TX

ETL Informatica/DW Developer

Responsibilities:

• Analyzed the source data, coordinated with Data Warehouse team in developing Relational Model and Participated in the Design team and user requirement gathering
• Involved in Designing ER models (Logical/Physical) for Oracle database to store data retrieved from other sources including legacy systems
• Extensively used Informatica Power Center 8.6.1 to extract data from various sources and load in to staging database
• Participated in the detailed level and high-level design documentation of the ETL system and mapping of business rules
• Interacted with business representatives for Need Analysis and to define Business and Functional Specifications
• Expertise in the optimization of the performance of the Designed workflows processes in Informatica and to identify the bottlenecks in different areas after the full volume system run
• Implemented Slowly Changing Dimension methodology for accessing the full history
• Created Several Informatica Mappings to populate the data into dimensions and fact tables
• Worked cooperatively with the team members to identify and resolve various issues relating to Informatica and other database related issues.
• Created visio diagram for scheduling UNICA jobs.
• Developed standard and re-usable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, and filter
• Developed Workflows and session to load data into targets
• Extensive use of Command tasks, Decision tasks, email tasks in the workflow design
• Developed the Test Scripts and performed the Unit Tests on the ETL mappings
• Used DT/designer to validate the physical model of data warehouse or data mart
• Extensively used DT/Studio to define the mapping process and identify about the data flow from source to target by using Data Flow Designer
• Used DT/Studio Designer to extract multiple sources such as XML files, flat files, Oracle tables and SQL Server tables for the target
• Used Power Exchange interface to get the data from mainframe files
• Used batch process CDC (change data capture) mechanism in Power Exchange to get the recent data
• Created IDQ Algorithm and Identified duplicate records from the source data by using IDQ
• Standardize and configure the mappings with data quality transformations to compare the values on a field-field basis by using IDQ Workbench
• Used Standardize transformation to identify the customer information such as spelling in the columns, address, number format of SSN and telephone area code etc
• Used Address Validator transformation to format the data by analyzing input/output ports
• Extensively used transformations such as Source Qualifier, Aggregator, Expression, Lookup, Router, Filter Update Strategy, Joiner, Transaction Control and Stored Procedure
• Scheduled sessions and work flows using Autosys / Informatica scheduler
• Worked with pre and post sessions and Created Workflows and used various tasks like Email, Event-wait and Event-raise, Timer, Scheduler, Control, Decision, Session in the workflow manager
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval
• Developed the Test Scripts and performed the Unit Tests on the ETL mappings
• Successful code migration from DEV to Testing & Production environment

Environment: Informatica Power Center 8.6.1/8.1.1 sp4, Informatica PowerExchange 8.6.1, Embarcadero DT Studio 8.6.2, Embarcadero Rapid SQL, IDQ (Workbench) 9.0.1, Oracle 11g, DB2, PL/SQL, Erwin 7.2, MS Visio, UNICA, SQL Server 2005, Win-XP, AIX 5.1

Confidential, STAMFORD, CT

Sr. Informatica Developer

Responsibilities:

• Identify tables/Scripts required for full load, daily delta load, and bi-hourly load.
• Lead the team of Datawarehouse developers and provided technical and logistics guidance.
• Document ETL process for full, daily and bi-hourly loads.
• Develop and document ETL validation process.
• Create detailed design documents and Informatica objects.
• Very good understanding of the Novell Network.
• Extracted data from complex XML hierarchical schemas for transformation and load into Teradata and vice versa.
• Used XML source analyzer to extract data from XML files.
• Used Informatica Data Quality (IDQ).
• Performed Teradata SQL tuning for HP Neoview.
• Hands on experience Using ETL platform SQL server integration services (SSIS) 2008 to build innovative ETL based application.
• Used SQL server reporting services (SSRS) using multiple output formats.
• Create Informatica extract scripts and execute extract- relational loader.
• Used IBM Maximo Asset management for planned and unplanned activities.
• Build Neoview mappings and load the GL data to HP neoview.
• Data migration from Teradata to HP Neoview.
• Performed Oracle DBA tasks and performance tuning.
• Validate data loads per plan and also validate load times.
• Used CRC incremental logic for complex fact tables.
• Import data from the data source Peoplesoft HR.
• Updating the Tivoli scheduler for the daily and bi-hourly loads for HP neoview.
• Installation and upgradation of Informatica from 8.1 sp2 to 8.1 sp4 with ebf memory patch.
• Upgradation from Informatica 8.1 sp4 to 8.5 on all the three servers (test, development and production).
• Informatica fix/fast export.
• Hands on experience on Data mirror constellar hub and Transformation server.
• Resolve syntax differences from Teradata to neoview and document it.
• Run benchmarks and complete tuning.
• Analyze the query performance and designed the loading process schedules.
• Resolved migration issues across repositories and for individual objects using objimport and objexport tasks.
• Worked with performance issues of Informatica mappings and tuned ETL mappings for better performance using various techniques and strategies.
• Maintaining Versioning provided by Informatica tool.
• Developed UNIX scripts for automation of Informatica jobs.
• Developed UNIX and PL/SQL scripts for pre and post session processes, creation and dropping the indexes to automate the daily loads.
• Identified and resolved numerous technical and operational problems in the datamart design and ETL implementation.

Environment: Informatica power center 8.1 sp2/sp4/8.5, Informatica Power Exchange, Teradata, HP Neoview, Unix Shell scripting, queryman, oracle 10.2.0.3,Business objects 6.5, Tivoli scheduler, MS SQL Server.

Confidential, BOULDER, CO

ETL/DW Developer

Responsibilities:

• Involved in the full systems life cycle and responsible for all part of designing, developing, testing and implementing
• Experienced in coordinating with offshore team (Deloitte) for day-to-day ETL Progress monitoring
• Interacted with Data Stewards and Subject Matter Experts to efficiently Transform, Extract and Load data sets to interpret business requirement specifications into data mapping
• Evaluated ETL coding specifications accurately and built the same into highly optimized Informatica mappings
• Prepared and Verified the High Level Design (HLD) and Detail Level Design (DLD) documents for Armor Build Datawarehouse
• Interface with the Database Administration Group to ensure proper configuration of database objects in Support of ETL code
• Extracted difference sources from like Staging area, CDMA, Flat Files, XML, Siebel, Metavance
• Created complex mappings for Staging area to EDW and from EDW to DataMart using different transformations like Joiner, Expression, Aggregator, Lookup, Update Strategy, Filter and Router Transformation
• Implemented SCD1 and SCD2 logic in the mappings whenever required
• Created Stored Procedure to load the Calendar Date table and then Calendar Month table
• Used the PMCMD command to run the workflows through UNIX shell scripts and job automation using Autosys scheduling tool
• Involved in performance tuning of the Informatica mapping using various components like parameter files, variables and various caches like Static, Dynamic, Shared, Persistent
• Implemented Email, Command task and Decision tasks and shell scripts in the Post session and Pre session commands
• Performed Data Profiling and Code migrations from DEV to QA, and then PROD repositories and monitoring all the environments
• Used HP-Quality Center for creating and maintaining the history of defects during Integration Testing
• Reviewed HLD/DLD/Code/VISIOs/Unit Test Plans to ensure code is of the highest quality and confirms to standards for implementation of Metavance System
• Successfully developed and delivered Test data for implementation of Metavance System (Armor - Build 2 warehouse) for Unit Testing
• Worked with Production support team and successfully delivered the Claims data for Audit

Environment: Informatica Power Center 8.1, Oracle 10g, Siebel, SQL*Plus, PL/SQL, Rapid SQL 7.3.0, MS Visual Sourcesafe 6.0, MS Visio, HP-CDMA (Access Application), WS FTP Pro 8.02, HP- Quality Center 9.2, Autosys 4.5.0, SQL Server 2005, Win-XP, AIX 5.3 (Korn shell)

Confidential, HOUSTON, TX

ETL/DW Analyst

Responsibilities:

• Prepared the Detail Design Document from the requirements specification document
• Developed various mapplets, Transformations and was responsible for validating and fine-tuning the ETL logic coded into mappings
• Made substantial contributions in simplifying the development and maintenance of ETL by creating re-usable Source, Target, Mapplets and Transformation objects
• Created (or edited existing) Informatica mappings and sessions to accomplish data migrations. Sources were Oracle, Sybase and flat files and load into target
• Created Complex mappings using transformation like Connected/Unconnected Lookup, Filter, Expression, Joiner, Aggregator, Router and Stored Procedure transformations for populating target table in efficient manner
• Re-designed ETL mappings to improve data quality
• Created and managed daily, weekly and monthly data operations, workflows and scheduling processes
• Was responsible for validating the Informatica mappings against the pre-defined ETL design standards
• Provided production support by monitoring the processes running daily
• Performance tuned the Mappings by identifying the bottlenecks in targets, sources, mappings, sessions and workflows and eliminated them
• Recommended tuning options to source/target database DBA team to gain optimum performance

Environment: Informatica PowerCenter 7.1, Oracle 9i/8i, Siebel, DB2, UNIX Shell Scripting, SQL, PL/SQL, TOAD, Sun Solaris 2.6 UNIX HP-UX, Windows 2000

Confidential, GROTON, CT

Informatica Developer

Responsibilities:

• Involved in Designing ER diagrams, logical model (relationship, cardinality, attributes, and, candidate keys) and physical database (capacity planning, object creation and aggregation strategies) for Oracle as per business requirements using Erwin 4.0.
• Wrote stored procedures in PL/SQL and UNIX Shell Scripts for automated execution of jobs
• Extracted, Transformed and Loaded OLTP data into the Staging area and Data Warehouse using Informatica mapping and complex transformations (Aggregator, Joiner, Lookup, Normalizer, Filter)
• Extracted data from various sources like Oracle8i, Sieble, and DB2
• Wrote validations using PL/SQL Stored Procedures before transferring data from temporary table to Interface tables
• Created Informatica Relational Database Connections, FTP Connections in Workflow Manager
• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Batches and Sessions and scheduling them to run at specified time with required frequency
• Migrated objects like mappings and workflows to different environments
• Created Autosys Jobs for Scheduling

Environment: Informatica PowerCenter 6.2, Autosys, COBOL, Oracle8i, Siebel, DB2, Toad, Erwin 4.0, PL/SQL, UNIX Shell Scripting, Windows NT, UNIX