Professional Summary

• About 9 years of IT experience in System Analysis, Design, Development and Maintenance of various software applications in client-server environment.
• Extensive experience in using Informatica Power Center 9.1.0/8.6.1/8.1.1/7.1.1/7.0, Source Analyzer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager, Work flow Monitor, Datamart, OLAP, OLTP, Mapplet, Transformations and SQL Plus.
• Worked extensively with Dimensional modeling, Data migration, ETL Processes for Data Warehouses.
• Experience in Data Warehouse/Data Mart Development Life Cycle and performed ETL procedure to warehouse using Informatica Power Center, load data from different sources systems into data
• Adept at understanding business processes / requirements and implementing them through mappings and transformations.
• Expert-level mastery in designing and developing complex mappings to extract data from diverse sources including flat files, RDBMS tables, legacy system files.
• Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Aggregator, Stored Procedure, Sorter and Sequence Generator.
• Strong Experience and knowledge in creating Stored Procedure and Trigger using Oracle 10g/9i.
• Highly Skilled with the Integration of various data sources like Oracle 10g, DB2, SQL Server, Flat Files, Teradata, XML and IBM Mainframe COBOL files.
• Strong experience in Data warehousing concepts, Star Schema and Snowflakes Schema methodologies used in relational, dimensional modeling and multidimensional modeling, Data Profiling and Data cleansing.
• Actively involved in Performance Tuning, Error handling, Product support on various Platforms.
• Used Informatica debugger to debug mappings to gain troubleshooting information about data and error conditions.
• Experience in UNIX Operating System and Shell scripting.
• Worked in Development, Production and Maintenance Support Projects
• Worked as Associate ETL Architect.
• A Very good team Player with excellent communication, analytical, verbal, writing and interpersonal skills.

Technical Skill Sets

Professional Experience

Confidential

Senior ETL Developer

Responsibilities at State:

• Involved in analysis, requirements gathering, function/technical specifications, development, deploying and testing.
• Involved in all the phases of project Client Interaction, Gathering requirements from Business users, Preparation of detail design, Development, Unit Testing and Production support .
• Created Informatica Mappings to load data using transformations like Sorter, Aggregator, Expression, Joiner, and Connected and Unconnected lookups, Filters, Sequence, Router and Update Strategy.
• Extensively used Source Qualifier Transformation to filter data at Source level rather than at Transformation level.
• Created scripts in PL/SQL to automate the process of creating and dropping indices before and after the ETL process.
• Cleansed the source data, extracted and transformed data with business rules, and built reusable transformation logic, known as 'Mapplets' using Informatica Designer.
• Modified several of the existing mappings and created several new mappings based on the user requirement.
• Used the Debugger in debugging some critical mappings to check the data flow from instance to instance.
• Created various tasks like sessions, worklets, and workflows in the workflow manager to test the mapping during development.
• Involved in Performance tuning of various mappings and sessions to increase the performance.
• Extensively worked on tuning and thereby improving the load time.
• Developed and executed UNIX scripts to schedule loads, through wrapper shell scripts for calling Informatica workflows using PMCMD command.
• Daily Data Validation and data quality checks at database level using SQL scripts.
• Developed the mapping to pull the information from different tables and used SQL Override to join the tables instead of Joiner transformation to improve the performance
• Responsible for monitoring all the sessions that are running, scheduled, completed and failed using Autosys. Debugged the mapping of the failed session.
• Developed all the mappings according to the design document and mapping specs provided and performed unit testing.
• Created static and dynamic deployment groups to deploy the ETL objects from Dev to test and from test to production.
• Reviewed the ETL mappings and data samples loaded in the test environment for data validation.

Environment: Informatica Power Center 9.1,Oracle10g, SQL, PL/SQL, Power Exchange 9.1, UNIX, Microsoft SQL Server2008, TOAD, Autosys, Visio, Microsoft Winscp, Windows 2000 Server, Putty

Confidential

Data Conversion ETL Developer

Key Projects at State Farm:

• Auto estimating Data Loading.
• Market Class Data Loading.
• Repair Facility Data Loading.

Responsibilities at State Farm:

• Involved in analysis, requirements gathering, function/technical specifications, development, deploying and testing.
• Involved in all the phases of project Client Interaction, Gathering requirements from Business users, Preparation of detail design, Development, Unit Testing and Production support .
• Created Informatica Mappings to load data using transformations like Sorter, Aggregator, Expression, Joiner, and Connected and Unconnected lookups, Filters, Sequence, Router and Update Strategy.
• Extensively used Source Qualifier Transformation to filter data at Source level rather than at Transformation level.
• Created scripts in PL/SQL to automate the process of creating and dropping indices before and after the ETL process.
• Cleansed the source data, extracted and transformed data with business rules, and built reusable transformation logic, known as 'Mapplets' using Informatica Designer.
• Modified several of the existing mappings and created several new mappings based on the user requirement.
• Used the Debugger in debugging some critical mappings to check the data flow from instance to instance.
• Created various tasks like sessions, worklets, and workflows in the workflow manager to test the mapping during development.
• Involved in Performance tuning of various mappings and sessions to increase the performance.
• Extensively worked on tuning and thereby improving the load time.
• Developed and executed UNIX scripts to schedule loads, through wrapper shell scripts for calling Informatica workflows using PMCMD command.
• Daily Data Validation and data quality checks at database level using SQL scripts.
• Developed the mapping to pull the information from different tables and used SQL Override to join the tables instead of Joiner transformation to improve the performance
• Responsible for monitoring all the sessions that are running, scheduled, completed and failed using Autosys. Debugged the mapping of the failed session.
• Developed all the mappings according to the design document and mapping specs provided and performed unit testing.
• Created static and dynamic deployment groups to deploy the ETL objects from Dev to test and from test to production.
• Reviewed the ETL mappings and data samples loaded in the test environment for data validation.

Environment: Informatica Power Center 8.6, Oracle10g, SQL, PL/SQL, Power Exchange 8.6, Microsoft SQL Server2005, TOAD, MKS Toolkit, MKS Scripting, Avaya CMS, Visio, Microsoft VSS, Windows 2000 Server.

Confidential

Enterprise Data Warehouse EDW programmer

Responsibilities

• Involved in data analysis, design, and development and Production stages of data warehouse Environment.
• Developed design documents, technical specifications for mappings and sessions based on user
• Requirements.
• Extensive experience in creation of ETL mappings and transformations to reflect business rules using Informatica Power Center to move data from multiple sources into target area, source systems is mainly flat files and relational tables.
• Designed and developed ETL routines, using Informatica Power Center. Within the Informatica
• Mappings, usage of Lookups, Aggregator, Ranking, connected and unconnected Lookups, Source Qualifiers and data flow management into multiple targets using Routers was extensively done.
• Created parameter files using the mapping parameters in mappings.
• Experienced in using Mapplets, Mapping variables in Informatica mappings.
• Experienced with Dimensional Data Modeling Techniques like Star Schema, Snowflake Schema, Surrogate Keys, Conformed dimensions and slowly changing dimensions modeling design.
• Migrated mappings from Development to Production folders.
• Fixing invalid Mappings, Unit and Integration Testing of Informatica Sessions, Batches and Target Data Analysis and Design of Migration Procedures for the DB Migration between Relational and Extended ERP Data Sources.
• Performed Database Migration from sources to the Data Warehousing database. Worked closely with Oracle DBA for migration support.
• Implemented efficient and effective performance tuning procedures.

Environment: Informatica Power Center 8.1 Informatica Designer, Repository Manager, Workflow Manager, Workflow Monitor , Windows XP, Oracle 10g, Toad, UNIX.

Confidential

Key Projects

• Group Facts Application
• Assurant Branding Project

Responsibilities

• Involved in analysis, requirements gathering, function/technical specifications, development, deploying and testing.
• Involved in all the phases of project Client Interaction, Gathering requirements from Business users, Preparation of detail design, Development, Unit Testing and Production support .
• Created Informatica Mappings to load data using transformations like Sorter, Aggregator, Expression, Joiner, and Connected and Unconnected lookups, Filters, Sequence, Router and Update Strategy.
• Extensively used Source Qualifier Transformation to filter data at Source level rather than at Transformation level.
• Cleansed the source data, extracted and transformed data with business rules, and built reusable transformation logic, known as 'Mapplets' using Informatica Designer.
• Modified several of the existing mappings and created several new mappings based on the user requirement.
• Used the Debugger in debugging some critical mappings to check the data flow from instance to instance.
• Created various tasks like sessions, worklets, and workflows in the workflow manager to test the mapping during development.
• Involved in Performance tuning of various mappings and sessions to increase the performance.
• Extensively worked on tuning and thereby improving the load time.
• Involved in the error checking and testing of ETL Procedures using Informatica Session log and workflow logs.
• Developed and executed UNIX scripts to schedule loads, through wrapper shell scripts for calling Informatica workflows using PMCMD command.
• Daily Data Validation and data quality checks at database level using SQL scripts.
• Developed the mapping to pull the information from different tables and used SQL Override to join the tables instead of Joiner transformation to improve the performance
• Reviewed the ETL mappings and data samples loaded in the test environment for data validation.

Environment: Informatica PowerCenter 7.1.3, Informatica Power Exchange ,Oracle 9i, SQL Server 2000, Flat Files, SQL, PL/SQL Stored Procedure, Trigger ,Teradata, Erwin 3.5, TOAD ,MS Visio, Windows 2000, UNIX AIX.

Confidential

Software Developer

Responsibilities

• Studied the project requirement and designed the project.
• Created tables, views, synonyms and sequences
• Created Database Triggers, Stored Procedure and Functions
• Optimized queries using rule based cost based approach.
• Used SQL Loader for data loading.
• Modified existing forms, reports, and graphs as per the enhancement.
• Tested all the new and modified program units.

Environment: Oracle 8i, Windows 98, UNIX, MS Office and MS excel.