SUMMARY

• 8+ Years of IT Experience in Software Design, Development, Testing and Deployment using SDLC life cycle.
• Having good exposure in designing and implementing the Data Warehouse applications, mainly Transformation processes using ETL tool Informatica Power Centre 9.5/9.1.0/8.6/8.1.1.
• Have involved in end to end project activities i.e. from gathering Business needs, converting them into requirements, analysis, design activities, build to testing phases, reviews and in release management.
• Extensively used Informatica for ETL purposes on various sources and targets like Flat files, Oracle 10g, SQL Server 2012, Sales force, Mainframe DB2 and Netezza.
• Extensive hands - on expertise using Informatica Power Center with strong business understanding (domains) of Insurance, Banking and financial services.
• Extensively worked with various components of the Informatica Power Center - Power Center Designer (Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Transformation developer), Repository Manager, Workflow Manager, and Workflow Monitor to create mappings, tasks and workflows for the extraction of data from various source systems to targets.
• Experience in implementing complex business rules by creating re-usable transformations, and robust mappings/mapplets using different transformations like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Stored Procedure, Normalizer etc.
• Proficient in full life cycle development of Data Warehousing, ETL strategies, reporting and hands on experience in Performance Tuning of sources, targets, transformations, mappings and sessions using Database Tuning, Index Usage, Aggregate Tables, Load strategies, commit intervals and transformation tuning.
• Extensive experience in integrating data from various Heterogeneous sources like Relational databases (Oracle, SQL Server), Flat Files (Fixed Width and Delimited) into Data Warehouse and Data Mart.
• Experience in PL/SQL Programming (Stored procedures, Triggers, Functions and Packages) and UNIX shell scripting.
• Good experience in documenting the ETL process flow for better maintenance and analyzing the process flow.
• Sound knowledge in administration tasks including importing/exporting Informatica objects, versioning to maintain objects history.
• Developed complex mappings and SCD type-I and Type-II mappings in Informatica to load the data from various sources using different transformations and created complex mapplets for reusable purposes.
• Strong in Data warehousing concepts, dimensional Star Schema, Snowflakes Schema methodologies.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.5/9.1/8.6/8.1 (Workflow managerWork Flow Monitor, Source Analyzer, Transformation developer, Mapplet Designer, Mapping Designer and Repository manager)

Data Modeling Tool: ERWIN 4.x and Concepts like Star Schema ModelingSnowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling.

Databases: Oracle 10g/9i, DB2 9.5, SQL Server 2012/2008, NetezzaLanguages SQL, PL/SQL, UNIX Shell Script, C, C++.

Development Tools: SQL *Plus, TOAD, SQL Developer, Putty, HP Quality CenterSQL Server management studio.

Scheduling Tools: Control M, Informatica Scheduler.

Operating Systems: Windows XP/NT/2008, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Madison WI

Sr. Informatica Consultant

Responsibilities:

• Extensively involved in all the phases of Project life cycle right from Requirements Gathering to Testing etc.
• Coordinated with Client SMEs and offshore team to get the requirements and get the code delivered in timely manner and with high quality and performance.
• Worked on coming up with templates for Source to Target Document, ETL Detail Design Document, Unit Test Plan, Code review checklist, Migration Check List and Production Handoff document.
• Created mappings using the Transformations like Source qualifier, Aggregator, Expression, Lookup, Router, Filter, Rank, Sequence Generator, and Update Strategy for the data integration.
• Involved in peer reviews of the code to ensure all the standards are implemented and tuned mappings in order to bring down the run time by using Informatica partitioning if needed.
• Performed thorough Unit testing & Integration testing using sample data from PROD, once the code is reviewed and met the standards, promoted to higher environments.
• Supported in UAT testing and fixed the defects and thoroughly tested them back and promoted to UAT for further testing.
• Build the deployment plan for every release to consolidate all the objects and backfills to the upper environments and laid out the execution plan.
• We constantly monitored the cycle run times and looked into the long running jobs and did performance tuning in order to meet the SLAs.
• Scheduled and ran Extraction-Load process and monitored tasks/workflows using the Workflow Manager and Workflow Monitor.
• Troubleshoot problems by checking sessions/error logs in the Workflow Monitor and also used debugger in Mapping Designer to debug complex mappings.
• Used the client tools (Ivalidator, dbView and db compare) to validate the informatica objects and compare the source and target data.
• Maintained all the standards and implemented the best practices in our development process.

Environment: Informatica Power Center 9.5, SQL Server 2012, SAP Business Objects 4.0, HP Quality Center, Control M

Confidential, Phoenix, AZ

Sr. Informatica Consultant

Responsibilities:

• Understand the Business Requirements in depth.
• Analyze the requirements of the business users by using ETL Specifications.
• Developed Entity Level, High level & Detail design documents based on requirement documents.
• Worked with Source Analyzer, Warehouse Designer, Transformation designer, Mapping designer and Workflow Manager.
• Developed Informatica Mappings and Sessions based on business user requirements and business rules to load data from source flat files & Sql server tables to flat files.
• Did performance tuning at source, transformation, target, and workflow levels.
• Parameterized the mappings and increased the re-usability.
• Used the transformations such as the Source Qualifier, Aggregator, Expression, Update strategy, Lookup, Sequence Generator, Normalizer, Union and Filter.
• Understand the existing vb scripts and do the required changes as per requirements.
• Perform Unit testing to ensure that the code is working properly
• Performance tuning of Sources, Targets, Mappings and Sessions by identifying bottlenecks and used Debugger to debug the complex mappings and fix them.
• Involved in Integration testing of the module after integrating all the data marts
• Perform Migration from one environment to another environment across the repositories.

Environment: Informatica Power Center 9.1, VBScript, MSSQL 2008, Cognos, HP Quality Center 10, AXIOM systems

Confidential, Phoenix, AZ

Sr. Informatica Consultant

Responsibilities:

• Understanding the requirements and translating them into technical requirements.
• Worked on Power Center Designed client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Extracting, transforming and validating the data and loading the data into Database Netezza.
• Extensively used transformations like Application source Qualifier, Unconnected Lookup, Aggregator, Filter, Router, Expression, Joiner, Sequence generator.
• Developed standard mappings using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, and filter.
• Created many reusable tasks and used them in different Worklets and Workflows.
• Involved in Preparation of Low level Design documents.
• Responsible for Testing and validating the Informatica mapping against the pre-defined ETL design standards.
• Prepared the UNIX shell scripts to perform the file level validations.
• Created the Unit Test Plans and did Unit Testing in E1 environment.
• Successfully moved the Mappings, Sessions and workflows from the Development environment to Production environment.
• Monitoring execution of implemented job in production during the warranty period and fix the identified issues.
• Provide knowledge transfer & process documents to Production Support for ongoing maintenance of the code.
• Completed documentation in relation to detailed work-plans, mapping documents and high-level data models.

Environment: Informatica Power Center 9.1, DB2 9.5, UNIX Shell Scripting, Netezza, Quality Center 10

Confidential

Informatica Developer

Responsibilities:

• Proficient in understanding business processes/requirements and translating them into technical requirements
• Worked on PowerCenter Designed client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Designed, developed mappings, enabling the extract, transport and update the data Salesforce.
• Extensively used transformations like Unconnected Lookup, Aggregator, Filter, Router, Expression, Joiner, Sequence generator and update strategy.
• Responsible for Testing and validating the Informatica mapping against the pre-defined ETL design standards.
• Perform Unit testing to ensure that the code is working properly
• Performance tuning of Sources, Targets, Mappings and Sessions by identifying bottlenecks and used Debugger to debug the complex mappings and fix them.
• Perform Integration testing of the module after integrating all the data marts
• Perform Migration from one environment to another environment across the repositories.
• Involved in production support activities.

Environment: Informatica Power Center 8.6.1, Sales force, BMC Remedy, Sql server 2008.

Confidential

ETL Developer

Responsibilities:

• Understand the Business Requirements in depth.
• Analyze the requirements of the business users by using ETL Specifications.
• Developed Designs both at High Level and Low Level for the ETL solutions Proposed.
• Developed the Mappings, sessions and workflows.
• Imported required target tables into target designer.
• Constructed ETL Logic for Staging Database using FULL LOADING.
• Constructed ETL Logic for Dimension tables using SCD 1 and SCD 2 from DELTA LOADING.
• Constructed ETL Logic for Fact tables using INCREMENTAL LOADING.
• Perform Unit testing to ensure that the code is working properly
• Performance tuning of Sources, Targets, Mappings and Sessions by identifying bottlenecks and used Debugger to debug the complex mappings and fix them.
• Perform Integration testing of the module after integrating all the data marts
• Perform Migration from one environment to another environment across the repositories.
• Involved in production support activities.

Environment: Informatica 8.6.1, Oracle 10g,Contro M,TOAD, HP Quality Center, Cognos.

Confidential

ETL Developer

Responsibilities:

• Understand the business requirements and translating them into technical requirements.
• Extensively used Informatica to extract data from various Operational Systems, External Systems and Staging Area.
• Used heterogeneous data sources, like flat files and Oracle.
• Applied Complex Mappings and various Transformations (Filter, Router, Lookup, Update Strategy, and Expression) on the extracted data according to the Business Rules and Technical Requirements.
• Created mappings using the transformations such as the Source qualifier, Aggregator, Expression, Router, Filter, Rank, Sequence Generator, and Update Strategy.
• Worked on connected as well as unconnected Lookup transformation to look up values in a table.
• Creating reusable transformations and mappings using Informatica.
• Used debugger to test the data flow and fix the mappings.
• Worked on Performance Tuning of various mappings and sessions to identify and remove Bottle Necks, created and monitored Informatica sessions.

Environment: Informatica Power Center 8.1.1, Oracle 9i, Sql Server, TOAD, UNIX.