This job board retrieves part of its jobs from: Fresh Gigs | Long Island Jobs | Georgia Hiring

Find tech jobs in the USA today!

To post a job, login or create an account |  Post a Job

  Tech support jobs   

Bringing you the best, highest paying job offers in the tech support industry

Slide 1
Slide 2
Slide 3
previous arrow
next arrow

MDM Developer

FastTek Global

This is a Full-time position in Dearborn, MI posted January 22, 2022.

Job description

Software Engineer Senior #711723, W2 Contract for 24 months with likely extension, remote to start but prefer those open to living/working in the metropolitan Detroit area (This is NOT a C2C opportunity)

Job Description:

  • Candidate is responsible for Informatica MDM HUB development support and should have detailed technical knowledge of Informatica MDM product, Powercenter and IDQ tools.
  • Drives technical solutions and issue resolutions based on business need.
  • Produce and develop detailed MDM design specifications, develop custom mapping functions and customizations to the database tier of Informatica MDM Hub.
  • Analyze and defines detailed MDM processes, tasks, data flows, and dependencies.
  • Develop extensions and customizations to the services (SIF) tier of Informatica MDM Hub.
  • Conducts MDM unit tests and code reviews.
  • Participates in MDM design reviews, including database code design reviews.
  • Creates ETL Mappings, Mapplets, Workflows, Worklets using Informatica PowerCenter and IDQ.
  • Support requirement analysis, system analysis, design, development, testing, implementation, technical issue / conflict resolution; demonstrate problem solving skill.
  • Participates in system and integration test, identifies and resolves solution defects.
  • Provides ongoing support, monitoring, and maintenance of deployed products.
  • Actively works with less experienced platform engineers providing technical guidance and oversight.

Skills Required:

  • Experience in Mater Data Management (MDM) Multi Domain Edition HUB Console Configurations, Informatica Data Director (IDD) Application creations, Informatica Powercenter and IDQ tools
  • Extensive experience in Master Data Management (MDM) HUB Console Configurations such as Staging Process Configurations, Landing Process Configurations, Match and Merge Process, Cleansing Functions, User Exits.
  • Experience in Mater Data Management (MDM) Multi Domain Edition HUB Console Configurations, Informatica Data Director (IDD) Application creations.
  • Experience working on Informatica MDM to design, develop, test and review & optimize Informatica MDM (Siperian).
  • Expertise in creating Mappings, Trust and Validation rules, Match Path, Match Column, Match rules, Merge properties and Batch Group creation.
  • Experience in creation and maintenance of entity objects, hierarchies, entity types, relationship objects Relationship types using Hierarchy tool to enable Hierarchy Manager (HM) in MDM HUB implementation.
  • Hands on experience in design and configuration of landing tables, staging tables, base objects, hierarchies, foreign – key relationships, lookups, query groups, queries/custom queries and packages.

Skills Preferred:

  • Designed, Installed, Configured core Informatica/Siperian MDM Hub components such as Informatica MDM Hub Console, Hub Store, Hub Server, Cleanse Match Server, Cleanse Adapter, Data Modeling.
  • Worked with Sif API to interact with real time applications. Strong SQL, PL/SQL, T-SQL programming skills in Oracle 12c/11g/10g,
  • Experience in debugging, error handling and performance tuning of sources, targets, mappings and sessions with the help of error logs generated by Informatica server.
  • Experience in Agile, Waterfall and UML Methodologies.
  • Good Exposure to development, testing, debugging, implementation, documentation and production support.
  • Extensive experience in implementation of Data Cleanup procedures, Transformations, Scripts and Execution of Test Plans for loading the data into the targets.
  • Experience in production support to resolve critical issues and mingle with teams to ensure successful resolution of the reported incident.
  • Strong analytical, logical and problem solving skills and ability to quickly adapt to new technologies by self-learning.

Experience Required:

  • Over six years of experience in Informatica Master Data Management, Informatica Data Director (IDD) Application , Informatica Powercenter and IDQ tools

Education Required:

  • Bachelor’s degree in Computer Science or equivalent

Job Requirements:

  • Perform the detailed design of ETL to DataMart (informatica)
  • Analyze data in the data warehouse, data mart or operational systems
  • Perform statistical analysis of business data
  • Load the data into the enterprise data warehouse
  • Support the lifecycle of physical data models and data maps for data warehouse system
  • Perform analysis on the data
  • Support the development and design of the internal data integration framework
  • Create data mappings from source systems to the target systems, data warehouses and data marts
  • Lead the development /integration of the following: data loading for data marts and enterprise data-warehouse
  • Obtaining table designs and analyzing data structures in preparation for data exchanges, and completing data testing for data exchanges
  • Perform data analysis and data profiling against source systems
  • Perform detailed data analysis to understand the source system data
  • Drive the design of solutions for the business
  • Develop data solutions to help the product and business teams make data driven decisions
  • Transform Load) and interface/integration of data into the data warehouse and data marts)
  • Participate in data modeling and data design with BI Tech Lead
  • Support new and existing data using Informatica
  • Develop and maintain data management standards and conventions, data dictionaries, data element naming standards and data dictionary metadata standards
  • Lead development on creating data-dictionaries of key tables and libraries within the data-warehouse
  • Integrating disparate sources of data