We provide IT Staff Augmentation Services!

Informatica Developer Resume

VA

SUMMARY

  • Over 7+ years of IT experience in the Requirement Analysis, Data Analysis, Application Design, Application Development, Implementation and Testing of Applications in Data warehousing, OLAP with strong business knowledge of Financial, Insurance, Energy Telecom, Banking domains.
  • Extensive Data Warehouse experience using Informatica Power Center v6.x, 7.x, 8.x (Repository Manager, Mapping Designer, Workflow Manager, Mapplet Designer, Workflow Monitor, Source Analyzer, Transformations Designer, Warehouse Designer) ETL tool on Oracle, Sybase, DB2 and SQL Server Databases.
  • Experience in supporting the offshore people.
  • Expertise in Informatica Performance tuning and Database Performance tuning.
  • Extensively used ETL methodology for supporting of Extract, Transform, and Load environment using Informatica Power Center.
  • Experienced in implementing the business rules by creating transformations (Expression, Aggregate, Unconnected and Connected Lookup, Router, Update Strategy, Filter, Joiner, Union, SCD’s Type1,Type2,Type3), and developing Mappings.
  • Experienced in SQL Optimization and SQL Loader.
  • Experience in integration of various data sources like Oracle, Sybase, DB2, SQL Server, and Flat Files.
  • Transformation and Loading of data from multiple feeds and sources into Data Warehouse.
  • Extensive knowledge of PL/SQL, SQL programming.
  • Experience in working with UNIX Shell Scripts for automatically running sessions, aborting sessions and creating parameter files. Written number of shell scripts (Korn Shell) to run various batch jobs.
  • Experience onDebuggerto validate the mappings and gain troubleshooting information about data and error conditions.
  • Good understanding with all phases ofSDLC (System Development Life Cycle) including Planning, Analysis, Design, Implementation and Maintenance.
  • Have strong work experience with Database Programming inOracle 10g/9i/8i/7xs,MS Sql Server 2K, & Access.
  • Excellent understanding and best practice of Data Warehousing Concepts, involved in Full Development life cycle of Data Warehousing. Expertise in enhancements/bug fixes, performance tuning, troubleshooting, impact analysis and research skills.
  • Good exposure in projects with the Onsite - Offshore model.
  • Expert in data warehouse performance tuning.
  • Data modeling experience using Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Erwin 4.x.
  • Excellent analytical, problem solving skills and a motivated team player with excellent inter-personal skills and familiar with offshore and multi-site development.
  • Created the Process Flow Documentation for the Informatica process.
  • Good team player, strong interpersonal and communication skills combined with self-motivation, initiative.

TECHNICAL SKILLS:

  • Database : Oracle 11g/10g/9i, MS SQL Server 2008/2005, MS Access, DB2, Sybase.
  • Operating Systems : Windows 2003/2000/XP/Vista, UNIX, Sun Solaris.
  • Programming Languages C, PL/SQL, Perl, java, SQL, UNIX shell scripting.
  • ETL Tools : Informatica (Power Center 8.x, 7.x, 6.x).
  • Data modeling tools : Erwin 4.x
  • Database Tools: TOAD, Visio, Control-M, SQL*Loader, Rapid SQL ,SQL Navigator, PUTTY, Autosys, Mercury Quality Center ,Business Objects, Oracle SQL Developer.

PROFESSIONAL EXPERIENCE:

Client: Confidential, VA.Aug ’10 to till date
Role:Informatica Developer.

Description:Verizon is a leader in delivering broadband and other wire line and wireless communication innovations to mass market, business, government and wholesale customers. Verizon is the wireless phone provider that owns and operates the largestmobile telecommunications network in theUnited States, based on a total of 101.1 million U.S. subscribers.
Responsibilities:

  • Identified data source systems integration issues and proposing feasible integration solutions.
  • Partnered with Business Users and DW Designers to understand the processes of Development Methodology, and then implement the ideas in Development accordingly.
  • Worked with Data modeler in developingSTARSchemas andSnowflakeschemas.
  • Created Oracle PL/SQL queries and Stored Procedures, Packages,Triggers, Cursorsand backup-recovery for the various tables.
  • Identifying and tracking theslowly changing dimensions (SCD)
  • Extracting data fromOracle and Flat file, Excel filessources and performedcomplex joiner, Expression, Aggregate, Lookup, Stored procedure, Filter, Router transformations and Update strategytransformations to extract and load data into the target systems.
  • Created reusableMailing alerts, events, Tasks,Sessions,reusable worklets andworkflowsin Workflow manager.
  • Scheduled the workflows at specified frequency according to the business requirements and monitored the workflows using Workflow Monitor.
  • Fixinginvalid Mappings,Debuggingthe mappings in designer,Unit and Integration Testingof Informatica Sessions, Worklets and Workflows.
  • Extensively usedTOADfor source and target database activities.
  • Involved in the development and testing of individualdata marts, Informatica mappings and update processes.
  • Created repository, users, groups and their privileges using Informatica Repository Manager
  • Involved in writing UNIX shell scripts for Informatica ETL tool to run theSessions.
  • Generated simple reports from the data marts usingBusiness Objects.

Environment: Informatica Power Center 8.6.1, Business Objects XI, Oracle 9i, SQL/PLSQL, TOAD,UNIX Shell Programming, UNIX, and Windows NT.
Client:Confidential,Houston, TX.June’09 to Jul’10
Role:Informatica Developer.
NAGP- CDM ( North America Gas and Power- Credit Data Mart)
Description:This application enables NAGP Credit and Contract teams to effectively and efficiently manage measure and monitor credit related risks in a timely manner. This way it helps business to understand credit risk of the entire portfolio and rectify discrepancies in case if any in deal source systems. The objective of CDM application is to:

  • Provide a medium to calculate current exposure, potential total exposure and expected loss.
  • Monitor and manage future exposure.

The commodities for which exposures and other measures are calculated in CDM include Gas, Power and Coal.

Responsibilities:

  • Interacted with Business Analyst (Line of Business) to understand requirements and translated them into the appropriate technical solution.
  • Developed complex mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Update Strategy Rank and Router transformations.
  • Created data modeling for staging area as well as Data warehouse (Star Schema) database.
  • Extensively worked on developingInformatica Mappings, Mapplets, Sessions, Workflows and Workletsfor data loads
  • Extensively used ETL to load data from wide range of sources such as flat files (CSV, fixed-width or delimited)
  • Performance tune ETL mappings, Maintenance and enhancements of ETL code.
  • Responsibilities included designing and developing complex Informatica mappings includingType-II slowly changing dimensions.
  • Taken part of Informatica administration. Migrated development mappings as well as hot fixes them in production environment.
  • Identifies, researches, and resolves ETL root cause of production issues or system problems.
  • Created packages using Microsoft Data Transformation Services (DTS/SSIS)
  • Created several projects and packages in Framework Manager and worked with Framework Manager to create metadata models and published packages based on the security.
  • Constructed Drill Through, Master-Detail and dashboard reports using parameterized filters in Report Studio.
  • Validated report results with the source data and sanctioned the reports to production environment.
  • Created Reports in Report studio comprising of list reports, cross-tab reports and chart reports, Maps, Repeater tables using underlying multiple query structure by using filters, calculations, complex expressions, conditional formatting, and prompts including cascading prompts.
  • Carried out training sessions for users to learn how to execute Cognos reports in Cognos connection.
  • Responsible for preparing test cases and technical unit testing for the developed reports.
  • Responsible for to analyze and apply new requirements to existing reports.
  • Continuously monitor the accuracy of the data and the content of the delivered reports.
  • Involved in Onsite & Offshore coordination.
  • Responsible for to provide production support and resolve issues.

Environment: Informatica 8.6.1, Toad tool for Oracle (10g), Business Objects XI, Oracle 9i, SQL/PLSQL, TOAD, UNIX Shell Programming, UNIX and Windows.

Client: Confidential, CT
Role: Informatica Developer Dec’08 to May’09
Description:- At Hartford Investment Management Company, asset management is the only business. No matter what kind of institutional investors are – an insurance company, mutual fund or employee benefit plan, a foundation or endowment, or other institution. All disciplines contribute buy/sell ideas and decisions are reached through fluid multi-disciplinary discussions.
Responsibilities:

  • Involved withBusiness AnalystTeam to identify the requirements
  • Identified and designed Information analysis attributes and entities
  • Written Technical Data Flows and Element Mapping between Source and Target Systems
  • Designed ETL architecture and mappings to process data
  • Prepared the deployment and metadata standards for ETL processes
  • Involved in Designing and creating mappings and Mapplets usingInformaticaSourceAnalyzer,Warehouse designer,Mapplet Designer&, Transformation Designer
  • Used all Transformations such as Expressions,Filters,Joiners,Aggregators, Lookups, NormalizerandRoutersto load consistent data into Database.
  • Worked on Mapplets, shortcuts and reusable transformations
  • InformaticaWorkflow Managerusedto create Workflows, database connections, sessions, and batches to run the mappings.
  • Various Performance and Tuning techniques used to improve the load.
  • Have writtencomplex SQL Queries involving multiple tables with joins.
  • Involved in writing ofTriggers, Functions, and Packages.
  • TuningPL/SQLprocedures and Functions with different utilities likeEXPLAIN PLAN,TKPROF.
  • Involved in writingUNIX shell scripts and PL/SQLprocedures,Pre-sessionandPost- SessionScripts.
  • Involved in development ofControl M jobsto schedule the Informatica jobs.
  • Extensively worked withTest Director

Environment:Oracle 10g,Linux, Sun Solaris 8,Informatica Power center8.1.1, SQL Loader, Microsoft Visio.

Client: Confidential,Southern California, CA. Oct ‘07 to Nov ‘08
Role: Informatica Developer.

Description: - CaliforniaNational Bank provides consumer, commercial, investment, brokerage and trust banking services, as well as leasing, mortgage services, to individuals and businesses. The project was to design, develop and maintain a data warehouse to understand the client needs, undertake trend analysis, provide better customer service and assess current and future profitability, Cross-sell products to increase revenue generation from the most profitable customers.

Responsibilities:

  • Assisted gathering business requirements and worked closely with various Application and Business teams to develop Data Model, ETL procedures to design Data Warehouse.
  • Designed and developed star schema model for target database using ERWIN Data modeling.
  • Extensively used ETL Informatica tool to extract data stored inMS SQL 2000, Excel, and Flat filesand finally loaded into a single Data Warehouse.
  • Used various active and passive transformations such asAggregator,Expression,Sorter,Router,Joiner,connected/unconnected Lookup, andUpdate Strategytransformations for data control, cleansing, and data movement.
  • Designed and developedMappletsfor faster development, standardization and reusability purposes.
  • ImplementedSlowly Changing DimensionType 1andType 2for inserting and updating Target tables for maintaining the history.
  • UsedDebuggerto validate transformations by creating break points to analyze, and monitor Data flow.
  • Tunedperformanceof Informatica Session by increasing block size, data cache size, sequence buffer length and Target based commit interval, and mappings by dropping and recreation of indexes.
  • Worked along with the QA Team and provided production support by monitoring the processes running daily.
  • Involved inpre and post sessionmigration planning for optimizing data load performance.
  • Interfaced with the Portfolio Management and Global Asset Management Groups to define reporting requirements and project plan for intranet applications for Fixed Income and Equities.
  • PerformedUnit testingduring the mapping phase to ensure proper and efficient implementation of the transformations.
  • WroteUNIX Shell Scriptsandpmcmdcommand line utility to interact with Informatica Server from command mode.

Environment: Informatica Power Center 7.x,MS SQL 2000, Oracle 9i, SQL, PL/SQL, SQL Navigator, Erwin 4.1,UNIX Shell Scripting, Windows XP and 2000.

Client: Confidential, MA
Role: Oracle DB/Informatica Developer May’06 to Aug’07

Description: This project involves building a Data warehouse. Worked for the brokerage department which arranges loans on mortgages .The primary aim of this project is to integrate the data sources from existing system and to provide analysis to make business related decisions.
Responsibilities

  • Involved in Designing and developing multi-dimensional model (Star Schema) using Erwin
  • Scheduling meetings with the business users to gather the business analysis reporting requirements.
  • Designing and developedETLprocess.
  • Developed Mappings and reusable Transformations and Mapplets.
  • Extensively worked with Informatica Transformations and also Override SQL using Oracle Functions.
  • InformaticaServer Managerusedto create database connections, sessions, and batches to run the mappings.
  • Various Performance and Tuning techniques used to improve the load.
  • Involved in writing of Triggers, Functions, and Packages.
  • Converting fromSQL/ProceduresandSQL Loaderscripts to Informatica mappings
  • Scheduling the batches and sessions for daily loads.
  • Automation ofFTPprocess to and from source systems.
  • Involved in writingUnix shell scripts and PL/SQLprocedures,Pre-sessionandPost- SessionScripts

Environment: Oracle9i,Sun Solaris,Windows NT/2000, Informatica PC 6.x SQL loader, Toad Modeler.

Client: Confidential, Goa, India Jan’04 to Feb’06 Jun 2002 to May 2003
Role: Informatica developer

Project Description:
ZIL is a project for the Birla Group of companies in providing the Zuari industries with a comprehensive Data store for their analytical purpose of their Sales and Purchase of Fertilizers and Pesticides.

Responsibilities:

As Tech Lead & Developer

  • Worked as aData Modeler and Data Analyst.
  • Worked at the client Site for theBuilding a Data warehouse Scheme.
  • Analyzed, diagnosed and resolved business and technical issues effectively consulting with clients.
  • Worked with ETL tools in building aCUBE for the logical design.
  • Worked on Purchase, Sales, Transport Billing, And Regional Accounting System Modules.

Environment: Informatica, Oracle.

Hire Now