Informatica Consultant Resume
NC
SUMMARY
- 7+years of IT experience in analysis, design, development and implementation of Client/Server, Internet/Intranet, Data Warehouse/Data Mart & Business Intelligence applications
- Experience and strong business knowledge in domains like Finance, Insurance, Banking and Pharma.
- Extensive experience with ETL tool Informatica Power Center /Power Mart 9x/8x/7x, Power Exchange 9.x/8.xin designing and developing complex Mappings, Mapplets, Transformations, Workflows, Worklets, Configuring the Informatica Server and scheduling the Workflows and sessions.
- Experienced in using Databases Oracle 11g/10g/9i, DB2, Sybase, Teradata, Netezza, SQL Server 2005/2008. Strong Experience on database interfaces like PL/SQL Developer, SQL Plus and TOAD.
- Extensive experience in designing and developing complex mappings from varied transformation logic likeUnconnected and Connected lookups, Normalizer, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy.
- Worked with Informatica Data Quality 8.6.1 (IDQ) toolkit, Analysis, data cleansing.
- Proficient with Informatica Data Quality (IDQ) for cleanup and massaging at staging .
- Experience in Configuration of Informatica MDM Data Director, Hierarchy Manager, Match/Merge process
- Hands - on experience with Informatica MDM Hub configurations - Data modeling Data Mappings (Landing, staging and Base Objects), Data validation, Match and Merge rules, writing and customizing user exits, customizing configuring Business Data director (BDD)Informatica data director (IDD)applications
- Experience in completeSoftware Development Life cycle(SDLC) including Requirement, Analysis, estimations, Design, Construction, Unit and System Testing and implementation.
- Experience in Application Design, Data Extraction, Data Acquisition, and Data Mining Development, Implementations and Testing of Data warehousing and Database business systems.
- Extensively followed the advanced concepts ofRalph KimballandBill Inmon Methodologies.
- Extensive knowledge ofData Modeling, Data Conversions, Data integration and Data Migrationwith specialization in Informatica Power Center and Erwin.
- Expert onSlowly Changing Dimensions Type 1, Type 2andType 3for inserting and updating Target tables for maintaining the history.
- Expert-level mastery in designing and developing complex mappings to extract data from diverse sources including flat files, RDBMS tables, legacy system files.
- Implemented data warehousing methodologies for Extraction, Transformation and Loading usingInformatica Designer, Repository Manager, Workflow Manager, Workflow Monitor, Repository Server Administration Console.
- Experience in working withUNIX Shell Scriptsfor automatically running sessions. Written number of shell scripts to run various batch jobs.
- Experience in working with Informatica web services components.
- Solid experience in writing SQL queries,Stored Procedures, Cursors, Indexes, and Views.
- Experience onDebuggerto validate the mappings and gain troubleshooting information about data and error conditions.
- Experience onpost-session and pre-session shell scriptsfor tasks like merging flat files after Creating, deleting temporary files, changing the file name to reflect the file generated date etc.
- Excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels.
TECHNICAL SKILLS
ETL Tools: Informatica Power Center 9.x/8.x/7.x/6.x, IDQ 8.x, MDM 9.x
Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snow Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Sybase Power Designer 16/15, Erwin 3.5.2/ 3.X & Toad 8.0/9.1
Databases: Oracle 11g/10g/9i/8i/8.0/7.x, IBM DB2 UDB 8.0/7.0, Netezza 5.0/6.0, XML, TeraData, SQL Server 2000/ 2005/ 2008 & MS Access
Scheduling Tools: Autosys, Control-M, ESP
Reporting/OLAP Tools: Business Objects XI 3.1, OBIEE 10.1.X, Cognos
Programming: SQL, PL/SQL, VB, C, C++ & Java, SQL*Plus & SQL*Loader, UNIX Shell Scripting
PROFESSIONAL EXPERIENCE
Confidential, Charlotte, NC
Sr. Informatica Developer/Lead
Responsibilities:
- Responsible for Business Analysis and Requirements Collection.
- Parsed high-level design specification to simple ETL coding and mapping standards.
- Designed and customized data models for Data warehouse supporting data from multiple sources on real time.
- Designed and developed ETL strategies and Mappings from source systems to target systems. ETL strategies were designed to cater initial and incremental load.
- Extensively used Power Center to design multiple mappings with embedded business logic. Creation of Transformations like Lookup, Joiner, Rank and Source Qualifier Transformations in the Informatica Designer.
- Worked with business SMEs on developing the business rules for cleansing. Used Informatica Data Quality (IDQ) tool for data cleansing by applying rules.
- Worked with Informatica Data Quality 8.6.1 (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ 8.6.1.
- Installation of Informatica MDM hub.
- Resolved Inconsistent and Duplicate date to support strategic with Multidomain MDM.
- Perform Informatica MDM Design, Configuration and Implementation. Designing ETL Mappings, Informatica MDM User Exists, Match rules etc.
- Created relationships for the base objects which reflects from look up tables in MDM.
- Created complex mappings using Unconnected Lookup, Sorter, and Aggregator, Lookup and Router transformations for populating target table in efficient manner.
- Created mapping documents to outline data flow from sources to targets.
- Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.
- Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
- Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
- Worked on using Informatica web services.
- Created Mapplets to use them in different mappings.
- Developed mappings to load into staging tables and then to Dimensions and Facts.
- Used existing ETL standards to develop these mappings.
- Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
- Performance tuning of the Informatica mappings using various components like Pushdown optimization, Parameter files, Variables and Dynamic Cache. Performance tuning using round robin, hash auto key, Key range partitioning.
- Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, Worklets, Assignment, Timer and scheduling of the workflow.
- Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
- Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
- Modified existing mappings for enhancements of new business requirements.
- Prepared migration document to move the mappings from development to testing and then to production repositories.
- Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.
- Worked with Session Logs and Workflow Logs for Error handling and troubleshooting in DEV/QA/PRD environment.
- Tuned performance of mapping and sessions by optimizing source, target bottlenecks and implemented pipeline partitioning.
- Development of customizedPL/SQLprocedures functions and packages to load data into and extract data from staging tables and facts.
- Created, developed and tested reports using Business Objects Info View web intelligence and Universe designer. Interaction with users to meet their reporting needs.
Environment: Informatica 9.x, Oracle 11g/10g, MDM 9.x, IDQ 8.x, SQL Server 2008, Autosys, Business Objects XI 3.1, CVS with Eclipse, JIRA V4.1, PL/SQL, SQL Developer, Toad for SQL Server, Cognos, Microsoft Excel, Visio.XML.
Confidential, Raleigh, NC
Sr. Informatica Developer
Responsibilities:
- Extensively used ETL to load data from different source systems like Flat files into the Staging table and load the data into the target database.
- Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
- Developed Informatica mappings, re-usable transformations, re-usable mappings and mapplets for data load to data warehouse and database.
- Multi source Extraction Transformation and Loading into the target structures using Informatica.
- Worked closely with multiple business units and a data solutions engineer to identify key information that will enhance business decision-making.
- Performance tuned mapping, sessions and database.
- Wrote stored procedures to accomplish tasks.
- Resolved Inconsistent and Duplicate Data to Support Strategic Goals with Multidomain MDM.
- Configured the match and merge rules and implemented in base objects in MDM.
- Created landing tables, stage tables and base objects in MDM and ran batch jobs which load data into base objects.
- Involved Data Flux Expression Language provides statements, functions, and variables for.
- Used Informatica IDQ 8.6.1 to complete initial data profiling and matching/removing duplicate data.
- Created sessions to move the data at specific intervals and on demand.
- Responsible for monitoring all the sessions that are running, scheduled, completed and failed.
- Debugged the mapping for failed session to fix data and code issues.
- As a part of daily loading into the warehouse, used UNIX shell scripting to triggers the workflows in a particular order.
- Involved in coding UNIX shell scripting to execute pre/post session commands.
- Involve in enhancements and maintenance activities of the data warehouse including performance tuning, rewriting of stored procedures for code enhancements.
- Analyzed and Created Facts and Dimension Tables.
- Used different Data Warehouse techniques like Star-Schema, Snow-Flake Schema.
- Involved in the installation and configuration of Oracle Business Intelligence OBIEE 10.1.3.4.
- Developing multiple dimensions (drill down hierarchies), logical objects in business model & mapping layer and creating presentation catalogs in presentation layer.
- Informatica Data Quality was used for cleansing and matching the customer data. Real-time address cleansing was achieved using Informatica Power Connect for Web Services.
Environment: Informatica Power Center 9.1/9.0, Oracle 11g/10g, MDM, IDQ, Autosys Scheduler, Cognos, Web Services, DB2 6.1, XML, Erwin, SQL Loader, PL/SQL, UNIX, SOA.
Confidential, Omaha, NE
ETL Consultant
Responsibilities:
- Extensively involved in interacting with Project coordinators, Business Analysts and End-users to gather requirements.
- Prepared the ETL spreadsheet after identifying the Facts and Dimensions.
- Designed the Star Schema after identifying the Facts and Dimensions.
- Prepared the Fact Dimension Matrix Spreadsheet prior to the development of rpd for the required reports.
- Used the Informatica Power center designer to develop the required mapping based on the mapping document.
- Used the Informatica Power Center Workflow Manager to develop the required sessions for the mappings developed based load dependency.
- Performed change data capture (CDC) process using SCD-I and SCD-II implementations.
- Used the Workflow Manager to create tasks, sessions, worklets and batches.
- Debugged and fixed failed or faulty mappings.
- Worked with Informatica Data Quality 8.6.1 (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ 8.6.1.
- Implemented the best practices for creating the mappings, sessions and workflows.
- Identified bottlenecks in the ETL process and restructured the mappings and sessions to improve the ETL performance.
- Used Control-M for scheduling jobs.
- Unit tested the mappings before including the developed sessions into the already existing batch.
- Integration tested the entire batch after including the individual sessions into the existing batch.
- Involved in configuring new jobs and importing the newly developed INFORMATICA sessions into DAC.
- Implemented the ETL processes using OWB 10gr2 to load data from sources system (SQL Server) into the staging.
- Developed mappings using OWB for data loading. Created Process flow, scheduled & monitored session.
Environment: Informatica Power Center 8.6,, IDQ, DAC, Control-M, Oracle 10g/9i, SQL Server 2005, Toad, Windows XP, Microsoft Word, Microsoft Excel, PowerPoint.
Confidential
Informatica Consultant
Responsibilities:
- Designed, Developed and Tested Physical Layer, Business Layer and Presentation Layer of Siebel Analytics.
- Created and Tested Report in the Dashboard.
- Designed, Developed and Tested Data security and Dashboard security in Analytics.
- Migrated the Tested Code from Dev to QA and QA to Production of Repository, Dashboard Reports and Informatica mappings and workflow and DAC Entities.
- Designed the logical and physical data model for Siebel data warehouse to store OLAP data.
- Analytics Admin work: New Id creation, Account modification of existing users, Password reset and Deletion of accounts.
- High Level Design and Detail Design for Informatica.
- Used Informatica Mappings and Transformations to load data into the data mart.
- Created & Called Stored Procedures and functions using Informatica.
- Used Oracle Loader to Load Bulk Data.
- Created Worklets & Workflows to Schedule and Trigger Mappings.
- Used Look Ups to Identify Data as per the predefined Criteria / Business Rule.
- Designed, Created and used Mapplets for Repeated functionalities.
- Sourced Data from multiple databases & files.
Environment: Informatica power center 8.1, TIDAL, TeraData, SQL Server 2005 and TOAD.
Confidential
Informatica Developer
Responsibilities:
- Prepared ETL Mapping spreadsheet and Fact - Dimension Matrix. Repository Design.
- Used Designer to develop the mappings based on ETL Mapping Spreadsheet.
- Debugged and implemented the best practices in mappings, sessions for data extraction and loading from source to target databases.
- Checked the source, target and mapping bottlenecks to tune the ETL process performance.
- Worked on the Siebel Analytics Admin Tool to configure the business model based on the end user requirements.
- Created Logical dimensions, columns, and Logical Joins. Set levels to support drill-down, and aggregation over Columns.
- Used Time series Wizard for time comparison measures in the business model.
- Created all the Reports as per requirements using Siebel Analytics answers.
Environment: Informatica Power mart 6.1.2, Siebel Analytics 7.5, Oracle 9i, PL/SQL, UNIX, TOAD.