Get your dream job within 2 days (HURRY UP) ENROLL NOW or Call +1 (804)-715-8126
+

Informatica Developer with MDM - H1B/GC


Job Id : 11279

Jobtitle : Informatica Developer With MDM - H1B/GC

Location : Plano, TX

Company Name : Insigma Inc

Industry : Information Technology

Salary : $68,500 - $119,519  YEAR

Job type : Contractor

Posted on: 2020-01-28


Required Skills : Informatica, Data Profiling, ETL, SQL, C, API, Data Cleansing, Deployment, Excel

Benefits : No benefits are available


Job Description:

  • Experience with Informatica suite of product such as IDQ, MDM, IDD and PowerCenter is required.
  • Adept in core MDM functionalities such as Match, Merge, Survivorship, Trust Scores, Hierarchy and External Match
  • Knowledge of MDM Real Time and Batch loads. Experience with SIF and API services preferred. Java and Web Services knowledge etc.
  • Experience with Data Quality. Worked extensively on Data Profiling, Data Standardization, DQ Analytics
  • Hands on Design and Development along with providing technical SME guidance to contracting resources both onsite and offshore
  • Conduct Design and Code reviews. Should be able to manage concurrent project implementations
  • Provide support to Testing(IT/ST) and UAT
  • Engage in Production deployment and release planning
  • Engage with prod support teams for troubleshooting defects and any escalations thereof.
  • Proficient in SQL and advanced data manipulation techniques
  • Experienced in performance tuning and service monitoring

Detailed description

  • Profile source data and determine all source data and metadata characteristics; Design and execute a Data Quality Audit/Assessment; Design and execute the data quality mappings that will cleanse, de-duplicate, and otherwise prepare the project data
  • Implement data quality processes including transliteration, parsing, analysis, standardization and enrichment at point of entry and batch modes; Deploy mappings that will run in a scheduled, batch, or real-time environment.
  • Document all mappings, mapplets, and rules in detail and hand over documentation to the customer
  • Collaborate with various business and technical teams to gather requirements around data quality rules and propose the optimization of these rules if applicable, then design and develop these rules with IDQ
  • Utilize Informatica Developer , Informatica Power Exchange , Informatica Metadata Manager , and Informatica Analyst to design and develop custom objects and rules, reference data tables and create/import/export mappings
  • As per business requirements perform thorough data profiling with multiple usage patterns, root cause analysis and data cleansing and develop scorecards utilizing Informatica, Excel and other data quality tools
  • Develop "matching" plans, help determine best matching algorithm, configure identity matching and analyze duplicates
  • Build complex profiles and scripts to execute and test mappings and workflows to implement data stewardship and exception processing
  • Build human task workflow scenarios and IDQ scorecards to support data remediation
  • Run data quality specific ETL jobs (address standardization and validation, email cleanups, name cleanup, parsing, etc utilizing IDQ and other ETL tools
  • Proficient at writing SQL queries and verifying the results

Latest jobs for you

  • UNIX/LINUX Admin

    Wallstreet Consulting Brooklyn, NY

    Job Description: 12 years of experience in a technical and/or business application, product, ...

    View Job
  • java developer

    XTGLOBAL Menomonee Falls, WI

    Primary Responsibilities: Creates desired functionality to assigned domain, products or ...

    View Job
  • Splunk Architect

    XTGLOBAL Durham, NC

    Job Description: Required Experience & Skills: 2-3 years of hands-on Architect ...

    View Job
  • Java Developer - Multiple Openings

    AVTECH SOLUTIONS, In Detroit, MI

    Job Description: 8+ years experience as a software developer/architect with a strong ...

    View Job
  • .NET Developer

    Involgix Inc. Minneapolis, MN

    Job Description: 7-10 Years of experience in .Net Developer. developing object-oriented ...

    View Job

Thanks For Your Feedback

We’re an equal opportunity provider.
All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran or disability status.
OPTnation.com is not a Consulting Company/Training Company/H1B Sponsor.

Attach A Resume First