We provide IT Staff Augmentation Services!

Informatica Mdm Developer Resume

5.00/5 (Submit Your Rating)

Atlanta, GA

SUMMARY:

  • Over 6+ years of experience in IT and 3+ years of experience on Data Management Multi Domain 10.2, 10.1, development, analysis, design, testing, maintenance and quality assurance with implementation of software applications in MDM and Data warehousing.
  • Installed and Configured Informatica MDM Hub, Cleanse Match Server (Process Server), Upgrading Master and User Specific ORS in different MDM versions.
  • Having 2 years of experience in Business Application Software Development Life Cycle (SDLC).
  • Illustrate and configuring Base Objects, Staging Tables, Landing Tables, Look - ups, Foreign Key Relationship, Hierarchies, Queries, Query Groups and Display/PUT Packages.
  • Experience in providing information management consulting services on Master Data Management, Data Integration and Business Intelligence Applications.
  • Over 2 years of Experience working in Informatica Master Data Management (MDM) Developer. Highly Skilled in MDM Hub configurations - Data modeling & Data Mappings, Data validation, Match and Merge rules, Hierarchy Manager, customizing/configuring Informatica/Business Data Director.
  • Creating Landing, Staging and Base Tables and defining Foreign Key relationships, Lookups in the Hub.
  • Working with Hierarchy Manager to develop to Hierarchies as per the business needs.
  • Creating IDD application as per the business needs by creating the subject area and subject area groups.
  • Configured mapping with cleanse functions including Address Doctor before running the stage job.
  • Configured match paths, match columns, match rule sets and match rules according to the requirement.
  • Used Data manager and merge manager tools under Data Steward workbench to manually merge and unmerge records.
  • Defined the Trust and Validation rules and setting up the auto match/merge rule sets to get the right master records (BVT).
  • Configured match rule set property by enabling search by rules in MDM according to Business Rules.
  • Increased performance and improved convenience for business users by configuring IDD.
  • Developing Put and Display packages for both Hierarchy Manager and IDD Application.
  • Extensively worked on Designer, Workflow Manager, Monitor and Repository Manager.
  • Acknowledge on Oracle 10g, PL/SQL, and SQL Server.

TECHNICAL SKILLS:

MDM Tool: Mata Data Management Multi Domain Edition 10.1, 10.2, Informatica Data Director (IDD)

EIM Tools: Informatica MDM Multi-Domain, IDD, SIF

Business Intelligence Tools: SQL Server Management Studio, SQL Server Integration Services.

ETL Tools: SQL Server Integration Services

Application Web server: JBoss EAP 6.2/6.4

Address: Doctor 5.X

Operating Systems: Windows 2008, 2000, XP, 2010

Databases: Oracle 10g, SQL Server 2012

Microsoft Office: MS. word, MS. Excel, MS. PowerPoint, MS. Access, MS. Outlook

Languages: SQL; C#; C++#

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Informatica MDM Developer

Responsibilities:

  • Installed and Configured Informatica MDM Hub Server, Cleanse Server, Resource Kit, Cleanse adapter, IDD.
  • Worked with ETL Developers in creating External Batches to execute mappings to integrate data from varied sources like Oracle, DB2, flat files and SQL databases and loaded into landing tables of Informatica MDM Hub.
  • Created and configured Base Objects , associated staging tables , mappings and transformations as per business requirements.
  • Configured mapping with cleanse functions including Address Doctor before running the stage job.
  • Used Metadata manager for validating, promoting, importing and exporting repositories from development environment to testing environment.
  • Involved in designing, documenting and configuring Informatica Data Director for supporting management of MDM data.
  • Configured foreign-key relationships, lookups, query groups, queries/custom queries and packages in MDM .
  • Configured hierarchy system tables and user defined tables and configured entity types and relationship types.
  • Configured match paths , match columns , match rule sets and match rules according to the requirement.
  • Involved in Data manager and merge manager tools under Data Steward workbench to manually merge and unmerge records.
  • Assisted in defined the Trust and Validation rules and setting up the auto match/merge rule sets to get the right master records ( BVT ). Configured match rule set property by enabling search by rules in MDM according to Business Rules.
  • Increased performance and improved convenience for business users by configuring IDD.
  • Involved SIF and configured SoapUI code for API calls to access hub data.

Environment: s: Informatica MDM 10.1, Oracle 11g, Address Doctor, Informatica Power Center/Analyst 9.5.1, SOAP UI, Eclipse, Linux and Windows.

Confidential

Informatica MDM Developer

Responsibilities :

  • Configured and installed Informatica MDM Hub server, cleanse, resource kit, and Address Doctor5 in Dev, QA, Pre-prod and Prod Environments.
  • Led effort for gathering business requirements for the data-warehouse as well as business-intelligence reports to be used by the management.
  • Involved in implementing the Land Process of loading the customer/product Data Set into Informatica MDM Hub using ETL tool.
  • Defined the Base objects, Staging tables, foreign key relationships, static lookups, dynamic lookups, queries, packages and query groups.
  • Configured Address Doctor which can cleanse whole world address Data and enhanced by making some modifications during installation
  • Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.
  • Defined the Trust and Validation rules and setting up the match/merge rule sets to get the right master records.
  • Configured match rule set property by enabling search by rules in MDM according to Business Rules.
  • Performed match/merge and ran match rules to check the effectiveness of MDM process on data.
  • Created and documented the secure resources, roles, users for roles, and assigned privileges to roles using Security Access Manager in Dev, QA, Pre-prod and Prod environment.

Environment : Informatica Multidomain MDM 10.1.0, Informatica Power Center 9.6.0, JBoss 6.4, Oracle 11g, SQL Developer, Address Doctor, IDD, SIF, Toad, SQL*Loader, Windows Server 2012

Confidential

SQL Developer

Responsibilities:

  • Participated in multiple contract projects through company name for various web and mobile applications and software brands, including Gamestop iOS, TruliaAgent, Twitter, NBA.com, and OutRide iOS.
  • Designed test cases and test scenarios, conducted functional, ad-hoc and exploratory testing for the variety of applications with expanded test coverage.
  • Created automation test cases for regression testing for number of web applications utilizing HP QTP.
  • Performed testing of mobile applications as well as web applications on Smartphone’s and handheld devices.
  • Conducted test execution and result analysis.
  • Updated documentation and send reports to client.

Environment: Oracle 9i , SQL*Plus, MS Word, MS Excel, MS SQL Server, JIRA, HP Quality Center, SDLC.

We'd love your feedback!