We provide IT Staff Augmentation Services!

Informatica Developer Resume Profile

5.00/5 (Submit Your Rating)

CA

Professional Summary

  • More than 7 years of experience in IT industry in Data Warehousing ETL Development/ Testing/ Maintenance , Performance tuning and Business Intelligence applications from initiation through design,development,deployment .
  • Worked extensively in Design and Development of Data Warehouse and Data Integration projects using ETL tool Informatica Power Center, Power Exchange and Data bases like MS SQL Server, Oracle, Teradata and DB2 and is versed in PL/SQL.
  • Extensively worked on Installation and configuration of Financials Analytics, Supply chain and Order management Analytics, HR Analytics, and Procurement and Spend Analytics.
  • 6 years of strong experience in Data Warehousing experience using Informatica Power Center.
  • Proficient in Design, Development, Implementation, Administration and Support of OBIEE 10g/11g, OBIA 7.9.6.3, Informatica, DAC and Oracle Database.
  • Experience in building and configuring Repository, creating and managing OBIEE Intelligent Dashboards, OBIEE Answers, OBIEE Delivers, and OBIEE iBots.
  • Worked extensively on OBIEE 11g components like oracle enterprise manager and weblogic server administration console.
  • Experience in extracting data from Oracle EBS, PeopleSoft, Siebel CRM, SAP HR, OLTP, and integration and loading data to OLAP systems
  • Experienced in General Ledger, Account Payables, Accounts Receivable, Inventory, Purchase Order and Order Management.
  • Good experience in full life cycle of project development including designing, developing testing, debugging, performance tuning, documentation, reporting and deploying the applications.
  • Strong in working with Source Analyzer, Target Designer, Transformation Developer, Mapplet Designer and Mapping Designer.
  • Developed Complex mappings from varied transformation logics like Unconnected /Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Union, Update Strategy and more.
  • Strong working experience in Data Warehousing concepts, Star Schema and Snowflake Schema methodologies.
  • Implemented Slowly Changing dimension types I, II III methodologies for accessing the full history of accounts and transaction information
  • 6 years of domain expertise in Health Care, Banking and Insurance.
  • Worked Extensively on OBIEE Administration Tool and Presentation Services.
  • Experience with various data source types including XML, VSAM, Data Bases and Flat files
  • Extensive experience in performance tuning and code optimization.
  • Full life-cycle development experience in Data Warehousing and ETL/Data Integration projects.
  • Experience working with both the Water Fall and AGILE methodologies.
  • Preparation of the High Level and Detailed Design documents.
  • Excellent Management skills, analytical and dynamic troubleshooting skills, Multi tasking, Posses good communication skills, Quick learner and adapts to new environments easily.

TECHNICAL SKILLS

  • Tools: Informatica Power Center 9.x/8.x/7.x,Oracle Bi Applications
  • Reporting Tools: OBIEE 11g/10g
  • Database: SQL Server 2005/2008, Oracle 11/10G/9i/8i, DB2, Teradata
  • Tools server: Toad,SQL Loader,SQL Developer,Autosys,Informatica Power Exchange
  • Languages: SQL,PL/SQL,UNIX Shell Scripting,C,C
  • Platforms: Windows XP/Vista/7, UNIX, Linux
  • Office Tools: MS Word, MS Excel, MS PowerPoint, MS VISIO
  • Scheduling Tools: DAC Data Warehouse Administration Console

PROFESSIONAL EXPERIENCES:

Confidential

OBIEE / Informatica Developer

Responsibilities:

  • Implemented Financial analytics and supply chain analytics.Extracted the data from finance and other enterprise systems and by using informatica the data is transformed.
  • Created ETL for sourcing the data received in Excel files for vendor processed payments
  • Worked on creating reports using the existing/ extending metadata content to fulfill the report requirements
  • Worked on extracting data from Oracle EBS, OLTP flat files and integration and loading data to OLAP system.
  • Involved in the ETL design and its documentation.
  • Involved in monitoring the workflows and in optimizing the load times.
  • Designed and developed Informatica Mappings and Sessions based on business user requirements and business rules to load data from source flat files and oracle tables to target tables.
  • Extensively used workflow variables, mapping parameters and mapping variables.
  • Implemented OBIEE with Financial and Procurement Spend Analytics against Oracle EBS
  • Gathered user requirements by conducting interviews, identifying ISW reports and created SR's and CR's from the gathered requirements.
  • Worked on SDE and SIL mappings for different Source containers like Oracle R12
  • Used flat files to source the data from flat files into DW using Informatica Mappings, Sessions and Workflows
  • Monitored performance by creating OBIEE's Usage metrics. Improved performance by using aggregate navigation, indexes and materialized views.
  • Copied existing RPD's from server into the local machine for testing and tuning of dashboards.
  • Migrated RPD and Catalog changes from DEV to QA and PROD.
  • Received excellent feedback from Users, Accounting Manager and Director of Business Intelligence.
  • Restarting the BI Servers with RPD changes, Running Cache Scripts and Catalog Merging on Dev and QA environments on Linux.
  • Created Presentation catalogs, Folders in Presentation Layer, and Performed Global Consistency Check in Oracle BI Administration Tool.
  • Worked on Answers, Dashboards and Security for users. Worked on creating complex reports.
  • Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository. Defined the Primary, Foreign keys and created Simple and Complex joins between various Dimension and Fact Tables.
  • Worked on Aggregates, Hierarchies, Calculation wizard in the Logical Layer.
  • Involved in Logical and Physical Database design and Star Schema design, Snow flake Schema, Fact tables and Transaction tables.
  • Designed and modified ETL Mappings using Informatica from Scratch to load the Data from Source System EBS to staging system SDE mappings and to the target Analytics Warehouse SIL mappings .
  • Closely worked with ETL team to configure Informatica connections, source DB connection and target DB connection in DAC.
  • Knowledge on configuring new customized mappings and work flows in DAC for new customized subject area.
  • Experience in configuring DAC to run nightly data loads on daily basis.
  • Worked on Data Extraction Transformations, Loading, Conversions and Analysis.

Environment: Power center 9.1, Oracle Business Intelligence 11.1.1.7,EBS 11i, DAC, Oracle BI Apps 7.9.6.4, Oracle 11g , Windows XP/ NT/2003, Linux, Toad

Confidential

Sr.OBIEE / Informatica Developer

Responsibilities:

  • Implemented Financial Analytics and Procurement and Spend Analytics
  • Developed and implemented the ETL approach from staging to target which is common irrespective of source system using Informatica.
  • Designed and Developed Dashboard Pages Like Total Spend Overview, Trends, Exceptions, Purchase Requisitions, Purchase Orders, Purchase Receipts and Employee Expenses in Procurement and Spend Dashboard.
  • Designed and Developed Procurement and Spend and Supplier Performance, General Ledger, Payables, Receivables, Profitability, Dashboards in OBIEE.
  • Created Shell Scripts for coping the files from Concur site to OBIEE server
  • Developed ETLs to source the data from SAE into EDW.
  • Created complex mappings which involved Slowly Changing Dimensions
  • Worked extensively with the connected lookup Transformations using dynamic cache.
  • Involved in extracting the data from the Flat Files and Relational databases into staging area
  • Monitored Workflows and Sessions using Workflow Monitor.
  • Worked extensively on PL/SQL as part of the process to develop several scripts to handle different scenarios.
  • Documented Informatica mappings in Excel spread sheet.
  • Tuned the Informatica mappings for optimal load performance.
  • Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
  • Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer
  • Worked on the Multidimensional data model to store the data provide support for reporting
  • Created an RPD model for reporting through BI answers.
  • Involved in creating Dimensional Hierarchies to support drill downs.
  • Designed Security to provide controlled access to the data
  • Worked on Aggregates, Hierarchies, Calculation wizard in the Logical Layer.
  • Worked on creating Reports and Dashboard to provide access to the employee level data.
  • Customized Min Max reports in Inventory INV by using Oracle BI Publisher.
  • Customized AR aging reports in Accounts Receivable AR and Chart of Account Detail Listing Report using Oracle BI Publisher.
  • Involved in Performance tuning at Informatica level and at Data base level.
  • Involved in Repository Configuration, Troubleshooting, Migration and Server Administration of DEV, QA and PROD environment.
  • Re-organized pages reports into new dashboards.
  • Monitoring Incremental Full load through DAC.
  • Imported and Exported Execution Plan in DAC from one Instance to other Instance.
  • Reviewed and analyzed functional requirements, mapping documents, problem solving and trouble shooting.

Environment: Power Center 8.6, Oracle Applications 11i AR, INV, SCM , Oracle Business Intelligence 11.1.1.7,BI Apps 7.9.6.3, DAC, Oracle 11g, Oracle DB, Windows XP/ NT/2003, Linux, PL/SQL,TOAD

Confidential

OBIEE developer

Responsibilities:

  • Worked with functional and technical project leads, finance, and other business groups to identify, analyze, and document Business requirements.
  • Configured Metadata and Web Catalog Objects and also created drill-down hierarchies and implemented business logic for facts and dimensions.
  • Managed security privileges for users groups using LDAP SSO authentication, EBS and Excel-based authorization as well as Dashboard/Report-level security.
  • Involved in cache management, performance tuning, data and object security.
  • Involved in the cut-over activities for Rpd and Web-catalog migration.
  • Configured OBIEE iBots to deliver analytics content based on schedule, automated iBot queries to obtain daily and weekly reports.
  • Performed end-user training to develop ad-hoc reports using BI Answers.
  • Designed and developed a standalone OBIEE solution for Process Manufacturing Inventory Period Balances, Work Order, Cost Analysis and Sub Ledger Accounting modules.
  • Designed Star-Schema using Facts, Dimensions, Physical, Logical, Alias and Extension tables and established relationships Foreign Keys Physical Logical between tables.
  • Created groups in the repository and added users to the groups and granted security privileges explicitly and through group inheritance.
  • Used Calculation Wizard, Time series wizard and Expression Builder to perform logical operations in the BMM layer.
  • Maintained effectiveness in creating the Dashboards by appropriately including guided navigation links, drilldowns, roll downs and slice dice features.
  • Participated in the entire SDLC starting from Analysis including design, development, testing, implementation and maintenance of the Gilead reporting application.

Environment: OBIEE 10.1.3.4.1, Oracle Bi Apps 7.9.6 Full-Suite , Informatica 8.6.1, DAC, Oracle 10g/11g, Oracle EBS R12, Oracle SQL Developer 2.1.1, Windows 2003 Server/XP, RHEL 5.x.

Confidential

OBIEE developer

Responsibilities:

  • Interacted with end users and developers to validate the data model, requirement validation of the reports and drilldowns with business users
  • Developed proof of concept to check the functional feasibility of the OBIEE implementation.
  • Involved in Installation, configuration and administration of OBIEE server and repository.
  • Effectively managed ODBC connections and imported the Physical tables, keys and physical joins from the databases.
  • Worked on repository Physical Data Layer, Business Model and Mapping Layer and Presentation Layer, Created session repository variables using OBI Administration Tool.
  • Managed security privileges for users groups using LDAP SSO authentication, OS external database authentication/login as well as Dashboard/Report-level security.
  • Configured Analytics Metadata objects Subject Area, Table, and Column and Web Catalog Objects Dashboard, Pages, Folders, and Reports .
  • Utilized Oracle BI Delivers for sending real-time, personalized alerts via intelligence agents iBots to interactive dashboards for subscribed users.
  • Optimized performance using Indexes, Aggregate tables and materialized views.
  • Developed different kinds of Reports pivots, charts, tabular using global and local Filters and custom reports/Ad-hoc queries using Oracle BI Answers and assigned them to application specific dashboards as per requirements.
  • Performed end-user training to develop ad-hoc reports using BI Answers.
  • Used Data Stage for ETL purpose, for Data Extraction from source tables, Data Mapping and Data Conversion Transformation and Data loading into the HR Data Mart.

Environment: OBIEE 10.1.3.4.1, Oracle 10g, SAP HR, Informatica Power Center 8.1.1, Microsoft SQL Server Management Studio Express 9.0, SQL Plus, SQL Loader, Windows NT Server/XP, UNIX.

Confidential

ETL Developer

Responsibilities:

  • Conducted interviews with representatives and senior management.
  • Extensively worked on Business Analysis and Data Analysis.
  • Interacted with the users to convert business logic into ETL specifications.
  • Extensively analyzed and used Ralph Kimball approach for building Data warehouse.
  • Drafted Bus Matrix along with the other team members.
  • Extensively used ERWin for Logical / Physical Data modeling and Dimensional Data Modeling, and designed Star Schemas.
  • Designed the ER diagrams, logical model relationship, cardinality, attributes, and, candidate keys and physical database capacity planning, object creation and aggregation strategies for Oracle as per business requirements using Erwin.
  • Worked with Power Center - Designer tool in developing mappings and mapplets to extract and load the data from flat files, Oracle to Oracle.
  • Used Power exchange CDC change data capture for pulling from oracle source.
  • Created different transformations like Source Qualifier, Joiner transformation, Update Strategy, Lookup transformation, Rank Transformations, Expressions, Aggregator, Sequence Generator for loading the data into targets.

Environment: Informatica Power Center 8.1.1/7.1.4, Informatica Power Connect, Work Flow Monitor, Trillium, ERWin 4.1, Oracle 9i, DB2, MS SQL Server 7.0/2000, Shell Programming, SQL Loader, Business Objects 6.0, XML, TOAD, Flat files, Toad 7.0, Unix Shell Scripting.

Confidential

Role: ETL Developer

Responsibilities:

  • Responsible for ETL process under development, test and production environments.
  • Interpreted logical and physical data models for Business users to determine common data definitions and established referential integrity of the system using ERWin.
  • Done extensive bulk loading in to target using Oracle SQL Loader.
  • Used workflow manager for session management, database connection management and scheduling of jobs.
  • Involved in writing UNIX shell scripts for Informatica ETL tool to automate sessions.
  • Monitored sessions using the workflow monitor which were scheduled, running, completed or failed. Debugged mappings for failed sessions.
  • Assisted the team in the development of design standards and codes for effective ETL procedure development and implementation.
  • Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings and sessions.
  • Involved in the process design documentation of the Data Warehouse Dimensional Upgrades.
  • Developed Mapplets using corresponding Source and Transformations.
  • Executed sessions, sequential and concurrent batches for proper execution of mappings and worked on workflow manager.

Environment: Informatica Power Center 7.1, Teradata , Oracle 8i, MS SQL Server 7.0/2000, MS Excel 97, Flat files, PL/SQL, SQL, SQL Loader, Erwin 3.5, Toad 7.0, Transact-SQL, Windows 2000, Unix Shell Scripting and Business objects.

We'd love your feedback!