SUMMARY

• Over 8years of IT experience in analysis, design, development, testing and implementation of data warehouses as an ETL Developer using Informatica.
• Experience in various business domains like Finance, Insurance, Healthcare and Pharmaceuticals.
• Have clear understanding of Data warehousingnd Business Intelligence concepts with emphasis on ETL and life cycle development Using Informatica Power Center (Repository Manager, Designer, Workflow Manager and Workflow Monitor).
• Extensive experience in developing Slowly Changing Dimensions mapping (Type I&Type II).
• Experience in creating the Workflows, Worklets, Mappings, Mapplets, Reusabletransformations and scheduling the Workflows and Sessions usingInformaticaPower Center
• Experience in designing and developing complex mappings using varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy etc.
• Expertise in OLTP/OLAP System Study, developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional modeling.
• Experience in data conversion of various data sources like Oracle, SQL Server, Fixed Width and Delimited Flat Files, COBOL files & XML Files
• Actively involved in Performance Tuning, Error handlingand Product support on various Platforms.
• Experience in different software development methodologies like Waterfall Model and Agile Software Development process
• Experience in UNIX Shell Scripting and Autosys for scheduling the Workflows.
• Experience in Enterprise Data Integration.
• Experience in scheduling the jobs using CONTROL M and AUTOSYS.
• Extensive experience in the areas of Systems Analysis, Fit - Gap Analysis, Business Process Reengineering, Product Configuration & Implementation, Configuration Management, Development & Deployment ETL tools & Reports, conducting testing and validations, conducting user training, documentation and Production Support.
• Implement procedures to maintain, monitor, backup and recover operations for ETLenvironment.
• Report regularly on health and performance of ETL environment and jobs.
• Perform import and export ETL jobs across various ETL projects and servers.
• Provide development support to ETL application development teams.
• Establish projects, roles, users, privileges in different ETL environments (DEV, QA, PROD).
• Conduct ETL optimization, troubleshooting and debugging.
• Experience in Healthcare data in different projects.
• Extensively worked with the Data Integration. TransformandLoadprocesses fordata integration projectstobuild data marts
• Maintain ownership of release activities interacting with ETL projects..
• Excellent communication and interpersonal skills. Ability to work effectively as a team member as well as an individual.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.6.1/9.0.1/8.6.1/8.1/7.1, Power Exchange version 8,9, Metadata Manager, Data Analyzer

Reporting Tools: BO 4.0/3.1,BO Universe Designer, Launch pad/Info view, Crystal Reports.

Databases: Greenplum, Oracle 9i/10g/11g, SQL-Server 2000/2005/2008, DB2 and MS Access.

Tools and Utilities: Erwin 4.0/3.5.2, MS-Visio, TOAD, SQL Developer, SQL plus Loader, WinSQL, SSIS, Tera Data, SAP Power connect.

Languages and Web Technologies: SQL, PL/SQL, HTML, XML, C, UNIX Shell Scripting, Autosys. Java,J2EE, Web Services.

Operating Systems: Windows NT, Windows Server 2008/2012 Windows 7

PROFESSIONAL EXPERIENCE

Confidential, Madison, WI

Senior ETL Developer

Responsibilities:

• Interacted with business community and gathered requirements based on changing needs and incorporated identified details into Informatica mappings to build Data Marts.
• Analyzed business requirements to understand source data systems and developed mappings between source systems and warehouse system.
• Extensively analyzed and used Ralph Kimball approach for building Data warehouse.
• Worked with Power Center - Designer tool to develop mappings and mapplets to extract and load the data from flat files and Oracle to Greenplum.
• Used Power exchange CDC (change data capture) for pulling from oracle source.
• Created different transformations like Source Qualifier, Joiner transformation, Update Strategy, Lookup transformation, Rank Transformations, Expressions, Aggregator, Sequence Generator for loading the data into targets.
• Extensively worked on SCD Type I and Type II mappings.
• Worked with different source systems like Relational tables, Flat files & SAP power connect.
• Involved in migrating the mappings and workflows to quality and then production environment.
• Experienced with functional web services tests
• Extensive experience Product Configuration & Implementation, Configuration Management, Development & Deployment ETL tools & Reports.
• Skilled with creating automated web services testing processes
• Created parameter file as per Amfam standards.
• Developed Unit test documents by testing the mappings.
• Extensively worked on Data Integration from multiple sources.
• Experience in scheduling the jobs using Autosys based on the requirement.
• Created and modified complex Reports usingBusinessObjectsmodule that comprised multiple data providers, charts, ranking etc

Environment: Informatica Power Center9.5.1, Informatica Power Connect, Work Flow Monitor, Green Plum,DB2, Business Objects 4.0/3.1, XML, Flat files, TOAD7.0, Unix Shell Scripting.

Confidential, Los Angeles, CA

Senior ETL Developer

Responsibilities:

• Extensively worked on Business Analysis and Data Analysis.
• Interacted with business community and gathered requirements based on changing needs and incorporated identified factors into Informatica mappings to build Data Marts.
• Extensively analyzed and used Ralph Kimball approach for building Data warehouse..
• Worked with Power Center - Designer tool in developing mappings and mapplets to extract and load the data from flat files, Oracle to Oracle.
• Used Power exchange CDC (change data capture) for pulling from oracle source.
• Created different transformations like Source Qualifier, Joiner transformation, Update Strategy, Lookup transformation, Rank Transformations, Expressions, Aggregator, Sequence Generator for loading the data into targets.
• Used Mini dimensions for large and rapidly changing dimensions.
• Created reusable transformations and Mapplets to use in multiple mappings.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Used SQL override option in Source Qualifier Transformation to improve query performance.
• Scheduled Sessions on the Informatica Server using Informatica Server Manager.
• Created Tasks, Workflows and Worklets using Workflow Manager. Monitoring of Workflows and Worklets using Workflow Monitor..
• Experience in Product Configuration & Implementation, Configuration Management, Development & Deployment ETL tools & Reports, conducting testing and validations, conducting user training, documentation and Production Support.
• Worked with reporting professionals for creating views and altering some of the dimensional tables to satisfy their reporting needs.
• Moved the mappings and workflows to staging and then production environment and tested the process at every level.
• Created different types of Business Objects Reports such asMaster/Detail, Cross Tab and Charts by using filter conditions, calculations, Alerts, ranking and report level variables.

Environment: Informatica Power Center9.5.1, Informatica Power Connect, Work Flow Monitor, Oracle 11g, DB2, Business Objects 4.0/3.1, XML, Flat files, TOAD7.0, Unix Shell Scripting.

Confidential, Thousand Oaks, CA

Senior ETL Developer

Responsibilities:

• Worked with different Informatica client Tools like Source Analyzer, warehouse designer, Mapping designer, Mapplets Designer, Transformations developer, Informatica Repository Manager and Informatica workflow designer, and workflow monitor.
• Worked with Business requirements analysts to identify and understand source data systems and developed mappings between source systems and warehouse components.
• Extensively created different complex mappings using expressions, aggregators, filters, lookup, router, joiner, sorter and procedures to develop and feed in Data Warehouse and used Update strategy transformation to transfer data from source to target effectively.
• Responsible for creating Workflows and sessions using Informatica workflow manager and monitor the workflow run and statistic properties on Informatica Workflow Monitor.
• Used debugger to validate mappings and gain troubleshooting information about data and error conditions.
• Involved in creating shell scripts for various database objects related to the data model, which involve in creation of schema, tables, sequences, views, Materialized views, constraints, and indexes.
• Sound knowledge in migrating mappings from development to testing and then to production.
• Used SQL, PL/SQL, and TOAD to validate the Data going in to the Data Ware House.
• Extraction involved in the development of Informatica mappings and also tuned them for better performance.
• Migrated Informatica folders, mappings, workflow, reusable objects from one environment to another and in the process of change control.
• Monitoring the existing ETL jobs and take necessary actions as per the error handling methodology.
• Experience in scheduling the jobs using CONTROL M and AUTOSYS based on the requirement.
• Extensively used ETL to load data from Flat files.
• Involved in creating the reports using Business Objects.
• Involved in maintaining existing Universes using Designer.
• Worked on Aggregate awareness, row and column level security functionalities in Universe.
• Involved in unit testing and integration testing.
• Involved in FTP process to transfer the files from one server to other.
• Worked with Autosys team to setup jobs and their dependencies.

Environment: Informatica Power Center 9.1, Oracle 10g, PL/SQL, SAP R/3, TOAD, andWindows 7, UNIX Shell Scripts.

Confidential, OH

ETL Developer

Responsibilities:

• Responsible for preparing ETL strategies for extracting data from different datasources like Oracle, SQL Server, flat file, and XML file.
• Developed low-level documents from high-level documentation to create informatica mappings.
• Created mappings to load source data into target tables using transformations like the Joiner, Expression, Filter, Lookup, Update, Rank and Sorter based on the business needs.
• Worked in various healthcare areas like Enrollment, Benefits and Claims..
• Implemented the ETL processes using Informatica to load different claim transactions into warehouse.
• Worked extensively with dynamic cache using the connected & unconnected lookup transformations.
• Designed and developed the Informatica workflows/sessions to extract, transform and load the data into oracle server.
• Extensively worked on Slowly Changing Dimensions - Type I & TYPE-II mappings.
• Used parameter files to initialize workflow variables, mapping parameters and mapping variables and used system variables in mappings for filtering records in mapping.
• Involved in discussions with business analysts and source and target system experts to map requirements to Informatica code.
• Responsible for developing Informatica development life cycle process documents.
• Prepared ETL specifications based on high-level design specification document.
• Analyzed the data models of the source systems to develop Mapping Specs.
• Informatica Power Center was used to extract, transform and load data from different operational data sources like Oracle, DB2, flat files in to Data staging area (Oracle).
• Informatica workflow manager was used to create, schedule, execute Sessions, Worklets, Command, E-Mail Tasks and Workflows.
• Developed and Implemented UNIX shell scripts through command task to handle requirements like dropping and building indexes, flat file archiving/dropping process etc.
• Extensively used Informatica Debugger to figure out the problems in mappings. Also involved in troubleshooting existing ETL bugs..
• Extensively worked in the performance tuning for the mappings and ETL Procedures both at
• Generated reports using Crystal Reports 10

Environment: Informatica Power Center 8.6.1, Oracle 9i, DB2, Crystal Reports 10, PL/SQL, SQL *Plus, Toad.

Confidential

ETL Developer

Responsibilities:

• Involved in full life cycle implementation of the project
• Helped Architect in design and development of Conceptual, Logical, and Dimensional Data Models for the Data Warehouse.
• Extensively involved in ETL code using Informatica ETL tool in order to meet requirements for extraction, transformation, cleansing and loading of data from source to target data structures.
• Wrote functional and technical plans for transformation and loading the Data Mart
• Developed transformation logic and designed various complex Mappings and Mapplets using the Designer.
• Performed tuning of the Mappings and optimized the mappings to provide maximum efficiency and performance.
• Created mappings using various transformations like Lookup, Aggregator, Expression, Router, Filter, Update Strategy transformations, Sequence generator.
• Designed complex mappings involving target load order and constraint based loading.
• Creating / Building and Running / scheduling workflows using the Workflow Manager.
• Configured and used the Debugger to troubleshoot the mappings.
• Set up batches of Worklets and sessions to schedule the loads at the required frequency.
• Developed UNIX shell scripts and used Autosys for automation of ETL processes.
• Actively involved in training and support.
• Involved in creating the reports using Business Objects.
• Involved in maintaining existing Universes using Designer

Environment: Informatica Power Center 8.1, Oracle 9i, Toad 8.5, Windows NT, Business Objects.

Confidential

ETL Developer

Responsibilities:

• Developed mappings using Power Mart Designer.
• Created transformations according to the business requirement.
• Created workflows for the different tasks using Workflow Manager.
• Developed Event Wait Tasks for the workflow.
• Developed Reusable Sessions.
• Involved in scheduling the workflows.
• Created flat file targets.
• FTP the Flat File target to Remote Server.
• Creating Users, Folders, Assigning access Permissions to repository Users.
• Developed Stored Procedures according to the requirement.

Environment: Informatica 7.1, Oracle 8i, PL/SQL, UNIX and Windows NT.