We provide IT Staff Augmentation Services!

Dq Expert Resume

5.00/5 (Submit Your Rating)
Hire Now

SUMMARY:

  • Extremely efficient in Master Data Management - tools used are Informatica MDM 9.5.1, Siperian XU SP2.
  • Part of the MDM CoE team in Capgemini.
  • Worked in MDM Data Model designing .
  • Solely prepared MDM material for Capgemini.
  • Part of DM-DQ portal development team.
  • Well familiar with SQL, PL/SQL and performance tuning.
  • Expertise in Informatica ETL - PowerCenter and IDQ.
  • Beginner level hands-on experience in IBM MDM.
  • Well acquainted with database concepts and has experience in Oracle and Teradata.
  • Acquainted with object oriented programming concepts - language - JAVA.
  • Involved in almost all stages of project life cycle like Requirement Analysis, Design, Development, Functional Studies, Quality Reviews, Testing etc.
  • Worked as part of both large and small teams.
  • Worked in various Pharmaceutical, Healthcare and Telecom projects.Informatica MDM hub configuration.
  • AddressDoctor and IDQ cleanse function implementation.
  • Hierarchy Configuration in MDM hub.
  • Upgrading Siperian ORS from Version XT SP2 Patch B Rollup 1 HF 10 to XU SP2 Patch B Rollup 1 HF30.
  • Installing Siperian XU SP2 application and register upgraded ORS.
  • ORS creation.
  • CMXUE package customization.
  • Creation of mapping, cleanse functions, cleanse list, match rule tuning, Trust Score configuration and Validation Rules configuration.
  • Triggering Siperian jobs, Debugging of aborted batches, Root Cause Analysis for critical problems in the batch flow.
  • IDD Configuration, User Role creation, Access and Workflow.
  • Bulk Upload through IDD.
  • Message Queue configuration.
  • SIF Implementation.
  • Worked in Vendor Master, Customer Master Data Model Designing.
  • Development of ETL mappings, workflows, worklets for loading data to Siperian landing tables.
  • IDQ Standardization plan creation.
  • Integrating IDQ plans in the Power Centre Web service enabled mappings and exposing through Web service hub .
  • Data loading from VSAM file and generation of XML files for downstream system.
  • Triggering ETL jobs, Debugging of failed workflows.
  • Configuration of Parameter file.

TECHNICAL SKILLS:

CDI Tool: Infomatica MDM 9.5.1HF1, Infomatica MDM 9.1, Siperian Hub XU

ETL Tool: Informatica PowerCenter 8.6, IDQ Workbench 8.6.2.

DBMS: Oracle 9i, 10g, SQL/PLSQL, Teradata.

Tools: and Utilities: SQL Developer,TOAD, Microsoft Visio, Erwin.

Programming: Core Java.

PROFESSIONAL EXPERIENCE:

DQ Expert

Confidential

Responsibilities:

  • Location Information handling - Leading 5 members team to design and develop the whole data parsing, cleansing, linking/matching,match-score generation process based on various matching criteria using SQL script and PL/SQl code

MDM Developer

Confidential

Responsibilities:

  • Product Master-Design and Develop Informatica MDM Dataflow . Prepared dataModel using Erwin. Designed the MDM data loading process through ETL workflow calling the MDM-batch group. Configured Hierarchy and Role based security accesses.Successfully implemented SIF customizations.

ETL Developer

Confidential

Responsibilities:

  • Customer information handling-Design and Develop Informatica Dataflow of XML file generation for downstream system through ETL using XSD.

DQ and MDM Developer

Confidential

Responsibilities:

  • Customer Master-Successfully integrate IDQ plans in Power Centre Webservice enabled mappings and use them in Informatica MDM exposing them through Webservice hub. Participated in Functional Requirement Analysis. Working with IDQ mapplets for Email and Address cleansing. Designing the Informatica MDM dataflow and Hierarchy Manager both in IDD and Hub. Making strategy for Match Rule tuning.

Module Lead

Confidential

Responsibilities:

  • Customer Master -Successfully led the whole project development process. ETL workflow design using SSIS. Successfully implement AddressDoctor in MDM and triple layered dependent lookup configuration in IDD and worked in various database customisation.

MDM developer- NNI, US

Confidential

Responsibilities:

  • Customer Master -Successfully Upgrading Siperian ORS from Version XT SP2 Patch B Rollup 1 HF 10 to XU and Installing Siperian XU SP2 application and register upgraded ORS.

ETL developer and Tester

Confidential

Responsibilities:

  • Successfully developed Informatica mappings, Teradata Scripts. Prepared test cases, test scripts and test data.
  • Worked in Defect Tracking and Reporting.

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship