Prasad Phone:972-***-****

Informatica Developer

Background Summary:

Over 7 years of experience in Information Technology with a strong back ground in Analyzing, Designing, Developing, Testing and Implementation of Databases in various verticals such as Financial, Health Payer, Pharmaceutical and Telecom.

Over 6+ years of Data Warehousing experience using Informatica Power center 9..6/8.6.1/8.5.1/8.1.1 dealing with various Data sources like Teradata, Oracle, SQL Server, Excel, Flat files, DB2.

Experience in integration of various data sources with Multiple Relational Databases like Teradata, Oracle, SQL Server, Sybase and XML files, Main Frames, IBM DB2 and Worked on integrating data from fixed width and delimited flat files.

Well acquainted with Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer.

Expertise in several key areas of Enterprise Data Warehousing such as Change Data Capture (CDC), Data Quality, and lookup Tables and ETL data movement.

Hands on experience in implementing push down optimization.

Have extensively worked in developing ETL for supporting Data Extraction, transformations and loading using Informatica Power Center.

Strong Experience in developing Sessions/tasks, Worklets, Workflows using Workflow Manager Tools - Task Developer, Workflow & Worklet Designer.

Extensively worked on Informatica Designer components Source Analyzer, Target Designer, Transformation Developer, Mapping Designer and Mapplet Designer and Documenting the same

Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator and XML Source Qualifier.

Good experience in using Informatica Workflow Manager to create and schedule workflows.

Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.

Expertise in developing SQL and PL/SQL codes through various procedures, functions and packages to implement the business logics of database in Oracle

Good exposure to development, testing, debugging, implementation, documentation and production support

Proficient in UNIX Shell scripting.

Good experience with job scheduling like CISCO Tidal.

TECHNICAL SKILLS:

Operating Systems

Windows NT/2000/2003/XP/7, Unix (HP-UX 11.x, Solaris 5), Red Hat Linux 5.1

Languages

HTML, SQL, PL/SQL, TSQL, C, C++

Databases

MySQL, MS Access, Oracle 8/9/10g/11g, Teradata 12, V2R5, V2R3, SQL Server 2000/05/08, DB2 UDB,AS400

Data Warehousing Tools

Informatica 8.1/8.6/9.6,Apex data loader, Cognos Impromptu 6.5, PowerPlay Web Reports, MicroStrategy 8.0, Business Objects4.x/5.x/11i, Web Intelligence2.6, SQL Loader, Erwin, Seibel analytics\OBIEE.

Applications

MS Office suite, MS. Project, MS Visio, MS FrontPage, Rational Rose, Mall-Surfer, Dream Weaver, Crystal Reports, SAS and Visual Interdev.

Utility Tools

Toad, Oracle SQL Developer, Teradata SQL Assistant, SQL server management studio, Putty, Filezilla, WinSCP, Erwin.

EXPERIENCE:

Anthem, Richmond, VA Sep 2014-Till date

Sr. Informatica Developer

Project

This project included designing and implementing a data repository for actual, schedule and time-code data from eWFM and ACD systems of the three divisions (Northeast, West and Central) and processing the data to provide a unified view to SAP for the UAP calculation

Responsibilities:

Analyzed business requirements and worked closely with various application teams and business teams to develop ETL procedures that are consistent across all applications and system.

Interacted with Business Users and Managers in gathering business requirements.

Wrote Informatica ETL design documents, established ETL coding standards and performed Informatica mapping reviews.

Extensively used Teradata utilities like Fast load, Multiload to load data into target database.

Extensively worked on Power Center Client Tools like Power center Designer, Workflow

Manager, and Workflow Monitor

Extensively worked on Power Center Designer tools like Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer and Transformation Developer.

Analyzed the source data coming from different sources (Oracle and SAP Flat files) and worked on developing ETL mappings.

Created Parameter files and validation scripts.

Created dictionaries using Informatica Data Quality(IDQ) that was used to cleanse and standardize data

Created Process Control and Metadata for informatica jobs.

Used User Defined Functions for converting SAP values.

Created Sessions, command task, reusable worklets and workflows in Workflow Manager.

Responsible for the Performance tuning at the Source Level, Target Level, Mapping Level and Session Level.

Assisted with peer code reviews and testing of development team's T-SQL code.

Wrote Transact-SQL stored procedures

Performed Unit testing and Data validation testing using Validation scripts.

Proven Accountability including professional documentation and weekly status report.

Provided production support for the Executive Management Information System (EMIS), a web reporting portal to informatica and teradata data sources

Created Data Validation document, Unit Test Case Document, Technical Design Document, Informatica Migration Request Document and Knowledge Transfer Document.

Environment: Informatica Power Center 9.6.0, Oracle 11gR2, SAP BW Flat Files, Teradata 14, UNIX, Win XP, SQL * Plus, Transact-SQL, Control-M, Putty, BTEQ,

MVP Healthcare,Schenectady, NY Mar 2011 - Aug 2014

Informatica Developer

Project

Handles all the business functions like marketing package setup, physician contracting, Hospital contracting, Billing, Enrollment, Claims entry(EDI and online), Adjudication, Check write and Financial reporting.

Responsibilities:

Involved in design and development of Business Requirements in liaison to business users and Technical teams by gathering requirements specification documents and identifying data sources and targets.

Analyzed the business requirements and framing the business logic for the ETL process.

Worked extensively on different types of transformations like normalize, expression, union, filter, aggregator, update strategy, lookup, stored procedure, sequence generator and joiner.

Designed and Developed complex mappings, reusable Transformations for ETL using Informatica Power Center 9.1.1.

Developing and testing all the Informatica mappings involving complex Router, lookups and update strategies.

Created workflows and tested mappings and workflows in development, test and Production environment.

Actively involved in Performance improvements of Mapping and Sessions and fine tuned all transformations.

Setting up batches and sessions to schedule the loads at required frequency using Power center workflow manager.

Performance tuning of the Informatica mappings using various components like Parameter files, variables and dynamic Cache.

Generated completion messages and status reports using workflow manager.

Working on Dimension as well as Fact tables, developed mappings and loaded data on to the relational database.

Involved in writing ETL specifications and unit test plans for the mappings.

Designed the ETL processes using Informatica to load data from SQL Server, Flat Files, XML Files and Excel files to target Oracle database.

Converted the data mart from Logical design to Physical design, defined data types, Constraints, Indexes, generated Schema in the Database, created Automated scripts, defined storage parameters for the objects in the Database.

Creation of Transformations like Lookup, Joiner, Rank and Source Qualifier Transformations in the Informatica Designer.

Created complex mappings using Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations for populating target table in efficient manner.

Developed logical and physical data models that capture current state/future state data elements and data flows using Erwin.

Written SQL overrides in source Qualifier according to business requirements.

Used workflow Monitor to monitor the performance of the Jobs.

Environment: Informatica Designer (9.1.1/9.5.1), Informatica Server Manager, Informatica Repository Manager, Workflow manager, Workflow monitor, Oracle 9i, Erwin 4.1, SQL 2005/2000, Flat Files, Windows XP.

Capital Group, Irvine, CA Jan ’2010- Feb’ 11

DWH Consultant

Project

The Capital Group companies manage the investments of individuals and large institutions through mutual funds, separately managed accounts and pooled investment funds.

Responsibilities:

Worked with business analysts to identify appropriate sources for data warehouse and to document business needs for decision support for data.

To build ETL Specification document based on Functional Requirement.

Involved in parsing of XML documents to fetch the data from xml through PL/SQL and store in oracle tables.

Implemented and reviewed the transformation logic in the ETL mappings according to the pre-defined ETL standards.

Created Mappings, reusable transformations using Designer of Power Center (Informatica Tool).

Implemented performance tuning logic on sources, mapping, sessions and targets in order to provide maximum efficiency and performance.

Defined Target Load Order Plan for loading data into Target Tables.

Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements.

Performance tuning of the Informatica mappings using various components like Parameter files, Variables and Dynamic Cache.

Coding & Debugging, Sorting out their time-to-time technical problems.

Created error log table to capture the error messages, session load time.

Created debugging sessions before the session to validate the transformations and also used existing mappings in debug mode extensively for error identification by creating break points and monitoring the debug monitor.

Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process.

Maintained the batch processes using Unix Shell Scripts.

Wrote PL/SQL stored procedures for processing business logic in the database. Tuning of SQL queries for better performance.

Develop and/or update Technical documentations i.e. operational manual etc.

Develop new and support existing ETL processes using the Informatica Tool.

Involved in performance tuning databases and SQL statements in connection to ETL code as required

Performed source system analysis as required.

Developed stored procedures, database triggers and SQL queries where needed.

Environment: Informatica Power Center 9.0,Erwin 4.x,Oracle 10g, PL /SQL, UNIX, UC4, CSV, XML.

TIAA, CREF, Charlotte Feb ‘09– Jan ‘10

Sr. Informatica Developer

Project

Teachers Insurance and Annuity Association – College Retirement Equities Fund (TIAA–CREF) is a Fortune 100 financial services organization that is the leading retirement provider for people who work in the academic, research, medical and cultural fields. In 2011, TIAA–CREF ranks 87th on Fortune's list of the 500 largest corporations in America.

Responsibilities:

Worked with architect and business managers to understand the requirement. Communicated with the DBA group to understand the source systems as well.

Worked with Database people to understand the environment. How they are managing source systems.

Worked with Data modeler to understand the source to target mapping documents, the structure of the tables, how the final target looks like.

Worked with DBA team to formulate the incremental loads, change data capture process to Informatica interface.

Created mappings of initial load for all source systems, cleansed data and load it into staging area.

Created mappings for initial load in PowerCenter Designer using the transformations Expression, Aggregator, Joiner, Normalizer, and Source Qualifier.

Created complex mappings for full load into target in PowerCenter Designer using Sorter, Connected Lookup, Unconnected Lookup, Update Strategy, Router, Union, Rank, Stored Procedures, External Procedure, Sequence Generator and Transaction Control.

Created Mapplets to reuse all the set of transformations for all mappings.

Created work flows and sessions for each mapping that we are extracting from source systems to staging area; staging area to target.

Implemented Type 1 and Type 2 Slowly Changing Dimensions for each data set.

Created various tasks like session, email, command, event raise and event wait to give various conditions in the workflows.

Wrote SQL scripts to verify counts and validate the data

Participated in the enterprise performance tuning of Informatica for sources, targets, mappings and sessions.

Performed Unit testing on the Informatica code by running in the debugger and writing simple test scripts in the database thereby tuning it by identifying and eliminating the bottlenecks for the optimum performance.

Involved in fixing invalid Mappings, testing of Stored Procedures and Functions, Testing of Informatica Sessions, Worklets and Workflows.

Used Informatica Scheduler to schedule the work flows as this organization is having Tidal Scheduler (Optional)

Created parameters and variables for the reusable sessions. Created Email task, Decision task

Worked on SQA environment to test the data before we move into Production Environment. Worked with DBA group to resolve performance.

Responsible for creating the parameter files in order to connect to the right environment and data base.

Worked with DBA on SQL scripts to automate the process of populating the various columns in the tables with surrogate keys

Worked with data architect to create table and column definition to prepare the data dictionary for users.

Environment: Informatica Power Center 8.6.1, Oracle 9i, Oracle 11i RAC, PL/SQL, SQL, UNIX, Shell script, Toad 8.5.1, E/R Studio 7.6, SQA

KVB Bank, Hyderabad, India Aug ’08-Dec‘09

ETL Developer

Responsibilities:

Developed ETL mappings, Transformations and Loading using Informatica Power Center 8.1.

Extensively used ETL to load data from Flat file, MS Excel, which involved both fixed width as well as Delimited files and also from the relational database, which was Oracle 9g.

Developed and tested all the Informatica mappings, sessions and workflows - involving several Tasks.

Worked on Dimension as well as Fact tables, developed mappings and loaded data on to the relational database.

Responsible for creating business solutions for Incremental and Full loads.

Worked extensively on different types of transformations like source qualifier, expression, filter, aggregator, update .

strategy, Lookup, sequence generator, joiner, Stored Procedure.

Analyzed the session, event and error logs for troubleshooting mappings and sessions.

Environment: Informatica 8.1, BO 6.5, Oracle 9g, MS Excel, SQL *Plus.

Education: Bachelor’s in Electronics from OU, HYD.

Contact this candidate