informatica developer

Udayabindu g

********@*****.***

SUMMARY

• *+ years of extensive experience in Information Technology SDLC (Software Development Life Cycle) with a strong background in Database development and Data warehousing and more than Five years of experience in Data Integration, Migration and ETL process using Informatica Power Center 8.x/7.x/6.x/5.x.

• Experience in integration of various Operational Data Source(ODS)s with Multiple Relational Databases like Oracle, SQL Server and Worked on integrating data from flat files like fixed width and delimited.

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

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

• Worked extensively with complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups and Aggregators.

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

• Designed complex ETL mappings like slowly changing dimensions, critical performance tweaking stages with partitioning, persistent cache and extensive use of mapplets for common sub routines.

• Experience in using the Informatica command line utilities like pmcmd to execute workflows in non-windows environments.

• Hands on experience in Performance Tuning of sources, targets, transformations and sessions.

• Worked with Stored Procedures, Triggers, Cursors, Indexes and Functions.

• Experience in End-to-End Database Development, Performance Tuning, Optimization of SQL and Production Support

• Strong Knowledge in optimizing database performance.

• Experience in UNIX shell scripting, CRON and file management in various UNIX environments.

TECHNICAL SKILLS

ETL Tools Informatica 8.x/7.x/6.x/5.x (Power Center/Power Mart/Power Exchange) (Designer, Workflow Manager, Workflow Monitor, Server Manager, Power Connect)

Data Modeling Erwin 4.0/3.5, Star Schema Modeling, Snow Flake Modeling, MS Visio, Rational Rose

Suite (UML)

Databases Oracle 11g/10g/9i/8i, MS SQL Server 2005/2000, DB2, My SQL, Sybase, DB2/400, Teradata

Reporting Tools Cognos 7.0/6.0, Business Objects XI R2, OBIEE, SSRS, SAS

Languages T-SQL, PL/SQL, Perl, Unix Shell Script, Visual Basic, XML, Java and ASP.

DB Tools Toad, SQL* Loader, Autosys, DB Visualizer, SQL Navigator

Operating Systems Windows 2003/2000/NT, AIX, Sun Solaris, UNIX, Linux

EDUCATION

• Bachelor’s in Information Technology, JNTU, Hyderabad, India.

CERTIFICATION:

• Oracle 9i Certified Professional (OCP).

Global Wireless Solutions - VA Jan 10 – Till Date

Role: ETL Developer

Project: GSMRT (Global Systems Management Reporting Technology)

Description: Global wireless solutions is a leading independent benchmarking solutions vendor for the wireless industry. Here, benchmarking refers to the process of comparing one operator’s network delivered quality against competitors and comparing network performance between markets. It also provides unique bench marking solutions for largest wireless carriers worldwide. My main job was to use data marts as the source data where each data mart belongs to a client and work on the ETL process using Informatica.

Responsibilities:

• Interacting with the end users to get the business Requirements, reporting needs and created Business Requirement Document.

• End-to-end ETL development of the Data Mart. Data Quality Analysis to determine cleansing requirements. Designed and developed Informatica mappings for data loads.

• Responsible for the Dimensional Data Modeling. Understand the business needs and implement the same into a functional database design.

• Extensively used ETL and Informatica to load data from MS SQL Server, Excel spreadsheet, flat files into the target DB2 database.

• Implemented various Transformations like Joiner, Aggregator, Expression, Lookup, Filter, Update Strategy, Stored Procedures, and Router etc.

• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Designer.

• Development of Informatica mappings and also in tuning of mappings for better performance.

• Tuning Informatica Mappings and Sessions for optimum performance.

• Used Informatica features to implement Type I & II changes in slowly changing dimension tables.

• Created and ran workflows and Worklets using Workflow Manager to load the data into the Target Database.

• Made substantial contributions in simplifying the development and maintenance of ETL by creating re-usable Mapplets and Transformation objects. Partitioned the sessions to reduce the load time.

• Optimized/Tuned queries, stored procedures and mappings for better performance and efficiency.

• Scheduled the jobs using third-party scheduler tool Autosys.

• Developed various shell scripts for different purposes.

• Designed and developed ETL strategies and mappings from source systems to target systems. ETL strategies were designed to cater initial load and incremental load.

• Tested all the modules and transported data to target Warehouse tables, scheduled, ran extraction and load process and monitor sessions and batches by using Informatica Workflow Manager and log files.

• Precise Documentation was done for all mappings and workflows.

• Responsible for ETL process under development, test and production environments.

• Wrote test plans and executed it at UNIT testing and also supported for system testing, volume testing and USER testing. Also provided production support by monitoring the processes running daily.

• Worked extensively with the major functionality of Business Objects, created the Universes with Default& Custom Hierarchies for multidimensional analysis and created reports with Multi-Level Scope of Analysis using Drill down, drill across, drill up, and slice and dice.

• Involved in developing reports using Business Objects 5.1

• Generated the Business Objects Reports using the universe as the main Data provider and writing the complex queries including Sub queries, Unions, Intersect and Aliases.

• Created User Objects including Dimensions, Details and Measures.

• Reports were formatted to the users according to the user requirements using Business Objects features like Slice and Dice, Drill Down, and Formulae.

Environment: Informatica Power Center 8.6.1, Informatica Power Exchange 8.6.1, Business Objects XI/ 6.1, DB2 UDB 9.5, ERWIN, UNIX.

General Information Systems – SC Apr 08 – Dec 09

Role: Informatica Developer.

Description: General Information Systems is one of the largest background screening providers in the world. It provides risk management service which is mainly the process of identification, analysis and mitigation of uncertainty in investment decision-making. GIS provides services to various industries like health care, food service telecommunications, Insurance, Education, etc. As an Informatica developer, i worked on data related to different industries where each industry was considered a data mart. My main job was to maintain the history and transaction details using slowly changing dimensions.

Responsibilities:

• Gathered the system requirements and created mapping document which gives detail information about source to target mapping and business rules implementation.

• Drafted Business Requirement Documents, System Requirement Specifications, Business Work Flow Diagram, Use Case Diagram, Data Flow Diagram, Cross Functional Diagram to represent Business and System requirements.

• Designed, developed and debugged ETL mappings using Informatica designer tool.

• Created complex mappings using Aggregator, Expression, Joiner, Filter, Sequence, Procedure, Connected & Unconnected Lookup, Filter and Update Strategy transformations using Informatica Power center designer.

• Extensively used ETL to load data from different sources such as flat files, XML to Oracle.

• Worked on mapping parameters and variables for the calculations done in aggregator transformation.

• Implemented slowly changing dimension for accessing the full history of accounts and transaction information.

• Implemented change data capture (CDC) .

• Tuned and monitored in Informatica workflows using Informatica workflow manager and workflow monitor tools.

• Created and configured workflows, worklets and sessions using Informatica workflow manager.

• Scheduled the jobs using third-party scheduler tool Autosys.

• Implemented the National City standard data population method loading the data into new set of tables after successful completion of the data loading, rolled over to original tables. This concept used to high availability of the data to users at the time of the data loading instead of users to wait to run their reports.

• Involved in designing and developing universes for reporting generation from warehouse database using Business Objects.

• Resolved loops by creating aliases and contexts.

• Created different types of reports like list, cross tab and etc.

Environment: Informatica Power Center, SAP Business Objects XIR3, Oracle 11g/10g, MS Sql Server, Toad, Erwin, UNIX, Windows.

ING Insurance, Windsor, CT Jul 07 – Mar 08

Role: Informatica Developer

Project: Health Care Management

Description: In the U.S., the ING family of companies offer a comprehensive array of financial services to retail and institutional clients, which includes annuities, retirement plans, life insurance, mutual funds, managed accounts, alternative investments, direct banking, institutional investment management, employee benefits, financial planning, and reinsurance. This project is to calculate the daily account balances at the participant level. Gathering the Source System data from the different Admin Engines like Omni, ACES SBA, DSS Producer (Agent info) and calculating the intermediate aggregations at plan and participant level dimensions and again calculating the final aggregations at Producer, fund and money source level. Finally sending the web reports to the individual participants, sponsor web, TPA web and User webs.

Responsibilities:

• Performed major role in understanding the business requirements to design and load data into data warehouse.

• Design of Logical and Physical schema generation.

• The business requirements were transformed into ETL metadata for the Aggregate tables.

Involved in designing the process for getting the data from all systems to Data warehousing system.

• Imported various Application Heterogeneous Sources, created Targets and Transformations using Informatica Power Center 8.1.

• Involved in the design and development of Aggregate mappings and tuned for better performance.

• Developed complex mappings using heterogeneous sources and targets in different Relational Databases and flat files.

• Optimized/Tuned queries, stored procedures and mappings for better performance and efficiency.

• Developed various shell scripts for different purposes. For example, starting workflow, balance checks, reset sequence generators, purge database tables.

• Developed shell scripts for workflow scheduling.

• Extensively worked with Informatica Workflow Manager to Design and Develop workflows and workflow dependencies.

• Moved the Informatica objects between various environments and testing the sessions and mappings.

• Developed Technical Specs, and Release manuals.

• Provided post production support for TDW.

• Provided 24 *7 production support during all the production release weeks.

• Wrote test plans and executed it at UNIT testing and also supported for system testing, volume testing and USER testing.

Environment: Informatica Power Center 8.1, Business Objects XIR2, Oracle10g, DB2, SQL Loader, PL/SQL, MS Access, DB2, XML files, UNIX Scripting, Windows XP/2000/NT, TOAD 7.0 and Erwin 4.0

National City Bank – Cleveland, Ohio Nov 05 – Jun 07

Role: ETL Developer.

Description In order to quickly identify customer needs and better target services to its huge subscribers, we implemented a business intelligence system using Informatica Powercenter Server. With Powercenter Server a large amount of customer-related data from diverse source is consolidated, including support and service usage. Then decision support system/analysis on this data is done using various reporting tools to gauge the effectiveness of promotional activities.

Responsibilities:

• Involved in Logical and Physical Database design and Star Schema design. Identified Fact tables, and Dimensional tables.

• Designed and developed end-to-end ETL process ad data from various source systems to trade mart system. Involved in dimensional modeling (star schema) of the data warehouse and used Erwin to design the data model.

• Developed mappings, workflows to extract data from various sources like SQL SERVER, Oracle, and DB2.

• Developed complex mappings and SCD type-I, Type-II and Type III mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Lookup (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router and SQL transformations. Created complex mapplets for reusable purposes.

• Enhanced the Previous ETL process with new features by exploring areas of improvements like data quality, slowly changing dimensions and performance enhancements. Implemented best practices for development in all the environments.

• Developed number of complex Informatica mappings to implement the business logic and to load the data incrementally.

• Designed and developed complex Procedures, Functions & Packages to handle errors and exceptions at database level using PL/SQL.

• Wrote UNIX shell scripts to spawn the Loader job for daily load of data.

• Experienced using RDBMS Oracle, Teradata, SQL server, DB2.

• Used various transformations like filter, expression, sequence generator, update strategy, joiner, stored procedure, normalizer and union to develop robust mappings using the Informatica designer.

• Used Autosys for Scheduling jobs.

• Created sessions, configured workflows to extract data from various sources to loading into data warehouse.

• Developed static and dynamic parameter files for reusability and database connection management among development/testing/production environments.

• Involved in Technical Documentation, Unit test, Integration Test and writing Test plans.

• Developed, tested and implemented new PL/SQL Packages, Functions, Stored Procedures and Triggers.

• Involved in Analyzing and Documenting End User requirements, Business requirements and Data Specifications for Business Objects reports

• Involved in designing and developing universes for reporting generation from warehouse database using Business Objects.

• Involved in the creation of Universes, Classes, Objects, and Hierarchies for Multidimensional Analysis.

• Resolved loops by creating aliases and contexts.

• Created Complex Reports by using functionalities like Slice and Dice, Drill Down, Master Detail, etc.

• Created and deployed WEBI Reports through Info View.

• Trained users to use interpret and modify reports as and when needed.

Environment: Informatica Power Exchange 6.2/7.1, Business Objects 5.1 Supervisor, Business Objects Designer 5.1, Business Objects, Erwin 4.0,Windows 2000, Oracle 8i/9i, DB2, TOAD, Autosys.

MCIT, India May 2004 - Apr 2005

Data Warehouse Developer

Description:

MCIT provides Software development, telecommunications services to about 21 million clients in 4,000 towns in India. Among its services is public booth telephony, mobile and wire line services, and fixed wireless phones. It has sales and distribution partnerships with such equipment providers as Motorola and ECI Telecom. MCIT also provides additional wireless phone service through a joint venture with Virgin Mobile.

Responsibilities:

• Collected requirements from business users and analyzed based on the requirements.

• Created and maintained the Narrative Use Cases (Business and System Use Cases) and modeled Use Case Diagrams, Activity Diagrams, State Diagrams, Data Flow Diagrams using MS Visio.

• Developed various Mappings and Transformations using Informatica Designer.

• Involved in design, development and maintenance of database for Data warehouse project.

• Designed procedures for getting the data from other systems to Data warehousing system.

• The data was standardized to store data from various Business Units in data warehouse tables.

• Designed and Customized data models for Data Mart supporting data from multiple sources on real time.

• Designed the ETL processes using Informatica tool to load data from MS SQL Server, MS Access & Oracle into the target Oracle 8i database.

• Used Mapping designer and Mapplets to generate different mappings for different loads.

• Used the PL/SQL procedures for data extraction, transformation and loading.

• Performance Tuning of sources, targets, mappings and SQL queries in transformations

• Used SQL Loader for loading data into table structures

• Created various transformations like Joiner, Aggregate, Expression, Filter, update Strategy.

• Experience in using TOAD.

Environment: Informatica, Oracle 8i, PL/SQL, SQL Loader, SQL Server 2000, Windows, UNIX.

Contact this candidate