Informatica Developer

P V V Prathap Email:ac0s4f@r.postjobfree.com

+1-848-***-**** https://www.linkedin.com/in/veera-venkata-prathap/

Summary:

Overall 9 Years of experience in Data Warehouse environments.

Proven experience in Leading the design, development and implementation of Data Warehouse Projects as well as Data Migration Projects

Involved in IDQ for Data profiling, Data Parsing & Data Standardization.

Involed in Data Analytics to create the hign level design for Migration.

Worked with Rules, Mapplets, key generator, Case converter, Merge, Exception and Consolidation Transformations.

Involved in creating a Data Model for implementing to Land Process of loading the customer/product Data Set into Informatica MDM 10.1 from various source systems.

Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.

Strong Data warehousing experience using ETL Tool-Informatica Power Center, (Source Analyzer, Warehousing Designer, Mapping Designer, Mapplet, Transformations).

Experience in loading data from Oracle database and MS SQL Server databases.

Involved in creating Low level ETL design documents.

Experience in Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.

Implemented slowly changing strategy to manage the data in the dimension tables.

Experience in Designing Reusable Transformations (Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank) and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.

Developed mappings in Informatica 7.1, 8.6.1 and 9.1 to Extract, Transform and Loading the data from various sources into the Data Warehouse and Data Migration using different transformations like Source Qualifier, Expression, Filter, Lookup, Update Strategy, Router, Sequence generator & Data Masking.

Extracted data from various source systems like flat files as per the requirements.

Worked on Workflow Manager and Workflow Monitor to create schedule, monitor Workflows, Worklets and various tasks like Command, Email and Session tasks.

Involved in preparation of Unit Test Cases (UTC) & Execution of Unit test cases.

Extensively worked with Development and Production Environments.

Excellent communication skills, able to explain complex technical structures in an understandable user- friendly format.

Team player with strong communication and interpersonal skills.

Proficient in interaction with the business users by conducting meetings with the clients in Requirements Analysis phase. Extensive functional and technical exposure. Experience working on high-visibility projects.

Education: MTech from JNTU Campus, Hyderabad India in 2009.

Technical skills

ETL

Informatica MDM 10.1,Informatica PowerCenter9.x/8.x/7.x/6.x, Informatica Data Quality (IDQ),SSIS.

Databases

Oracle 11g,10g,9i,8i, SQL Server 2000, DB2

Languages

SQL, PL/SQL, Unix

DB Tools

Toad, Sql Developer, SQL* plus, SQL* Loader, Import, Export

Scripting

Windows, Unix.

OS

Windows 7/Vista/XP/2003/2000/NT/98/95, Sun Solaris 2.x, HP-Unix, Red.

Reporting

Tableau, BO

EXPERIENCE:

SHELL Sep'11 –Till Date

Lead Analyst.

The Horizon program is concerned with providing a service to manage Shell Fuel card operations. In order to migrate the business data from the current suite of systems into the new H3 suite there is a significant data migration activity. There are circa 39 countries in scope for transformation to the new H3 applications set. The Data Migration solution is divided into eight functional areas. Each functional area is decomposed into a set of software modules for technical implementation, that define the set of steps required to transform the businesses data from source to target formats. So in order to migrate, ETL & MDM process is used to load the data for different countries.

Responsibilities:

Perform data profiling and Join Analysis on the source data and capture possible source system data anomalies.

Mainly involved in ETL Team Leading, developing and Low Level Design.

Created Source and Target Definitions in the repository using Informatica Source Analyzer and Warehouse Designer.

Extensively worked with Expression, Lookup, Source Qualifier, Router transformations.

Involved in gathering business requirements for the data-warehouse as well as business-intelligence reports to be used by the management.

Implemented Data Profiling and Involved in Data Quality using Informatica Developer creating Data Profiles, Data parsing& Data Standardization Mappings.

Implemented Bad record Exemption using Exception transformation in Informatica Developer.

Extensively worked with Rules, Mapplets, key generator, Case converter, Merge and Consolidation Transformations.

Analyzed the source system for integrity issues to the data resided in various source systems and defined the same in Systems and Trust.

Involved in implementing the Land Process of loading the customer/product Data Set into Informatica MDM from various source systems.

Defined the Base objects, Staging tables, foreign key relationships, static lookups, dynamic lookups, queries, packages and query groups.

Defined the Trust and Validation rules and setting up the match/merge rule sets to get the right master records.

Performed match/merge and ran match rules to check the effectiveness of MDM on data.

Used Hierarchies tool for configuring entity base objects, entity types, relationship base objects, relationship types, profiles, put and display packages

Involved in Admin activities like deploying the code from and Dev to Test and handling the privileges.

Involved in creating, monitoring, modifying, & communicating the project plan with other team members.

Environment:Informatica MDM 10.1,Informatica 9.6,Informatica Developer 9.6,MS SQL Server 2008, Flat Files.

GE Nov’ 09 – Sep'11

Sr. Informatica Developer.

GE Answer Center (GEAC) DW project aims at providing the reporting solution to the business on the GEAC cases which helps immensely in analyzing the consumer experience with GE. Consumers would be calling the GE Answer center on a variety of reasons and each would be created as a GEAC case in the GEAC Siebel application. So, in order to provide a reporting capability, new DW tables would be created and the ETL process need to be developed to load the GEAC cases into these new tables on a daily basis.

Responsibilities:

Involved in understanding the architecture of project upstream systems, down streams system and clients

Created Source and Target Definitions in the repository using Informatica Source Analyzer and Warehouse Designer.

Designed and developed complex ETL mappings making use of transformations like Source Qualifier, Joiner, Update Strategy, Connected Lookup and unconnected Lookup, Rank, Expression, Router, Filter, Aggregator, Sequence Generator and Data Masking.

Implemented error handling and validation rules.

Developed Incremental Load mappings using Dynamic cache.

Extensively worked with debugger to test the data.

Involved in Unit testing of the reports and worked with the end users in performing the user acceptance testing.

Participated in documentation part and tracking progress of Data Profiling project.

Extensively involved in testing the system from beginning to end to ensure the quality if the adjustments made to oblige the source system up-gradation.

Involved in code migration.

Involved in Data Masking workshop by Informatica corporation

Environment:Informatica Power Center 9.1/8.6 Informatica Developer 9.1,Data Quality (IDQ), Oracle 9i/10g, SQL/PL-SQL,, Tableau,TOAD.

Zensar Wells Fargo Date: Feb’ 06 – Aug’ 07

Project: Enterprise Data Warehouse

Informatica Developer.

Wells Fargo is one of the largest financial organizations serving individual consumers, small and middle market businesses and large corporations with a full range of banking, investing, asset management and other financial and risk-management products and services. This project was to implement an enterprise data warehouse (EDW) by means of integrating data from different feeder system situated across various locations into a central repository of business information. The EDW provides quick access to data to enable a more informative decision making process.

Responsibilities:

Perform impact analysis on the existing Legacy piece of code

Analyze the proposed changes and prepare design based on functional requirements

Transform the approved functional requirements into technical code

Worked on Informatica Designer Tool’s components – Source Analyzer, Warehouse Designer, Transformation Developer, and Mapping Designer.

Creating mapping for extracting data from oracle and production systems to stage using Informatica designer.

Created mappings using transformations such as Source Qualifier, Aggregator, Lookup, Joiner, Router and Update Strategy.

Extensively worked with incremental loading mappings.

Extensively worked with debugger to test the data and fix the issues.

Worked with mapping parameters and Involved in creating sessions and managing sessions.

Worked with Shortcuts across Shared and Non Shared Folders.

Created Pre-Sqland Post-Sql scripts which need to be run at Informatica level.

Developed Oracle views to identify incremental changes for full extract data sources

Implemented Error Handling strategy in mappings.

Used Informatica’s Workflow manager & Workflow Monitor tools to Load data from Oracle sources into the Target Oracle 9i Data Ware House.

Extensively worked with Power Centre debugger to test the data.

Environment: InformaticaPowerCenter 8.6, Oracle, DB2, Toad, Fact.

Achievements:

Received appreciations from various clients for individual excellence and contributions towards the projects.

Received special performance award from SHELLUK, for the innovative solution in migration project.

Proposed and successfully implemented few Infrastructure changes that improved Performance of existing applications. Received appreciations from Client for this proactive & innovative approach at Onshore.

Contact this candidate