We provide IT Staff Augmentation Services!

Informatica Mdm Developer Resume

5.00/5 (Submit Your Rating)

Richmond, VA

SUMMARY:

  • 7+ years of IT industry with substantial experience in providing information management consulting services on Informatica Power Center, Informatica Master Data Management, Data Integration and Business Intelligence Applications.
  • Extensive experience in implementation of Data Warehousing, Data Marts, Star and Snowflake Schema, Dimensional Modeling on OLTP and OLAP concepts
  • Hard working results - oriented professional team player with good communication skills and quest for excellence.
  • Have extensively worked in developing ETL for supporting Data Extraction, transformations and loading using Informatica Power Center.
  • Designing, Installing & Configuring core Informatica MDM Hub components Informatica MDM Hub Console, Hub Store, Hub Server, Cleanse Match Server, Cleanse Adapter and IDD & Data Modeling.
  • Master Data Management concepts, Methodologies and ability to apply this knowledge in building MDM solutions.
  • MDM Hub configurations - Data modeling, Data Mappings, Data validation, Match and Merge rules, Hierarchy Manager, customizing/configuring Informatica Data Director.
  • Defining and configuring landing tables, staging tables, base objects, hierarchies, foreign-key relationships, lookups, query groups, queries/custom queries and packages.
  • Designing & developing multiple cleansing and standardization scenarios using Address Doctor.
  • Informatica (Siperian) MDM processes including batch based and real-time processing.
  • Performing Data standardization of addresses using Address Doctor, Trillium, and Informatica Data in real-time using SIF API’s.
  • Informatica MDM Hub Match and Merge Rules, Batch Jobs and Batch Groups.
  • Configuring Informatica Data Director (IDD) to meet Data Governance objectives in many project life cycles.
  • Strong experience in Informatica Data Quality (IDQ), Power Center, Data Cleansing, Data profiling, Data quality measurement and Data validation processing
  • 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.
  • Experience with Type 1, Type2, Type3 Dimensions.
  • Experience with slowly changing dimension methodology and slowly growing targets methodologies.
  • Experience in using the Informatica command line utilities like pmcmd to execute workflows in non-windows environments.
  • Extensively used Informatica Repository Manager and Workflow Monitor.
  • Experience in debugging mappings. Identified bugs in existing mappings by analyzing the data flow and evaluating transformations.
  • Hands on experience in Performance Tuning of sources, targets, transformations and sessions.
  • Good experience in documenting the ETL process flow for better maintenance and analyzing the process flow.
  • Worked with Stored Procedures, Triggers, Cursors, Indexes and Functions.

TECHNICAL SKILLS:

EIM Tools: Informatica MDM Multi-Domain 9.7.1, 9.x, IDD, SIF.

ETL Tools/Packages: Informatica Power Center 9.5/9.1/8.6/7. X

Reporting Tools: Cogno s 10 & Informatica Power Analyzer 4.0

Data Modeling Tools: ER Studio, Erwin, Address Doctor, And Trillium.

Querying Tools: SQL Query Analyzer 2000, Microsoft Query, SQL Developer, SQL Advantage, SQL*PLUS, File-Aid/MVS, Toad

Database: Oracle 11g/10g/9i/8i, Sybase, SQL server 2000

Scheduling Tools: Workflow Manager, ESP, Control-M

Languages: SQL, PL/SQL, C, C++

Operating System: Windows NT/2000/XP, UNIX, Windows 7, Windows 8, 8.1

MS Products: MS Visio, MS Project, MS office Suite, MS SharePoint

PROFESSIONAL EXPERIENCE:

Confidential, FL

Informatica MDM Developer

Responsibilities:

  • Implement and configure new partner data model and partner data hub.
  • Enable Partner data model Front End for business to enable partner management functions.
  • Leverage front end to validate and accept cleaned partner data.
  • Make partner profile data available to BI / Analytics / DWH layer.
  • Installed & Configured MDM Hub on Dev, Test and Prod Server, cleanse, and Address Doctor in Dev, QA.
  • Gathered requirements from business users by conducting brain storming sessions.
  • Played an important Key role to create data model according to the requirements.
  • Defined the Base objects, Staging tables, foreign key relationships, static lookups, dynamic lookups, queries, packages and query groups.
  • Created Mappings to get the data loaded into the Staging tables during the Stage Process.
  • Defined Trust and validation rules before loading the data into the base tables.
  • Coordinated with Business Leads in making them understand Match & Merge and incorporated their requirements and ideas.
  • Created Match rule sets in for the base objects by defining the Match Path components, Match columns and rules.
  • Developed Hierarchies using Hierarchy Manager in the Hub as per the needs.
  • Created IDD application and Subject Areas, Subject Area Groups, Deploy and test IDD application, cleanse functions, utilizing timeline, export and import master data from flat file.
  • Worked extensively on BDD config file to get the changes reflected on IDD.
  • Analyzed the data by running the queries and provided the stats after Initial data and incremental Loads.
  • Configured JMS message Queue and message triggers with SIF API.
  • Configured Web services using SIF API Interface.
  • High-level review of SAM - discussed use of Roles, creation of users and assignment of user to Role.
  • Defined Roles and privileges for each environment according to the platform requirements.
  • Scheduled MDM Stage Jobs, Load jobs.
  • Helped UAT team testing the new platform and authoring test cases.
  • Involved with ETL team in getting the data loaded into the landing tables.
  • Work closely with Enterprise Data Quality Lead and business users to understand the Data lineage and DQ framework.
  • Participate in design and development for DQ and Data lineage, Implementation and coordinating User testing and business training.
  • Execute data quality measurement and monitoring process utilizing techniques to provide insights into the quality of Data
  • Experience in developing data quality initiatives to evaluate new and existing data attributes

Environment: Informatica MDM 9.7.1, Power Centre, SIF, IDQ, IDD, Toad, SQL Developer, Oracle 11g, SQL loader, Linux

Confidential, Richmond, VA

Informatica MDM Developer

Responsibilities:

  • Installed & Configured MDM Hub on Dev, Test and Prod Server, cleanse, resource kit, and Address Doctor in Dev., QA.
  • Gathered requirements from business users
  • Creating the Base objects, Staging tables and landing tables foreign key relationships, static lookups, dynamic lookups, queries, packages and query groups.
  • Created Mappings to get the data loaded into the Staging tables during the Stage Process.
  • Defined Trust and validation rules for the base tables.
  • Coordinated with Business team and making them understand Match & Merge and incorporated their requirements.
  • Created Match rule sets in for the base objects by defining the Match Path components, Match columns and rules.
  • Created IDD application and Subject Areas, Subject Area Groups, Deploy and test IDD application, cleanse functions, utilizing timeline, export and import data.
  • Configured Address Doctor and fixed the AD issues by doing the changes in the config file.
  • Worked on BDD config file to get the changes reflected on IDD.
  • Developed and created queries that can be used for over and under Matching.
  • Analyzed the data by running the queries and provided the stats after Initial data and incremental Loads.
  • Discussed use of Roles, creation of users and assignment of user to Role.
  • Defined Roles and privileges for each environment according to requirements.
  • Defined the security such that schema will be secured with access only granted for specific downstream integration uses, using users created for those specific integrations.
  • Created Batch Groups in Utilities Workbench and scheduled them externally using Power Center and Autosys (any scheduling tool).
  • Contribute towards enrichment of data quality rules.
  • Combining regulatory and application requirements into the business rules.
  • Providing the advanced business rule writing skills via IDQ Developer and our skilled technicians

Environment: Informatica Multidomain MDM 9.5.0, IDD, Informatica Power Center 9.1.0, IDQ, Jboss, Oracle 10g,SQL Developer, Address Doctor, SIF, Toad, SQL*Loader, Erwin.

Confidential , Pittsburgh, PA

ETL/Informatica Developer

Responsibilities:

  • Interacted with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business.
  • Designed ETL specification documents for all the projects.
  • Created Tables, Keys (Unique and Primary) and Indexes in the SQL server.
  • Extracted data from Flat files, DB2, SQL and Oracle to build an Operation Data Source. Applied business logic to load the data into Global Data Warehouse.
  • Extensively worked on Facts and Slowly Changing Dimension (SCD) tables.
  • Maintained source and target mappings, transformation logic and processes to reflect the changing business environment over time.
  • Used various transformations like Filter, Router, Expression, Lookup (connected and unconnected), Aggregator, Sequence Generator, Update Strategy, Joiner, Normalizer, Sorter and Union to develop robust mappings in the Informatica Designer.
  • Extensively used the Add Currently Processed Flat File Name port to load the flat file name and to load contract number coming from flat file name into Target.
  • Worked on complex Source Qualifier queries, Pre and Post SQL queries in the Target.
  • Worked on different tasks in Workflow Manager like Sessions, Events raise, Event wait, Decision, E-mail, Command, Worklets, Assignment, Timer and Scheduling of the workflow.
  • Extensively used workflow variables, mapping parameters and mapping variables.
  • Created sessions, batches for incremental load into staging tables and scheduled them to run daily.
  • Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
  • Implemented Informatica recommendations, methodologies and best practices.
  • Implemented performance tuning logic on Targets, Sources, Mappings and Sessions to provide maximum efficiency and performance.
  • Involved in Unit, Integration, System, and Performance testing levels.
  • Written documentation to describe program development, logic, coding, testing, changes and corrections.
  • Migrated the code into QA (Testing) and supported QA team and UAT (User).
  • Created detailed Unit Test Document with all possible Test cases/Scripts.
  • Conducted code reviews developed by my team mates before moving the code into QA.
  • Provided support to develop the entire warehouse architecture and plan the ETL process.
  • 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.
  • Involved in production support.
  • Works as a fully contributing team member, under broad guidance with independent planning & execution responsibilities.

Environment: Informatica Power Center 8.6, Oracle 10g, SQLServer2008, IBM I Series (DB2), MS Access, Windows XP, Toad, Tidal, Cognos 8.4.1., SQL developer.

Confidential, NEW YORK, NY

Informatica Developer

Responsibilities:

  • Actively Participated in collecting user requirements.
  • Involved in drafting Software Requirement Specification for the project.
  • Developed High Level Technical Design specification and Low-level Design based on business requirements.
  • Drove the development of the logical and physical data models, ETL programs/scripts, metadata definitions, schedules, work processes, and maintenance procedures
  • Prepared database DDL scripts for create, delete, alter table.
  • Created ETL specifications describing the mapping logic for developers.
  • Identified bottlenecks in source, target, mapping, session and resolved them by implementing better logic and/or database object/query optimization.
  • Involved in performance tuning and optimization of Informatica mappings and sessions using features like partitions and data/index cache to manage very large volumes of data.
  • Monitoring Production system, performed complex defect fixes in various environments like UAT, SIT etc. to ensure the proper delivery of the developed mapping into the production environment.
  • Oversaw the design of the data and technical architecture for the data warehouse.
  • Evaluate the Change Data Design, including slowly changing dimensions and Operational Data Store Design.
  • Prepared time estimates and tracked each task against the estimated task and assisted in keeping project delivery deadline.
  • Document all ETL related work per company's methodology.
  • Worked with the testers closely in determining both medium and high severity defects, and also fixed the defects before moving into production.
  • Worked along with UNIX team for writing UNIX shell scripts to customize server job schedules.
  • Co-ordinated with Off-Shore team in .
  • Documented the process for maintenance of the project and for production support.
  • Prepared the Standard Operating Procedure (Knowledge Transfer) document, which provides necessary information, required for the Maintenance and Operation of the application.
  • Actively involved in production support. Implemented fixes/solutions to issues/tickets raised by user community.

Environment: Informatica Power Center7.x, Oracle 10g, Pl/Sql, Visio, Erwin, Windows, UNIX Shell Scripts, AIX.

Confidential

ETL/Informatica Developer

Responsibilities:

  • Responsible for designing and developing of mappings, mapplets, sessions and work flows for load the data from source to target database using Informatica Power Center and tuned mappings for improving performance.
  • Performed Informatica Admin role by creating new repositories, users and groups.
  • Involved in ETL process from development to testing and production environments.
  • Extracted date from various sources like Flat files, Oracle and loaded it into Target systems using Informatica 7.x.
  • Developed mappings using various transformations like update strategy, lookup, stored procedure, router, joiner, sequence generator and expression transformation.
  • Used Informatica Power Center Workflow Manager to create sessions, batches to run with the logic embedded in the mappings.
  • Tuned mappings and SQL queries for better performance and efficiency.
  • Performed Unit testing and validated the data.
  • Created & Ran shell scripts in UNIX environment.
  • Created and ran the Workflows using Workflow manager in Informatica Maintained stored definitions, transformation rules and targets definitions using Informatica repository manager.
  • Created tables and partitions in database Oracle.

Environment: Power Center 7.x, Oracle, SQL developer, MS Access, Windows XP.

We'd love your feedback!