We provide IT Staff Augmentation Services!

Informatica Mdm Developer Resume

GA

SUMMARY:

  • Over 11 years of IT experience on Client - Server architecture, Business applications in various phases of IT projects such as analysis, design, development, implementation and testing of Data warehousing using Informatica (ETL), SQL, PL/SQL, and Oracle on OLAP and OLTP environment and also implementation of Database Management Systems for Health care and Insurance clients.
  • 3 Years of experience in configuring maintenance, testing and troubleshooting on Informatica Master Data Management9.x/10.x (MDM)
  • Experience in creating Base objects, Staging & landing tables, foreign key relationships, queries, packages, query groups and custom functions in Informatica MDM.
  • Good exposure in IDD using Hierarchy Configuration and created subject area groups, subject areas, subject area child, IDD display packages in hub and search queries for searching the data.
  • Experience in configuring batch groups for processing staging, loading base objects and for performing match jobs.
  • Experience in Configuring JMS Message Queue in the MDM hub Console and Soap based SIF API projects by using SoapUI for performing multiple tasks in Informatica MDM Hub. 
  • Involved in design of Dimension Models, Star Schemas and Snowflake schemas.
  • Experience in mapping techniques for Type 1, Type 2 and Type 3 slowly changing dimensions.
  • Experience with Mapping Designer, Workflow Manager, Workflow Monitor, Repository Manager.
  • Experience with all components of mapping designer such as Source Analyzer, Warehouse Designer, and Transformation Developer, Maplet designer.
  • Experience in Performance Tuning of Sources, Mappings, Targets and Sessions.
  • Strong skills in development of mappings, documentation, implementation and enhancement of ETL strategies.
  • Experience in designing and developing complex mappings applying various transformations such as Source Qualifier, Expressions, Sorter, Router, Filter, Aggregator, Joiner, Connected and Unconnected Lookups, Sequence Generator, Rank, Update Strategy and Stored Procedure.
  • Experience with Informatica Power Exchange 9.x/8.x for change data capture (CDC) and mainframe data.
  • Extensively worked with Informatica Data Quality for data analysis, cleansing, and data matching.
  • Extensive experience in Oracle Development in table designs, writing stored procedure, Database Triggers, Functions and PL/SQL packages. Strong knowledge in Oracle Cursor management and Exception Handling.
  • Extensive experience in performance Tuning SQL and PL/SQL code by using Explain Plan Table, Trace and TKPROF to significant improvement in system response time and efficiency.
  • Used pmcmd, mailx command to execute jobs from UNIX platform.
  • Programming skills using PL/SQL and Shell Scripts. Creation of scripts for collection of statistics, reorganization of tables and indexes and creation of indexes for enhancing performance.
  • Coordinated with business users and team members to resolve data quality related issues.
  • Experience in performing and supporting Unit testing, System Integration testing (SIT), UAT and production support for issues raised by application users.
  • Experience of systems analysis, design, development, testing, implementation, maintenance and business analysis.
  • Clear understanding of Business Intelligence and Data Warehousing Concepts.

TECHNICAL SKILLS:ETL: Informatica Power Center 9.1.0/8.x/7.x, Informatica MDM 9.1 & Informatica Data Quality (IDQ), Data Validation

Scheduling Tools: Autosys, ControlM

Reporting Tools: Business Objects 4.0, OBIEE 10g (10.1.3.4.1 )/11g, Cognos

Databases: Oracle11g/10g/9i/8i, Teradata, MS SQL Server, IBM DB2, Netezza

Operating Systems: Windows 07/XP/Vista/95/98, UNIX

Programming: SQL, PL/SQL, Matlab, HTML, XML, DHTML

Other Tools: SQL*Loader, SQL*Plus, TOAD v10.6/11.x/12.0, Oracle SQL Developer, MS Visio

Scripting Languages: UNIX Shell Scripting

Methodologies: E-R Modeling, Star Schema, Snowflake Schema

Web services : Soap, Rest web services, WSDL

Data Modeling Tool : Erwin r9.x/r8.x, SQL Developer Data Modeler

PROFESSIONAL EXPERIENCE:

Confidential, GA

Informatica MDM Developer

Responsibilities:
  • Designed, documented, and configured Informatica MDM Hub to load, cleanse, match, merge, and publish MDM Data.
  • Configured MDM Hub on JBoss Application Server.
  • Designed the Physical Data Model and assisted the Logical Data Model design.
  • Configured Landing Tables, Stage tables, and Base Objects.
  • Defined Foreign Key relationships among Base Objects and configured Lookups for Staging Tables.
  • Developed the ETL process to load data into the landing tables during the land process.
  • Developed mappings using various cleanse and address doctor functions.
  • Developed Hierarchies by configuring the Entity Base Objects, Entity Types, Relationship Base Objects, Relationship Types, Profiles, Put and Display Packages.
  • Tested existing Match Rules and performed Match Tuning by determining over and under Matches.
  • Monitored the Match/Merge process to ensure Data Quality.
  • Created MDM Stored Procedures and Batch Groups for MDM Hub.
  • Created relevant documentation and participated in end user training.
  • Created mapping between the databases and identified the possibilities of incorporating the new business rules with the existing design.
  • Created prototype reporting models, specifications, diagrams and charts to provide direction to system programmers.
  • Prepared High-level design (HLD), LLD, Project functional Specification Document and Business Requirement documentation (BRD).
  • Participated in Design team brainstorm and user requirement gathering meetings.
  • Converted the Business rules into Technical Specifications for ETL process.
  • Involved in all phases of SDLC from requirement, design, development, testing, pilot, training and rollout to the field users and support for production environment.
  • Implemented mapping techniques for Type 1, Type 2 and Type 3 slowly changing dimensions.
  • Developed ETLs for Data Extraction, Data Mapping and Data Conversion using Informatica PowerCenter.
  • Involved in the Development of Informatica mappings and mapplets and also tuned them for Optimum performance, Dependencies and Batch Design.
  • Worked on Informatica Power center 9.0.1 Tool - Source Analyzer, warehouse designer, Mapping Designer, Workflow Manager, Mapplets, Worklets and Reusable Transformation.
  • Involved in designing and developing complex mappings applying various transformations such as Source Qualifier, Expressions, Sorter, Router, Filter, Aggregator, Joiner, Connected and Unconnected Lookups, Sequence Generator, Rank, Update Strategy and Stored Procedure.
  • Extensively used Mapplets and Reusable Transformations to prevent redundancy of transformation usage and maintainability.
  • Worked with Informatica Power Exchange 9.0.1 for change data capture (CDC) and mainframe data.
  • Wrote scripts for collection of statistics, reorganization of tables and indexes, and creation of indexes for enhancing performance for data access.
  • Extensively used Explain Plan Table, Trace and TKPROF in performance Tuning SQL and PL/SQL code to significantly improve system response time and efficiency.
  • Used awk, sed, tar, grep commands, sql plus for connecting and loading data through UNIX.
  • Involved in Testing and Test Plan Preparation, Process Improvement for the ETL developments.
  • Involved in Data Quality Assurance, created validation routines, unit test cases and test plan.
  • Worked on design document through conduct of design walkthroughs, and independent review. Prepared Technical Specifications for all the utilities, as per the company's standards.
  • Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the Informatica mappings.
  • Prepared Technical documents for all the modules developed by our team.

Technical Environment: Informatica Multidomain MDM 9.1, PowerCenter 9.1, Informatica Power Exchange, COGNOS 8.3, SQL server 2008, JBoss, Windows Vista 

Confidential, Washington DC

Senior ETL/Informatica Developer

Responsibilities:

  • Involved in requirements gathering, analysis and implementation of the data warehouse.
  • Implemented delete detection on real-time data for operational real-time reporting purposes using Informatica Mappings and Staging tables.
  • Involved in Data Modeling the Dimensional and FACT tables E-R relationship.
  • Used various Informatica transformations like Aggregator, Joiner, Filter, and Sorter to improve the ETL performance.
  • Created Informatica mappings to transform source data and load it to target tables.
  • Used Informatica parameter variables and mapping variables to generate Dimensional keys and FACT keys for different source systems.
  • Effectively used Informatica’s BULK loading and parallelism strategy to improve the ETL data loads.
  • Added complex logic for Metrics calculations through Stored Procedures and used Informatica stored procedure transformations to load data.
  • Designed and developed Staging and Error tables to identify and isolate duplicates and unusable data from legacy systems through Informatica ETL data loads.
  • Developed Scheduled and Monitored Informatica ETL data extraction/load from legacy source to Operational Data Sources and then processed to Data Marts.
  • Provided 24*7 support for Production Migration.
  • Implemented Custom and Dimensional hierarchies through Informatica ETL load process.
  • Involved in various Test cycles and debugged errors with in ETL Transformations using Informatica Debugger.
  • Implemented Slowly Changing Dimensions of Type 2 and Type 3 and stored historical data in Data Marts through Informatica Mappings.
  • Developed reusable transformations and mapplets maximize the ETL load performance.
  • Implemented parallelism and dynamic caching at Informatica session level to reduce the load durations.
  • Used Informatica Update/Insert/Reject strategy to re-route the data to different FACT tables.
  • Developed complex Stored Procedures for automation of ETL process and data capture from Oracle EBS to ODS and DM tables.
  • Used Parameter files to initialize workflow variables, Mapping parameters and mapping variables and used system variables in mappings for filtering records in mappings.
  • Used pmrep and pmcmd Informatica commands to schedule and monitor data loads.
  • Used event wait/raise and Decision tasks to schedule data loads in a timely manner.
  • Implemented pre-sql and post-sql tasks to handle other data processing requirements.

Confidential, IL

ETL Developer

Responsibilities:
  • Involved in data analysis and development to understand attribute definitions for migration.
  • Prepared mapping specifications documents, unit testing documents for developed Informatica mappings.
  • Prepared mapping documents for loading the data from legacy system, flat files to staging area.
  • Prepared mapping documents for loading the data from staging area to IDS.
  • Defined Target Load Order Plan for loading data into different Target Tables.
  • Worked on Informatica Power center 8.5.1 Tool - Source Analyzer, warehouse designer, Mapping Designer, Workflow Manager, Mapplets, Worklets and Reusable Transformation.
  • Extensively used Router, Lookup, Aggregator, Expression and Update Strategy transformation.
  • Involved in the design and development of mappings from legacy system to target database.
  • Involved in performance tuning of the mappings by doing necessary modification to reduce the load time.
  • Used SQL tools like TOAD to run SQL queries and validate the data.
  • Defined test cases and prepared test plan for testing ODS jobs.
  • Involved in identifying bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing the bugs so that they conform to the business needs.

Technical Environment: Informatica PowerCenter 8.6 & 7.1, Informatica Power Exchange, COGNOS 8.3, SQL server 2005, Windows Vista, EPIC SYSTEM, Chronicles, Clarity Compass and Caboodle dimensional models 

Confidential, MI

ETL Developer

Responsibilities:
  • Involved in data analysis and development.
  • Prepared mapping specifications documents, unit testing documents for developed Informatica mappings.
  • Prepared mapping documents for loading the data from legacy system, flat files to staging area.
  • Prepared mapping documents for loading the data from staging area to ODS.
  • Defined Target Load Order Plan for loading data into different Target Tables.
  • Worked on Informatica Power center 8.5.1 Tool - Source Analyzer, warehouse designer, Mapping Designer, Workflow Manager, Mapplets, Worklets and Reusable Transformation.
  • Extensively used Router, Lookup, Aggregator, Expression and Update Strategy transformation.
  • Involved in the design and development of mappings from legacy system to target data base.
  • Involved in performance tuning of the mappings by doing necessary modification to reduce the load time.
  • Defined test cases and prepared test plan for testing ODS jobs.
  • Optimized Query Performance, Session Performance and Reliability.
  • Used pmcmd, mailx command to execute jobs from UNIX platform.
  • Coordinated with DBA team to resolve issues pertaining to load timings and any other database related issues which are hindering performance of loads.
  • Supported UAT testing and production testing by identifying the bugs and also helped to resolve various Data issues, Load Issues.
  • Involved in identifying bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing the bugs so that they conform to the business needs.
  • Used Informatica debugger for data fixes. Coordinating with offshore team to resolve mapping and functional related issues.

Technical Environment: Informatica PowerCenter 8.6, Informatica Power Exchange, Teradata, COGNOS8.3, SQL server 2005, Windows Vista 

Confidential

ETL Developer

Responsibilities:
  • Involved in design and development of business requirements by co-coordinating with business users.
  • Prepared mapping documents for loading the data from legacy system, flat files to staging area.
  • Defined Target Load Order Plan for loading data into different Target Tables.
  • Worked on Informatica Power center 7.1.4 Tool - Source Analyzer, warehouse designer, Mapping Designer, Workflow Manager, Mapplets, Worklets and Reusable Transformation.
  • Extensively used Router, Lookup, Aggregator, Expression and Update Strategy transformation.
  • Involved in the design and development of mappings from legacy system to staging, staging to ODS and ODS to data marts.
  • Involved in performance tuning of the mappings by doing necessary modification to reduce the load time.
  • Defined test cases and prepared test plan for testing ODS jobs.
  • Involved in identifying bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing the bugs so that they conform to the business needs.
  • Used Informatica debugger for data fixes. Coordinated with offshore team to resolve mapping and functional issues.

Technical Environment: Informatica PowerCenter 7.1, Business Objects, Microstrategy, Oracle 10g,SQL Server 2005,DB2, Toad, PL/SQL, Windows xp, Unix shell scripting 

Hire Now