We provide IT Staff Augmentation Services!

Senior Informatica Mdm Developer Resume

5.00/5 (Submit Your Rating)

SUMMARY

  • 11+ years of IT experience in Enterprise Information Management and Data Warehousing with Analysis, Design, Implementation of EIM Tools, Business Intelligence systems, Reporting tools and OLAP environments along with strong analytical skills.
  • Strong expertise in installing and configuring the core Informatica MDM components (Informatica MDM Hub Server and Hub Cleanse).
  • Proficient in developing solutions using Informatica MDM & SAG One - Data MDM.
  • Configuring and maintaining various components of the Informatica MDM Hub including the Landing and Staging tables, Base objects, Relationships, Cleanse Lists, Cleanse Functions, Mappings, Queries, Packages, Triggers, Hierarchies and Validation Rules.
  • Expertise in Informatica MDM Hub Match and Merge Rules, Trust, Batch Jobs and Batch Groups.
  • Extensive experience in creating Entity 360 application using Provisioning tool and IDD application using BDD configuration.
  • Created Business Entities, Business Entities View, Reference Entities, Relationships, Transformations, Tasks, Triggers, Events, Elastic Search Configuration, Entity 360 layout configuration in Provisioning Tool.
  • Worked on BES External Calls for Entity 360 validation and User Exits to perform IDD data validation.
  • Created and Configured Subject Areas and Subject Area Groups, related Base Object relationships with Subject Area relationships in IDD.
  • Experience in using SOAP UI to interact with MDM using SIF calls.
  • Created Entity Base Objects, Hierarchies, Foreign Key Relationship Objects, Relationship Base Objects, Packages and Profiles using Hierarchy manager.
  • Worked on User groups, Privileges and Roles to the users using Security Access Manager (SAM) in Informatica MDM.
  • Created and configured SAG One-Data Master Data Management (MDM) components i.e. Base objects, Interchange Mappings, Filters, Source System, Import Jobs, Rules, Batch Groups, Hooks, Export Jobs, Messaging, UI layout.
  • Knowledge in Informatica Power Center tools such as Source Analyzer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager, Workflow Monitor and Repository Manager.
  • Excellent experience in using and writing UNIX Shell Scripts.
  • Expertise in using Fastload, Multiload, Sqlloader, BTEQ and Crontab scripts.
  • Extensively involved in writing Oracle, Teradata, PL/SQL, Stored Procedures/ Functions/Cursors/ Packages & Triggers.
  • Worked with various SQL developer tools such as TOAD, Teradata SQL Assistant, SQL Plus, and SQL Developer.
  • Expertise in OLTP/OLAP system study, analysis, E-R modeling and developing database schemas like Star Schema and Snowflake schema.
  • Worked on Scala Programming Language in IntelliJ IDEA.
  • Experience in using Databricks, Spark SQL, DataFrames and Storage Explorer.
  • Certified IBM Cognos BI Author with immense experience in the area of Report Studio, Framework Manager, Query Studio and Cognos Connection.
  • Strong experience in Installing, Configuring, Monitoring and Management of Cognos on Windows Platform.
  • Proficient in developing business models using Framework Manager by applying various business specific calculations, filters and security requirements and publishing metadata into IBM Cognos BI platform in the form of Packages.
  • Excellent knowledge in creating various kinds of reports in Cognos - List, Crosstab, Chart, Drill-Through, Master-Detail Relationship, etc.
  • Working experience in integrating Java code inside Prompt pages and Report pages using HTML object.
  • Experience in creating Prompt pages using different kind of prompts and have excellent skill in creating a Report Layout.
  • Experience in using different relational reporting styles like Group, Summarize, Detail and Summary filter, Sort, Over- riding the data model, etc.
  • Expert in using Cognos Connection for Customizing, Security, Organizing, Managing, Scheduling and Distributing reports.
  • Created Test Cases, Test Steps, Requirement Mapping, Defects in HP ALM.

TECHNICAL SKILLS

EIM Tools: Informatica MDM Multi-domain, Informatica MDM Provisioning Tool, Informatica Data Director (IDD), Entity 360, Informatica Power Center, SAG One-Data

Databases: Oracle, Teradata, MySQL, SQL Server

Languages: SQL, PL/SQL, Unix Shell Scripting, Scala Programming

RDBMS Tools: TOAD (Oracle), Oracle SQL Developer, SQL*Loader (Oracle), SQL*Plus, Teradata SQL Assistant, MySQL

OLAP/ Reporting Tools: IBM Cognos Report Studio 8.x/10.x, IBM Cognos Query Studio 8.x/10.x, IBM Cognos Framework Manager 8/10MSTR (Microstrategy)

Modeling Tools: Erwin, MS Visio

Environment: Windows, Unix

Packages: MS Office (MS Outlook, MS Excel, MS PowerPoint, MS Word, MS OneNote, MS Lync)

Other Tools: HP Application Life Cycle Management, HP Service Manager, Serena Dimension, Clear Case, JIRA, IntelliJ IDEA

Utilities: Putty, WinSCP, SOAP UI, REST Client, mIRC, Beyond Compare

PROFESSIONAL EXPERIENCE

Senior Informatica MDM Developer

Confidential

Responsibilities:

  • Creates and configures Informatica Master Data Management (MDM) and Entity 360 (E360) components i.e. Base objects, Staging tables, Landing tables, Hierarchies, Mappings, Packages and Queries, Trust and Source System, Validation Rules, Match and Merge rulesets, Cleanse list, Cleanse functions, JMS Messaging, Batch Groups, Roles, Hub user exits, Business Entities, Business Entities View, Reference Entities, Relationships, Transformations, Tasks, Triggers, Events, BES External Calls, Elastic Search Configuration, Entity 360 layout.
  • Works on deploying the HUB side user exits and BES External Calls to customize and validate the data flow according the business rules.
  • Creates Global ID’s (using Oracle sequence and Views) and implements the persistent Global ID module using Oracle and Informatica MDM Hub.
  • Develops inbound and outbound mappings/workflows to extract data from different source systems, cleansing and standardizing and loading into Informatica MDM Hub landing tables using Informatica ETL tool.
  • Develops Oracle (PL/SQL) custom procedures to provide reports and data load stats.
  • Creates Materialized Views to publish the data to downstream systems.
  • Configures Match Columns and Match Rules by performing Match Tuning.
  • Performs Code Migration of MDM Hub and BES components to promote changes from development to SIT environment.
  • Updated UNIX shell script as part of multi-threading in Inbound Submission parsing of 356H forms using UNIX shell script and Informatica ETL to increase the performance of parsing.
  • Creates MDM part of Version Description Document (VDD) for deploying the JIRA fixes in Pre-Production and Production.
  • Participates in runbook creation for the Pre-Production and Production release.
  • Works with Informatica product support team for MDM product related issues.

Environment: Informatica MDM 10.3, Informatica MDM Provisioning Tool, Weblogic 10.3.6, TOAD for Oracle, UNIX, SOAP UI, JIRA.

Confidential

Senior MDM Developer / Scala Developer / Tester

Responsibilities:

  • Participate in gathering and analyzing of internal business requirements by means of interviews, workflow analyses and facilitated discussions with users.
  • Translate user’s business requirements into technical requirements and then creating detailed functional designs for development, testing and implementation.
  • Help in creation of features from technical/business requirements and decomposition of features to user stories, writing user stories for the Development Team.
  • Prepare detailed specifications using case statements and related documentation.
  • Identify and communicate risks and issues impacting business rules, functional requirements and specifications.
  • Participate in managing the scope of applications and related changes.
  • Create tasks and sub-tasks for each user story.
  • Develop the user story and unit test it.
  • Create inbound views in source to make data extraction easier.
  • Create base tables, outbound views in Release Area (RA) and Work Area (WA) and synchronize those in One-Data.
  • Creates and configures SAG One-Data Master Data Management (MDM) components i.e. Base objects, Interchange Mappings, Filters, Source System, Import Jobs, Rules, Batch Groups, Hooks, Export Jobs, Messaging, UI layout.
  • Migrate the code to higher environments.
  • Create confluence pages for the data loads and technical details of features.
  • Maintain code versions as per each sprint and release.
  • Assist quality assurance with functional test case reviews.
  • Creation of training materials and assist with user orientation, sprint/release demo and training.
  • Interact with internal and external peers and managers to exchange information related to areas of specialization.
  • Liaison between engineering, quality assurance and non-technical stakeholders during the development and deployment process.
  • Mentor less experienced members of the team.
  • Responsible for the scope of the features within a Release based on priority and keep Scrum team aligned to development of these features within a Release.
  • Being able to drive resolution, taking accountability and being proactive in driving closure to issue.

Environment: SAG One-Data 10.1, Informatica MDM 10.2, Oracle, SQL Developer, UNIX, SOAP UI, JIRA, IntelliJ IDEA, Scala Programming Language, Databricks, Spark SQL and DataFrames, Storage Explorer.

Senior Informatica MDM Developer / Support Resource / Tester

Confidential

Responsibilities:

  • Creates and configures Informatica Master Data Management (MDM) and Informatica Data Director (IDD) components i.e. Base objects, Staging tables, Landing tables, Hierarchies, Mappings, Packages and Queries, Trust and Source System, Validation Rules, Match and Merge rulesets, Cleanse list, Cleanse functions, JMS Messaging, Batch Groups, Composite service, Hub user exits, IDD Subject Area group, Subject Area, Subject Area Child and Grandchild layout.
  • Works on deploying the HUB side user exits and IDD user exits to customize and validate the data flow according the business rules.
  • Creates Global ID’s (using Oracle sequence and Views) and implements the persistent Global ID module using Oracle and Informatica MDM Hub.
  • Develops inbound and outbound mappings/workflows to extract data from different source systems, cleansing and standardizing and loading into Informatica MDM Hub landing tables using Informatica ETL tool.
  • Develops Oracle (PL/SQL) custom procedures to provide reports and data load stats, integrate into Informatica Master Data Batch groups.
  • Finalizes the Match Columns and Match Rules by performing Match Tuning.
  • Configures the Composite services (Rest based web services) using Informatica Provisioning tool for internal User Interface interaction and publish to the downstream consumers.
  • Performs Code Migration in Hub and in IDD (by importing Business Data Director (BDD) Configuration files, Message bundles, Error code bundles and User Exits by clearing cache and redeploying the applications) to promote changes between all environments from development to production
  • Created UNIX shell script as part of Implementing multi-threading in Inbound Submission parsing of 356H forms using UNIX shell script and Informatica ETL to increase the performance of parsing.
  • Creates email notification script in UNIX to notify when messages are not successfully sent from MDM to the outbound queue. Support Space
  • Provides technical Support to data quality team to performs Unmerges on over-merged records, de-link a relationship and creating new records.
  • Changes configurations in Informatica Data Director, as needed by the Data entry team after Business approvals.
  • Provides replay of messages to downstream system on adhoc basis.
  • Analyzes the open JIRA’s and provide LOE’s
  • Creates MDM part of Version Description Document (VDD) for deploying the JIRA fixes in Pre-Production and Production
  • Participates in runbook creation for the production release
  • Works with Informatica product support team for MDM related issues.
  • Grants access to new users in IDD in all environments after Business approvals.
  • Validates the MDM applications after each release.

We'd love your feedback!